filter post by
Showing all blog

Using goal seek macro to achieve maximum debt limit

This tutorial demonstrates how the maximum debt limit can be solved based on a target debt service cover ratio (DSCR) when modelling a project finance project. This exercise indicates the maximum debt size that can be supported by a certain cash flow available for debt service (CFADS) profile.

Learn More

ModelOff crowns a new financial modelling champion in 2014

Congratulations to the finalists for ModelOff’s Financial Modelling World Championship finals in New York.

Learn More

Financial modelling case study - ModelOff 'Purple City'

Well done to all the participants who were through to the second round of the ModelOff 2014 Financial Modelling World Championships! Last week, we provided solutions to the questions from ModelOff 2014, Financial Modelling World Championships round one – Precise Debt Modelling and Dealing with Data. This week, I will walk you through a solution for the 'Purple City' case study, featured in Round two.

Learn More

ModelOff round one recap

Round one has just finished. How did you go? Read the recap to discover how you went and where you can improve in time for round two.

Learn More

Stop the guessing game: Intuition vs robust analysis

Do you trust your financial model to provide a good representation of your business? Don’t leave it up to intuition to guide decision making. Download “A strategic planning process for confident decisions” to align your financial model with strategic objectives.

Learn More