Financial Modelling

Question 1- Line chart (+ Comment on features of interest) - 10 Marks

Question 2- Estimate a model of volume sales, comment on findings, and compare trend variable with Qn 1- 10 Marks

Question 3
Refine model in Qn 2 by adding a seasonal index, months that exhibit above average sales, reason? How does it compare to previous and commend on findings- 10 Marks

Question 4:

Refine model created in previous by adding a dummy variable, what is the overall impact of the disease? How do your findings compare to observations in previous questions? Comment on findings- 20 marks

Question 5:
What is the effect of increasing the price of brand, Effect from competitors? Which competitors are relevant, which ones are not? Compute various elasticities? Why do you think your brand is affected by some competitors and not others?- 20 Marks

Write a report summarizing findings. Be sure to address each clients key areas of interest. select a final model to present to client, explain why model is chosen. Interpret the model so that client can understand its meaning.

Sample Solution