~/ learn/ afm-121/ cards/ Present value and discounting
1 of 6

Type the Excel function that gives, as a positive number, the deposit today that grows to $25,000 in 6 years at 5 %.

Type the Excel function that gives, as a positive number, the deposit today that grows to $25,000 in 6 years at 5 %.

Answer

=-PV(0.05,6,0,25000)

fv positive (you will receive it), so PV returns the deposit negative; the leading minus flips it to 18,655.38.

Bigel, Introduction to Financial Analysis (CC BY 4.0) §10.2 (the reciprocal factor) — shape only; original scenario

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/fcab1f8f-0f0e-4033-9a46-cc88314b5f01/flashcard utf-8 LF