| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use the Loan Template to calculate bi-weeky payments
I have downloaded the Loan Amortization Template from the office web site.
This helps you calculate on monthly payments. However I would like to change the formula so that it can accurately track bi-weekly payments. =IF(Pay_Num<"",DATE(YEAR(Loan_Start),MONTH(Loan_S tart)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),""). This is how it looks at the moment. Could anyone assist me to change it to track bi-weekly payments. Any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate loan balances when payments are missed? | Excel Worksheet Functions | |||
| Excel Template - Loan Calculator with Extra Payments | Excel Discussion (Misc queries) | |||
| Add insurance to loan payments | Excel Worksheet Functions | |||
| WANTED: Excel template for loan payment record with random/irregular payments | Excel Discussion (Misc queries) | |||
| How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions | |||
Threaded Mode
