Financing the New Real Estate ... Save As Excel | 
Loading...
Updating...
Please wait to edit...
Ready for editing X
 
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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
Capital Expenditures:
Demolition/Office Buildout$100,000
Furniture20,000
Appliances5,000
TV / Computers / Electronics15,000
Electrical / Networking3,000
Plumbing3,000
x0
x0
Architect/Space Planner0
Other/Contingency15,000
Sum Total$161,000
Buildout $/sf$117.69
Lease Savings
Current Annual Rent$80,000
Square Footage4,000
$/sf$20.00
New Square Footage1,368
New Annual Rent$27,360 Overwrite actual rent into cell C20 if needed
Savings$52,640
Productivity Change
Recruiting of New Agents:
GCI$20,000
Split50%
Company Dollar$10,000
Loss of Existing Agents:
GCI$50,000 Make all numbers positive (formula will subtract)
Split65%
Company Dollar$17,500
Net Company Dollar Change($7,500)
Total Costs$161,000
Total Savings (net of Production Change)$45,140
Return on Investment (ROI) *28.0%
Payback Period *3.6 years
* Analysis does not include tax benefits (e.g., depreciation of CapEx)
Other Cost Considerations:
Will a temporary location be needed during renovation?
Permits
Office 1
Office 2
Office 3
 
      0
powered by ZOHOSheet
Processing...
Assign Macro Edit Label More