Mathew has plans to invest £1,500,000 in a new hotel which will open on 1 May 2021. In the first year, he proposes to spend the £1,500,000 as follows:

                                                                                          £

Leasehold Property (60 year lease)                            1,200,000

Kitchen equipment (10 year life)                                      10,000

Inventory                                                                              25,000

Gym equipment (10 year life)                                           12,000

Laundry equipment (5 year life)                                         8,000

Furniture and fittings (15 year life)                                180,000

Cash remaining                                                                   65,000

                                                                                         1,500,000

Mathew has made the following forecasts:

• The hotel will have 40 rooms and will be open for dinner seven days a week.
• The hotel will operate from 1 May to 31 October and the average monthly occupancy levels are expected to be the following:

May                                         25%

June                                         60%

July                                          86%

August                                     97%

September                              80%

October                                   55%

• Average spend by a customer is expected to be £135 per room per night and 40% of sales are expected to be for cash and remaining on credit received in the next month.
• Labour cost is budgeted at 30% of sales paid in the month they are incurred.
• Monthly purchases of food, drink and laundry materials are expected to be 25% of sales. 90% of these purchases will be on credit paid in the following month after the purchase is made and the remaining will be in cash.
• Inventory levels are expected to be £15,000 on average.
• Overhead costs are budgeted at 15% of sales paid with a time lag of two month.
• Depreciation should be applied using the straight line method.

Required:

Prepare the following documents for the first six (6) months of the hotel’s operation from 1 May 2021 to 31 October 2021 and include a copy of them in the main body of the report:

1. A cash budget
2. A budgeted income statement
3. A budgeted statement of financial position
4. Calculate the Payback Period, the Net Present Value of the project, and Internal Rate of Return
5. A cost of capital of 8%, using four decimal points on the discount factor;
6. Net cash flow will grow 7% and Profit will grow 5% on a yearly basis compared to the previous year up to 10 year

Answer rating: 100% (QA)

May 2021 Inflows Opening Cash Balance 65000 Receipts from customers 1000000 Total Inflows 1065000 Outflows Leasehold Property 1200000 Kitchen equipment 10000 Inventory 25000 Gym equipment 12000 Laundr... View the full answer