Please solve this que you don't even provide me one answer
3:49AM G) 0 1'4} 4ceiooo oooo Read Only - You can't save changes t... v The construction of budgets and capital Investment appraisal for a new hotel. Mathew has plans to invest 1,500,000 in a new hotel which will open on 1 May 2021. In the rst year, he proposes to spend the 1,500,000 as follows: E 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 55 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 2 5% Ju he 60% Ju ly 86% Augu st 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 dash lnventory 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 he applied using the straight line methods Required: Prepare a report for the board of directors that addresses the following tasks: Task 1 (10 marks) An explanation of the nature of budgeting, use of budgets and their limitations. Task 2 (50 marks) 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: (a) A cash budget (20 marks) (b) Ahudgeted income statement [15 marks) in) A budgeted statement of financial position (15 marks) Task 3 (35 marks) (a) Calculate the Payback Period [5 marks). the Net Present Value ofthe project (7 marks) and Internal rate of Return (5 Marks) assuming the following: if A cost of capital of 8%. using four decimal points on the discount factor; 1? Net cash flow will grow 7% and Profit will grow 5% on a yearly basis compared to previous year up to 10 years (b) Identify and discuss the comparative advantages and disadvantages of NPV. IRR and Payback' (lB Marks)