Iain Rutgers


Excel Models

Here is another BSYS project: excel models! I learned how to use excel back at Waterloo, in an earlier post of got a more complicated model I made for a case study, but rules say I’ve got to put up so many BSYS projects.

It’s a mortgage calculator, handy for seeing how bad of a deal your getting.

Mortgage calc SS


Dynamic Business Model & Case study

This is a dynamic model I made in MS Excel 07 for our 2nd marketing case study. Based on price and units sold, It uses a customizable formula to calculate and graph revenues, costs, profits and margins.

Dynamic model of Case study 2

Dynamic model of Case study 2


Business Model
You can also see the report it was used to produce.
Decoline Report