Building Integrity Checks in Project Finance Models (Manual & Template)
Originally published: 05/12/2019 14:14
Last version published: 22/02/2020 06:39
Publication number: ELQ-82920-3
View all versions & Certificate
certified

Building Integrity Checks in Project Finance Models (Manual & Template)

This is a spreadsheet that can be integrated in any project finance model. It contains most common integrity checks.

Description
It is common to hear people complaining about excel being prone to errors. Even if we take a very systematic and methodical approach to using excel modeling, we won’t eliminate errors . The benefits of using excel however, far outweigh the risks it potentially poses.

One way to help reduce errors is to include integrity checks in your models and dedicate a sheet within your model that collects all the individual checks throughout the model into one sheet. This allows the model builder to check that the model, or section of the model, works correctly. All the checks are then summed up and a master error check and alert indicator can be created and included in the freeze pane in each worksheet within the model.

This workbook and the manual are designed to help you build necessary checks in your project finance model.

You can use this template as a road map on the typical checks that needs to be included in any project finance model. This is mainly designed for project finance models but you can also use it in a corporate model and adjust it to your own project model.

I do not call these error checks because they might not necessarily be errors but are needed to alert the user of your model of any issues that may require their attention. For example, in down case scenarios, the cash available for debt service might not be enough to pay back the loan. Then a flag in the model should notify the user that this is the case.

This Best Practice includes
1 Excel file, 1 PDF

FinExMod offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

This is a spreadsheet that can be integrated in any project finance model. It contains most comment integrity checks.

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from FinExMod

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Building Integrity Checks In Project Finance Models (Manual & Template)

The user community and author are here to help. Go ahead!


4.7 / 5 (43 votes)

please wait...