GandiBaat
VIP Member
- Dec 23, 2014
- 2,994
- NOC Code......
- 2173
- App. Filed.......
- 26th September 2021
- Doc's Request.
- Old Medical
- Nomination.....
- None
- AOR Received.
- 26th September 2021
- IELTS Request
- Sent with application
- File Transfer...
- 11-01-2022
- Med's Request
- Not Applicable, Old Meds
- Med's Done....
- Old Medical
- Interview........
- Not Applicable
- Passport Req..
- 22-02-2022
- VISA ISSUED...
- 22-02-2022
- LANDED..........
- 24-02-2022
One more mistake. You are comparing Gains in House vs Total Value in S&P investment.No, because you're not exempted from paying property taxes, and you're required to avail CHMC insurance since your downpayment is only 5% otherwise the bank won't approve your loan. I thought at 3.5K you're already counting both of them, but here goes.
https://www.cmhc-schl.gc.ca/consumers/home-buying/calculators/mortgage-calculator/mortgage-calculator-result?mc_PurchasePrice=$500,000&mc_DownPayment=$25,000&mc_AmortizationPeriod=25&mc_Interest=5.69&mc_Frequency=1
total price of mortgage with insurance: $3,070.19 / month
property taxes: $1,390 / year[down town vancouver @ 500K property price] = 115.8 / month
average house insurance: $300 / year = $25 / month
Total monthly mortgage cost = $3,210
Net Expenses: 25K + 3.21K * 60 = 218K
Net Debt: 444.58 K
Asset FMV = 701K
Total Value: 38.42K
By the way Vancouver raised property taxes by 7.5% so this reflects 2023 property tax, and I did not account for property value inflation for tax evaluation purposes.
Non-FHSA (if invested instead of getting a condo):
Capital: 25K + $210/month
Net Asset Price (S&P 500, 10% return) [25K compounding + 210/month at annuity] : 25K * (1.1)^5 + (210* 12) * ((1.1)^5 - 1) / 0.1 = 55.6K
Capital Gains Tax (assuming 40% income tax rate) = (55.6 - 37.6) * 0.5 * 0.4 = 3.6K
Total Value: 55.6K - 3.6K = 52K
FHSA:
Only looks at tax rebate from FHSA, assumes 0 tax exemption, and exempted income is not re-invested (because I'm too lazy to compute annualized tax exemption and gain, so let's look at worst case FHSA)
Tax Savings: 40K * 0.4 = 16K
Total Value = 52K + 16K = 68K
For Condo you are using this formula, right?
Net Expenses = Downpayment + Mortgage Monthly * 60 + yearly expense in taxes and insurance
Net Debt (after 5 years)
Asset FMV (7% compounded rate) = Condo Value * (1 + 0.07) ^ 5
Total Value = Asset FMV - (Net Expenses + Net Debt)
The above is NOT Total Value at the end of 5 years, BUT GAIN on value.
The Total Value will be Asset FMV - Net Debt. That is the Amount you will get when you sell the house.
You are comparing it with Total Value of investment in S&P @ 10% return:
Since that is compounding at 10%, you used AMOUNT formula (for compounding and annuity).
So lets do the calculation again, with the scenario I had in my mind when I started.
Lets calculate buying a Condo (@500K) with two scenarios :
1. 20% Downpayment (the scenario that I assumed in my first post)
2. 5% Downpayment (the scenario that you used)
1. 20% Downpayment (no insurance required)
Mortgage Rate : 5.39%
Calculator Link : https://www.cmhc-schl.gc.ca/consumers/home-buying/calculators/mortgage-calculator/mortgage-calculator-result?mc_PurchasePrice=$500,000&mc_DownPayment=$100,000&mc_AmortizationPeriod=25&mc_Interest=5.39&mc_Frequency=1
Mortgage Payment per Month : 2416
Property taxes: These are on assessment value and NOT on actual prices. Typically, for Vancouver sales price is 8-10% more of assessment value. Anyhoo lets take your figures. $1,390 / year[down town vancouver @ 500K
Average condo insurance: $300 / year = $25 / month (I am discounting this because tenants also typically take a $25 tenant insurance as well to cover liability and personal belonging loss in things like fire damage or flooding. When I came in vancouver in 2017 I also took one at 30$ per month.)
Total Monthly Expense : 2416 + 115.8 = 2531.8
Net Expenses: 100K + 2.532K * 60 = 252K
Net Debt (after 5 years) = 358K
Asset FMV (7% compounded rate) = 500 * (1 + 0.07) ^ 5 = 701K
Total Amount (or house equity) you will get after selling the house = Asset FMV - Net Debt = 701K - 358K = 343K
2. 5% Downpayment (the scenario that you used)
(Here I am using 5.39 %, which the best mortgage available right now.)
https://www.cmhc-schl.gc.ca/consumers/home-buying/calculators/mortgage-calculator/mortgage-calculator-result?mc_PurchasePrice=$500,000&mc_DownPayment=$25,000&mc_AmortizationPeriod=25&mc_Interest=5.39&mc_Frequency=1
total price of mortgage with insurance: $2984 / month
property taxes: $1,390 / year[down town vancouver @ 500K property price] = 115.8 / month (rounded to 116 / month)
Average condo insurance: $300 / year = $25 / month (I am discounting this because tenants also typically take a $25 tenant insurance as well to cover liability and personal belonging loss in things like fire damage or flooding. When I came in vancouver in 2017 I also took one at 30$ per month.)
Total monthly mortgage cost + property tax = $3100
Net Expenses: 25K + 3.1K * 60 = 211K
Net Debt: 442.45 K
Asset FMV = 701K
Total Amount (or house equity) you will get after selling the house = Asset FMV - Net Debt = 701K - 442.45K = 259K
Now Comparing with your S&P ones (for 5% down payment ) :
Capital: 25K + $100/month
Annuity Calculator : https://www.calculator.net/annuity-calculator.html?cstartingprinciple=0&cannualaddition=0&cmonthlyaddition=100&cadditionat1=end&cinterestrate=10&cyears=5&printit=0&x=Calculate#annuity-result
Amount = Net Asset Price (S&P 500, 10% return) [25K compounding + 100/month at annuity] : 25K * (1.1)^5 + (100* 12) * ((1.1)^5 - 1) / 0.1 = 40K + 7.7K = 47.7K
Gain over Downpayment = 47.7 - 25 = 22.7K
I will not even talk about capital gain tax here now.
Now Comparing with your S&P ones (for 20% down payment ) :
Capital: 100K
Additional you will be paying to rental: 400 dollars each month
Amount = 100*(1.1)^5 = 161K
Extra Expenses per month in rental = 400*60 = 24000 (for simplicity)
Total Amount = 137K
Gain over Downpayment : 37K
Last edited: