I'm doing an auto loan amortization and getting conflicting results with
similar Excel functions. I'm looking at a GM loan of 1.9% for 4 years on a
loan of $32,000, and trying to obtain the total cost of loan, P+I. If I do a
FV(0.019/12,48,,32000,0) I get $34,524. However, if I use several online
auto loan calculators I get $33,257. I can obtain the latter result by using
$32,000 + CUMIPMT(0.019/12,48,32000,1,48,0). But shouldn't the FV
calculation agree, or am I incorrect in trying to use a compound interest
formula with an amortization application?

BTW, CUMIPMT requires the Analysis Toopak Addin.

Thanks!!

Terry