以下公司估值作业项目用时三天左右，修改两次，最终成功交付，感谢信任！
PROJECT 1 – COMPANY VALUATION
Instructions for the Project
Students are required to develop a company valuation model using the discounted cashflow valuation and other methods for a company publicly listed on a stock exchange of a country of your choice (for example, the US, Japan, the UK, etc.). The company of your project requires 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, Cashflow Statement)
- Assumptions made in forecasting the future should be identified and justified withreference to past financial information, other annual report information and any other information sources that the student deems important
- All assumptions made by the student should be reasonable andjustified
- The model should also contain opportunities for the user to change key inputs to assess the impact on the firm’svalue
- Students should feel free to add in additional information from the annual reports where it will add value to their model i.e. segmented revenue information or more detailed expense
- The model should accurately compute the weighted average cost of capital and beta with the option of allowing users to alter the period and frequency of the beta used in the calculation of the WACC (i.e. one year daily data versus five yearsmonthly)
- Accurately employ the Free Cashflows formula to compute the cashflows for the next 5 years based on the forecasted financial statements’ information, and then use the Discounted Cashflow and/or other methodologies to compute the value of the company and hence stock
- Modelshould contain a summary page that brings together key inputs and key
- The valuation model should conform to the rules of good financial model
留学顾问の QQ：2128789860
留学顾问の微信：risepaper
The model will only be marked if it is built within the spreadsheet file 2020_V1_Valuation.xlsm available from Blackboard. Students are expected to be able to explain or demonstrate any features or techniques in their assignments if requested.
–Model contains simple financial statements lacking in detail or that are exact copies of those provided by the company
–Model contains suitable forecasting methods for most values
–Weighted Average Cost of Capital is correctly calculated
–Model correctly calculates the beta of the company
–Model correctly calculates the financial cashflows
–Company Valuation is accurate given the inputs without excessive changes in values