EFTA01089995.pdf

Pro Forma Statement Instructions: Enter data in the yellow cells only. Increase Site: US Citizenship Immigration Services For. Financing By: Hoover Prop. St Thomas, LTC Date: 101112014 Per Square Foot Annual % (Totals) income Actual Budget Variance Increase Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Gross Potential Income (GPI) $45.21 0.00% 000% $517,332 $577,332 $577.332 $577.332 $663.931 $577,332 $577.332 $577.332 $5777332 5577.332 $577,332 - Loss to Lease $0.00 0.00% $0 $0 $0 $0 SO $0 $0 $0 SO - Vacancy and Collection Loss $0.00 0.00% $O $0 IC $0 $0 SO $0 $0 50 50 = Net Rent Revenue 545.21 $0 0.00% $577,332 $577,332 $577.332 $577,332 6663.931 $577.332 5577.332 5577,332 $577.332 5577,332 5577,332 • Miscellaneous Income 0.00% $O SO $0 ST W Sr SO SO SO $0 « Expense Reimbursements 54.34 0.00% 2.50% $55,422 $56,807 S58.228 $59.683 $61,175 j $62:707 $64,272 $65.579 569.214 570.945 $67.526 = Effective Gross Income (EGI) $49.55 $0 0.00% 5632.7541 $634.135 $638.507 $734.87ti $635,5591 $637.015 $640.036 5641.604 $643,211 5644.858 5646.546 RSF Yell Increase 15% Operating Expenses mimes Heat 0.00% $0 Ur te— $0 $0 $0 SO SO $0 SO Electric $0.00 0.00% 2.50% $0 $0 $0— $0 $0 $O $0 $0 SO SO SO Water and Sewer $0.15 0.00% 230% $1,915 $1,963 $2,012 $2,114 $2,062 $2,167 52221 $2,276 $2.333 52,392 $2,451 Total Utilities $0.15 $ 0.00% 5179T5 $1,963 $2,012 $2,062 $2,114 $2.451 $2,167 $2,221 $2276 $2,333 $2.392 Maintenance Landscaping in. 4 0.00A 2.50% 59,730 I, $10,478 $10,740 1 , ir 11.":': -11,855 $12.152 Janitorial $1.27 0.00% 2.50% 516,155 $16.559— $16,9P3 517.397 •, A $17.832 $913:278 ST8:733- $19,683- $20,175 $20,680 Painting and Decorating .0. i 0.00% 2.50' . 51.277 $1,309 51.410 .1,- : 51635 $1,445 .1.595 Maintenance Labor berms 0.00% 2.50% $0 $0 $0 RIO! $0 $0 $0 $0 $0 $0 $0 Maintenance Contract $0.73 0.00% 2.50% $9.271 $9,503 $9,740 $10,233 $10.480- $11,578 $11,868 $10,752 $11,020 $11,296 Plumbing $0.20 0.00% 2.50% $2.554 $2,618 $2,683 $2,750 $2,890 $3,036 $3,112 $3,190 $3,269 $7:819 $2702 Electrical $0.20 0.00% 2.50% $2,554 $2,618 52.683- $2,750 $2,819 $2,890 $2,962 $3,036 $3.112 $3,190 $3,269 Land Lease $0.00 0.00% - 2-150% SO $13- 50 $0 $0 ST $0 SO SS Total Maintenance 53.23 $0' 0.00% $41.304 $42,337 $43,395 $44,480 $45,592 $46.732 $4.7,900 $49,097 $50;325 $51.583 $52.81 Adnanisuabon Management Fee 50.99 0.00% 0.00% 512.655 512.655 $12,655 $12,655 $12,655 $12,655 $12,655 512,655 $12,655 $12,655 $12,655 Personnel Expense 0.00% $0 $0 So 50— $0 $0 $0 SO SO $0 Office Supplies 0.00% $0 SO $0 SO $0 SO SO $6" SO $0 Telephone 0.000? $0 SO $0— $0 SO $0 $0 $0 $0 $0 Marketing 0.00% $0 $0 SO SO $0 $0 $0 $0 $0 $0 otaf ministration Fixed Expenses St 99 $0 0.00% $12.655 I $12,655 517655 I $12,655 I $12.655 $12,655 512.656-1 $12.655 512.655 i $12,655 $12,655 Insurance $3.11 0.00% 2.50% $39,762- $40.156 $41,775 542.819 $43,890 $44,987 546112 $48,446 $49,657 $50,899 $47,265 Real Estate Taxes $1.61 0.00% 0.00°/ 520.500 $20,500 520,500 520.500 $20,500 $20,500 $20,500 $20,500 $20.500 520.500 $20,500 Replacement Reserves $0.15 0.00% 0.00% $1,916 $1.916 $1.916 $1,916 $1,916 $1,916 $1,916 51,916 51.916 $1,916 $1,916 Total Fixed Expenses $4.671 Se 0.00% $52,1/8 $63,172 $64,191 $63,235 $66,306 $67,403 $68.528 $69,681 $70.862 $72.073 $73,315 - Total Operating Expenses $9.24 SO $118.052 I $120,127 I $122,253 I 5124.4321 $131,304 $126.666 I $128.955 1 $133.7091 $136,175 I $138,703 I $141,294 I; Net Operating Income (NOD $40.31 30 $514,702 $514,0131 $513,306] $512,5621 $511,840 I $511,0801 $510,3001 $509,501 I $508,-6821 $507,8431 $593,582 Capital Expenditures (Note. Will adjust BTCF on Before-Tax Cash Flow Tab) Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 $0 $0 $0 $0 $0 $0 $0 $0 SO SO 02008 Institute of Real Estate Management EFTA01089995