Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loan Schedule with Balloon Payment | Excel Worksheet Functions | |||
Loan Amortization Schedule Template from Business Financial Plng. | Excel Discussion (Misc queries) | |||
change loan periods in an amortization schedule | Excel Worksheet Functions | |||
loan amortization schedule | Excel Discussion (Misc queries) | |||
Loan amortization schedule | New Users to Excel |