Developing a Company Valuation Model Using Discounted Cashflowvaluation and Other Methods

Financial Statements for Forecasting 5 Years into the Future

Students are required to develop a company valuation model using the discounted cashflowvaluation and other methods for a company publicly listed on a stock exchange of a countryof your choice (for example, the US, Japan, the UK, etc.). The company of your projectrequires the lecturer’s prior approval by the end of week 5. The model should contain:

? Financial statements that are forecasted 5 years into the future based on the 5 years’worth of past information provided. (Balance Sheet, Income Statement, CashflowStatement)

o Assumptions made in forecasting the future should be identified and justifiedwith reference to past financial information, other annual report information andany other information sources that the student deems important

o All assumptions made by the student should be reasonable and justifiedo The model should also contain opportunities for the user to change key inputsto assess the impact on the firm’s value

o Students should feel free to add in additional information from the annualreports where it will add value to their model i.e. segmented revenueinformation or more detailed expense data.

? The model should accurately compute the weighted average cost of capital and betawith the option of allowing users to alter the period and frequency of the beta us