Question
You are an equities analyst at a stock broking firm and your boss has asked you to build a financial model to value a publically
You are an equities analyst at a stock broking firm and your boss has asked you to build afinancial modelto value a publically listed Australian company calledWoolworths.You must value the company's shares using pro- forma financial statements and need guide whether the stock broking firm's clients should buy, hold or sell equity in the company. The model should be easily editable so that your boss and colleagues can use and tweak it. You are required to use Multistage Discounted Cash Flow (DCF) model to evaluate your chosen company. However, you can use Constant Growth Model or Price Multiples to estimate the terminal value.
Long answer Question:
Critique your valuation result. Is there any possible bias in modelling? How sensitive is your result to the variations of the key parameters (e.g. growth rate, capital structure, discount rate)? You may consider to perform a sensitivity or scenario analysis in this section.
(You are not need to show the calculation detail and result.Analyse what methodology you use and is it suitable in this case. And how you find the results such as projected free cash flow, CAPM or multifactor model, cost of capital, or other important results.)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/666153a001b48_4316661539fdc326.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started