a.Produce a Microsoft Excel based model that shows the current income statement and the forecast position. The model should be capable of being used to sensitise the forecast. (5 marks)
b.Calculate the forecast cash received from customers for next year. (5 marks)
c.Next to your model, insert a pie chart that demonstrates how the forecast revenue gets split among the various costs and net profit. (5 marks)
d.Using the ‘goal seek’ function in Excel, find the volume growth (or fall) in percentage terms that will produce a net profit break even. Post an image of the input panel next to your model. (Note: the input panel is the small table where you enter which cell you are setting and which you wish to change. Take the screenshot before you press ‘ok’.) (5 marks)