Mortgage Refinancing Math: Break-Even, Points, Cash-Out & ARMs
Decide a refinance from the borrower's side, number by number: the remaining balance with CUMPRINC and CUMIPMT, new payments by term, itemised closing costs and the break-even month, points vs lender credits, the term-extension trap in total interest, a cash-out refinance with its LTV and the true rate on the cash, ARM resets with index, margin and 2/2/5 caps, and a decision table ranking offers by NPV with a chart – 8 labs on one fictional household's loan, every cell checked instantly. Illustrative rates, educational only, not financial advice.
- 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.
- Work out what the Reyeses still owe four years into their mortgage, how much principal they have repaid and how much of their payments went to interest.
- Price four refinance terms on the Reyeses' balance and see which ones really lower the payment and how many months each adds or cuts.
- Add up the Reyeses' refinance closing costs (leaving out what is not a cost), find the break-even month and the net saving if they move after five years.
- Compare four rate/point combinations on the same loan: what each costs up front, its payment, the break-even of buying a point and the cheapest offer over the Reyeses' stay.
- Compare the interest still to pay on the current loan with three refinance plans and see why a lower payment can save almost no interest.
- Size a cash-out refinance for the Reyeses, check it against the 80 % LTV limit and work out the effective interest rate they pay on the cash itself.
- Run a 5/1 ARM offer through five yearly resets on a hypothetical stress path, apply the 2/2/5 caps and the floor, recompute the payment each year, find where the lifetime cap bites and chart the payment shock.
- Rank four refinance offers by net present value over the Reyeses' seven-year stay, counting the discounted payment savings, the balance left at sale and the upfront costs, then chart the result.
About this course
A lower rate does not automatically mean a refinance saves money. This course shows homeowners and loan officers how to check. You find the remaining balance and interest paid to date with CUMPRINC and CUMIPMT, then compare new payments across terms. Closing costs give a break-even month, and you weigh discount points against a higher rate or lender credits. A total-interest lab exposes the trap of restarting a longer term. Cash-out refinancing is evaluated on the new loan-to-value and the true cost of the extra cash, and adjustable-rate scenarios model index plus margin, caps and the payment path. Finally a decision table discounts the savings to a net present value. Educational, not financial advice.
Curriculum
Course content
8 lessons · 8 labs · 2.1 h · final exam
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Final exam
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.
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
