Thread: Formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Formula?

Using any standard loan amorization schedule as as :

http://office.microsoft.com/en-us/te...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.
--
Gary's Student
gsnu200702


"mason" wrote:

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