Set cell E64 equal to the appropriate cell in the Operating Expense Assumptions table. Assume youll pay a brokerage fee to either rent out or renew all of the residential units every 2 years. The brokerage fee for each unit will be 1-month of that years rental rate. Enter a formula every two years starting in Year 3 to calculate the Brokerage Fee for Residential units. |
Expenses % Increase or Fee 2022 2025 2027 2029 2030 Use Hlookup Taxes 2023 $30,605 $8,240 $1,483 $5,933 $4,120 $3,296 $16,068 $36,062 $900 $61,701.12 3% Insurance 3% Repairs & Maintenance 3% Utilities 3% Legal 3% Accounting 3% Janitorial Cleaning 5% Management Fees 0% Elevator Maint. 3% Security 1 month Brokerage Fee - Residential 5% Brokerage Fee - Commercial 2024 $30,758 $8,487 $1,528 $6,111 $4,244 $3,395 $16,550 $36,616 $900 $63,552.15 $30,453 $8,000 $1,440 $5,760 $4,000 $3,200 $15,600 $35,520 $900 $59,904 $45,200 $3,500 $39,488 $10,134 $1,824 $7,297 $5,067 $30,912 $8,742 $1,574 $6,294 $4,371 $3,497 $17,047 $37,180 $900 $65,458.72 2026 $31,066 $9,004 $1,621 $6,483 $4,502 $3,602 $17,558 $38,596 $900 $67,422.48 2028 $38,710 $9,552 $1,719 $6,878 $4,776 $3,821 $18,627 $39,782 $900 $71,528.51 $31,222 $9,274 $1,669 $6,677 $4,637 $3,710 $18,085 $39,183 $900 $69,445.15 $39,097 $9,839 $1,771 $7,084 $4,919 $3,936 $19,186 $40,392 $900 $73,674.36 $4,054 2031 $39,883 $10,438 $1,879 $7,515 $5,219 $4,175 $20,354 $41,651 $900 $78,161.13 $19,762 $41,015 $900 $75,884.59 200 Canital Poconior 12 910 $14 227 20 14 757 12 $15 199 9? $15 655 92 16 125 50 15 sog 7 17 107 55 17520 77 10 140 20 Expenses % Increase or Fee 2022 2025 2027 2029 2030 Use Hlookup Taxes 2023 $30,605 $8,240 $1,483 $5,933 $4,120 $3,296 $16,068 $36,062 $900 $61,701.12 3% Insurance 3% Repairs & Maintenance 3% Utilities 3% Legal 3% Accounting 3% Janitorial Cleaning 5% Management Fees 0% Elevator Maint. 3% Security 1 month Brokerage Fee - Residential 5% Brokerage Fee - Commercial 2024 $30,758 $8,487 $1,528 $6,111 $4,244 $3,395 $16,550 $36,616 $900 $63,552.15 $30,453 $8,000 $1,440 $5,760 $4,000 $3,200 $15,600 $35,520 $900 $59,904 $45,200 $3,500 $39,488 $10,134 $1,824 $7,297 $5,067 $30,912 $8,742 $1,574 $6,294 $4,371 $3,497 $17,047 $37,180 $900 $65,458.72 2026 $31,066 $9,004 $1,621 $6,483 $4,502 $3,602 $17,558 $38,596 $900 $67,422.48 2028 $38,710 $9,552 $1,719 $6,878 $4,776 $3,821 $18,627 $39,782 $900 $71,528.51 $31,222 $9,274 $1,669 $6,677 $4,637 $3,710 $18,085 $39,183 $900 $69,445.15 $39,097 $9,839 $1,771 $7,084 $4,919 $3,936 $19,186 $40,392 $900 $73,674.36 $4,054 2031 $39,883 $10,438 $1,879 $7,515 $5,219 $4,175 $20,354 $41,651 $900 $78,161.13 $19,762 $41,015 $900 $75,884.59 200 Canital Poconior 12 910 $14 227 20 14 757 12 $15 199 9? $15 655 92 16 125 50 15 sog 7 17 107 55 17520 77 10 140 20