ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Purchase Info
4
Address123 Sample LanePurchase Price*$119,900
5
City/State/Zip
Townsville, NV 90210Building Cost$109,900
6
MLS #123456Land Cost🡐 unsure?$10,000
7
Square Feet:1,784Beds:3Baths:2After Renovation Value*$120,000
8
Other NotesAnnual Property Taxes*$1,416
9
Estimated Renovation Costs
10
Amortization Period27.5
11
12
13
Closing Costs
14
Cash Purchase?*
NoPrepaid Insurance
15
Down Payment (as percentage)
3.50%Prepaid Property Taxes
16
or- Fixed down payment amount
Annual Asmnts, HOA, Etc
17
Loan Amount$115,704Title and Escrow Fees$2,000
18
Loan Interest Rate
4.30%Attorney Charges$1,000
19
Points Charged by Lender
1Inspection Cost$500
20
Other Charges From Lender
2200Recording Fees
21
Wrap loan fees/points into loan?
NoAppraisal Fee$350
22
Loan Duration (Years)
30Other Fees/Charges$1,000
23
Total$4,850
24
25
26
27
28
Future Assumptions
29
Rent$1,550Rent Escalation (%)3.00%
30
Other Income$0Market Appreciation (%)3.00%
31
Total$1,550Inflation (%)3.00%
32
Property Sale Costs (%)10.00%
33
34
35
Uncertainty Range
36
Electricity0#ERROR!
37
WaterRent Range10%
38
SewerVacancy Range6%
39
Trash60Ongoing Repair Costs4%
40
HOACapEx10%
41
Monthly Insurance
55Property Management8%
42
Property Taxes (calculated)
118
43
Principal and Interest
628
44
Vacancy (%)8%
45
Repairs and Maintenance (%)
10%
46
CapEx (%)5%
47
Property Management (%)
10%
48
Total$1,373
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