Home |
Search |
Today's Posts |
#1
|
|||
|
|||
impt and cumimpt with a residual
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 |
Display Modes | |
|
|