How to Prepare a Loan Amortization Table with EXTRA PAYMENTS in Excel

In this accounting lesson, we show how to prepare a Loan Amortization Schedule with extra payments using Excel. We look at the mortgage Loan Amortization Schedule using Excel and show how to calculate the interest portion and capital portion of the mortgage loan installments for each period and what happens when you make extra payments toward a mortgage loan amortization schedule.
Loan Amortization Schedule | Lesson 1: • Loan Amortization Sche...
Loan Amortization Schedule | with Variable (Changing) Interest Rate | Excel: • Loan Amortization Sche...
Check out other straightforward examples and business-related topics on our channel.
We also offer one-on-one tutorials at reasonable rates as well as other accounting and tax services. Email us and/or visit our website or FaceBook page for more info.
Connect with us:
Email: [e-mail]
Our Website: Counttuts.com
Our Facebook Page: / counttuts
Support our Efforts: paypal.me/counttuts

[@sizwemchunu6110]

your ability to explain clearly is very impressive... thank you

[@bhavneshparikh8283]

Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest

[@maliktauz6563]

Bro please help me with fixed cost and variable cost calculation please 🥺

[@crownedwithgrace8004]

Thank you very much, i was really looking for this information

[@Counttuts]

You're welcome

[@musafirifrank3885]

What is this A4 you are saying sir