Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
zardozoz
 
Posts: n/a
Default loan/lease repayment using IPMT/CUMIPMT

I have been trying to create a monthly loan/lease calculation where there is
a residual at the end of a 5 year term. I am happy with each month (using
IPMT), but when tried to use CUMIPMT do make a compact form rather than 60
lines, the term involving residual (ie future value) is missing and the total
calc does not equal the sum of each month. Any leads?

  #2   Report Post  
Vacation's Over
 
Posts: n/a
Default loan/lease repayment using IPMT/CUMIPMT

CUMIPMT assumes a fully amortizing loan.
if there is a residual value you need to add an interest only calculation on
the residual to the CUMIPMT calculation

"zardozoz" wrote:

I have been trying to create a monthly loan/lease calculation where there is
a residual at the end of a 5 year term. I am happy with each month (using
IPMT), but when tried to use CUMIPMT do make a compact form rather than 60
lines, the term involving residual (ie future value) is missing and the total
calc does not equal the sum of each month. Any leads?

  #3   Report Post  
zardozoz
 
Posts: n/a
Default loan/lease repayment using IPMT/CUMIPMT

It all seesm so obvious once somelse can put you on the right track and
explain it properly. Take the cumipmt calc for the amount excluding residual
and add the reisdual int calc as well. But why does the cumipmt assume a full
amortization, whereas ipmt doesn't?
Thanks

"Vacation's Over" wrote:

CUMIPMT assumes a fully amortizing loan.
if there is a residual value you need to add an interest only calculation on
the residual to the CUMIPMT calculation

"zardozoz" wrote:

I have been trying to create a monthly loan/lease calculation where there is
a residual at the end of a 5 year term. I am happy with each month (using
IPMT), but when tried to use CUMIPMT do make a compact form rather than 60
lines, the term involving residual (ie future value) is missing and the total
calc does not equal the sum of each month. Any leads?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mortages Repayment Cynthia A via OfficeKB.com Excel Worksheet Functions 1 August 3rd 05 12:02 AM
Is there a template for rapid debt repayment in Excel? fofanna Excel Worksheet Functions 0 January 26th 05 04:07 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"