G Guest Jan 29, 2007 #1 I need a weekly amoritization table for a loan. I need it for 18 months and all I seem to be able to display are whole number years.
I need a weekly amoritization table for a loan. I need it for 18 months and all I seem to be able to display are whole number years.
D Dave O Jan 29, 2007 #2 The Microsoft website has a month-by-month amort schedule available as a free download. www.microsoft.com
The Microsoft website has a month-by-month amort schedule available as a free download. www.microsoft.com
F Fred Smith Jan 30, 2007 #3 I find it just as simple to create my own table. Then I know it does what I want. The columns you need are: Period (week), Opening Balance, Payment, Interest, Closing Balance. Interest is previous ClosingBalance * InterestRate / PeriodsPerYear
I find it just as simple to create my own table. Then I know it does what I want. The columns you need are: Period (week), Opening Balance, Payment, Interest, Closing Balance. Interest is previous ClosingBalance * InterestRate / PeriodsPerYear
