Reference no: EM133953644

Problem

Panama Resort is strategizing its financial plan for the first half of the year. The finance team has estimated figures based on the Average Daily Rate (ADR) and the number of nights booked. The resort also anticipates income from other amenities like recreational activities and exclusive event hosting. The team is tasked with creating a cash budget that encompasses these estimates and the anticipated operating expenses. Get expert-level assignment help in any subject.

Forecasted Financials:
Room Revenue Projections:
The resort has predictions for the number of nights booked for each month and the ADR for January, which is expected to increase by 10% per month due to inflation.
Additional Service Revenue:
Predicted revenue from recreational activities, event hosting, and other services.
Operational Costs:
Encompass expenses for resort operations.

Monthly Projections:

Month    Nights Sold    ADR ($)    Additional Service Revenue ($)    Operational Costs ($)      
January    2,200    130    100,000    180,000      
February    2,400        105,000    185,000      
March    2,700        110,000    190,000      
April    2,900        115,000    195,000      
May    3,100        120,000    200,000     

Financial Operations:
Collections:
Room Revenue: 55% collected in the same month, 35% the following month, 10% two months after.
Additional Services: 75% collected in the same month, 25% the following month.
Payments:
Operational Costs: 70% paid in the same month, 30% the following month.
Fixed Costs:
Employee salaries: $160,000 per month.
Utilities: $50,000 per month.
Depreciation: $20,000 per month.
Beginning Cash Balance in March: $350,000.

Required:

Draft a monthly cash budget for March, April, and May, incorporating:
Collections from room revenue and additional services.
Payments for operational costs and fixed costs.
Ensure a minimum cash balance of $300,000 at the end of each month.