ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula? (https://www.excelbanter.com/excel-discussion-misc-queries/126977-formula.html)

mason

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

Gary''s Student

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