ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Buy-Fix-Sell Analysis
2
Property InfoExpenses While HeldYearlyMonthlyActual%Sale Costs
3
Address
Property Tax / School Tax
 $ 3,672.00 $ 306.00 $ 918.00 #DIV/0!Closing Costs (% of ESP)0.60%
4
After Repair Value (ARV) $ 525,000.00 Insurance $ 1,000.00 $ 83.33 $ 250.00 #DIV/0!Closing Costs (Actual $) $ 3,150.00
5
Expected Sale Price (% of ARV)100%Electricity / Hydro $ 2,000.00 $ 166.67 $ 500.00 #DIV/0!Sales Comm. (% of ESP)3.00%
6
Expected Sale Price (Actual $) (ESP)
 $ 525,000.00 Gas / Heat $ 800.00 $ 66.67 $ 200.00 #DIV/0!Sales Comm. (Actual $) $ 15,750.00
7
Offer Price / Purchase Price $ 280,000.00
Lawn/Snow Maintenance
 $ - $ - #DIV/0!Advertizing $ -
8
Expected Hold Time, months3Water/Sewer $ 600.00 $ 50.00 $ 150.00 #DIV/0!Mortgage Pre-Payment Costs $ -
9
Management $ - $ - $ - #DIV/0!Hard Money Financing Cost $ -
10
Purchase CostsCaretaking $ - $ - $ - #DIV/0!Total Selling Costs $ 18,900.00
11
Closing Costs $ 2,000.00 Advertizing $ - $ - #DIV/0!
12
Land Transfer Tax $ 300.00 Association Fees $ - $ - $ - #DIV/0!Profit / Loss
13
Repairs $ 125,000.00 Pest Control $ - $ - $ - #DIV/0!Expected Selling Price $ 525,000.00
14
Repairs Contigency (% of Repairs)
10.00%
Change Locks / Security
 $ - $ - #DIV/0!Offer Price / Purchase Price $ (280,000.00)
15
Repairs Contigency (Actual $) $ 12,500.00 Trash Removal $ - $ - $ - #DIV/0!Total Purchasing Costs $ (140,450.00)
16
Lender Fees $ - Miscellaneous / Other $ - $ - #DIV/0!Total Expenses while Held $ 4,000.00
17
Broker Fees $ -
Common Area Maintenance
 $ - $ - $ - #DIV/0!Total Income while Held $ -
18
Enviromentals Capital Improvements $ - $ - $ - #DIV/0!Total Selling Costs $ (18,900.00)
19
Inspection / Engineer Report $ 650.00 Accounting $ - $ - #DIV/0!Equity from Mtg Paydown $ -
20
Appraisals Legal $ - $ - #DIV/0!Net Profit / Loss to You $ 89,650.00
21
Misc (site visit, title ins, RPR, corp, assign fee)
Evictions $ - $ - $ - #DIV/0!
Is This a Good Return On Effort (ROE)?
($ per hour)
22
Utility Acct Set Up Fee / OtherPayroll $ - $ - $ - #DIV/0!Cash Required
23
Less Proration of Rents $ -
Tenant Unit Repairs While Holding
 $ - $ - $ - #DIV/0!Deposit(s) made with Offer $ 10,000.00
24
Total Purchasing Costs $ 140,450.00 Bad Debts $ - $ - $ - #DIV/0!Cash Required to Close $ 270,000.00
25
Debt Servicing#DIV/0!#DIV/0!#DIV/0!#DIV/0!Total Purchasing Costs $ 140,450.00
26
Financing
Total Expenses while Held
#DIV/0!#DIV/0!#DIV/0!#DIV/0!Upfront Cash Required $ 420,450.00
27
1st Mtg Principle Borrowed $ - Total Expenses while Held#DIV/0!
28
1st Mtg Interest Rate0.00%Income While HeldYearly Monthly Actual % Advertizing Costs $ -
29
1st Mtg Amortization Period, years
30Effective Gross Rent $ - $ - $ - #DIV/0!Other $ -
30
1st Mtg CMHC Fee (% of Principle)
0.00%Vending $ - $ - $ - #DIV/0!Less Income (Not Equity!) $ -
31
1st Mtg Total Principle (Incl. CMHC Fees)
 $ - Laundry $ - $ - $ - #DIV/0!Total Cash Required By You#DIV/0!
32
1st Mtg Total Payment#DIV/0!Parking / Garage $ - $ - $ - #DIV/0!
33
2nd Mtg Amount $ - Other $ - $ - $ - #DIV/0!Analysis (ROI)
34
2nd Mtg Rate0.00%Signage/Roof Rental $ - $ - $ - #DIV/0!CoC ROI#DIV/0!
35
2nd Mtg Amortization, years20Total Income while Held $ - $ - $ - #DIV/0!CoC ROI / Yr#DIV/0!
36
2nd Mtg Payment#DIV/0!
37
Hard Money Amount
38
Hard Money Int Rate (not included in Exp While Held)
39
Cash Required at Close (not inc purchasing costs)
 $ 280,000.00
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