As a reminder, the formula to calculate the DSCR is as follows: Net Operating Income / Total Debt Service. Place your cursor in cell D3. The formula in Excel will begin with the equal sign. Type ...

Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals zero.

Key Points Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252.