Present Value Lump Sum
Use this template to calculate the present value of a lump sum, the interest rate earned on a lump sum, and the number of investment periods. It also allows you to calculate the interest rate (or discount rate) if you know the present value, future value, and number of periods. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Copyright © KMT Software, Inc. All Rights Reserved.
Present Value of a Lump Sum
Future Amount (at the end of n periods) Number of Periods (n) Interest Rate Per Period (per n periods) The present value is:
Calculating an Interest Rate
Future Amount (at the end of n periods) Present Value Number of Periods (n) The interest rate per period is:
Calculating the Number of Periods
Future Amount (at the end of n periods) Present Value Interest Rate Per Period (per n periods) The number of periods is: