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," ...

In the world of finance, an annuity is a contract between you and a life insurance company in which you give the company a lump sum or series of payments, and in return, the insurer promises to ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Amy is an ACA and the CEO and founder of ...

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 ...

Too many financial decisions are made without factoring in the time value of money. Whether providing financial planning advice related to a client’s retirement, advising a client about a business ...

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 ...