Thread
:
Mortgage amortization Template
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Mortgage amortization Template
Sure, Send to my email below.
--
Don Guillett
SalesAid Software
"Scott" wrote in message
...
-----Original Message-----
You need to subtract the extra payment along with the
principal payment
before calculating the next month. Lots of ways to do
that. Easiest would
probably be with an additional column for extra payments
and then adjust the
formula for that col.
--
Don Guillett
SalesAid Software
"Scott" wrote in message
...
I have been using a mortgage amort. template that I
believe came with the excel software. May have been
from
office 97 or something I'm not sure. Anyway, it works
great except that when I enter additional principal
payments(as a negative number), everything seems to
calculate correctly except the summary field
called "total
paid". I think this number should equal the initial
amount borrowed plus the total interest paid. And it
does
calculate correctly in cases where additional principal
payments are not entered, but when an additional
principal
payment is entered it is throwing it off. I was
wondering
if anyone is familiar with the template, and if not if I
could get some help adding the additional payment into
the
formula in the summary "total paid" field.
Thanks for any help.
Scott
.
Don. Would you be willing to look at this if I send it
to you?
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]