Posted by David Alexander on May 27, 2001 at 19:11:50:

Use the function button at the top of the spread sheet.

It gives you the ability to figure out PMT(payment), I%(rate), N (number of Months, periods), PV (present Value) and FV (future value).

You calculate for future value to determine a balloon.

David Alexander

Excell program for Balloon payments? - Posted by Mike Nilsson

Posted by Mike Nilsson on May 27, 2001 at 16:38:34:

I’m happy to say that I found this board! What a wealth of information. I’ve been looking for an excell program with Balloon payments and amortization schedules to use in my own spreadsheets. I cannot find it. I know it is out there, but where…I want the formula! Can anyone point me in the right direction?

Re: Excell program for Balloon payments? - Posted by Jim Locker

Posted by Jim Locker on May 27, 2001 at 20:35:26:

If you wish, you may email me and I will send you a copy of my spreadsheet.

Although you really should learn how to use a spreadsheet yourself, to generate your own data.