GEFINTECH

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 

Starting from 09.02.25, 12:25 PM India  The most important thing that drive the success of all industries is the Energy Industry, the growth, innovation & future matters a lot for all of us. India  India is seeing the Energy Industry now from the specs of Green/Renewable Sources, it's capital intensive but the most sustainable and long run requirements for us, it requires innovation, support and more human capital every moment we live by. What's the current stats ? : (the  below data is as on 31.12.24) According to Central Electricity Authority of India,  Total Renewable Energy Source (RES), Installed Capacity is  162476.58 MW In which Solar is  97864.72 MW.  India is now able to get almost near to 50% - 50% in Thermal and Renwable Energy Installed Capacity where :  Thermal being  244376.91 MW & Renewable being  209444.75 MW and total Installed Capacity is  462001.66 MW. Finance Industry Outlook The outlook of the Lenders...

Formulas & Others Market Capitalization : PAT X P/E Alternative of :  P/E  X EPS   X No. of Shares  PAT = EPS   X  No. of Shares 

Formatting word documents takes eternity until you learn it ! How to remove my name from Author ? By clicking file , then on Info   Inspect Document > Inspect Document, uncheck Comments, Revisions and Versions  Then Inspect and Remove Document Propoerties and Personal Information Note : If it is track changes mode then the changes by different Author will become one and just show tracj changes rather than changes by different authors.

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

A daily exercise in the Excel to make a better future makes you learn a lot of formulas these are those ! 1. SUMIF Function  Use Case : to sum a particular category from the n numbers of catergories available  For eg.  1. Types of Liabilities : Term Loan, ECB and NCD 2. Amounts for the type of Liabilities  We want to sum only Term Loam  Formula  SUMIF(Range = Type of Liabilities,Criteria = "Term Loan",Sum Range = Amounts of type of Liabilities)