Your task is to use the information on the spreadsheet(s) to create a forecast for years 2013-2016. DO NOT LOOK AT THE ACTUAL RESULTS at any source.
The idea is to compare your results with your forecasts (how much your results deviate from reality is not relevant!)
You know how to take shortcuts, which is fine, but you won't learn anything if you use them. The point of having the functions for the ratios is to learn how they are put together in excel. Other points:
1. Use the AVERAGE ratios to develop your forecasts.
2. Find out what EVA means … it's good for you!
3. Two ratios were left for you to calculate..