Financial Modelling for Project Finance

Financial Modelling for a Project Finance is not a easy thing, we will here do the most basic of that. 

While in real life project real life problems come like taxation, sensitivity analsysis and all, but this model is prepared by me in the most simplistic and basic level of Project Finance that too with referrence to Renewable Energy Sector.

In the first step will be timelines 

The start comes from writing down the assumption that is Construction and Operations period, 

the Construction Period starts from 1st Jan 2023 and the end date will be withing one year that I took as a year (=Eomonth(Start date,12)). 

the Opeartion Period start after the Construction Period that is 31st Jan 2023 and will be 1st Jan 2024 (=edate(startd ate,12))

Then we will start with the quarterly start and end of the periods that can be seen in dark blue by Quarter 1 (Start Date will be 1st Jan 23 and End of the period will be =Eomonth(Start date,3-1) 

then the next quarter 2 start date will be end of the period of Quarter 1 + 1, and the we can stretch it till we get 2060 end.

And then to understand the Operation and Construction Period we will use True and False Feature for that. 

Whereas for Operation =if(and(startdate>=to the operation start date, enddate<=to the opration end date), True, False) and then to the next lines same for the Construction Period.

If you want to understand Formatting : Click Here

In the Second step will be Input Sheet and Main Calculation

Tips : 

Outflow should be negatively shown (in bracket) and cash inflow in positive