Microsoft Excel
Building models exercise
Average difficulty

This Microsoft Excel BUILDING MODELS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl EXCEL BUSINESS MODELLING course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: London Olympics - internal course - base model

A full answer to this exercise is provided as part of the training course!

1)	Download the files needed to start this exercise: exercise-664.zip (and click here if you experience any problems unzipping this file after downloading it).
2)	You have been commissioned to produce a simple (!) model to calculate the investment return on the London Olympics 2012.  First open the workbook in the above folder, and use the Window menu to freeze the windows on the Inputs and Calculations sheets as appropriate.
3)	Following strict modelling best practice, create the following revenue inputs: Ticket sales for each of the 8 years (enter 0 for years 1-5, then 1,000,000, 2,000,000 and 3,000,000 for the last 3 years leading up to and including the Olympics themselves). A single-figure input showing the price of a ticket (assumed to be constant throughout the 8-year model - enter this as £60 in a single cell). Sponsorship income (starting at £100,000,000 in year 1, and rising in £50,000,000 increments to £450,000,000 in year 8)
4)	Still following modelling best practice, create the following cost inputs: Running costs - these should be variable, but initially enter £250,000,000 in each of the 8 years. A single-cell cost escalator, entered as 10% initially - this is the cost overrun multiplier to apply to the basic running cost figures.
5)	Your model should now look something like this:
	Your formatting and range names may be different
6)	Create 3 calculation lines giving total revenue, total costs and net cash for each year, and apply number formatting - your final answer should look like this:
	Numbers are scaled by a million using the , symbol
7)	Apply conditional formatting to make the cash figures stand out when they exceed £150,000,000:
	One suggestion for a format to use
8)	Save your workbook with the same name, then close it down!

Thank you for showing an interest in this Excel Business Modelling training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.

Return to the list of exercises for this topic