On Mon, 02 May 2005 13:18:48 GMT, "Lewis Clark" <lewis_clark_644 @
yahoo.com wrote:

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?

Here's another excellent template site.
http://www.vertex42.com/ExcelTemplat...alculator.html

After reviewing these Excel spreadsheets, they seem straight-forward.
I still need to customize the template for my application, buying a
car for mom.

Basically, the template should help me analyze the dealer's offer; and
their subsequent counter-offer. The incentive plan is a balloon
payment plan: $269 a month, 48 months until the balloon, $10,500
payment at the end. They make no mention of the total purchase price,
amortization term, or interest rate. What questions do I need to ask
the dealer to develop a viable Balloon Payment Calculator?

I have to develop worksheets to figure out the purchase price,
interest rate, and payments. In case the dealer only gives me a subset
of the information.