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