Jan 17Feb 17Mar 17Apr 17May 17Jun 17Jul 17Aug 17Sep 17Oct 17Nov 17Dec 17Ttl 17
Gross Incomehide
201 Office (10000 sf)$1.41$1.41$1.45$1.45$1.45$1.45$1.45$1.45$1.45$1.45$1.45$1.45$17.35
102 Drug Store (7500 sf)$1.46$1.46$1.46$1.46$1.50$1.50$1.50$1.50$1.50$1.50$1.50$1.50$17.88
103 Beauty Salon (2000 sf)$1.65$1.65$1.65$1.65$1.65$1.65$1.65$1.65$1.65$1.65$1.65$1.70$19.83
104 Donuts (2000 sf)$1.61$1.66$1.66$1.66$1.66$1.66$1.66$1.66$1.66$1.66$1.66$1.66$19.83
105 Flowers (1000 sf)$1.64$1.64$1.64$1.64$1.64$1.64$1.64$1.64$1.69$1.69$1.69$1.69$19.83
Base Rental Revenue$1.66$1.67$1.69$1.69$1.70$1.70$1.70$1.70$1.71$1.71$1.71$1.71$22.03
Percentage Rent$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.36
Total Reimbursements$0.20$0.20$0.20$0.20$0.20$0.20$0.20$0.20$0.20$0.20$0.20$0.20$2.65
Total Gross Income$1.89$1.90$1.92$1.92$1.93$1.93$1.93$1.93$1.94$1.94$1.94$1.94$25.05
Less: Vacancy & Credit Loss$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.20$0.22
Effective Income$1.89$1.90$1.92$1.92$1.93$1.93$1.93$1.93$1.94$1.94$1.94$1.74$24.83
Less: Expenseshide
Maintenance$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.81
Insurance$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.39
Property Taxes$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.94
Security$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.21
Utilities$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.24
Management 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$0.99
Total Operating Expenses$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$4.58
Net Operating Income$1.54$1.55$1.57$1.57$1.58$1.58$1.58$1.58$1.59$1.59$1.59$1.39$20.25
Less: Debt Servicehide
Loan$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$12.35
Total Debt Service$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$0.95$12.35
Net Operating Cash Flow$0.59$0.60$0.62$0.62$0.63$0.63$0.63$0.63$0.64$0.64$0.64$0.44$7.90
Less: Capital Spendinghide
Market TI'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
Market Commissions$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
Total Capital 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
Cash Flow Before Tax$0.59$0.60$0.62$0.62$0.63$0.63$0.63$0.63$0.64$0.64$0.64$0.44$7.90
Taxable Income and Taxes
(Losses Taken Currently)
Taxable Revenues$1.89$1.90$1.92$1.92$1.93$1.93$1.93$1.93$1.94$1.94$1.94$1.74$24.83
Less: Deducted Expenses$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$0.35$4.58
Less: Interest Expense$0.55$0.55$0.55$0.55$0.54$0.54$0.54$0.54$0.53$0.53$0.53$0.52$7.02
Less: Amortized Points$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
Less: Depreciation$0.28$0.28$0.28$0.28$0.28$0.28$0.28$0.28$0.28$0.28$0.28$0.28$3.59
Ordinary Income$0.70$0.71$0.74$0.74$0.76$0.76$0.76$0.77$0.77$0.77$0.78$0.58$9.58
Taxable Income$0.70$0.71$0.74$0.74$0.76$0.76$0.76$0.77$0.77$0.77$0.78$0.58$9.58
Taxes Due (- = Savings)$0.29$0.30$0.31$0.31$0.31$0.32$0.32$0.32$0.32$0.32$0.32$0.24$3.98
Cash Flow After Tax$0.30$0.30$0.31$0.31$0.32$0.32$0.32$0.32$0.32$0.31$0.31$0.20$3.93