ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
InputsValue
2
Cost to Buy:$573,500
3
Property Tax:$2,216
4
Monthly Strata:$629
5
Monthly Heating Costs:$0
6
Cost to Rent:$2,200
7
Annual Salary:$110,000
8
Stress Test Rate:4.79%
9
Amortization (yrs):25
10
Unsecured Debt Balances:$3,000
11
Monthly Debt Payments:$350
12
13
CalculationsValue
14
20% Down Payment:$114,700
15
Stress Test Mortgage Payment:$2,614
16
17
18
IndicatorsValueRatingExplanation
19
Price to Rent Ratio: 21.72FAILPrice to rent Ratio should be 15.5 or less.
20
Price to Income Ratio:5.21FAILPrice to Income Ratio should be 2.5 or less.
21
5% Rule from Buy:$2,390FAILTotal rent per year should be 5% or less than the purchase price.
22
5% Rule from Rent:$528,000FAILTotal rent per year should be 5% or less than the purchase price.
23
GDS Ratio:32.57PASSThe CMHC Gross Debt Service indicator should be 39 or less.
24
TDS Ratio:40.51PASSThe CMHC Total Debt Service indicator should be 44 or less.
25
Gross Rental Yield:4.60%FAILGross rental yield should be 5% or less.
26
Partial Net Rental Yield:2.90%A proper net rental yield is difficult to calculate without actual costs and is presented as is.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100