Formula?

[mason]

trying to determin how much money would be saved if a loan was paid off
sooner, after one year, two year, tec..
Please help

 

[Gary''s Student]

Using any standard loan amorization schedule as as :

http://office.microsoft.com/en-us/templates/TC010197771033.aspx?pid=CT101172751033

Generate a by-the-month schedule showing the principal and interest for each
month.

If you pay off the loan 12 months early, you will save the residual interest
on the final 12 payments.

Some might say the net present value of the stream.