### Present Value of a Lump Sum with more than 1 compounding period per year

Sometimes, certain institutions pay out interest more than once each year. It is possible the interests are paid out
• Semi Annualy
• Quarterly
• Monthly
• Daily
• Continuously
Basically, we will need to discount the compound interests we have earned over the two years taking into account that interests are paid out more than once in a year to derive the Present Value.

Formula of Present Value of a Lump Sum with more than 1 compounding period per year

PV = FVn * (1+(r/m))^(-(m*n))
• FVn is the Future Value after a specific period
• PV is Present Value
• r is the interest rate
• n is the period. For example 5 years.
• m is the compounding period
You may want to bring up the Present Value.xls spreadsheet and refer to the Worksheet Present Value (m CompoundPeriod).

Next :
Present Value of an Ordinary Annuity

Back to Free Investment and Financial Calculator main page.

Back to Excel Add-Ins and Templates main page.