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.

Using the closing values, you will first calculate the asset's daily returns. With those values, you can use a spreadsheet program like Microsoft Excel to calculate the asset's standard deviation.