Formula?
trying to determin how much money would be saved if a loan was paid off
sooner, after one year, two year, tec.. Please help |
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 |
All times are GMT +1. The time now is 07:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com