ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions: Please download a copy of this template sheet to make modifications. The yellow cells are where you enter numbers and the other cells use formulas for calculations. Please note that this is a work in progress, and edits will be made reguarly. Please revisit the original document for the most recent version.
2
DescriptionValueSourceNotes
3
AddressSee Source
9260 Bush Poppy Ave
4
Purchase Price$415,000.00
https://www.redfin.com/NV/Las-Vegas/9260-Bush-Poppy-Ave-89147/home/29558044
5
Square Feet2,092
https://www.redfin.com/NV/Las-Vegas/9260-Bush-Poppy-Ave-89147/home/29558044
6
Dollars per square foot$198.37Calculated
7
Repair Cost$0.00
8
ARV (After Repair Value)$415,000.00
9
Appraiser Cost$800.00
10
Inspector Cost$500.00
11
Down Payment %5.00%
12
Down Payment$20,750.00Calculated (5%)
13
Closing Costs$15,617.00
https://www.bankofamerica.com/mortgage/closing-costs-calculator/
14
Total Cost (Purchase)$37,667.00Calculated
15
16
Total Financed$394,250.00Calculated
17
Interest Rate5.800%
18
Interest Rate (Month)0.483%Calculated
19
Term (Years)30
20
Number of Payments360Calculated
21
Estimated Mortgage$2,313.27Calculated
22
23
Estimated Mortgage/Month$2,313.27
https://www.realtor.com/realestateandhomes-detail/2186-Maple-Shade-St_Henderson_NV_89002_M14189-73263
24
Estimated Mortgage/Year$27,759.29Calculated
25
Property Taxes/Month (0.550% of Purchase Price)$190.21
https://smartasset.com/taxes/nevada-property-tax-calculator
26
Homeowner's Insurance/Month$128.75
https://www.moneygeek.com/insurance/homeowners/calculator-estimate-home-insurance-cost/
27
Repairs/Month$345.83
1% of purchase price/year
28
Private Mortgage Insurance $105.00
https://www.nerdwallet.com/article/mortgages/pmi-calculator
29
HOA Dues$50.00See Source
30
Utilities$300.00
Call utility companies to get averages (gas, power, electricity, trash, sewer, internet)
31
Total Estimated Monthly Expenses$1,119.79Calculated
32
Total Estimated Monthly Expenses + Loan Expense$3,433.07Calculated
33
34
Year house was built
Remember, shingle roofs are replaced on average once every 20 years.
35
Neighborhood (Exceptional/Good/Average/Fair/Poor; A/B/C/D/F)
36
Can put another wall up to increase number of bedrooms?
37
Asbestos Ceiling (in most homes before 1980s)?
38
Lead Pipes (Outlawed after 1986)
39
Lead Paint (Outlawed after 1978)
40
Las Vegas average dollars per square foot (2022)$234
41
Crime
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