Mortgage Repayment Calculator

Since a mortgage principal gradually reduces are you make the monthly payments, the interest accrued reduces as you make payments. This make is so that calculating equal payments of the life of the loan a bit difficult. A brute force method would be to just calculate every payment for the life of the loan and make sure the payment amount results in a 0 payment at the end. In contrast, one can just also use a pre-calculated formula for this.

There’s an error in this video. The (1-r)^n term should be replaced with (1+r)^n. The formula in the spreadsheet is correct. Sorry for the confusion.

Mortgage Calc Spreadsheet:

Support more videos like this along with getting a bunch of perks here:

Get a free audiobook and 30-day trial. Even if you cancel, you still keep the book and you still support my channel for signing up. Support my channel by signing up to help me make more videos like this:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Credit Card for Starters
Who Should NEVER Get a Credit Card:
Only Use Credit or Only Use Debit:

Credit Card Basics
How Credit Card Calculates Interest:
How Credit Card Grace Periods Work:
Difference Between Credit Card Inactivity and 0% Utilization:
Credit Card Statement Closing Date vs. Due Date:
Does Canceling Credit Cards Affect Credit Score:
Can You Afford a No Limit Credit Card:
Credit Card Balance Transfer Hack:

Credit Score Less Than 700
Maximize Credit Score while in College:
Build Credit Fast with a 0 Credit Limit:
How to Pay off Credit Card Debt:
How to Build Credit with Bad Credit or No Credit :
How to Boost Your Credit Score Within 30 Days:

Credit Score More Than 700
How to Increase Credit Score from 700:
740+ is Not Just For Show:
My Credit Score: 848, How to get it Part 1:
My Credit Score: 848, How to get it Part 2:
My Credit Score: 848 – Credit Card Hacks and How I got it:

Advanced Credit Card Tricks
How to get a Business Credit Card:
Keep 16 Credit Cards Active:
Rejected for a New Credit Card with 826 Credit Score:
Make Credit Cards Pay You Instead:
Credit Card Low Balance Cancellation per mont :

Cash Back
Are Credit Card Points Taxable?:
How to Churn Credit Cards:
Best Cash Back Credit Cards for 2017:
5% Cash Back on Everything:
Always get 11% Off Amazon Gift Cards and Amazon Hacks:
Max Rewards: What’s in My Wallet:
How I Make 200 Dollars in 10 Minute :
When Your Best Cash Back Card Gets Cancelled:
Amex Blue Cash Preferred vs. Everyday Effective Cash Back on Groceries:
Double Dip Groceries Cash Back with Safeway Just for U:
Milk the Barclays Cashforward Card for the MOST Cash Back:

This Channel: BeatTheBush
I’ve obtained a high credit score of 848 out of 850 and I am glad to share the knowledge for everyone. Since 3 years ago, I’ve started making numerous videos that helped people increase their credit score that are free and accessible to all. Please enjoy my channel.

Other Channels:
BeatTheBush DIY:
My Tech Reviews: