ABCDGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Address
2
Asking PriceSection 870% ARV
As-Is Comparables
3
Bedroom333 Address Sold PriceSQFPP-SQFSold DateBedBath
4
Bathroom 2.02.02.0Comp 1240 Amethyst Ct$247,0001,530$161.4405/29/2432
5
SQF1,6511,6511,651Comp 23305 Valley Bend Rd$252,0001,504$167.5504/03/2432
6
ARV $ 267,603.86 $ 267,603.86 $ 267,603.86 Comp 3935 Old Rocky Rd$235,9001,500$157.2708/09/2443
7
8
Purchase Price $ 165,000.00 $ 165,000.00 $ 150,000.00 $162.09
9
Seller Paid Commission $ 4,950.00 $ 4,950.00 $ 4,950.00
10
Buyer Paid Commission $ - $ - $ - Notes:
11
Closing Costs $ 4,125.00 $ 4,125.00 $ 4,125.00
12
Renovations $ 33,020.00 $ 33,020.00 $ 33,020.00
13
Furniture/ Set Up (Padsplit) - 1.5k per room $ - $ - $ -
14
Total initial investment $ 202,145.00 $ 202,145.00 $ 187,145.00
15
16
Rent Amount
(Monthly: Master w/ensuite=$1140, Regular=$710)		 $ 1,800.00 $ 1,950.00 $ 1,800.00
17
18
Annual Income
19
Gross Revenue $ 21,600.00 $ 23,400.00 $ 21,600.00
20
Vacancy 10% $ (2,160.00) $ (2,340.00) $ (2,160.00)
21
Total Income $ 19,440.00 $ 21,060.00 $ 19,440.00
22
23
Annual Expenses
24
Property Management Fee's (Padsplit=$40/room) $ 1,140.00 $ 1,140.00 $ 1,140.00
25
HOA Fees $ - $ - $ -
26
Property Tax $ 3,617.00 $ 3,617.00 $ 3,617.00
27
Insurance $ 1,300.00 $ 1,300.00 $ 1,300.00
28
Maintenance $ 1,500.00 $ 1,500.00 $ 1,500.00
29
Utilities
($65=internet, 155$=gas, 120$=landscaping, about 1k/month)
 $ - $ - $ -
30
Misc. $ 750.00 $ 750.00 $ 750.00
31
Padsplit Managment (~12% of Gross Revenue) $ - $ - $ -
32
Total Expenses $ 8,307.00 $ 8,307.00 $ 8,307.00
33
NOI before debt $ 11,133.00 $ 12,753.00 $ 11,133.00 Added SQF: $0.00
34
CAP Rate (All Cash)5.5%6.3%5.9%
35
Cost vs ARV percentage76%76%70%
36
37
Mortgage Calculator
38
Principal $ 123,750.00 $ 123,750.00 $ 112,500.00
39
Down Payment (Cash Basis) $ 41,250.00 $ 41,250.00 $ 37,500.00
40
Interest Rate (%)7%7%7.00%
41
Life Loan (In Years)303030
42
Number of Payments per year121212
43
Total # of Payments360360360
44
Payment per period (Actual payment) $ 823.31 $ 823.31 $ 748.47
45
Debt Service $ 9,879.74 $ 9,879.74 $ 8,981.58
46
NOI after debt $ 1,253.26 $ 2,873.26 $ 2,151.42
47
Cash on Cash Return1.60%3.67%2.88%
48
49
Cash Needed to Close (Purchase) $50,325.00$50,325.00$46,575.00
50
Cash needed to Reno/Set Up$33,020.00$33,020.00$33,020.00
51
All in Cash for the deal $83,345.00$83,345.00$79,595.00
52
53
Date Inspected:
54
Inspector:
55
Approximate Renovation Costs:
56
Inspection Notes:
57
58
59
Value at 10% CAP $ 111,330.00 $ 127,530.00 $ 111,330.00
60
Value at 9% CAP $ 123,700.00 $ 141,700.00 $ 123,700.00
61
Value at 8% CAP $ 139,162.50 $ 159,412.50 $ 139,162.50
62
Value at 7% CAP $ 159,042.86 $ 182,185.71 $ 159,042.86
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