~/ learn/ afm-121/ cards/ Compounding frequency: monthly, quarterly, semi-annual
1 of 6

Type the Excel function for $3,000 at 6 % for 5 years, compounded monthly, adjusting both arguments inline.

Type the Excel function for $3,000 at 6 % for 5 years, compounded monthly, adjusting both arguments inline.

Answer

=FV(0.06/12,5*12,0,-3000)

rate 0.06/12 = 0.005 and nper 5×12 = 60, written inline so the marker — and you — can see both adjustments. Returns 4,046.55.

Bigel, Introduction to Financial Analysis (CC BY 4.0) §10.4 (“p occurs twice”) — shape only; original scenario

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/782050ec-c7bf-4809-8c46-ef5b5b6b84ce/flashcard utf-8 LF