Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I wanted to figure how much my savings would be on a loan if I made biweekly
payments instead of monthly payments. Example: if the regular monthly payment was $1,231 , I would make two payments of $615 instead. How can I determine how much I will save in interest with option 2? rate:6.25%/12 nper:12*30 loan amount:200,000 The above amounts are what I used to determine the monthly payment of $1231, which multiplied out will have me repaying $443,160 over the life of the loan. How much interest would I be saving making the biweekly payments is what I want to figure out? Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Flexible loan calculator-additional borrowing, irregular payments | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Add insurance to loan payments | Excel Worksheet Functions | |||
WANTED: Excel template for loan payment record with random/irregular payments | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel |