Timing Flags and Master sheet in a Project Finance Model

Contains necessary flags, counters and switches to build in flexibility in your project finance models

by FinExMod
Financial modelsFollow 34

3 reviews174 views|Start the discussion!|Bookmark download for free

Description
This Excel workbook and Pdf manual are designed to help you build necessary flags, counters and timeline into your Project financial model.

The workbook can be used as a template for building your own financial model.

It also contains sensitivity analysis sheet and Integrity checks that should be linked to the model once all the building blocks are put in place.

In this manual you will learn:
- Why it is important to have flexible timeline in your financial models
- What is a timeline?
- Single timeline versus multiple timeline
- How to use the timing flags

The main aim of a project finance model is to make cash flow projections covering a lifetime of a project. Therefore, one of the building blocks is to have a timeline on top of each worksheet in the financial model.

In this workbook, I am using a single timeline with the flexibility to have different periodicity for pre-operational phases versus operational phases.

If you choose to use the timing template then you are a couple of steps ahead in building your financial model.

In the worksheet labeled “Time” you already have typical flags and counters that are required to automate any possible changes in key project timeline.

This Best Practice includes
1 Excel Workbook, 1 PDF file