This video presents the formula for calculating a monthly mortgage payment and demonstrates how to calculate a mortgage payment using the formula with a comprehensive example.
—
Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world.
—
SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS:
• A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING
• A 44-PAGE GUIDE TO U.S. TAXATION
• A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS
• MANY MORE FREE PDF GUIDES AND SPREADSHEETS
* http://eepurl.com/dIaa5z
—
SUPPORT EDSPIRA ON PATREON
*https://www.patreon.com/prof_mclaughlin
—
GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT
* https://edspira.thinkific.com
—
LISTEN TO THE SCHEME PODCAST
* Apple Podcasts: https://podcasts.apple.com/us/podcast/scheme/id1522352725
* Spotify: https://open.spotify.com/show/4WaNTqVFxISHlgcSWNT1kc
* Website: https://www.edspira.com/podcast-2/
—
GET TAX TIPS ON TIKTOK
* https://www.tiktok.com/@prof_mclaughlin
—
ACCESS INDEX OF VIDEOS
* https://www.edspira.com/index
—
CONNECT WITH EDSPIRA
* Facebook: https://www.facebook.com/Edspira
* Instagram: https://www.instagram.com/edspiradotcom
* LinkedIn: https://www.linkedin.com/company/edspira
—
CONNECT WITH MICHAEL
* Twitter: https://www.twitter.com/Prof_McLaughlin
* LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin
—
ABOUT EDSPIRA AND ITS CREATOR
* https://www.edspira.com/about/
* https://michaelmclaughlin.com
source
Categories: Blog
43 Comments
@teresacompean4784 · November 15, 2026 at 8:32 pm
How in the world did he get $632 for a monthly payment?
@manueldejesus7495 · November 15, 2026 at 8:32 pm
Unbelievable. You can't go through the steps. Its seems no one can teach anymore we just assume.
@ezranair · November 15, 2026 at 8:32 pm
Realizing this was a normal mortgage payment when this was made 8 years ago is so depressing –___–
@tylercampbell6272 · November 15, 2026 at 8:32 pm
Why does no one explain the why in any of these formulas?
@chbry1050 · November 15, 2026 at 8:32 pm
Thank you for the clear breakdown!
@timsmith3621 · November 15, 2026 at 8:32 pm
Great video. One thing however. I always thought when you borrow at 6.5% annually you actually are getting 6.5% annual rate compounded semi-annually which would make the rate a wee bit higher than 6.5% annually. That is [(1+.065/2)^2-1]. I guess the "fine print" could make a difference.
@Belle0934 · November 15, 2026 at 8:32 pm
how do you calculate the 360 power?
@akoredetaofiqah3862 · November 15, 2026 at 8:32 pm
Please how can I calculate a principal repayment in the next 24 months
@cjstone8499 · November 15, 2026 at 8:32 pm
Showing you do the math would be really helpful.
@ianlombardo7728 · November 15, 2026 at 8:32 pm
how about just going on line and use a calculator !
@NaCl221b · November 15, 2026 at 8:32 pm
I was gong to give an upvote but its at a good number…
@molonlabe8979 · November 15, 2026 at 8:32 pm
Thank you that was so much more strait forward than anything else on Youtube.
@Asmrnerd10 · November 15, 2026 at 8:32 pm
does this work for monthly compound as well?
@mdrezaulislam8790 · November 15, 2026 at 8:32 pm
Please check about Amortization payment, if you like than click on thanks button, https://forum.mt5.com/showthread.php?297869-What-are-the-differences-between-depreciation-and-amortization&p=15027970&viewfull=1#post15027970
@mccannhealthcompany8625 · November 15, 2026 at 8:32 pm
I got a transfer of $65,000 directly to my bank account from expeditetools,com.
@henrycavill1601 · November 15, 2026 at 8:32 pm
I received a transfer of $30,000 from expeditetools,com.
@maryrubiom · November 15, 2026 at 8:32 pm
You are an awesome teacher 🙂 Thank you!!!
@felixchien1664 · November 15, 2026 at 8:32 pm
You showed how to use the formula. Can you explain how the formula was derived?
@anush7386 · November 15, 2026 at 8:32 pm
BROOOO I HAD DOUBT IN KHAN ACADEMY VIDEO VIDEO HOW TO GET THE MONTLY PAYMENT I GOT IT THX BRO
@nitroyt5743 · November 15, 2026 at 8:32 pm
Thank you so much I love u
@vjjames4567 · November 15, 2026 at 8:32 pm
what if you put a down payment . where would your down payment go.
@codecode1948 · November 15, 2026 at 8:32 pm
can someone explain this formula?
@kmart5258 · November 15, 2026 at 8:32 pm
12 years of school and they never taught me this! SMH
@kevinleon7772 · November 15, 2026 at 8:32 pm
Hi there. For a RE test where you are only allowed a standard calculator, is there a more simple way to input the calculation. I imagine you can solve within the parenthesis, round, and proceed to compute. Thank you!
@androidphone6972 · November 15, 2026 at 8:32 pm
Thank you so much for this awesome video.
So on loan of 100,000 borrowed @6.5% , i will be paying 227,520 over 30 yrs which includes 127,520 which is just interest. No wonder these big banks have skyscrapers as corporate offices in downtowns of most expensive cities. Fantastico.
Thanks for the video once again
@DiggybackGaming · November 15, 2026 at 8:32 pm
Hi this was a really good video and I was hoping you can help me with a formula or an answer..
In the UK, our mortgage products offer a fixed (lower) rate for a number of years (or, promotional period). This promotional rate could last for 1, 2, 3, 4 or 5 years . After that promotional period, the rate goes up to a variable rate until you paid off your loan or refinance. With one of the providers I plugged in a loan/mortgage of £500,000 over 25 years for a property worth £609,000. They came back to me with an initial promotional 5 year rate of 1.95% which means I would have to pay £2107.12 per month for 62 months. After that, I would be placed on a variable rate of 4% which requires 238 monthly payments of £2538.43. My question is, how do I work out how much interest I'm paying in both the initial promotional period and after that? I want to know how much equity will be paid off after the first 5 years, and therefore how much is left remaining. This is so I can understand how much LTV I have on the property at different points of the duration of the loan.
@shantanushekharsjunerft9783 · November 15, 2026 at 8:32 pm
How would you figure out the interest portion and the principal portion of each payment (as time goes the interest portion decreases and principal portion increases). Also, does this formula still work if we make extra payments towards principals.
@danimoosakhan · November 15, 2026 at 8:32 pm
The question is how do I punch that big fraction into my calculator? I have a graphing calculator.
@82sasquatchks · November 15, 2026 at 8:32 pm
how did the 6.5% become .065?????????????????????????? I'm lost…
@SexyBulldozerMan · November 15, 2026 at 8:32 pm
what im trying to figure out is if i make a lump sum payment of $40 000 on my mortgage, how much will i save, but i cant find help anywhere.
@harderheart · November 15, 2026 at 8:32 pm
And then some people are so eager to buy a house as an investment. You pay more than double the principle to pay off the mortgage.
@tusharsharma6207 · November 15, 2026 at 8:32 pm
To know about mortgage calculator visit :- https://www.myloancare.in/loan-against-property-emi-calculator/
@304-P-ROCK · November 15, 2026 at 8:32 pm
math is wrong
@JackSpratt-g5r · November 15, 2026 at 8:32 pm
You lost me at calculating ,,,,,,,,,thanks
@clearb3441 · November 15, 2026 at 8:32 pm
Didnt help. Why didnt you solve it step by step.
@zainabdin3551 · November 15, 2026 at 8:32 pm
This is good information, what is the answer?
@igee · November 15, 2026 at 8:32 pm
What operation should i press on the scientific calculator to calculate the N?
@idunno7916 · November 15, 2026 at 8:32 pm
Pm=P•i•(1+i)^n/(1+i)^n-1
This was the formula that my teacher taught
@Christian_Villanueva · November 15, 2026 at 8:32 pm
I need help entering this in Excel. Can anyone help?
@imbeaug74 · November 15, 2026 at 8:32 pm
So if I make bi weekly payments, instead of 12, I should divide the interest rate by 26?
@mortgagecalculator2056 · November 15, 2026 at 8:32 pm
You can easily calculate it online (e.g. http://www.mlcalc.com). What is it for?
@sincaraz · November 15, 2026 at 8:32 pm
thank you so much! you explained every single step unlike some other youtubers that skip steps that are vital to explain. Thank you i will ace my exam i have next thursday!
@victorp9575 · November 15, 2026 at 8:32 pm
It shouldn't take 5min to plug numbers into a formula, why not show how it's derived in the video?