ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   amortization table (https://www.excelbanter.com/excel-discussion-misc-queries/128215-amortization-table.html)

Holly Ramsey

amortization table
 
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.

Dave O

amortization table
 
The Microsoft website has a month-by-month amort schedule available as
a free download.
www.microsoft.com


Fred Smith

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.





All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com