formula to calculate savings from paying loan off sooner

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mason - 20 Jan 2007 20:33 GMT

a formula to calculate the amount of money saved in interest payments if the
loan was paid off after one year, two years, etc..

Reply to this Message

joeu2004@hotmail.com - 20 Jan 2007 22:41 GMT

> a formula to calculate the amount of money saved in interest payments if the
> loan was paid off after one year, two years, etc.

That depends on the type and specification of the loan. It might also
depend on the jurisdiction of the loan. For example, the computation
for Canadian mortgages can be very different.

For a typical US loan with monthly payments and no balloon payment, the
CUMIPMT() function might give you what you want. See Help > Excel Help
for detail

If not, please post back with particulars.

Reply to this Message