Chisos Mountain Case Instructions Spring 2023

.docx

School

Roosevelt University *

*We aren’t endorsed by this school

Course

370

Subject

Accounting

Date

May 5, 2024

Type

docx

Pages

1

Uploaded by ProfessorRose20487 on coursehero.com

HSAD 370 Healthcare Budgeting and Reporting Spring 2023 Extra Credit: Chisos Mountain Case Study Textbook (p. 463-480) Student Instructions: Please complete questions 1 & 9 of the Chisos Mountain Case Study in your textbook (pages 463-480) using the Excel templates provided. All answers for this case should be filled into the provided Excel templates. Make sure to read the case in its entirety before you begin to answer the questions. For Question 1 (p.464), you only need to answer the following: After reading the case, please develop a non-GAAP (generally accepted accounting principles) statement of operations (start with gross patient service revenue) for FY2020. There is no need to develop questions, a balance sheet or ratio analysis as indicated in the textbook. You only need to fill out the blue cells in the excel templates. For Question 9 (p.467), you only need to answer the following questions/bullets: For FY 2021: Develop a revenue budget and four expense budgets in statement of operations format. (No footnotes are needed for these questions. Please only fill in the blue cells in the templates.) Expense Budget Scenarios (There is a different excel sheet for each scenario already provided.) 1. Increase rates the maximum allowed and increase expenses the maximum requested. 2. Increase rates the maximum allowed and maintain expenses at FY 2020 levels after adjusting for volumes 3. Increase rates the maximum allowed and cut expenses to break even in FY 2021 4. Increase rates the maximum allowed and cut expenses to recover FY 2020 losses. Excel Template Instructions: When you open the templates, please do not change any of the formulas on the first sheet titled “Student Answer Sheet”. All numbers will be updated and input automatically as you go through the case. You are required to fill in only the BLUE cells in the templates . Do not modify any cell highlighted yellow, as these calculations have already been provided for you. All of the numbers you will need to use in your calculations have been provided on the "Case Information" sheet. Read the case carefully, and for hints, please check the 'comments' in the boxes with a red triangle in the top righthand corner. 1 | P a g e
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help