This file might be a help:
http://www.bygsoftware.com/examples/...Calculator.zip
... except that it arrives at a figure of $34,432. This file also shows the
loan replayment schedule.
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
This workbook includes two worksheets that can help you calculate the likely
repayments you will have to make on mortgages and personal loans (including
HP and conditional sale agreements).
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"TerryG" <[email protected]> wrote in message
news:[email protected]...
> 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
Bookmarks