ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Please copy this google sheet and save to your drive.
3
4
Input Fields
5
Worksheet for Office in Home
6
Rent Computation
7
Sq. Ft. in home -
8
Sq. Ft. in office (Note 3) -
9
Percentage (see note 1)#DIV/0!
10
11
12
Annual Reimburseable Expenses
13
Utilities (PGE, H20, Garbage) $ -
14
Repairs & maintenance -
15
Insurance -
16
Housekeeper -
17
Gardener -
18
Internet -
19
**Add any other expense here** -
20
**Add any other expense here** -
21
Pool Maintenance -
22
Homeowner Dues -
23
Property Tax
24
Rent paid or Mortgage Interest -
25
Depreciation (see below) -
26
 Total -
27
Reimburseable #DIV/0!
28
29
Cost of home (including improvements)
 $ -
30
Exclude land (25%) See note 2 -
31
Depreciable basis -
32
Depreciation (39 years) $ -
33
34
Note 1 - If garage has a substantial
35
portion of business storage, equip, etc.
36
may want to include the garage in
37
both sides.
38
Note 2 - If a townhouse, exclude 15%,
39
if condominium, exclude 10%
40
Note 3 - If bathroom closely situated,
41
may consider adding to sq. ft.
42
43
44
45
46
47
www.edgysolutions.com
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