Excel Formatting : Advance
1. To get "-" instead of "0" in the excel sheet
Go to home then Cell Style and then do New Rule
> Custom, Write instead of General 0;-0;"-"
2. To wrap the text in row
Ctrl+A > then > Alt+H+W
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 da...
.png)
Comments
Post a Comment