Find out the best practices for most financial modeling to price a bond, calculate coupon payments, and calculate a bond's yield to maturity in Microsoft Excel.

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

How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...

Learn how to approximate the effective convexity of bonds using Microsoft Excel with a modified and simpler version of the standard convexity formula.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

Excel can calculate a single value for one specific number of days or multiple values for a list of different days that you create.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...