Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Excel Intermediate

Loan Amortization Schedules in Excel: PMT, IPMT, PPMT, Extra Payments & Balloons

Build a real amortization schedule step by step: PMT and the sign convention, a full schedule copied down to zero, IPMT/PPMT and CUMIPMT/CUMPRINC for any month or year, extra monthly payments, lump sums and recasting, balloon loans, interest-only periods and an APR comparison with a balance chart. 8 hands-on labs, every cell checked. Educational only, not financial advice.

8 lessons 8 labs 2.5 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Price Leo's $28,500 car loan with PMT, add up what he pays over five years and see what paying at the start of each month changes.
  • Build Leo's 36-month schedule row by row: opening balance, interest, principal and closing balance, copied down until the balance reaches zero.
  • Split payment 61 of Leo's 30-year mortgage into interest and principal and build an annual summary with CUMIPMT and CUMPRINC, without a 360-row schedule.
  • Add $150 a month to Leo's loan payment, stop the schedule cleanly at zero with MIN, count the months saved and the interest saved.
  • Drop a $3,000 bonus into Leo's 48-month loan in month 12 with an IF in the schedule, then compare keeping the payment (paid off early) with re-amortising (lower payment).
  • Price a car loan that leaves a $10,000 balloon at the end, find the balloon that fits a $450 budget and test what happens if the balloon has to be refinanced.
  • Compare a 30-year loan that is interest-only for 5 years with a standard 30-year loan: the payment in each phase, the jump at the switch and the extra interest.
  • Compare three $20,000 offers: monthly payment, the APR that includes the upfront fee (RATE), the total cost, and a line chart of how each balance falls.

About this course

Whether it is a mortgage, car loan or business loan, a repayment schedule shows where every payment goes. You start with PMT and the sign convention, then build a complete amortisation table month by month. IPMT, PPMT, CUMIPMT and CUMPRINC give interest and principal for any month or year without the full table. Extra monthly payments show how many months and how much interest you save, and a one-off lump sum is tested two ways: a shorter term or a lower payment. Balloon loans use PMT with a future value, an interest-only period reveals the payment jump that follows, and the final lab compares loans by APR including fees, total cost and balance curves. For borrowers, brokers and finance students.

Curriculum

Course content

8 lessons · 8 labs · 2.5 h · final exam

  1. PMT Basics & the Sign ConventionLab14 min4 checked tasks
    Unlocked when you buy the course
  2. Build a Full Amortization ScheduleLab22 min4 checked tasks
    Unlocked when you buy the course
  3. IPMT, PPMT, CUMIPMT & CUMPRINC: Any Month, Any YearLab18 min4 checked tasks
    Unlocked when you buy the course
  4. Extra Monthly Payments: Months & Interest SavedLab22 min4 checked tasks
    Unlocked when you buy the course
  5. One-Off Lump-Sum Payments: Shorter Loan or Lower PaymentLab20 min4 checked tasks
    Unlocked when you buy the course
  6. Balloon Payment Loans: PMT with fvLab16 min4 checked tasks
    Unlocked when you buy the course
  7. Interest-Only Then Amortising: The Payment JumpLab16 min4 checked tasks
    Unlocked when you buy the course
  8. Comparing Loans: APR with Fees, Total Cost & Balance Curves (Chart)Lab20 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Excel courses →
$9.99one-time payment
Buy course