Using Excel to Model an Annuity (HSC SSCE Mathematics Standard): Flashcards

FV, PV, NPER, PMT, RATE

Calculates future value after regular payments

Calculates what future payments are worth today

Calculates regular payment amount needed

Calculates number of payment periods needed

Calculates interest rate per period

Enter as negative values (money leaving account)

Divide by 100 (e.g., $10\% = 0.10$)

Payment period (e.g., annual $\div 12$ for monthly)

Payments at end of period (most common)