Jan 17Feb 17Mar 17Apr 17May 17Jun 17Jul 17Aug 17Sep 17Oct 17Nov 17Dec 17Ttl 17
Gross Incomehide
100 Pharmacy (5000 sf)$2.37$2.37$2.37$2.37$2.37$2.37$2.37$2.42$2.42$2.42$2.42$2.42$28.72
101 Lab Tech (2500 sf)$2.37$2.37$2.37$2.37$2.37$2.37$2.37$2.42$2.42$2.42$2.42$2.42$28.72
102 Dentist (2500 sf)$2.50$2.50$2.50$2.50$2.50$2.50$2.50$2.91$2.91$2.91$2.91$2.91$32.04
201 Medical (5000 sf)$2.35$2.40$2.40$2.40$2.40$2.40$2.40$2.40$2.40$2.40$2.40$2.40$28.72
202 Medical (2500 sf)$2.44$2.44$2.44$2.44$2.44$2.44$2.44$2.44$2.44$2.49$2.49$2.49$29.41
203 Medical (2500 sf)$2.54$2.59$2.59$2.59$2.59$2.59$2.59$2.59$2.59$2.59$2.59$2.59$31.01
Base Rental Revenue$2.41$2.43$2.43$2.43$2.43$2.43$2.43$2.50$2.50$2.51$2.51$2.51$31.97
Reimbursement Detailhide
Reimb Taxes$0.03$0.03$0.03$0.03$0.03$0.03$0.03$0.03$0.03$0.03$0.03$0.03$0.41
Reimb Insurance$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.07
Reimb Common Area Maintenance$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.14
Reimb Managment Fee$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$1.06
Total Reimbursements$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$1.68
Total Gross Income$2.54$2.56$2.56$2.56$2.56$2.56$2.56$2.63$2.63$2.64$2.64$2.64$33.65
Less: Vacancy & Credit Loss$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.36$0.00$0.00$0.00$0.00$0.39
Effective Income$2.54$2.56$2.56$2.56$2.56$2.56$2.56$2.27$2.63$2.64$2.64$2.64$33.26
Less: Expenseshide
Taxes$0.06$0.06$0.06$0.06$0.06$0.06$0.06$0.06$0.06$0.06$0.06$0.06$0.79
Insurance$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.13
Common Area Maintenance$0.02$0.02$0.02$0.02$0.02$0.02$0.02$0.02$0.02$0.02$0.02$0.02$0.26
Managment Fee$0.15$0.15$0.15$0.15$0.15$0.15$0.15$0.15$0.15$0.15$0.15$0.15$1.96
Reserve$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.12
Total Operating Expenses$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$3.27
Net Operating Income$2.29$2.31$2.31$2.31$2.31$2.31$2.31$2.01$2.38$2.38$2.38$2.38$29.98
Less: Debt Servicehide
Permanent$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$17.87
Total Debt Service$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$1.37$17.87
Net Operating Cash Flow$0.92$0.93$0.93$0.93$0.93$0.93$0.93$0.64$1.00$1.01$1.01$1.01$12.11
Less: Capital Spendinghide
Land Purchase$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Construction Spending$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Hard Cost Contigency$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
General Conditions$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Trash Enclosures$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Clearing & Grading$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Storm Drainage$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Site Concrete$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Sub Base paving$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Building Pad stabalization$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Site Utilities$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Site Electric-Lighting$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Signage$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Landscape & Irrigation$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Contg.$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Sewer Capacity$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Water Fee's$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Electricial Fee's$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Permits-Zoning-Review Fee's$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Plan Copies$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Developers Liability Insurance$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Architects$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Civil Engineering$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Landscape Design$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Reimbursable Architects$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Legal$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Travel to site$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Construction Management Fee$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Appraisal$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Survey$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Title Insurance$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
General Contigency$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TI for First Floor$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Commisions for First Floor$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Market TI's$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.29$0.00$0.00$0.00$0.32
Market Commissions$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.16$0.00$0.00$0.00$0.18
Total Capital Spending$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.45$0.00$0.00$0.00$0.49
Cash Flow Before Tax$0.92$0.93$0.93$0.93$0.93$0.93$0.93$0.64$0.55$1.01$1.01$1.01$11.62
Taxable Income and Taxes
(Losses Carried Forward)
Taxable Revenues$2.54$2.56$2.56$2.56$2.56$2.56$2.56$2.27$2.63$2.64$2.64$2.64$33.26
Less: Deducted Expenses$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$0.25$3.27
Less: Interest Expensehide
Permanent$0.84$0.84$0.84$0.84$0.83$0.83$0.83$0.82$0.82$0.82$0.81$0.81$10.76
Total Interest Expense$0.84$0.84$0.84$0.84$0.83$0.83$0.83$0.82$0.82$0.82$0.81$0.81$10.76
Less: Depreciationhide
Construction Spending$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$0.13$1.70
Hard Cost Contigency$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.05
General Conditions$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.06
Trash Enclosures$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.01
Clearing & Grading$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.03
Storm Drainage$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.05
Site Concrete$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.03
Sub Base paving$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.04
Building Pad stabalization$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.01
Site Utilities$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.04
Site Electric-Lighting$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.06
Signage$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.04
Landscape & Irrigation$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.03
Contg.$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.04
Sewer Capacity$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.01
Water Fee's$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Electricial Fee's$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.01
Permits-Zoning-Review Fee's$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Plan Copies$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Developers Liability Insurance$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.02
Architects$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.09
Civil Engineering$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.03
Landscape Design$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Reimbursable Architects$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.01
Legal$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.06
Travel to site$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Construction Management Fee$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.01
Appraisal$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.01
Survey$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Title Insurance$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
General Contigency$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.04
TI for First Floor$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.71
Commisions for First Floor$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.01$0.17
Market TI's$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$0.08$1.05
Market Commissions$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.05$0.65
Total Depreciation$0.39$0.39$0.39$0.39$0.39$0.39$0.39$0.39$0.39$0.39$0.39$0.39$5.08
Ordinary Income$1.06$1.08$1.08$1.08$1.09$1.09$1.09$0.80$1.16$1.17$1.17$1.18$14.15
Taxable Income$1.06$1.08$1.08$1.08$1.09$1.09$1.09$0.80$1.16$1.17$1.17$1.18$14.15
(Cum Suspended Losses)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Taxes Due (- = Savings)$0.37$0.38$0.38$0.38$0.38$0.38$0.38$0.28$0.41$0.41$0.41$0.41$4.95
Cash Flow After Tax$0.55$0.56$0.56$0.55$0.55$0.55$0.55$0.36$0.14$0.60$0.60$0.60$6.67