Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome ...

Method Two Let’s assume that we didn’t calculate the IRR of 57% as we did above and have no idea what the correct discount rate is. We can use Excel’s What-If calculator in this case.

If you want to calculate the CAGR (Compound Annual Growth Rate), then your best bet is to use Microsoft Excel to get the job done. You will have to use the RRI function to complete this task, but ...