View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default amortization table

I find it just as simple to create my own table. Then I know it does what I
want. The columns you need a Period (week), Opening Balance, Payment,
Interest, Closing Balance.

Interest is previous ClosingBalance * InterestRate / PeriodsPerYear

--
Regards,
Fred


"Holly Ramsey" <Holly wrote in message
...
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.