| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a loan amortization schedule with balloon at final pmt?
When you use the pmt function there is an optional argument for fv which is
future value. Set that to your balloon payment as it is the amount of the loan that remains outstanding at the end of the loan period. -- HTH... Jim Thomlinson "Dommerdog" wrote: I'm looking for a loan amortization template which will calculate monthly payments taking into account a final balloon payment. Does anybody have one of these? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loan Schedule with Balloon Payment | Excel Worksheet Functions | |||
| loan amortization schedule | Excel Discussion (Misc queries) | |||
| Loan Amortization Schedule | Excel Worksheet Functions | |||
| Loan amortization schedule | New Users to Excel | |||
| Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Hybrid Mode
