Jan 14Feb 14Mar 14Apr 14May 14Jun 14Jul 14Aug 14Sep 14Oct 14Nov 14Dec 14Ttl 14
Gross Incomehide
201 Office (10000 sf)$12,880$13,267$13,267$13,267$13,267$13,267$13,267$13,267$13,267$13,267$13,267$13,267$158,814
102 Drug Store (7500 sf)$10,025$10,025$10,025$10,025$10,325$10,325$10,325$10,325$10,325$10,325$10,325$10,325$122,701
103 Beauty Salon (2000 sf)$3,010$3,010$3,010$3,010$3,010$3,010$3,010$3,010$3,010$3,010$3,100$3,108$36,309
104 Donuts (2000 sf)$3,025$3,025$3,025$3,025$3,025$3,025$3,025$3,025$3,025$3,025$3,025$3,025$36,299
105 Flowers (1000 sf)$1,494$1,494$1,494$1,494$1,494$1,494$1,494$1,539$1,539$1,539$1,539$1,539$18,152
Base Rental Revenue$30,434$30,820$30,820$30,820$31,121$31,121$31,121$31,166$31,166$31,166$31,256$31,264$372,275
Percentage Rent$481$481$481$481$481$481$481$481$481$481$481$481$5,766
Total Reimbursements$3,900$3,900$3,900$3,900$3,900$3,900$3,900$3,900$3,900$3,900$3,900$3,900$46,800
Total Gross Income$34,814$35,201$35,201$35,201$35,502$35,502$35,502$35,546$35,546$35,546$35,637$35,644$424,841
Less: Vacancy & Credit Loss$0$0$0$0$0$0$0$0$0$0$3,678$0$3,678
Effective Income$34,814$35,201$35,201$35,201$35,502$35,502$35,502$35,546$35,546$35,546$31,959$35,644$421,164
Less: Expenseshide
Maintenance$1,134$1,134$1,134$1,134$1,134$1,134$1,134$1,134$1,134$1,134$1,134$1,134$13,612
Insurance$514$514$514$514$514$514$514$514$514$514$514$514$6,164
Property Taxes$2,815$2,815$2,815$2,815$2,815$2,815$2,815$2,815$2,815$2,815$2,815$2,815$33,785
Security$299$299$299$299$299$299$299$299$299$299$299$299$3,582
Utilities$338$338$338$338$338$338$338$338$338$338$338$338$4,060
Management Fee$1,393$1,393$1,393$1,393$1,393$1,393$1,393$1,393$1,393$1,393$1,393$1,393$16,717
Total Operating Expenses$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$77,920
Net Operating Income$28,321$28,707$28,707$28,707$29,008$29,008$29,008$29,053$29,053$29,053$25,466$29,151$343,243
Less: Debt Servicehide
Loan$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$227,991
Total Debt Service$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$18,999$227,991
Net Operating Cash Flow$9,322$9,708$9,708$9,708$10,009$10,009$10,009$10,054$10,054$10,054$6,466$10,152$115,252
Less: Capital Spendinghide
Market TI's$0$0$0$0$0$0$0$0$0$0$0$2,454$2,454
Market Commissions$0$0$0$0$0$0$0$0$0$0$0$1,153$1,153
Total Capital Spending$0$0$0$0$0$0$0$0$0$0$0$3,606$3,606
Cash Flow Before Tax$9,322$9,708$9,708$9,708$10,009$10,009$10,009$10,054$10,054$10,054$6,466$6,545$111,646
Taxable Income and Taxes
(Losses Taken Currently)
Taxable Revenues$34,814$35,201$35,201$35,201$35,502$35,502$35,502$35,546$35,546$35,546$31,959$35,644$421,164
Less: Deducted Expenses$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$6,493$77,920
Less: Interest Expense$12,777$12,736$12,694$12,652$12,610$12,567$12,524$12,481$12,437$12,394$12,350$12,305$150,526
Less: Amortized Points$95$95$95$95$95$95$95$95$95$95$95$95$1,136
Less: Depreciation$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,095$6,140$73,475
Ordinary Income$9,325$9,753$9,795$9,837$10,180$10,223$10,266$10,354$10,397$10,441$6,927$10,611$118,107
Taxable Income$9,325$9,753$9,795$9,837$10,180$10,223$10,266$10,354$10,397$10,441$6,927$10,611$118,107
Taxes Due (- = Savings)$3,870$4,048$4,065$4,082$4,225$4,242$4,260$4,297$4,315$4,333$2,875$4,403$49,015
Cash Flow After Tax$5,452$5,661$5,643$5,626$5,784$5,767$5,749$5,757$5,739$5,721$3,592$2,142$62,631