How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.

Most analysts use Excel to calculate NPV. You can input the present value formula, apply it to each year's cash flows, and then add together each year's discounted cash flows, minus expenditures ...

Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

Find out how to use Microsoft Excel to calculate the present value of a fixed annuity, including a calculation example. The calculation doesn't account for taxes.

Determine the present value of $1 factor. Use the present value of a $1 table. In the example, the term is 10, because the maturity is five years and the bond pays interest semi-annually. The ...

Here's how to calculate the present value of a perpetual annuity that promises to pay flat or growing annual payments with helpful examples.

To calculate the present value of any cash flow, you need the formula below: Present value = Expected Cash Flow ÷ (1+Discount Rate)^Number of periods Thus, for year one, the math would look like ...