amortization table

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loan amortization years 4
How do I get a formula to calculate the third Thursday of the mont 7
Picking a cell to show in another page. 2
Loan Amortization with a rest value 2
Amortization Tables 1
amortization table 2
need a vehicle loan amortization 6
Help with Loan Calc 1

Top