Learn how to calculate the present value of various bond types using Excel, including zero-coupon, annuities, and continuous ...

Claire Boyte-White is the lead writer for NapkinFinance.com, co-author of I Am Net Worthy, and an Investopedia contributor. Claire's expertise lies in corporate finance & accounting, mutual funds, ...

Begin with the following formula:=PV*(1+R)^NEither write this formula in an Excel spreadsheet cell or elsewhere for reference. Enter the present value in an Excel spreadsheet cell in place of "PV," ...

Image source: Flickr user Ken Funakoshi. A perpetual annuity, also called a perpetuity, promises to pay a certain amount of money to its owner forever. A classic example would be that of a perpetual ...

Calculating the present value of an annuity using Microsoft Excel is a fairly straightforward process if you know the annuity's interest rate, payment amount, and duration. Calculating this value is ...