Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amortization template for uneven monthly payments
Need an amortization template for uneven monthly payments for multiple years.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amortization template for uneven monthly payments
You're probably better off to "roll your own" amortization table. You need four
columns: Date, Payment, Interest, Balance. Interest = Balance from previous row * Interest Rate / 12 Balance = Previous Balance - Payment + Interest. Copy down until Balance = 0 -- Regards, Fred "DOUG ODOM" wrote in message ... Need an amortization template for uneven monthly payments for multiple years. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what template should i use for collecting monthly payments from m. | New Users to Excel | |||
spread sheet template for monthly business for a year | Excel Discussion (Misc queries) | |||
WANTED: Excel template for loan payment record with random/irregular payments | Excel Discussion (Misc queries) | |||
Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) | |||
TEMPLATE IN EXCEL FOR MONTHLY PAYMENTS FOR MORE THAN ONE PROP | New Users to Excel |