Prospective Analysis and Application - Sensitivity Analysis - Economics Assignment Help

Assignment Task:

Pat B: Prospective Analysis and Application 
Task: Based on the same company chosen for the group and first individual assignment, produce an individual professional report on the prospective analysis of the company. Forecast the future financial performance of your company for the next five years and beyond. Use four valuation models, i.e. Dividend Discount Model, Residual Income Model, Residual Operating Income Model and Free Cash Flow Model, to produce an estimate of the firm’s share value, and compare to its current stock price. Perform sensitivity analysis on key forecasting assumptions using only Residual Operating Income Model and discuss the results. Based on sensitivity analysis and as a potential management consultant to your chosen firm, provide a discussion as to the possible opportunities for improvement, and potential challenges for the firm. Provide specific and reasonable remedies for these concerns. The report should cover: 
Forecasting:
Prepare your forecasts in an excel spreadsheet following a 10-step forecasting template. The forecasting table should include your specific forecasts for the next five years and should be included as an appendix in the report.

Explain the reasons for your initial forecast assumptions, i.e. assumptions for sales growth, ATO, PM, net dividend payout ratio, cost of debt and cost of equity. 
Valuation:(allocated 4 marks) 

Provide the calculation and results of four valuation models in a table and include it as an appendix in the report.Compare and discuss the estimates obtained from the four models. Compare the estimates with the actual share price to see whether the firm is currently overvalued or undervalued. 

Sensitivity Analysis:

1. Adjust your initial forecast assumptions to reflect your optimistic and pessimistic outcomes for sales growth, ATO, PM, and recalculate the estimated share value from the residual operating income model.
2. Provide the sensitivity analysis results in a table. 
3. Provide explanations of how the optimistic and pessimistic outcomes for forecasting assumptions are chosen.
4. Identify and discuss the key assumptions that the valuation is most sensitive to. 
5. Management Consulting Advice: (allocated 8 marks) 
6. Based on sensitivity analysis and the key factors that have significant impact on valuation, discuss potential opportunities and challenges for the firm to maintain or improve current profitability. Provide creative advice on what business strategies and measures specific to your firm that can be adopted to improve value. 

This Economics Assignment has been solved by our Economics Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.