impt and cumimpt with a residual

Z

zardozoz

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loan/lease repayment using IPMT/CUMIPMT 2
Can excel calculate a loan payment with a balloon at the end? 2
SUMIF with NAME RANGE 1
How do I calculate a lease? 6
Dsum and Dmax with structured references 1
Need formula for cumulative interest with additional monthly princ 0
Help Please- Report Calculation 2
Help with RATE function 8

Top