Is there a loan amortization schedule with balloon at final pmt?

D

Dommerdog

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?
 
J

Jim Thomlinson

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.
 
D

Dommerdog

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
 
F

Fred Smith

"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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top