Starter

What types of contractor do we need to build our houses?

ObjectivesWhat: Build a financial model

How: Using Microsoft Excel

Why: To see if we can afford it!

What information do we need to

know?• What types of workers we need• Their hourly wage• How much work they need to do• How long the job will take• Overtime!!!

Before we start:• Open Excel• Click Tools >> Options• Go into the Security tab• Set the Macro Security to

Medium• Close Excel

The spreadsheet model

• Use a formula to complete the highlighted cells

• They will go green if they’re right!• Try to complete the extension task• Only use the hint if you’re stuck!• Click Done when you are!