1 / 21

財 報資料

財 報資料. 上網搜尋公司公開財務 報表. 找到每年度的季報表，此次以 2013Q2 為例. 主要參數為 CE 、 MV 、 MV/CE. 市場價值. 市場價值 : 發行股數*當季最後一天 股價 ( 取自奇摩股價 網站 )

ford
Download Presentation

財 報資料

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 財報資料

  2. 上網搜尋公司公開財務報表 找到每年度的季報表，此次以2013Q2為例

  3. 主要參數為CE、MV、MV/CE

  4. 市場價值 市場價值:發行股數*當季最後一天股價(取自奇摩股價網站) http://finance.yahoo.com/echarts?s=EBAY+Interactive#symbol=ebay;range=20130225,20130423;compare=;indicator=volume;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined;

  5. 市場價值 STEP2: 查詢當季最後一天股價 STEP1: 設定日期

  6. Number of subscribers 注意單位

  7. Number of lost subscribers =上一季的active users * Current quarter vs prior quarter = 3,486,000

  8. Number of new subscribers =net new subscribers + Number of lost subscribers net new subscribers=本季總顧客數– 上季總顧客數 =3500,000

  9. Subscriber cash flow = (net revenue - Total operating expenses + Selling and marketing) /number of subscribers

  10. Retention rate =1-(Number of lost subscribers/((上季的Number of subscribers + Number of subscribers)/2))

  11. Acquisition cost = Selling and marketing/ Number of subscribers

  12. Acquisition cost Margin = Average Subscriber cash flow Retention rate = Average Retention rate Acquisition cost = Average Acquisition cost Discounted rate =美國十年期公債殖利率 (固定值 =0.0495) [m*(r/(1+i-r)-ac]

  13. 非線性規劃求解及Customer Equity 計算

  14. 1. 找出目標函數 目標函數:(估計 – 實際) 平方的加總

  15. 2. 利用 Excel 非線性規畫的程式找出一組解 p q m

  16. 3. 使用 Bass 擴散模型公式計算出『估計現有人數』 擴散模型公式

  17. 4. 計算 估計值之(估計人數-實際人數)平方 (估計人數-實際人數)平方

  18. 5. 使用(實際, 預測 + 誤差平方)跑回歸分析

  19. 迴歸分析輸出結果

  20. 6. 計算『真正估計現有人數』

  21. 7. Customer Equity 計算

More Related