Hello, I'm trying to work out understanding the PV function. Yes, I've read
Excel's help on this function. What I don't understand: When changing the
percentage from 8%/12 to 4%/12 why does the PV go up? I would think the
less percentage my money was making would make the PV go down?

Another question, as the example in Excel's help feature shows; I'm paying
$60,000, the formula reads: PV(8%/12,12*20,500, ,0) the Present Value of
the annuity
(-59,777.15). They say NOT a good investment, even though in 20 years it
would be worth $120,800? Why not a good investment? The amount $60,000 is
close to the PV?

Thanks

Thanks