In this video I provide a clear guide on how to create a loan amortization schedule in Google Sheets and Microsoft Excel. This can be useful to break down each installment on a mortgage, a car loan, a student loan, or even a personal loan any loan as long as it has a fixed term and interest rate. We can then make smarter financial decisions by structuring our loan better, and making strategic lump sum repayments to pay it off quicker, and, pay less interest. The overall interest paid will reduce in the case you reduce the loan term, increase the installments per term (more compounding), and making additional repayments.
The loan schedule I create has a few columns, namely the loan balance, the installment amount, the P&I (principal and interest) split of each installment, and the option to add additional payments.
// SOCIAL
Follow Me On Instagram @brentcolemaninvesting
// USEFUL LINKS
✅ Dosh NZ Best Way To Pay: https://dosh.nz/app and use my referral code 00030886
✅ Get $5 FREE with Sharesies (NZ/AU): https://sharesies.com/r/C744KD
✅ Get $45 with DoorDash: https://drd.sh/yzemFEO8gYRTjiKt
✅ Free Month Car Insurance https://coveinsurance.co.nz/referred/...
✅ Get $10 FREE with Hatch Invest (NZ): https://app.hatchinvest.nz/share/hmwy...
✅ Hnry (NZ) Free $25 Freelance Accountant: https://app.hnry.io/r/BRENT82488
✅ Sharesight (NZ/AU/US/UK) 4 Months Free: https://sharesight.com.au/brentcoleman
// TIMESTAMPS
► 0:00 Intro
► 0:38 Create the schedule
► 6:36 Add the extra payment
► 8:43 Adapt the model to accept different variables
► 9:35 Outro
Disclaimer:
I am not a financial adviser. This video is for education and entertainment purposes only. Seek professional help before making any investment decision.
Song: Skylines Anno Domini Beats
YouTube Studio Copyright Free Music