Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amortization with up front skips
Need to get an amortization schedule working that allows the first six month
as no payment but accruing interest. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amortization with up front skips
I see two options, although there could be more.
1. Roll you own spreadsheet. You'll need headings like Period, Start Value, Payment, Interest, Ending Value. The formulas for each are straightforward. 2. To use a template, like Excel provides, just calculate the amount owing six months hence (use the FV function). Use that as the starting value for the template. -- Regards, Fred "kmagolden" wrote in message ... Need to get an amortization schedule working that allows the first six month as no payment but accruing interest. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Office Pro with Front page | Excel Discussion (Misc queries) | |||
Loan Amortization calculater (Canadian version) | Excel Discussion (Misc queries) | |||
Copy and Paste Macro for front totals sheet | Excel Discussion (Misc queries) | |||
export excel to Front Page | Excel Discussion (Misc queries) | |||
Microsoft Excel tries to load front page on opening | Excel Discussion (Misc queries) |