Question: how to do on excel 2. You are considering a luxury apartment building project that requires an investment of $12,500,000. The building has 50 units.

 how to do on excel 2. You are considering a luxury

how to do on excel

2. You are considering a luxury apartment building project that requires an investment of $12,500,000. The building has 50 units. You expect the maintenance cost for the building to be $250,000 and it will increase by $50,000 per year in the subsequent years. The cost to hire a manager for the building is estimated to be $80,000 per year. The property tax per year for the building is 3% of the original investment. After 5 years of operation, the apartment building can be sold for $14,000,000. What is the monthly rent per unit that will provide a return on the investment of 15%? Assume that the occupancy rate is 90% on average. 2. You are considering a luxury apartment building project that requires an investment of $12,500,000. The building has 50 units. You expect the maintenance cost for the building to be $250,000 and it will increase by $50,000 per year in the subsequent years. The cost to hire a manager for the building is estimated to be $80,000 per year. The property tax per year for the building is 3% of the original investment. After 5 years of operation, the apartment building can be sold for $14,000,000. What is the monthly rent per unit that will provide a return on the investment of 15%? Assume that the occupancy rate is 90% on average

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!