Sunday, June 13, 2004

Ok - we have nearly finished our Financial Statement Analysis report. All of what is in the report is based on publicly available information, mostly contained in the company's financial report (the company we studied went public in 2002). We followed our class approach and basically, the report looks something like

Company Description
I - Industry Competitive Analysis
A - The Opportunities
B - Value Creation
1) For the consumers
2 ) For the studios and the distributors
C - SWOT analysis
1) Strengths
2) Weaknesses
3) Opportunities
4) Threats – Industry Dynamics That Might Impair Netflix’ Sustainability
Rivalry and substitutes
Suppliers
Customers
Complements
D - Key Profitability and Risk Factors
II - Accounting Quality
III- Financial Ratios Analysis
A - Gross Margin
B - Operating Margin
C - Return on Assets
D - Current Ratio
E - Total Liabilities to Assets
F - Return on Equity Ratio
G - Price to Earnings Ratio
IV Pro-Forma Income Statement
A - Revenues Forecasts
B - Costs Forecasts
C - Balance Sheet Forecasts
Assets
Liabilities
V Valuation Assumptions
VI Valuation Results
A – Free Cash Flows For All Debt and Equity Holders
B – Free Cash Flows For Common Equity Shareholders
C – Residual Income Valuation
D – Residual Income Valuation – Market-to-Book Approach
E – Dividend-Based Valuation
F – Market Opinion
VI Recommendation

+ some humongous spreadsheet. Our valuation for all models comes within $1 of industry analysts' and is on the right side (meaning that our recommendation would be the same as what you can find in reports, analysts' opinion on various financial websites).

No comments: