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

asked 2021-02-22 13:56:53 +0100

laaxtell gravatar image

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

edit retag flag offensive close merge delete

Comments

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

laaxtell gravatar imagelaaxtell ( 2021-02-22 14:28:46 +0100 )edit

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: https://en.wikipedia.org/wiki/Amortiz...

Przemo gravatar imagePrzemo ( 2021-02-22 15:12:43 +0100 )edit

Does this OpenOffice template help you? Cheers, Al

Earnest Al gravatar imageEarnest Al ( 2021-02-22 22:37:04 +0100 )edit