Description
ALMARAI’s NPV based on the financial forecast using the WACC as a hurdle rate. (Chapter 11 and 12) (7 Marks) (should be placed in the attached (Almarai company) excel sheet under NPV with all calculations shown) – ALMARAI is a Saudi dairy, food and beverages company -similar steps are attached in chapter 12 excel sheet that shows how to get the npv
Don't use plagiarized sources. Get Your Custom Essay on
Financial modeling Assignment | Essay Help Services
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Financial Modeling
three phase Project
50 Marks
Project summAry
phase two – company’s valuation (18 Marks)
Looking into the company’s future performance using different forecasting methods. Student is encouraged to use scenario analysis when it is appropriate
- Financial statement forecast for the coming 3 years using the company’s future projections and making your own assumptions based on historical data. (Chapter 5) (10 Marks)
- Common stock valuation clearly stating which method you chose for your valuation and reason behind this choice. (Chapter 9) (3 Marks) capam/ constant growth modle rafal
- The company’s NPV based on your financial forecast using the WACC as a hurdle rate. (Chapter 11 and 12) (7 Marks)
The analysis should be submitted on BB on excel format. Please note that I will be reviewing your formulas and assumption thus make sure to keep your excel files clean and organized.
