You can use the IPMT and PPMT functions to find the interest and principle
payments during each payment period, and the PMT function to find the total
principle and interest payment.

With a balloon loan, you usually just make interest payments each month.
Then when the time for the balloon payment arrives you are paying back all
of the still-outstanding principle.

What sort of customizing are you looking to do?


"R0bert Neville" wrote in message
...
On Sat, 30 Apr 2005 18:22:12 -0400, "Dana DeLouis"
wrote:

Microsoft's Template gallery had this, but I'm not sure if it's helpful.

Balloon loan calculator
http://office.microsoft.com/en-us/te...525031033.aspx


Thanks Dana.

The template works.

Does anyone know the math portion? The information will help me
customize the template.