15 Feb The Colorado Slope Side Hotel, is a resort hotel is in the Rocky Mountains. For the hotel, management expects occupancy rates to be 95 % in December, January, February and March; 8

Background Information Provided by Your Client:
The Colorado Slope Side Hotel, is a resort hotel is in the Rocky Mountains. For the hotel, management expects occupancy rates to be 95 % in December, January, February and March; 85% in November and April; and 75% the rest of the year. This hotel has 355 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 $45.00 per occupied room, per night. Fixed salaries (including benefits) run $420,000 per month, depreciation is estimated to be $400,000 a month, other fixed costs are $150,000 per month, and interest expense is $550,000 per month. Fixed, variable costs and salaries are paid in the month they are incurred, and interest is paid semi-annually each June and December. No new fixed assets are expected to be purchased during the year.
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.
Assume the starting cash balance for January 1 is zero, build the monthly cash table at the bottom using zero as the start, add January activity to get January ending, aka February beginning balance.
Please place your answers in a text box for each part to summarize your answers. Also, your cells need to contain the Excel formulas to show your work.