Project Modelling in Excel

As a way of saying thank you to Queensland University of Technology (QUT) for providing me with a baseline model for a recent full day training course for CPA Australia, I will be presenting a financial modelling half day course at QUT this October.  The course will cover financial modelling in Excel, with a particular slant on project modelling (the creation of bottom up revenue, expenses and capital allocation model).  I am thoroughly looking forward to sharing my knowledge with the students at QUT.  The model will focus on the creation of a wind farm in Brisbane.  It is a green field project which will be build from the ground up.  The following is the output from the model I will be presenting.

Excel Dashboard Wind Turbine

Some of the things which need to be considered are the average wind speeds for the area of the farm, price per kw of electricity, cost of construction, cost of maintenance and the project NPV over20 to 50 years.