The Rocky Mountain Hotel, is a resort hotel is in Crested Butte, Colorado. For the hotel, management expects occupancy rates to be 95% in December, January, February and March; 85% in November and April; and 70% the rest of the year. This hotel has 325 rooms and the room rental is $250.00 per night. Of this, on average 10% is received as a deposit the month before the stay, 60% is received in the month of the stay, and 28% is collected the month after. The remaining 2% is never collected and assumed bad debt in the month after as a sales & general admin cost. Most of the costs of running the hotel are fixed. The variable costs are only $40.00 per occupied room, per night. Fixed salaries (including benefits) run $400,000 per month, depreciation is estimated to be $360,000 a month, other fixed costs are $165,000 per month, and interest expense is $550,000 per month. Fixed, variable costs and salaries are paid in the month they are incurred, depreciation is only recorded at the end of each quarter and interest is paid semi-annually each June and December. Financial statements should have proper heading, titles and format for the period they cover. You are making a presentation to a client. Summarize your answers & conclusions for each part in a textbox. The template is just an idea starter. Project Part 2: 1. The client wants your accounting firm to prepare a traditional monthly income statement (profit and loss statement) using the information above. 2. Take the monthly information and prepare an annual statement in accrual format. 3. Kindly show formulas
The Rocky Mountain Hotel, is a resort hotel is in Crested Butte, Colorado. For the hotel, management expects occupancy rates to be 95% in December, January, February and March; 85% in November and April; and 70% the rest of the year. This hotel has 325 rooms and the room rental is $250.00 per night. Of this, on average 10% is received as a deposit the month before the stay, 60% is received in the month of the stay, and 28% is collected the month after. The remaining 2% is never collected and assumed bad debt in the month after as a sales & general admin cost. Most of the costs of running the hotel are fixed. The variable costs are only $40.00 per occupied room, per night. Fixed salaries (including benefits) run $400,000 per month, depreciation is estimated to be $360,000 a month, other fixed costs are $165,000 per month, and interest expense is $550,000 per month. Fixed, variable costs and salaries are paid in the month they are incurred, depreciation is only recorded at the end of each quarter and interest is paid semi-annually each June and December. Financial statements should have proper heading, titles and format for the period they cover. You are making a presentation to a client. Summarize your answers & conclusions for each part in a textbox. The template is just an idea starter. Project Part 2: 1. The client wants your accounting firm to prepare a traditional monthly income statement (profit and loss statement) using the information above. 2. Take the monthly information and prepare an annual statement in accrual format. 3. Kindly show formulas
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:The Rocky Mountain Hotel, is a resort hotel is in Crested Butte, Colorado. For the hotel, management expects occupancy rates to be 95% in December, January, February and
March; 85% in November and April; and 70% the rest of the year. This hotel has 325 rooms and the room rental is $250.00 per night. Of this, on average 10% is received as a
deposit the month before the stay, 60% is received in the month of the stay, and 28% is collected the month after. The remaining 2% is never collected and assumed bad debt
in the month after as a sales & general admin cost.
Most of the costs of running the hotel are fixed. The variable costs are only $40.00 per occupied room, per night. Fixed salaries (including benefits) run $400,000 per month,
depreciation is estimated to be $360,000 a month, other fixed costs are $165,000 per month, and interest expense is $550,000 per month. Fixed, variable costs and salaries
are paid in the month they are incurred, depreciation is only recorded at the end of each quarter and interest is paid semi-annually each June and December.
Financial statements should have proper heading, titles and format for the period they cover. You are making a presentation to a client. Summarize your answers &
conclusions for each part in a textbox. The template is just an idea starter.
Project Part 2:
1. The client wants your accounting firm to prepare a traditional monthly income statement (profit and loss statement) using the information above.
2. Take the monthly information and prepare an annual statement in accrual format.
3. Kindly show formulas
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education