Finance Report
The Main Contents of the Report for an analysis of Netflix
It must contain an Excel file with the required calculations
– Executive summary: A very brief introduction to the company, which models you have used for valuation, what your overall view of the companys price is and what the main risk factors are. (5%)
– Company overview: Including info on the services or products, market share, main competitors, major events (M&As, strategic reviews, management turnaround, etc.), business strategy, management of the company, life cycle and a brief look into Porters Five Forces and industry conditions. (15%)
– Historical information of the company: 3 – 5 years financial statements (balance sheet, income statement and cash flow statement), preferably common-sized as well to give a better perspective. These will probably end up in the appendix. (5%)
– Ratio analysis: You will be able to calculate them or extract them directly from a source, but if I find errors and irregularities Ill hold you responsible for not checking. So even if youre extracting these from a source, make sure you cross-check the main numbers. These can include liquidity, leverage, efficiency and capital ratios along with anything else required. Look into these and discuss any irregularities or major patters. Also you’d ideally compare these ratios with some benchmark, like the peer companies’ ratios or the industry average. (15%)
– Quality of financial reporting: Balance sheet-based accrual ratio and cash flow-based accrual ratio. If the net value of these ratios is increasing, then they have more room for manipulation; otherwise, you are good. If there is manipulation, you might as well look at cash flows too, like the case of Nestle right after checking the accrual ratios. (10%)
– Choice of valuation model: Dividend Discount Model, FCF models and Relative Valuation. Explain why youre using/not using a specific model. You probably dont need to do both FCFE and FCFF, one would suffice. (5%)
– Discuss the main assumptions you make and how you get there: Growth rate- why did you assume this? How do you calculate the required return on equity? What are your assumptions about your cost of debt and target capital structure? etc. Present your case and the valuation results clearly under each method. (25%)
– Sensitivity analysis: What happens if your main assumptions change? Range of potential values. (10%)
– Conclusion and recommendations: Checking the price in the market, is the share under or over-priced? What are the main concerns about your valuation outcome and the main risks the company faces, which might affect this valuation? (10%)
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
