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?

My concern in a balloon loan calculator relates to an automobile
purchase. Customizing the worksheet means allowing one to find the
interest from terms, pmt, balloon payment; finding the pmt from terms,
interest, balloon payment; finding the balloon payment from term,
interest, and pmt. In addition, I need to customize it to include all
other automobile purchase fees.

I am just looking for a few references on the math portion as I work
to reassemble the worksheet. But your suggestions on functions does
lead me in the right direction.