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 listed Australian company called Woolworths. 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.)

Finical datas you may use in the attach files.