Advanced Graphing – Step / Waterfall Charts

Download Excel file This is the second tutorial in a series that discusses how the graphing functions in Excel can be used to enhance your financial model. This tutorial focuses on the ‘Step’ or ‘Waterfall’ charts and how they can be developed and incorporated into a financial model. A waterfall chart effectively displays variances and […]

Modelling Capex and S-Curves

Download Excel file Capital Expenditure (Capex) is a common component of all project finance and many other types of financial model. An asset (power station, refinery, toll road etc) has to be constructed before it can generate any income. In the early stages a projects assessment there may not be a lot of information regarding […]

Implementing ‘Intelligent’ Model Checks

Download Excel file The most common and arguably the most important check in a financial model is the balance sheet check (Net Assets = Shareholder Equity), but you would be surprised at how many models I’ve seen with this missing or with a plug number inserted so that the check is always “OK”. A project finance model […]

End of content

No more pages to load

Scroll