How do I set up and format cells on an amortization schedule
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
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
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...
Does this OpenOffice template help you? Cheers, Al