Jan 19Feb 19Mar 19Apr 19May 19Jun 19Jul 19Aug 19Sep 19Oct 19Nov 19Dec 19Ttl 19
Gross Incomehide
100 Pharmacy (5000 sf)$12,347$12,347$12,347$12,347$12,347$12,347$12,347$12,594$12,594$12,594$12,594$12,594$149,394
101 Lab Tech (2500 sf)$6,173$6,173$6,173$6,173$6,173$6,173$6,173$6,297$6,297$6,297$6,297$6,297$74,697
102 Dentist (2500 sf)$7,420$7,420$7,420$7,420$7,420$7,420$7,420$7,420$7,569$7,569$7,569$7,569$89,636
201 Medical (5000 sf)$12,560$12,560$12,560$12,811$12,811$12,811$12,811$12,811$12,811$12,811$12,811$12,811$152,977
202 Medical (2500 sf)$6,342$6,342$6,342$6,342$6,342$6,342$6,342$6,342$6,342$6,469$6,469$6,469$76,489
203 Medical (2500 sf)$6,601$6,733$6,733$6,733$6,733$6,733$6,733$6,733$6,733$6,733$6,733$6,733$80,670
Base Rental Revenue$51,444$51,576$51,576$51,827$51,827$51,827$51,827$52,197$52,346$52,472$52,472$52,472$623,863
Reimbursement Detailhide
Reimb Taxes$641$641$641$641$641$641$641$641$641$641$641$641$7,693
Reimb Insurance$112$112$112$112$112$112$112$112$112$112$112$112$1,349
Reimb Common Area Maintenance$209$209$209$209$209$209$209$218$218$218$218$218$2,555
Reimb Managment Fee$1,606$1,606$1,606$1,606$1,606$1,606$1,606$1,701$1,701$1,701$1,701$1,701$19,749
Total Reimbursements$2,569$2,569$2,569$2,569$2,569$2,569$2,569$2,672$2,672$2,672$2,672$2,672$31,347
Total Gross Income$54,013$54,145$54,145$54,396$54,396$54,396$54,396$54,870$55,018$55,145$55,145$55,145$655,209
Less: Vacancy & Credit Loss$0$0$0$0$0$0$0$0$0$0$0$0$0
Effective Income$54,013$54,145$54,145$54,396$54,396$54,396$54,396$54,870$55,018$55,145$55,145$55,145$655,209
Less: Expenseshide
Taxes$1,270$1,270$1,270$1,270$1,270$1,270$1,270$1,270$1,270$1,270$1,270$1,270$15,237
Insurance$220$220$220$220$220$220$220$220$220$220$220$220$2,637
Common Area Maintenance$415$415$415$415$415$415$415$423$423$423$423$423$5,021
Managment Fee$3,167$3,167$3,167$3,167$3,167$3,167$3,167$3,262$3,262$3,262$3,262$3,262$38,478
Reserve$199$199$199$199$199$199$199$199$199$199$199$199$2,390
Total Operating Expenses$5,271$5,271$5,271$5,271$5,271$5,271$5,271$5,374$5,374$5,374$5,374$5,374$63,764
Net Operating Income$48,742$48,874$48,874$49,125$49,125$49,125$49,125$49,496$49,644$49,771$49,771$49,771$591,445
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$21,254$21,386$21,386$21,637$21,637$21,637$21,637$22,008$22,156$22,283$22,283$22,283$261,587
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$0$0$0$0$0$0$0$0$0$0$0$0
Market Commissions$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Capital Spending$0$0$0$0$0$0$0$0$0$0$0$0$0
Cash Flow Before Tax$21,254$21,386$21,386$21,637$21,637$21,637$21,637$22,008$22,156$22,283$22,283$22,283$261,587
Taxable Income and Taxes
(Losses Carried Forward)
Taxable Revenues$54,013$54,145$54,145$54,396$54,396$54,396$54,396$54,870$55,018$55,145$55,145$55,145$655,209
Less: Deducted Expenses$5,271$5,271$5,271$5,271$5,271$5,271$5,271$5,374$5,374$5,374$5,374$5,374$63,764
Less: Interest Expensehide
Permanent$15,312$15,241$15,170$15,098$15,026$14,953$14,880$14,806$14,732$14,658$14,583$14,508$178,966
Total Interest Expense$15,312$15,241$15,170$15,098$15,026$14,953$14,880$14,806$14,732$14,658$14,583$14,508$178,966
Less: Depreciationhide
Construction Spending$2,509$2,509$2,509$2,509$2,509$2,509$2,509$2,509$2,509$2,509$2,509$2,509$30,107
Hard Cost Contigency$73$73$73$73$73$73$73$73$73$73$73$73$878
General Conditions$84$84$84$84$84$84$84$84$84$84$84$84$1,004
Trash Enclosures$20$20$20$20$20$20$20$20$20$20$20$20$238
Clearing & Grading$48$48$48$48$48$48$48$48$48$48$48$48$577
Storm Drainage$73$73$73$73$73$73$73$73$73$73$73$73$878
Site Concrete$48$48$48$48$48$48$48$48$48$48$48$48$577
Sub Base paving$63$63$63$63$63$63$63$63$63$63$63$63$753
Building Pad stabalization$21$21$21$21$21$21$21$21$21$21$21$21$251
Site Utilities$52$52$52$52$52$52$52$52$52$52$52$52$627
Site Electric-Lighting$84$84$84$84$84$84$84$84$84$84$84$84$1,004
Signage$52$52$52$52$52$52$52$52$52$52$52$52$627
Landscape & Irrigation$42$42$42$42$42$42$42$42$42$42$42$42$502
Contg.$63$63$63$63$63$63$63$63$63$63$63$63$753
Sewer Capacity$10$10$10$10$10$10$10$10$10$10$10$10$125
Water Fee's$4$4$4$4$4$4$4$4$4$4$4$4$50
Electricial Fee's$10$10$10$10$10$10$10$10$10$10$10$10$125
Permits-Zoning-Review Fee's$6$6$6$6$6$6$6$6$6$6$6$6$75
Plan Copies$1$1$1$1$1$1$1$1$1$1$1$1$13
Developers Liability Insurance$25$25$25$25$25$25$25$25$25$25$25$25$301
Architects$136$136$136$136$136$136$136$136$136$136$136$136$1,631
Civil Engineering$46$46$46$46$46$46$46$46$46$46$46$46$552
Landscape Design$5$5$5$5$5$5$5$5$5$5$5$5$63
Reimbursable Architects$9$9$9$9$9$9$9$9$9$9$9$9$113
Legal$94$94$94$94$94$94$94$94$94$94$94$94$1,129
Travel to site$2$2$2$2$2$2$2$2$2$2$2$2$20
Construction Management Fee$16$16$16$16$16$16$16$16$16$16$16$16$188
Appraisal$9$9$9$9$9$9$9$9$9$9$9$9$113
Survey$7$7$7$7$7$7$7$7$7$7$7$7$88
Title Insurance$7$7$7$7$7$7$7$7$7$7$7$7$88
General Contigency$63$63$63$63$63$63$63$63$63$63$63$63$753
TI for First Floor$1,045$1,045$1,045$1,045$1,045$1,045$1,045$1,045$1,045$1,045$1,045$1,045$12,545
Commisions for First Floor$251$251$251$251$251$251$251$251$251$251$251$251$3,011
Market TI's$848$848$848$848$848$848$848$848$848$848$848$848$10,180
Market Commissions$364$364$364$364$364$364$364$364$364$364$364$364$4,365
Total Depreciation$6,192$6,192$6,192$6,192$6,192$6,192$6,192$6,192$6,192$6,192$6,192$6,192$74,303
Ordinary Income$27,238$27,441$27,513$27,836$27,908$27,981$28,054$28,498$28,720$28,921$28,996$29,071$338,176
Taxable Income$27,238$27,441$27,513$27,836$27,908$27,981$28,054$28,498$28,720$28,921$28,996$29,071$338,176
(Cum Suspended Losses)$0$0$0$0$0$0$0$0$0$0$0$0$0
Taxes Due (- = Savings)$9,533$9,604$9,629$9,742$9,768$9,793$9,819$9,974$10,052$10,122$10,149$10,175$118,362
Cash Flow After Tax$11,721$11,782$11,757$11,895$11,869$11,844$11,818$12,033$12,104$12,160$12,134$12,108$143,226