Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Business Finance

Authors: Michael Connolly

1st Edition

0415701538, 9780415701532

More Books

Students also viewed these Finance questions