Timing Flags and Master sheet in a Project Finance Model
  • Timing Flags and Master sheet in a Project Finance Model
Originally published: 08/01/2020 08:40
Publication number: ELQ-43516-1
View all versions & Certificate
certified

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

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

FinExMod offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

This manual and accompanying workbook 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.

Project Finance

Reviews

More Best Practices from FinExMod

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Timing Flags And Master Sheet In A Project Finance Model?

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


3.3 / 5 (3 votes)

please wait...