Sensitivity Analysis :Increasing Real Estate Management Profits: Harnessing Data Analytics (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025

✅ Answers

1. How many “profitable” properties are there?
   ✔ 31
   ❌ 11
   ❌ 30
   ❌ 40

2. Total profit for the sufficiently profitable properties in the year after the conversion year?
   ✔ $1.228 million
   ❌ $2.323 million
   ❌ $1.104 million
   ❌ $1.079 million

3. How many “profitable” properties are in Miami, FL at $30,000 threshold?
   ✔ 5
   ❌ 3
   ❌ 4
   ❌ 2

4. Cash required to convert all the “sufficiently profitable” properties?
   ✔ $480,000
   ❌ $330,000
   ❌ $300,000
   ❌ $240,000

5. Number of “profitable” properties with 40% total fees, 1-night stay, $10,000 upkeep?
   ✔ 7
   ❌ 3
   ❌ 11
   ❌ 6

6. Total yearly profits after conversion for the “profitable” properties?
   ✔ $723,300
   ❌ $194,900
   ❌ $114,500
   ❌ $1,228,800

7. Type of property with most properties over $6,000 in annual profits?
   ✔ 2 bedroom house
   ❌ 1 bedroom apartment
   ❌ 1 bedroom house
   ❌ 2 bedroom apartment

8. Cash required to convert all “profitable” properties with 20k capex over 3 years?
   ✔ $1,050,000
   ❌ $1,380,000
   ❌ $1,290,000
   ❌ $920,000

9. City with the greatest number of “profitable” properties?
   ✔ Miami, FL
   ❌ New York, NY
   ❌ Austin, TX
   ❌ San Diego, CA

10. Total yearly profits after conversion for all “profitable” properties?
    ✔ $2,697,400
    ❌ $1,728,200
    ❌ $1,274,800
    ❌ $2,444,900

📄 Summary