Finance Terms

1. CAGR ?

Compound Annual Growth Rate : 

Let's say we have 5 years 

If the value is given : (5th year/1st year) ^ 1/period (5years) -1 
If the Return (Y-o-Y) growth % is given : ([1+R1] x [1+R2] x [1+R3]....) ^ 1/period (5years) -1 

Comments

Post a Comment

Popular posts from this blog

Financial Modelling for Project Finance

Image
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 da...
Read more