Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Adventure Travel Ltd (AT) information about the company and forecasts for next year is as follows: Travel agents deduct a 10% commission from the full
Adventure Travel Ltd (AT) information about the company and forecasts for next year is as follows:
- Travel agents deduct a 10% commission from the full price of each holiday before remitting the other 90% to the company at the time of booking.
- Winter sports holidays have a cost to the customer of 700 each and beach holidays cost 600 each.
- Flights and hotel accommodation are booked by AT as soon as the booking is received from a customer. Airline charges for both types of holiday are 200 per passenger. Hotel charges are 250 for beach holidays and 300 for winter sports holidays. Both airline and hotel charges must be paid in the month in which the holiday was originally due to be taken. It is not ATs practice to make any refunds to its clients, irrespective of the date of cancellation.
- At 31 December 2019 the company has received 1,320 bookings for winter sports holidays. It is estimated that bookings and cancellations for next year will be as follows:
- Salaries at AT will be 41,200 for each month of the ensuing year. These will be paid during the month in which they are incurred.
- Electricity is expected to be the same as this year at about 3,000 each quarter, payable on 1 January, 1 April, and so on. (Electricity is billed in arrears in other words electricity for January, February, March is paid for on 1 April.)
- The business rate is also expected to be the same as this year at 4,000 in total, payable in two equal instalments on 1 April and 1 October. (Rates are billed in advance).
- Repairs are expected to cost about 200 each month, payable in the month concerned.
- Depreciation is to be charged at the rate of 20% on the net book value of the equipment and furniture. No depreciation is to be charged on the building.
- Staff will incur costs for travelling on behalf of the company. These are expected to be at the rate of 7,000 each month during the months when holidays are being taken by clients. During each of the other three months, the figure will be 1,000.
- The company has always adopted the policy of realising the profit on a particular holiday (i.e. recording the sale and the related expense in the income statement) in the month in which it is taken.
Requirements:
- Prepare:
- A projected month-by-month cash flow statement for the year ended 31 December 2020.
- A projected income statement for the year ending 31 December 2020.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started