Type the Excel function that values $1,200 at the end of each year for 10 years at 6 %, as a positive number.

Answer

=-PV(0.06,10,1200)

rate 0.06, nper 10, pmt 1,200 (received). PV returns −8,832.10 — the price you would pay — so the leading minus reads it positive.

Bigel, Introduction to Financial Analysis (CC BY 4.0) §11.2–11.8 (factor derivation) — shape only; Excel PV with pmt authored fresh; original scenario