Answer Happy

YO16_XL_BU05_GRADER_PS1_HW - Financial Analysis 1.2 Project Description: The hotel area has asked you to develop a spreadsheet model that will assist in determining room rates and the break-even pointfor specifictypes of rooms—such as the Grand Villa Suite. As part of this analysis, you will need to import data on reservations made at the hotel. Currently, William Mattingly is not certain whether the pricing helps cover expenses such as housekeeping costs or whether the price even generates a profit for the resort. He would also like you to generate a Scenario summary report that will illustrate the net income based on best-case, worst-case, and most-likely scenarios. Mr. Mattingly gave you an Excel workbook with a partial model already built and some data to use while building your model. Upon completion, you will present your model to Mr. Mattingly before the spreadsheet model is implemented.