amortization table

H

Holly Ramsey

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.
 
F

Fred Smith

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
 
Top