OPERATING PRO FORMA
Gross Potential Rental Income $1,005,924 $1,026,042 $1,046,
563 $1,067,495 $1,088,844 $1,110,621 $1,132,834 $1,155,490 $1,178,600 $1,202,172 $1,226,216 $1,250,740 $1,275,755 $1,301,270 $1,327,295
Other Income
Ancillary Income $84,211 $85,895 $87,613 $89,365 $91,153 $92,976 $94,835 $96,732 $98,667 $100,640 $102,653 $104,706 $106,800 $108,936 $111,115
Miscellaneous $68,000 $69,360 $70,747 $72,162 $73,605 $75,077 $76,579 $78,111 $79,673 $81,266 $82,892 $84,549 $86,240 $87,965 $89,725
Gross Potential Income $1,158,135 $1,181,298 $1,204,924 $1,229,022 $1,253,603 $1,278,675 $1,304,248 $1,330,333 $1,356,940 $1,384,079 $1,411,760 $1,439,995 $1,468,795 $1,498,171 $1,528,135
Less:
Physical Vac. Loss Percentage: 4.00% $46,325 $47,252 $48,197 $49,161 $50,144 $51,147 $52,170 $53,213 $54,278 $55,363 $56,470 $57,600 $58,752 $59,927 $61,125
Collection Loss Percentage: 1.00% $11,581 $11,813 $12,049 $12,290 $12,536 $12,787 $13,042 $13,303 $13,569 $13,841 $14,118 $14,400 $14,688 $14,982 $15,281
Total Effective Gross Income $1,100,228 $1,122,233 $1,144,677 $1,167,571 $1,190,922 $1,214,741 $1,239,036 $1,263,816 $1,289,093 $1,314,875 $1,341,172 $1,367,996 $1,395,355 $1,423,263 $1,451,728
Fi xe d:
Real Estate Taxes $76,000 $78,280 $80,628 $83,047 $85,539 $88,105 $90,748 $93,470 $96,275 $99,163 $102,138 $105,202 $108,358 $111,609 $114,957
Insurance $88,000 $90,640 $93,359 $96,160 $99,045 $102,016 $105,077 $108,229 $111,476 $114,820 $118,265 $121,813 $125,467 $129,231 $133,108
Variable:
Management Fee Percentage: 4.00% $44,009 $44,889 $45,787 $46,703 $47,637 $48,590 $49,561 $50,553 $51,564 $52,595 $53,647 $54,720 $55,814 $56,931 $58,069
General and Administrative $36,000 $37,080 $38,192 $39,338 $40,518 $41,734 $42,986 $44,275 $45,604 $46,972 $48,381 $49,832 $51,327 $52,867 $54,453
Payroll Expenses $112,000 $115,360 $118,821 $122,385 $126,057 $129,839 $133,734 $137,746 $141,878 $146,135 $150,519 $155,034 $159,685 $164,476 $169,410
Utilities $36,000 $37,080 $38,192 $39,338 $40,518 $41,734 $42,986 $44,275 $45,604 $46,972 $48,381 $49,832 $51,327 $52,867 $54,453
Marketing and Advertising $4,000 $4,120 $4,244 $4,371 $4,502 $4,637 $4,776 $4,919 $5,067 $5,219 $5,376 $5,537 $5,703 $5,874 $6,050
Maintenance and Repairs/Pest Control $72,000 $74,160 $76,385 $78,676 $81,037 $83,468 $85,972 $88,551 $91,207 $93,944 $96,762 $99,665 $102,655 $105,734 $108,906
Reserve for Replacements $24,000 $24,720 $25,462 $26,225 $27,012 $27,823 $28,657 $29,517 $30,402 $31,315 $32,254 $33,222 $34,218 $35,245 $36,302
Total Expenses $492,009 $506,329 $521,070 $536,245 $551,865 $567,944 $584,497 $601,536 $619,077 $637,133 $655,721 $674,857 $694,555 $714,834 $735,709
Net Operating Income $608,219 $615,903 $623,607 $631,326 $639,058 $646,796 $654,539 $662,280 $670,016 $677,741 $685,451 $693,139 $700,800 $708,429 $716,018
Debt Service Payments
First Mortgage - Grandbridge/Freddie Mac $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450 $537,450
Second Mortgage - City of Bradenton $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050 $8,050
Third Mortgage - Manatee County $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500
Fourth Mortgage - Bradenton CRA $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Debt Service Payments $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000 $570,000
Cash Flow after Debt Service $38,219 $45,904 $53,607 $61,327 $69,058 $76,797 $84,539 $92,281 $100,016 $107,742 $115,451 $123,139 $130,801 $138,429 $146,019
FINANCIAL COSTS: