Jan 11Feb 11Mar 11Apr 11May 11Jun 11Jul 11Aug 11Sep 11Oct 11Nov 11Dec 11Ttl 11
Gross Incomehide
100 Pharmacy (5000 sf)$10,417$10,417$10,417$10,417$10,417$10,417$10,417$10,417$10,417$10,417$10,417$10,417$125,000
101 Lab Tech (2500 sf)$5,208$5,208$5,208$5,208$5,208$5,208$5,208$5,208$5,208$5,208$5,208$5,208$62,500
102 Dentist (2500 sf)$6,250$6,250$6,250$6,250$6,250$6,250$6,250$6,250$6,250$6,250$6,250$6,250$75,000
201 Medical (5000 sf)$10,590$10,643$10,643$10,643$10,643$10,643$10,643$10,643$10,643$10,643$10,643$10,643$127,658
202 Medical (2500 sf)$5,625$5,747$5,747$5,747$5,747$5,747$5,747$5,804$5,804$5,804$5,804$5,804$69,128
203 Medical (2500 sf)$5,625$5,625$5,625$5,625$5,775$5,775$5,775$5,775$5,775$5,775$5,775$5,775$68,704
Base Rental Revenue$43,715$43,890$43,890$43,890$44,040$44,040$44,040$44,097$44,097$44,097$44,097$44,097$527,990
Reimbursement Detailhide
Reimb Taxes$553$553$553$553$553$553$553$553$553$553$553$553$6,630
Reimb Insurance$78$78$78$78$78$78$78$78$78$78$78$78$935
Reimb Common Area Maintenance$177$177$177$177$177$177$177$184$184$184$184$184$2,160
Reimb Managment Fee$1,250$1,250$1,250$1,250$1,250$1,250$1,250$1,325$1,325$1,325$1,325$1,325$15,375
Total Reimbursements$2,058$2,058$2,058$2,058$2,058$2,058$2,058$2,140$2,140$2,140$2,140$2,140$25,100
Total Gross Income$45,772$45,947$45,947$45,947$46,098$46,098$46,098$46,237$46,237$46,237$46,237$46,237$553,090
Less: Vacancy & Credit Loss$23,883$12,394$12,394$12,394$12,544$12,544$12,544$6,297$6,297$6,297$6,297$6,297$130,180
Effective Income$21,889$33,553$33,553$33,553$33,553$33,553$33,553$39,940$39,940$39,940$39,940$39,940$422,910
Less: Expenseshide
Taxes$1,084$1,084$1,084$1,084$1,084$1,084$1,084$1,084$1,084$1,084$1,084$1,084$13,005
Insurance$149$149$149$149$149$149$149$149$149$149$149$149$1,785
Common Area Maintenance$354$354$354$354$354$354$354$361$361$361$361$361$4,285
Managment Fee$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,575$2,575$2,575$2,575$2,575$30,375
Reserve$170$170$170$170$170$170$170$170$170$170$170$170$2,040
Total Operating Expenses$4,257$4,257$4,257$4,257$4,257$4,257$4,257$4,339$4,339$4,339$4,339$4,339$51,490
Net Operating Income$17,633$29,297$29,297$29,297$29,297$29,297$29,297$35,601$35,601$35,601$35,601$35,601$371,420
Less: Debt Servicehide
Permanent$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$329,858
Total Debt Service$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$27,488$329,858
Net Operating Cash Flow($9,856)$1,809$1,809$1,809$1,809$1,809$1,809$8,113$8,113$8,113$8,113$8,113$41,562
Less: Capital Spendinghide
Land Purchase$0$0$0$0$0$0$0$0$0$0$0$0$0
Construction Spending$0$0$0$0$0$0$0$0$0$0$0$0$0
Hard Cost Contigency$0$0$0$0$0$0$0$0$0$0$0$0$0
General Conditions$0$0$0$0$0$0$0$0$0$0$0$0$0
Trash Enclosures$0$0$0$0$0$0$0$0$0$0$0$0$0
Clearing & Grading$0$0$0$0$0$0$0$0$0$0$0$0$0
Storm Drainage$0$0$0$0$0$0$0$0$0$0$0$0$0
Site Concrete$0$0$0$0$0$0$0$0$0$0$0$0$0
Sub Base paving$0$0$0$0$0$0$0$0$0$0$0$0$0
Building Pad stabalization$0$0$0$0$0$0$0$0$0$0$0$0$0
Site Utilities$0$0$0$0$0$0$0$0$0$0$0$0$0
Site Electric-Lighting$0$0$0$0$0$0$0$0$0$0$0$0$0
Signage$0$0$0$0$0$0$0$0$0$0$0$0$0
Landscape & Irrigation$0$0$0$0$0$0$0$0$0$0$0$0$0
Contg.$0$0$0$0$0$0$0$0$0$0$0$0$0
Sewer Capacity$0$0$0$0$0$0$0$0$0$0$0$0$0
Water Fee's$0$0$0$0$0$0$0$0$0$0$0$0$0
Electricial Fee's$0$0$0$0$0$0$0$0$0$0$0$0$0
Permits-Zoning-Review Fee's$0$0$0$0$0$0$0$0$0$0$0$0$0
Plan Copies$0$0$0$0$0$0$0$0$0$0$0$0$0
Developers Liability Insurance$0$0$0$0$0$0$0$0$0$0$0$0$0
Architects$0$0$0$0$0$0$0$0$0$0$0$0$0
Civil Engineering$0$0$0$0$0$0$0$0$0$0$0$0$0
Landscape Design$0$0$0$0$0$0$0$0$0$0$0$0$0
Reimbursable Architects$0$0$0$0$0$0$0$0$0$0$0$0$0
Legal$0$0$0$0$0$0$0$0$0$0$0$0$0
Travel to site$0$0$0$0$0$0$0$0$0$0$0$0$0
Construction Management Fee$0$0$0$0$0$0$0$0$0$0$0$0$0
Appraisal$0$0$0$0$0$0$0$0$0$0$0$0$0
Survey$0$0$0$0$0$0$0$0$0$0$0$0$0
Title Insurance$0$0$0$0$0$0$0$0$0$0$0$0$0
General Contigency$0$0$0$0$0$0$0$0$0$0$0$0$0
TI for First Floor$0$0$0$0$0$0$0$0$0$0$0$0$0
Commisions for First Floor$0$0$0$0$0$0$0$0$0$0$0$0$0
Market TI's$0$127,711$0$0$0$0$0$77,389$0$0$0$0$205,099
Market Commissions$0$47,472$0$0$0$0$0$18,123$0$0$0$0$65,595
Total Capital Spending$0$175,182$0$0$0$0$0$95,512$0$0$0$0$270,694
Cash Flow Before Tax($9,856)($173,374)$1,809$1,809$1,809$1,809$1,809($87,399)$8,113$8,113$8,113$8,113($229,132)
Taxable Income and Taxes
(Losses Carried Forward)
Taxable Revenues$21,889$33,553$33,553$33,553$33,553$33,553$33,553$39,940$39,940$39,940$39,940$39,940$422,910
Less: Deducted Expenses$4,257$4,257$4,257$4,257$4,257$4,257$4,257$4,339$4,339$4,339$4,339$4,339$51,490
Less: Interest Expensehide
Permanent$20,522$20,481$20,440$20,399$20,358$20,316$20,274$20,232$20,190$20,147$20,105$20,062$243,527
Total Interest Expense$20,522$20,481$20,440$20,399$20,358$20,316$20,274$20,232$20,190$20,147$20,105$20,062$243,527
Less: Depreciationhide
Construction Spending$2,618$2,618$2,618$2,618$2,618$2,618$2,618$2,618$2,618$2,618$2,618$2,618$31,416
Hard Cost Contigency$76$76$76$76$76$76$76$76$76$76$76$76$916
General Conditions$87$87$87$87$87$87$87$87$87$87$87$87$1,047
Trash Enclosures$21$21$21$21$21$21$21$21$21$21$21$21$249
Clearing & Grading$50$50$50$50$50$50$50$50$50$50$50$50$602
Storm Drainage$76$76$76$76$76$76$76$76$76$76$76$76$916
Site Concrete$50$50$50$50$50$50$50$50$50$50$50$50$602
Sub Base paving$65$65$65$65$65$65$65$65$65$65$65$65$785
Building Pad stabalization$22$22$22$22$22$22$22$22$22$22$22$22$262
Site Utilities$55$55$55$55$55$55$55$55$55$55$55$55$654
Site Electric-Lighting$87$87$87$87$87$87$87$87$87$87$87$87$1,047
Signage$55$55$55$55$55$55$55$55$55$55$55$55$654
Landscape & Irrigation$44$44$44$44$44$44$44$44$44$44$44$44$524
Contg.$65$65$65$65$65$65$65$65$65$65$65$65$785
Sewer Capacity$11$11$11$11$11$11$11$11$11$11$11$11$131
Water Fee's$4$4$4$4$4$4$4$4$4$4$4$4$52
Electricial Fee's$11$11$11$11$11$11$11$11$11$11$11$11$131
Permits-Zoning-Review Fee's$7$7$7$7$7$7$7$7$7$7$7$7$79
Plan Copies$1$1$1$1$1$1$1$1$1$1$1$1$13
Developers Liability Insurance$26$26$26$26$26$26$26$26$26$26$26$26$314
Architects$142$142$142$142$142$142$142$142$142$142$142$142$1,702
Civil Engineering$48$48$48$48$48$48$48$48$48$48$48$48$576
Landscape Design$5$5$5$5$5$5$5$5$5$5$5$5$65
Reimbursable Architects$10$10$10$10$10$10$10$10$10$10$10$10$118
Legal$98$98$98$98$98$98$98$98$98$98$98$98$1,178
Travel to site$2$2$2$2$2$2$2$2$2$2$2$2$21
Construction Management Fee$16$16$16$16$16$16$16$16$16$16$16$16$196
Appraisal$10$10$10$10$10$10$10$10$10$10$10$10$118
Survey$8$8$8$8$8$8$8$8$8$8$8$8$92
Title Insurance$8$8$8$8$8$8$8$8$8$8$8$8$92
General Contigency$65$65$65$65$65$65$65$65$65$65$65$65$785
TI for First Floor$1,091$1,091$1,091$1,091$1,091$1,091$1,091$1,091$1,091$1,091$1,091$1,091$13,090
Commisions for First Floor$262$262$262$262$262$262$262$262$262$262$262$262$3,142
Market TI's$0$387$387$387$387$387$387$903$903$903$903$903$6,837
Market Commissions$0$308$308$308$308$308$308$671$671$671$671$671$5,203
Total Depreciation$5,196$5,892$5,892$5,892$5,892$5,892$5,892$6,770$6,770$6,770$6,770$6,770$74,395
Ordinary Income($8,086)$2,924$2,965$3,006$3,047$3,089$3,131$8,599$8,641$8,684$8,727$8,770$53,498
Taxable Income$0$0$0$0$0$0$0$0$0$5,405$8,727$8,770$22,902
(Cum Suspended Losses)$0$0$0$0$0$0$0$0$0$0$0$0$0
Taxes Due (- = Savings)$0$0$0$0$0$0$0$0$0$1,892$3,054$3,069$8,016
Cash Flow After Tax($9,856)($173,374)$1,809$1,809$1,809$1,809$1,809($87,399)$8,113$6,221$5,059$5,044($237,148)