1% Deal Calc
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
Made by Elliott Elkhoury- contact: www.acenwi.com / elliott@acenwi.com
2
3
Unit BreakdownPresent Pro Forma Analysis
4
5
Unit ##BedsRent/Mo
Market Rent
Item$/Mo.
Mortgage Calculator
6
12 $ 1,000.00 $ 1,000.00 Gross Rents $ 2,000.00 Property Value $ 200,000.00
7
22 $ 1,000.00 $ 1,000.00 Property Mgmt (9%) $ 180.00 Loan to Value Ratio0.8
8
Property Taxes $ 166.67 Down Payment $ 40,000.00
9
Insurance $ 100.00 Closing Costs $ -
10
Owner-Paid Utilities $ 120.00 Principal $ 160,000.00
11
Vacancy Reserve (5%) $ 100.00 Interest Rate0.0599
12
Maintenance Reserve (10%)
$ 200.00 Term (Years) 25
13
Total Operating Expenses
$ 866.67
Monthly Mortgage
$ 1,029.90
14
$ - Monthly NOI $ 1,133.33 Monthly Net $ 103.43
15
Totals $ 2,000.00 $ 2,000.00 Annualized NOI $ 13,600.00 Annualized Net $ 1,241.15
16
Capitalization Rate6.80%Annualized ROI3.10%
17
Does it qualify for a loan?
18
Stabilized Pro Forma Analysis
19
Pro FormaActual
20
Gross Rents$24,000.00$24,000.00Item$/Mo.
Mortgage Calculator
21
Lender Vacancy (10%)$2,400.00$2,400.00Gross Potential Rents $ 2,000.00 Property Value $ 200,000.00
22
Property Management (9%)$2,160.00$2,160.00Property Mgmt (9%) $ 180.00 Loan to Value Ratio0.8
23
Cash Res (3%)$720.00$720.00Property Taxes $ 166.67 Down Payment $ 40,000.00
24
Taxes (actual)$2,000.00$2,000.00Insurance $ 100.00 Closing Costs
25
Ins (actual)$1,200.00$1,200.00Owner-Paid Utilities $ 120.00 Principal $ 160,000.00
26
Util + Rep (20% or actual)$4,800.00$3,840.00Vacancy Reserve (5%) $ 100.00 Interest Rate0.0599
27
Total Expenses$13,280.00$12,320.00
Maintenance Reserve (10%)
$ 200.00 Term (Years) 25
28
NOI$10,720.00$11,680.00Monthly Mortgage $ 1,029.90
29
Mortgage$12,358.85$12,358.85Monthly NOI $ 1,133.33 Monthly Net $ 103.43
30
Annualized NOI $ 13,600.00 Annualized Net $ 1,241.15
31
Capitalization Rate6.80%Annualized ROI3.10%
32
DSCR (lender requires 1.25)0.870.95
33
Net Profit-$1,638.85-$678.85
34
35
36
37
38
39
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
Loading...