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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Analysis And Use Of Financial Statements
Authors: Gerald I. White, Ashwinpaul C. Sondhi, Haim D. Fried
3rd Edition
0471375942, 978-0471375944
