Reviewed by David Kindness The debt service coverage ratio (DSCR) is used in corporate finance to measure the amount of a ...

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 ...