Page 31 - Guardian Broker Questionnaire Summary Complete Package 2 2 22_Neat
P. 31
PROPERTY CASH FLOW PROJECTIONS
Oct-21 Jul-23 Jul-24 Jul-25 Jul-26 Jul-27 Jul-28 Jul-29
T3 Adjusted Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
OPERATING REVENUE
Potential Market Rent $ 2,445,432 $ 2,581,116 $ 2,761,794 $ 2,899,884 $ 2,986,880 $ 3,076,487 $ 3,168,781 $ 3,263,845
(Loss to Lease) / Gain to Lease $ 130,545
Gross Potential Revenue $ 2,575,977 $ 2,581,116 $ 2,761,794 $ 2,899,884 $ 2,986,880 $ 3,076,487 $ 3,168,781 $ 3,263,845
Vacancy ($ 21,826) ($ 129,056) ($ 138,090) ($ 144,994) ($ 149,344) ($ 153,824) ($ 158,439) ($ 163,192)
Concessions ($ 25,152) ($ 24,147) ($ 25,837) ($ 27,129) ($ 27,943) ($ 28,781) ($ 29,644) ($ 30,534)
Collection Loss / Bad Debt ($ 19,467) ($ 12,140) ($ 6,495) ($ 6,819) ($ 7,024) ($ 7,235) ($ 7,452) ($ 7,675)
Base Rental Revenue $ 2,509,532 $ 2,415,774 $ 2,591,373 $ 2,720,941 $ 2,802,570 $ 2,886,647 $ 2,973,246 $ 3,062,444
Expense Reimbursements $ 19,604 $ 19,860 $ 20,257 $ 20,662 $ 21,075 $ 21,497 $ 21,927 $ 22,365
Other Residential Income $ 18,378 $ 18,500 $ 18,870 $ 19,247 $ 19,632 $ 20,025 $ 20,425 $ 20,834
Other Income $ 37,982 $ 38,360 $ 39,127 $ 39,909 $ 40,707 $ 41,522 $ 42,352 $ 43,199
EFFECTIVE GROSS REVENUE $ 2,547,514 $ 2,454,134 $ 2,630,500 $ 2,760,851 $ 2,843,277 $ 2,928,168 $ 3,015,598 $ 3,105,643
OPERATING EXPENSES
Repair & Maintenance ($ 53,940) ($ 55,019) ($ 56,119) ($ 57,242) ($ 58,387) ($ 59,554) ($ 60,745) ($ 61,960)
Contract Services ($ 47,340) ($ 48,287) ($ 49,252) ($ 50,237) ($ 51,242) ($ 52,267) ($ 53,312) ($ 54,379)
Turnover / Make-Ready ($ 632) ($ 645) ($ 658) ($ 671) ($ 684) ($ 698) ($ 712) ($ 726)
Landscaping / Grounds ($ 27,064) ($ 27,605) ($ 28,157) ($ 28,720) ($ 29,295) ($ 29,881) ($ 30,478) ($ 31,088)
Personnel ($ 508,923) ($ 377,600) ($ 385,152) ($ 392,855) ($ 400,712) ($ 408,726) ($ 416,901) ($ 425,239)
Marketing / Advertising ($ 28,622) ($ 29,195) ($ 29,779) ($ 30,374) ($ 30,982) ($ 31,601) ($ 32,233) ($ 32,878)
Administrative ($ 38,641) ($ 39,414) ($ 40,202) ($ 41,006) ($ 41,826) ($ 42,663) ($ 43,516) ($ 44,386)
Utilities ($ 342,175) ($ 349,018) ($ 355,998) ($ 363,118) ($ 370,381) ($ 377,788) ($ 385,344) ($ 393,051)
Insurance ($ 109,844) ($ 112,041) ($ 114,282) ($ 116,567) ($ 118,899) ($ 121,276) ($ 123,702) ($ 126,176)
Real Estate Taxes ($ 257,928) ($ 257,987) ($ 263,147) ($ 268,410) ($ 273,778) ($ 279,253) ($ 284,838) ($ 290,535)
Property Management Fee ($ 149,432) ($ 73,624) ($ 78,915) ($ 82,826) ($ 85,298) ($ 87,845) ($ 90,468) ($ 93,169)
TOTAL OPERATING EXPENSES ($ 1,564,541) ($ 1,370,434) ($ 1,401,661) ($ 1,432,026) ($ 1,461,483) ($ 1,491,553) ($ 1,522,250) ($ 1,553,587)
NET OPERATING INCOME
Net Operating Income (bef. Reserves) $ 982,974 $ 1,083,700 $ 1,228,839 $ 1,328,825 $ 1,381,794 $ 1,436,615 $ 1,493,348 $ 1,552,055
Replacement Reserves ($ 70,800) ($ 70,800) ($ 70,800) ($ 70,800) ($ 70,800) ($ 70,800) ($ 70,800) ($ 70,800)
NET OPERATING INCOME (AFT. RESERVES) $ 912,174 $ 1,012,900 $ 1,158,039 $ 1,258,025 $ 1,310,994 $ 1,365,815 $ 1,422,548 $ 1,481,255
OPERATING CASH FLOW $ 1,012,900 $ 1,158,039 $ 1,258,025 $ 1,310,994 $ 1,365,815 $ 1,422,548 $ 1,481,255
GUARDIAN PLACE | 23
