ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
90
2
3
Property DetailsOperating ExpensesYearly TotalEGI %
Monthly Total
Standards
4
Months to Complete Project12Taxes$6,68010%$557
https://www.greatersudbury.ca/city-hall/tax-services/tax-calculator/
5
Years to Complete Project1Insurance$5,4358%$453
6
Purchase Price$850,000Price/UnitHydro$3,0004%$250$90/unit/month
7
Sqft of building 6Water$3,0004%$250$75/unit/month
8
# of Units before Reno6$141,667Gas$4,0006%$333$90/unit/month
9
# of Units after Reno6Lawn & Maintenance$00%$0$750-$1400
10
Income GeneratorsIncome/monthIncome/yearRental Equipment$00%$0
11
Rent Totals$5,850$70,200Pest Control$00%$0
12
Laundry$150$1,800Reserve (1%)$6841%$571% EGI
13
Storage$0$0Garbage$00%$0
14
Parking$0$0Common Cleaning$00%$0
15
Garage$0$0Heat Pump ($190/per Unit)$00%$0
16
Other$0$0
Elevator Maintenance ($300/M)
$00%$0
17
Vacancy Rate5.00%$293Management (8%)$5,4728%$4565% EGI
18
Effective Gross Income (EGI)$68,400Maintenance ($800/unit)$4,8007%$4005% EGI
19
Total Operating Expenses$33,071Other0%
20
Net Operating Income$35,329Other0%
21
Estimated Property ValueOther0%
22
NOI$35,329Other0%
23
Capitalization Rate6.25%Other0%
24
Property Value$565,264Other0%
25
ASKING PRICE$925,000Other0%
26
ASKING CAP RATE3.82%Total Expenses$33,0710%$0870000
27
UPLIFT LEFT IN RENTAL VALUES167.52%$565,264
28
Financing Overview717632
29
Purchase Price$850,000
30
PercentageAmountTerm (Years)AmortizationInterest RatePaymentsTotal/Year5,250
31
First Mortgage75.00%$637,5000254.75%$3,618 $43,410
32
Second Mortgage0.00%$009990.00%$0 $0
33
Third Mortgage 0.00%$09990.00%$0
34
Prom - Note0.00%$09990.00%$0
35
Total75%$637,500$3,618 $43,410
36
PPD $13,129 DCR 1.2 MAX0.81
37
Loan to Value75.00%
Profit/Loss (per year/month)
($8,081)($673)$750
38
Cash Requirements to CloseAcquisition CostsMISC COSTSRenovation BreakdownLegendRefinance Costs (Conventional)Refinance Costs (CMHC)
39
Acquisition Costs$14,225.00Land Transfer Tax$13,475Cash for Keys$12,000Bachelors$0Cost Per Unit (bachelor)$25,000CMHC Application Fee$0CMHC Application Fee$900
40
Legal Costs$13,000.00Title Insurance750$750Appraisal$0One Beds$0
Number of Units to Renovate
0Title Insurance$0Title Insurance$750
41
Financing Costs$6,375.00Lenders 1st Fee1%$6,375Leasing Costs $0Two Beds 10k per$0Mortgage Broker Fee$11,383Mortgage Broker Fee$7,500
42
Holding Costs$0.00Lenders 2nd Fee0%$0Last months rents $0Three Beds$0Cost Per Unit (one bed)$30,000Legal Refinance$4,000Legal Refinance$12,000
43
Renovation Costs$150,000.00Acquisition Fee0%$0Other$0Other$0
Number of Units to Renovate
0Lenders Fee$0Lenders commitment$3,500
44
Total Down Payment
$212,500.00Project Management0%$0Other$0Other$0Insurance Review Fee$0Insurance Review Fee$1,250
45
Misc costs$12,000.00Renovation$125,000Other$0Bank Buffer$15,000Cost Per Unit (two bed) $35,000Insurance Monitoring Fee$0Insurance Monitoring Fee$626
46
Technical cost$500.00Miscellaneous R.20%$25,000Other$0Common area$50,000
Number of Units to Renovate
0CMHC Insurance Premium PST$0CMHC Insurance Premium PST#REF!
47
Purchase Financials Holding Costs$8,081Other$0Unit 5 Renos$35,000Lender Insp Fee$500Lender Insp Fee$500
48
Cash on Cash Return-1.98%Miscellaneous H.10%$808Other$0Front entry$0Cost Per Unit (three bed)$40,000
49
Cashflow-$8,081.35Legal Purchase$5,000Other$0Additional$25,000
Number of Units to Renovate
030yr AMM, 7% INT, 75% LTV or 1.2 DCR35yr AMM, 6% INT, 80% LTV or 1.2 DCR
50
PPD$12,853.00New Corp + SHA$5,000TOTAL COST $12,000Other$0
51
Total$4,771.65Lenders Legals$3,000Technical Costs Other$0Cost Per Unit (Other)$20,000
52
IRR Y1 / Cash Flow + PPD1.17%OtherLetter of opinion$500Other$0
Number of Units to Renovate
0
53
OtherOther$0Other$0
54
Appreciation 2%$17,000.00OtherOther$0Other$0Cost Per Unit (Other)$20,000
55
Total21,771.65OtherOther$0Other$0
Number of Units to Renovate
0
56
IRR Y1 / Cash Flow + PPD + APP5.33%OtherOther$0Other$0
57
Initial Investment$408,100.00OtherTOTAL COST$500Total$125,000TOTAL NUMBER OF UNITS0Total$15,882.57Total#REF!
58
Tenant Ledger (AS - IS)Tenant Ledger (After Renovation)
59
Unit NumberRental IncomeStatusUnit Number
Rental Income
Status
60
11300N/A11750N/A
61
21500N/A21500N/Aseptic issue in basement
62
31500N/A31500N/ACinderblocks2000040000
63
41550N/A41550N/A
basement apartment needs to be gutted to be replaced
40000
64
cash for keys50N/A51750N/Acity sewer
65
cash for keys60N/A61750N/A
5 meters (2 basement apartments are likley illegal)
66
70N/A70N/A
5th panel could have been whole basement
67
80N/A80N/Ashingles are great
68
90N/A90N/Amight need insullation in roof
69
100N/A100N/A
proof of rent collection of last 8 months
70
110N/A110N/A
71
120N/A120N/A
72
130N/A130N/A
73
140N/A140N/A
74
150N/A150N/A
75
160N/A160N/A
76
170N/A170N/A
77
180N/A180N/A
78
190N/A190N/A
79
200N/A200N/A
80
210N/A210N/A
81
220N/A220N/A
82
230N/A230N/A
83
240N/A240N/A
84
250N/A250N/A
85
260N/A260N/A
86
270N/A270N/A
87
280N/A280N/A
88
290N/A290N/A
89
300N/A300N/A
90
310N/A310N/A
91
320N/A320N/A
92
330N/A330N/A
93
340N/A340N/A
94
350N/A350N/A
95
360N/A360N/A
96
$25/unitLaundry0N/ALaundry0N/A
97
Storage0N/AStorage0N/A
98
Parking0N/AParking0N/A
99
Garage0N/AGarage0N/A
100
Other0N/AOther0N/A