Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Selling my hotel Given: Cap Rate is now 9% Scenario 1 Scenario 2 Scenario 3 Scenario 4 Download and complete the spreadsheet Save the spreadsheet
Selling my hotel | ||||||
Given: Cap Rate is now 9% | ||||||
Scenario 1 | Scenario 2 | Scenario 3 | Scenario 4 | Download and complete the spreadsheet | ||
Save the spreadsheet using the format "firstnamevaluation.xlsx" | ||||||
ADR Index | 100 | 105 | 110 | 115 | Upload to the assignment link | |
Occupancy Index | 100 | 105 | 110 | 115 | ||
Available Rooms | 130 | 130 | 130 | 130 | ||
Available Room Nights (365) | 47,450 | 47,450 | 47,450 | 47,450 | ||
ADR | $ 135.00 | ? | ? | ? | Calculate the data based on changes in the indexes above | |
Occupancy | 65.0% | ? | ? | ? | ||
Revpar | $87.75 | ? | ? | ? | ||
Revenue | $4,163,738 | $0 | $0 | $0 | ||
Operating Expense (70%) | $2,914,616 | $0 | $0 | $0 | ||
Operating Profit | $1,249,121 | $0 | $0 | $0 | ||
FFE Reserve (3% of Revenue) | $124,912 | ? | ? | ? | ||
EBITDA | $1,124,209 | ? | ? | ? | Operating Profit less the FFE Reserve | |
Capitalization Rate | 9.0% | 9.0% | 9.0% | 9.0% | ||
Hotel Valuation | $12,491,213 | ? | ? | ? | Calculate the value of the hotel | |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started