How do I set up and format cells on an amortization schedule

[laaxtell]

link text How do I set up and format cells on an amortization schedule.

I have an amortization schedule in Libre Office and lost the formulas for the balance, interest and principle. I need them to calculate to the end of the contract.

Thank you for any help in this matter.

Lynn

[laaxtell]

I have an amortization schedule in Libre Office and lost the formulas in the middle of the contract for the balance, interest and principal. I need them to calculate to the end of the contract.Thank you for your help in this matter.

Lynn

[Przemo]

It’s an accounting question, not a LO question. Once you know the rules you can do the formulas and we can help with that part. Start here: Amortization schedule - Wikipedia

[EarnestAl]

Does this OpenOffice template help you? Cheers, Al