Any interest in excess of maximum amount will be credited on the Principal Amount…. Interest on the debt evidenced by this note will not exceed the maximum rate or amount of non-usurious interest that may be contracted for, taken, received under law. Reasonable Attorney Fees & Court Costs:Īttorney Rate (approximately $250.00 per hour) * these expenses will bear interest at the Annual Interest Rate from date of advance.Ĩ. Late Fee: $50.00 (if more than 5 days late, at Lender Option)ħ. Related: This allows you to see the entire loan from start to finish.
You can also see how much you still owe on the loan at any given time with the outstanding balance after a payment is made. Monthly Installments: $606.00 (beginning November 1, 2003)Ħ. An amortization schedule, sometimes called an amortization table, displays the amounts of principal and interest paid for each of your loan payments. Create the proper labels in column A to help keep your information organized. To create an amortization schedule, first, open Excel and make a new spreadsheet. Annual Interest Rate: Seven Present (7.0%)ĥ. Here are eight steps to help you create an amortization schedule within the Excel software application: 1. Both files have a 1 month delay on interest, and no Attorney Fees added only late fees recorded.įYI, the Terms of the Promissory Note are:ģ. I have mocked up two examples (Promissory Note, Promissory Note 07_08_17.
Thank you for any help that may be offered.
I have not used Excel much for over 10 years, so I am not sure of my use of formulas.
