To determine the value of a bond today—for a fixed principal (par value) to be repaid in the future—we can use an Excel spreadsheet.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

Calculating the interest rate using the present value formula can at first seem impossible. However, with a little math and some common sense, anyone can quickly calculate an investment's interest ...

Calculating the interest rate using the present value formula can at first seem impossible. However, with a little math and some common sense, anyone can quickly calculate an investment's interest ...