zardozoz

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:07 PM

All times are GMT +1. The time now is 07:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us