Jan 17Feb 17Mar 17Apr 17May 17Jun 17Jul 17Aug 17Sep 17Oct 17Nov 17Dec 17Ttl 17
Gross Incomehide
201 Office (10000 sf)$14,109$14,109$14,533$14,533$14,533$14,533$14,533$14,533$14,533$14,533$14,533$14,533$173,545
102 Drug Store (7500 sf)$10,954$10,954$10,954$10,954$11,283$11,283$11,283$11,283$11,283$11,283$11,283$11,283$134,078
103 Beauty Salon (2000 sf)$3,297$3,297$3,297$3,297$3,297$3,297$3,297$3,297$3,297$3,297$3,297$3,396$39,666
104 Donuts (2000 sf)$3,217$3,314$3,314$3,314$3,314$3,314$3,314$3,314$3,314$3,314$3,314$3,314$39,666
105 Flowers (1000 sf)$1,637$1,637$1,637$1,637$1,637$1,637$1,637$1,637$1,686$1,686$1,686$1,686$19,834
Base Rental Revenue$33,214$33,311$33,734$33,734$34,063$34,063$34,063$34,063$34,112$34,112$34,112$34,211$406,791
Percentage Rent$561$561$561$561$561$561$561$561$561$561$561$561$6,731
Total Reimbursements$4,075$4,075$4,075$4,075$4,075$4,075$4,075$4,075$4,075$4,075$4,075$4,075$48,906
Total Gross Income$37,851$37,947$38,371$38,371$38,699$38,699$38,699$38,699$38,748$38,748$38,748$38,847$462,428
Less: Vacancy & Credit Loss$0$0$0$0$0$0$0$0$0$0$0$4,022$4,022
Effective Income$37,851$37,947$38,371$38,371$38,699$38,699$38,699$38,699$38,748$38,748$38,748$34,825$458,406
Less: Expenseshide
Maintenance$1,240$1,240$1,240$1,240$1,240$1,240$1,240$1,240$1,240$1,240$1,240$1,240$14,874
Insurance$595$595$595$595$595$595$595$595$595$595$595$595$7,136
Property Taxes$2,988$2,988$2,988$2,988$2,988$2,988$2,988$2,988$2,988$2,988$2,988$2,988$35,853
Security$326$326$326$326$326$326$326$326$326$326$326$326$3,914
Utilities$370$370$370$370$370$370$370$370$370$370$370$370$4,436
Management Fee$1,522$1,522$1,522$1,522$1,522$1,522$1,522$1,522$1,522$1,522$1,522$1,522$18,267
Total Operating Expenses$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$84,481
Net Operating Income$30,811$30,907$31,331$31,331$31,659$31,659$31,659$31,659$31,708$31,708$31,708$27,785$373,926
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$11,811$11,908$12,331$12,331$12,660$12,660$12,660$12,660$12,709$12,709$12,709$8,786$145,934
Less: Capital Spendinghide
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$11,811$11,908$12,331$12,331$12,660$12,660$12,660$12,660$12,709$12,709$12,709$8,786$145,934
Taxable Income and Taxes
(Losses Taken Currently)
Taxable Revenues$37,851$37,947$38,371$38,371$38,699$38,699$38,699$38,699$38,748$38,748$38,748$34,825$458,406
Less: Deducted Expenses$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$7,040$84,481
Less: Interest Expense$11,096$11,043$10,990$10,937$10,883$10,829$10,774$10,719$10,664$10,609$10,553$10,496$129,592
Less: Amortized Points$95$95$95$95$95$95$95$95$95$95$95$95$1,136
Less: Depreciation$5,531$5,531$5,531$5,531$5,531$5,531$5,531$5,531$5,531$5,531$5,531$5,500$66,338
Ordinary Income$14,090$14,239$14,715$14,769$15,151$15,205$15,260$15,314$15,419$15,474$15,530$11,694$176,861
Taxable Income$14,090$14,239$14,715$14,769$15,151$15,205$15,260$15,314$15,419$15,474$15,530$11,694$176,861
Taxes Due (- = Savings)$5,847$5,909$6,107$6,129$6,288$6,310$6,333$6,356$6,399$6,422$6,445$4,853$73,397
Cash Flow After Tax$5,964$5,999$6,224$6,202$6,372$6,350$6,327$6,304$6,310$6,287$6,264$3,933$72,537