Jan 12Feb 12Mar 12Apr 12May 12Jun 12Jul 12Aug 12Sep 12Oct 12Nov 12Dec 12Ttl 12
Gross Incomehide
Executive Lots - Interior ( units)$0$0$0$0$0$0$105,000$105,000$105,000$105,000$105,000$105,000$630,000
Executive Lots - Golf/Lake ( units)$0$0$0$0$0$0$0$0$0$33,000$33,000$33,000$99,000
Prestige Lots - Interior ( units)$0$0$0$0$0$0$0$0$0$37,000$74,000$37,000$148,000
Total Gross Income$0$0$0$0$0$0$105,000$105,000$105,000$175,000$212,000$175,000$877,000
Less: Vacancy & Unit Sale Cost$0$0$0$0$0$0$6,300$6,300$6,300$10,500$12,720$10,500$52,620
Effective Income$0$0$0$0$0$0$98,700$98,700$98,700$164,500$199,280$164,500$824,380
Less: Expenseshide
Land$0$1,050,000$0$0$0$0$0$0$0$0$0$0$1,050,000
Clearing & Grading$0$29,715$29,715$0$0$0$0$0$0$0$0$0$59,429
Paving$0$0$0$0$0$0$59,831$59,831$0$0$0$0$119,663
Curb & Gutter$0$0$0$0$0$0$33,550$33,550$0$0$0$0$67,100
Sanitary Sewer$0$0$0$53,518$53,518$53,518$0$0$0$0$0$0$160,554
Storm Sewer$0$0$0$20,650$20,650$20,650$0$0$0$0$0$0$61,950
Water$0$0$0$0$65,006$0$0$0$0$0$0$0$65,006
Entrance$0$0$0$0$0$0$0$19,010$19,010$0$0$0$38,020
Power & Street Lighting$0$0$0$9,402$0$0$0$0$0$0$0$0$9,402
Amenity$0$0$0$0$0$0$0$57,030$57,030$57,030$57,030$57,030$285,150
Contingency$0$35,000$0$0$0$0$0$0$0$0$0$0$35,000
Design$0$12,500$12,500$12,500$0$0$0$0$0$0$0$0$37,500
Layout$0$0$0$0$8,517$8,517$8,517$0$0$0$0$0$25,552
Taxes & Insurance$0$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$11,000
Legal & Closing$0$13,000$0$0$0$0$0$0$0$0$0$0$13,000
Appraisal$0$5,000$0$0$0$0$0$0$0$0$0$0$5,000
Marketing & Advertising$0$0$0$0$0$0$4,266$4,266$4,266$4,266$4,266$4,266$25,594
County Fees$0$2,000$0$0$0$0$0$0$0$0$0$0$2,000
Development Fees$0$5,000$5,000$5,000$5,000$5,000$5,000$5,000$5,000$5,000$5,000$5,000$55,000
Total Operating Expenses$0$1,153,215$48,215$102,070$153,691$88,685$112,164$179,687$86,306$67,296$67,296$67,296$2,125,919
Net Operating Income$0($1,153,215)($48,215)($102,070)($153,691)($88,685)($13,464)($80,987)$12,394$97,204$131,984$97,204($1,301,539)
Cash Flow Before Tax$0($525,000)$0$0$0$0$98,700$14,805$14,805$80,605$59,455($4,888)($261,518)
Taxable Income and Taxes
(Losses Taken Currently)
Taxable Revenues$0$0$0$0$0$0$98,700$98,700$98,700$164,500$199,280$164,500$824,380
Less: Deducted Expenses$0$0$0$0$0$0$90,430$90,430$90,430$126,601$144,687$126,601$669,179
Less: Interest Expense$0$0$0$0$0$0$0$0$0$16,599$59,239$10,150$85,988
Ordinary Income$0$0$0$0$0$0$8,270$8,270$8,270$21,299($4,647)$27,749$69,213
Taxable Income$0$0$0$0$0$0$8,270$8,270$8,270$21,299($4,647)$27,749$69,213
Taxes Due (- = Savings)$0$0$0$0$0$0$3,275$3,275$3,275$8,435($1,840)$10,989$27,408
Cash Flow After Tax$0($525,000)$0$0$0$0$95,425$11,530$11,530$72,170$61,295($15,877)($288,926)