I'm looking for a loan amortization template which will calculate monthly
payments taking into account a final balloon payment. Does anybody have one
of these?

hi
check these sites out....
http://office.microsoft.com/en-us/te...197771033.aspx
http://www.vertex42.com/ExcelTemplat...readsheet.html
http://office.microsoft.com/en-us/te...CL100632981033

i'm sure you'll find one.

Regards
FSt1
"Dommerdog" wrote:

I'm looking for a loan amortization template which will calculate monthly
payments taking into account a final balloon payment. Does anybody have one
of these?

When you use the pmt function there is an optional argument for fv which is
future value. Set that to your balloon payment as it is the amount of the
loan that remains outstanding at the end of the loan period.
--
HTH...

Jim Thomlinson


"Dommerdog" wrote:

I'm looking for a loan amortization template which will calculate monthly
payments taking into account a final balloon payment. Does anybody have one
of these?

Thanx to you and Jim Thomlinson both. Jim, the one you linked to, and the
first one FSt1 linked, is the one that comes standard in Excel. The vertex
42 came close, but not quite. I'm trying to replicate one that I received
from a lender; however, their is based on a 360 day, and I think that's why
I'm slightly off on these.

I appreciate your help.

Dommerdog

"FSt1" wrote:

hi
check these sites out....
http://office.microsoft.com/en-us/te...197771033.aspx
http://www.vertex42.com/ExcelTemplat...readsheet.html
http://office.microsoft.com/en-us/te...CL100632981033

i'm sure you'll find one.

Regards
FSt1
"Dommerdog" wrote:

I'm looking for a loan amortization template which will calculate monthly
payments taking into account a final balloon payment. Does anybody have one
of these?

"based on a 360 day" year simply means that each month is assumed to have an
equal number of days. In other words, the monthly payment is the same
regardless of the number of days in the month. This matches Excel's
financial functions when you use a term (Nper) in months.

A discrepancy between Excel and your financial institution is typically
because the FI does their caclulation based on the actual date the payment
is received. So if your due date is on a Saturday, they credit it on the
following Monday and charge you this two days' interest.

There shouldn't any reason you can't get Excel to exactly match your
financial institution, although it may involve building a complete
amortization table.

Regards,
Fred.

"Dommerdog" wrote in message
...
Thanx to you and Jim Thomlinson both. Jim, the one you linked to, and the
first one FSt1 linked, is the one that comes standard in Excel. The
vertex
42 came close, but not quite. I'm trying to replicate one that I received
from a lender; however, their is based on a 360 day, and I think that's
why
I'm slightly off on these.

I appreciate your help.

Dommerdog

"FSt1" wrote:

hi
check these sites out....
http://office.microsoft.com/en-us/te...197771033.aspx
http://www.vertex42.com/ExcelTemplat...readsheet.html
http://office.microsoft.com/en-us/te...CL100632981033

i'm sure you'll find one.

Regards
FSt1
"Dommerdog" wrote:

I'm looking for a loan amortization template which will calculate
monthly
payments taking into account a final balloon payment. Does anybody
have one
of these?