Uploaded March 2026 | Updated September 2026, 2 weeks ago

---

Learn how to calculate loan payments and interest with ease using Excel’s PMT, PPMT, and IPMT functions. This video breaks down each function step by step, helping you understand payment schedules, principal amounts, and interest portions with real examples. Ideal for individuals seeking to enhance their financial analysis skills in Excel.

🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses

🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses

✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT

🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)