ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQAR
1
ID
137 KANDAHAR Lane
The Blue Mountains, Ontario L9Y0N3
LOT SIZELWSQFT
2
LOCATION:Blue Mountain1846612144
3
AREA:
4
CCS STRATEY:SHORT TERM RENTAL
5
SUBJECT PROPERTY ADDRESS:
137 KANDAHAR Lane
The Blue Mountains, Ontario L9Y0N3
6
PROPERTY TYPE:SINGLE FAMILY454000$774.77390000
7
SQFT:1600+900 (BASEMENT) SQFT
8
AIRBNB:https://abnb.me/WoMQNbkwrIb
9
10
11
LISTING PRICE$1,278,888.8801/28/20181/3/2018
12
13
$0.00$2565/mo Until 2018
14
15
Home Inspections$850.00$0.00$20,000.00
16
Bank Financing Appraisal$550.00$0.00$20,000.00
17
Title Insurance$992.00$0.00$20,000.00
18
Land Transfer Tax$22,053.00
19
Legal Acquisition$1,717.00
20
MORTAGE BALANCE
21
22
DOWNPAYMENT$255,777.7820%
80% 1ST MORTGAGE
$1,023,111.10DOWN PAYMENT%MORTGAGEMONTHLYRATETERM CONDITIONSEQUITY PAYDOWN (0)123456789101112131415161718192021222324252627282930
23
$255,777.7820.00%$1,023,111.10$5,677.855.30%30 YR | 1 YR CLOSED$14,443.64$1,008,667.46$993,448.28$977,411.79$960,654.76$942,857.17$924,103.82$904,343.37$883,651.38$861,718.54$838,607.87$814,256.09$788,712.63$761,681.40$733,198.51$703,186.03$671,661.13$638,343.94$603,237.58$566,245.92$527,346.42$486,279.26$443,006.67$397,410.27$349,418.47$298,796.17$245,455.37$189,250.04$130,048.23$67,645.29$1,891.17$0.00
24
6.301566251Domestic vacation data is growing
25
15% CASH RESERVE$42,290.9715%BAREBONES
26
27
TOTAL UPFRONT COST:$281,939.78
28
29
30
31
FINANCIAL INCOME STATEMENT 2022
32
Does not include Cash Payment Stays
33
EXPENSES
CURRENT EARNINGS
HISTORICAL EARNINGS
34
35
ANNUALMONTHLY2024ANNUALMONTHLY2023ANNUALMONTHLY2022ANNUALMONTHLY2021ANNUALMONTHLY2020ANNUALMONTHLY2019ANNUALMONTHLY2018ANNUALMONTHLY
36
MORTGAGE$68,134.20$5,677.855.30%PAID OUT TO DATE$113,046.47$9,420.54$138,071.18$11,505.93$200,819.74$16,734.98$182,076.65$15,173.05$142,606.00$11,883.83$233,384.03$19,448.67$250,536.39$20,878.03
37
CONFIRMED BOOKINGS
$10,000.00$833.33
38
PROPERTY TAX$3,700.00$308.33As of 08.31.2024
39
HOME INSURANCE$4,500.00$375.00
40
41
UTILITIES
42
43
WATER$1,800.00$150.00
44
GAS$900.00$75.00
45
ELECTRICITY$1,500.00$125.00
46
47
INTERNET$1,016.76$84.73
48
LAWN MAINTENANCE$480.00$40.00
49
SNOW REMOVAL SERVICE$750.00$62.50
50
51
HOT TUB FILTER (4)$450.00$37.50
52
HOT TUB CHEMICALS$250.00$20.83
53
AIRDUCT FILTERS$150.00$12.50
54
55
(REMITTED DIRECTLY FROM AIRBNB) AIRBNB FEE$0.00$0.00
56
(PAID DIRECTLY BY GUESTS) CLEANING FEES$0.00$0.00
57
58
PROPERTY MANAGEMENT$36,344.00$3,028.6720%
59
60
TOTAL EXPENSES:$119,974.96$9,997.91
TOTAL NET EARNINGS
$3,071.51$255.96
TOTAL NET EARNINGS
$18,096.22$1,508.02
TOTAL NET EARNINGS
$80,844.78$6,737.07
TOTAL NET EARNINGS
$62,101.69$5,175.14
TOTAL NET EARNINGS
$22,631.04$1,885.92
TOTAL NET EARNINGS
$113,409.07$9,450.76
TOTAL NET EARNINGS
$130,561.43$10,880.12
61
62
TOTAL OPERATING EXPENSES$48,140.76
63
64
BREAKEVEN$80,534.20$6,711.18$3,286.73
65
66
NET OPERATING INCOME$133,579.24
67
CAP RATE0.10444945
68
69
70
71
INVESTMENT SUMMARY
72
73
UPFRONT CAPITAL$281,939.78
74
LICENSE FEE$2,000.00
EVERY 2 YEARS
75
76
TOTAL INVESTMENT REQUIRED$288,361.78
77
78
79
FINANCIAL FORECAST
80
81
CAP APPRECIATION0.05
82
83
YEAR202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054
84
123456789101112131415161718192021222324252627282930
85
ESTIMATED SALE PRICE$1,342,833.32$1,409,974.99$1,480,473.74$1,554,497.43$1,632,222.30$1,713,833.41$1,799,525.08$1,889,501.34$1,983,976.40$2,083,175.22$2,187,333.99$2,296,700.69$2,411,535.72$2,532,112.51$2,658,718.13$2,791,654.04$2,931,236.74$3,077,798.58$3,231,688.51$3,393,272.93$3,562,936.58$3,741,083.41$3,928,137.58$4,124,544.45$4,330,771.68$4,547,310.26$4,774,675.77$5,013,409.56$5,264,080.04$5,527,284.04
86
MORTGAGE BALANCE$1,008,667.46$993,448.28$977,411.79$960,654.76$942,857.17$924,103.82$904,343.37$883,651.38$861,718.54$838,607.87$814,256.09$788,712.63$761,681.40$733,198.51$703,186.03$671,661.13$638,343.94$603,237.58$566,245.92$527,346.42$486,279.26$443,006.67$397,410.27$349,418.47$298,796.17$245,455.37$189,250.04$130,048.23$67,645.29$1,891.17
87
ANNUAL AMORTIZATION PAY DOWN$14,443.64$15,219.18$16,036.49$16,757.03$17,797.59$18,753.35$19,760.45$20,691.99$21,932.84$23,110.67$24,351.78$25,543.46$27,031.23$28,482.89$30,012.48$31,524.90$33,317.19$35,106.36$36,991.66$38,899.50$41,067.16$43,272.59$45,596.40$47,991.80$50,622.30$53,340.80$56,205.33$59,201.81$62,402.94$65,754.12
88
INTEREST PAYMENT$53,690.56$178,885.66$178,068.35$177,347.81$176,307.25$175,351.49$174,344.39$173,412.85$172,172.00$170,994.17$169,753.06$168,561.38$167,073.61$165,621.95$164,092.36$162,579.94$160,787.65$158,998.48$157,113.18$155,205.34$153,037.68$150,832.25$148,508.44$146,113.04$143,482.54$140,764.04$137,899.51$134,903.03$131,701.90$128,350.72
89
CASH FLOW$61,745.04$52,483.28$61,745.04$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58
90
CASH ON CASH:19.98%16.98%19.98%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%23.48%
91
92
ANTICIPATED CAPITAL EXPENDITURE$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
93
ANTICIPATED CASH FLOW$61,745.04$52,483.28$61,745.04$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58$67,717.58
94
ACCUMULATED
95
ANTICIPATED CASH ON CASH21.90%18.62%21.90%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%24.02%
96
97
CASH+AMORTIZATION:$76,188.68$67,702.46$77,781.53$84,474.61$85,515.17$86,470.93$87,478.03$88,409.57$89,650.42$90,828.25$92,069.36$93,261.04$94,748.81$96,200.47$97,730.06$99,242.48$101,034.77$102,823.94$104,709.24$106,617.08$108,784.74$110,990.17$113,313.98$115,709.38$118,339.88$121,058.38$123,922.91$126,919.39$130,120.52$133,471.70
98
(CASH+AMORTIZATION) ON CASH:27.02%24.01%27.59%29.96%30.33%30.67%31.03%31.36%31.80%32.22%32.66%33.08%33.61%34.12%34.66%35.20%35.84%36.47%37.14%37.82%38.58%39.37%40.19%41.04%41.97%42.94%43.95%45.02%46.15%47.34%
99
100