I am looking for a loan schedule which allows for a residual
All of the loan amortisation tables in Excel assume a nil balance at the end
- I am looking for one which allows a balance at the end, ie: a residual. |
I am looking for a loan schedule which allows for a residual
Hi
Would the PMT function work for this, as you are able to specify 'fv' - future value. This is the balance left at the end of the loan. HTH. Louise "Loan Schedule with residual" wrote: All of the loan amortisation tables in Excel assume a nil balance at the end - I am looking for one which allows a balance at the end, ie: a residual. |
I am looking for a loan schedule which allows for a residual
Allow me your email address and shall forward as an attachment a spreadsheet
which calcualtes payments in advance or arrears and makes allowance for residual or balloon payments. From there it generates an amortization schedule. regards "Loan Schedule with residual" wrote: All of the loan amortisation tables in Excel assume a nil balance at the end - I am looking for one which allows a balance at the end, ie: a residual. |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com