| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cumulated interest paid
I was wanting a formula to return the cumulative interest paid between two periods on a loan which has a residual value. Similar to CUMIPMT but it does not factor in a residual value. -- melafont ------------------------------------------------------------------------ melafont's Profile: http://www.excelforum.com/member.php...o&userid=36610 View this thread: http://www.excelforum.com/showthread...hreadid=563536 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cumulated interest paid
a1=(FV at p1 - FV at p2) is the amount that the principal decreased between
start-period (p1) and end-period (p2). a2=PMT * (p2 - p1) is the total payments made in that period. =a2-a1 is the total interest charged over that period. -- Regards, Fred "melafont" wrote in message ... I was wanting a formula to return the cumulative interest paid between two periods on a loan which has a residual value. Similar to CUMIPMT but it does not factor in a residual value. -- melafont ------------------------------------------------------------------------ melafont's Profile: http://www.excelforum.com/member.php...o&userid=36610 View this thread: http://www.excelforum.com/showthread...hreadid=563536 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working out interest lost on a loan | Excel Worksheet Functions | |||
| HOW to calculate the interest paid between 2 custom periods? | Excel Worksheet Functions | |||
| Fv & Emi! | Excel Worksheet Functions | |||
| Effective interest paid - need formula/function | Excel Worksheet Functions | |||
| How do I calc interest when using multiple dates within a given ye | Excel Worksheet Functions | |||
Linear Mode
