21/02/2021 · This payment loan calculator template generates a loan amortization schedule based on the details you specify. Enter the interest rate, loan amount, and loan period, and see what your monthly principal and interest payments will be. Then specify an additional monthly principal payment and see your equity grow and interest balance of the loan; The loan's interest rate; The payments remaining; And the additional amount paid; This amortization schedule will let you know what making extra payments will save you for your circumstances. The payment schedule supports: one "lump-sum" extra payment; a specific number of extra payments; extra payments until you've paid off the loanSimple Interest Amortization Calculator is an online personal finance assessment tool which allows loan borrower to find out the best loan in the finance market. The principal amount, simple interest rate and maturity period are the key terms to generate the amortization schedule, monthly payment and … for the extra payment amount; Select July 2019 as the beginning extra payment date; Select July 2029 as the ending date. (June will actually be the last extra payment.) Press the View Amortization Schedule button, and you'll see that your mortgage will be paid in 322 months (instead of 360 months) and you'll pay about $130, interest (instead of $154, ).08/05/2019 · Total extra payments: Add up cells in the Extra Payment column, beginning with Period 1: =SUM(C10:C369) Total interest: Add up cells in the Interest column, beginning with Period 1: =SUM(F10:F369) Optionally, hide the Period 0 row, and your loan amortization schedule with additional payments is done! The screenshot below shows the final result:Simple Interest Amortization CalculatorLoan calculator with extra payments - Schedule with Extra PaymentsAmortization Schedule with Extra PaymentsSimple Loan Calculator This simple loan calculator (that can be used as an amortization calculator as well) lets you estimate your monthly loan payments (or any other selected payment frequency). It will show you the breakdown between interest and principal in your loan arrangement, the specific monetary amount put towards interest and the amount applied towards the principal balance.

Tags: Simple interest loan amortization schedule excel with extra payments,