Page 139 - Guardian Broker Questionnaire Summary Complete Package 2 2 22_Neat

03 GUARDIAN PLACE
VALUATION
GUARDIAN PLACE I - CASH FLOW

2023 2024 2025 2026 2027 2028 2029
YEAR ENDING: PER UNIT YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 YEAR 6 YEAR 7
REVENUE
Gross Potential $11,509 $1,392,572 $1,552,970 $1,777,137 $1,896,011 $1,952,891 $2,011,478 $2,071,823

Vacancy ($460) ($55,703) ($62,119) ($71,085) ($75,840) ($78,116) ($80,459) ($82,873)
Concessions ($84) ($10,154) ($4,853) ($5,554) ($5,925) ($6,103) ($6,286) ($6,474)
Effective Gross Income $10,965 $1,326,715 $1,485,998 $1,700,498 $1,814,246 $1,868,673 $1,924,733 $1,982,475
Bad Debt ($22) ($2,653) ($2,972) ($3,401) ($3,628) ($3,737) ($3,849) ($3,965)
Net Rental Income $10,943 $1,324,062 $1,483,026 $1,697,097 $1,810,617 $1,864,936 $1,920,884 $1,978,510
Total Other Income $400 $48,400 $96,800 $145,200 $148,104 $151,066 $154,087 $157,169
Total Revenue $11,343 $1,372,462 $1,579,826 $1,842,297 $1,958,721 $2,016,002 $2,074,971 $2,135,679
OPERATING EXPENSES
Controllable Expenses
Payroll ($2,089) ($252,764) ($257,819) ($262,976) ($268,235) ($273,600) ($279,072) ($284,653)
Repairs & Maintenance ($936) ($113,212) ($115,476) ($117,786) ($120,141) ($122,544) ($124,995) ($127,495)
Utilities ($1,243) ($150,352) ($153,359) ($156,426) ($159,554) ($162,746) ($166,000) ($169,320)
General & Administrative ($107) ($12,918) ($13,177) ($13,440) ($13,709) ($13,983) ($14,263) ($14,548)
Marketing ($208) ($25,159) ($25,663) ($26,176) ($26,699) ($27,233) ($27,778) ($28,333)
Total Controllable Expenses ($4,582) ($554,405) ($565,493) ($576,803) ($588,339) ($600,106) ($612,108) ($624,350)
Fixed Expenses

Management Fees ($340) ($41,174) ($47,395) ($55,269) ($58,762) ($60,480) ($62,249) ($64,070)
Insurance ($528) ($63,874) ($65,152) ($66,455) ($67,784) ($69,140) ($70,523) ($71,933)
Other Taxes and Fees ($21) ($2,499) ($2,549) ($2,600) ($2,652) ($2,705) ($2,759) ($2,814)
Real Estate Taxes ($1,326) ($160,412) ($165,257) ($170,248) ($175,389) ($180,686) ($186,143) ($191,764)
Total Fixed Expenses ($2,215) ($267,960) ($280,353) ($294,571) ($304,587) ($313,011) ($321,673) ($330,582)
Total Operating Expenses ($6,796) ($822,365) ($845,846) ($871,375) ($892,926) ($913,117) ($933,782) ($954,932)
Net Operating Income $4,546 $550,097 $733,980 $970,922 $1,065,795 $1,102,885 $1,141,190 $1,180,747
Capital Reserve ($250) ($30,250) ($30,855) ($31,472) ($32,102) ($32,744) ($33,398) ($34,066)
NOI (after reserve) $4,296 $519,847 $703,125 $939,450 $1,033,693 $1,070,141 $1,107,791 $1,146,681

10