Coconut Palm PLC (CPP') is an unlisted business that manufactures training shoes. The company was founded five years ago and has grown steadily since then. Major expansion is planned for 2022 and 2023. The 'Coconut Palm' brand has grown very quickly. The company's training shoes are seen on television and social media being worn by well-known personalities advertising home fitness equipment. The company sells mainly in Europe but has in place a licence deal with a company in the US that will manufacture and distribute the 'Coconut Palm' branded training shoes in North America in return for a quarterly licence fee. The Board of Directors is concerned that this growth in demand will create cash flow problems and so they have prepared a cash flow forecast to identify any issues with the proposed expansion. Oct Nov Jan m Feb m Mar m Apr m May m Jun m Jul m Aug m Sep m Dec m m m 1.41 Cash in: Customer receipts Licence receipts Total cash in 1.88 0.00 1.88 0.00 1.00 0.50 1.50 0.75 0.00 0.75 0.55 0.00 0.55 0.60 0.50 1.10 0.65 0.00 0.65 0.70 0.00 0.70 0.95 0.50 1.45 1.65 0.00 1.65 2.19 0.00 2.19 2.45 0.50 2.95 1.41 Cash out: Supplier payments Wages Operating costs Interest Corporate taxation Dividends Capital expenditure Total cash out: 0.53 0.53 0.25 0.00 0.00 0.00 0.00 1.31 0.41 0.53 0.25 0.00 0.00 1.00 0.85 3.04 0.35 0.53 0.25 0.00 0.00 0.00 0.00 1.13 0.23 0.53 0.28 0.00 0.00 0.00 0.00 1.04 0.15 0.55 0.28 0.01 0.00 0.00 0.00 0.99 0.15 0.57 0.28 0.02 0.00 0.00 0.35 1.37 0.20 0.57 0.32 0.02 0.00 0.00 0.00 1.11 0.23 0.57 0.32 0.03 0.00 0.00 0.27 0.57 0.35 0.04 0.65 0.00 0.00 1.88 0.53 0.53 0.37 0.04 0.00 0.00 0.00 1.47 0.75 0.53 0.39 0.03 0.00 0.00 0.00 1.70 1.03 0.53 0.40 0.02 0.00 0.00 0.00 1.98 0.00 1.15 Net cash flow Opening cash Closing cash 0.57 (1.63) 0.37 0.50 1.07 (0.56) 1.07 (0.56) (0.19) (0.29) (0.44) (0.27) (0.46) (0.45) (0.43) (0.19) (0.48) (0.92) (1.19) (1.65) (2.10) (0.48) (0.92) (1.19) (1.65) (2.10) (2.53) 0.18 0.49 0.97 (2.53) (2.35) (1.86) (2.35) (1.86) (0.89) The cash flow forecast is based on the following key assumptions: . All sales are on 60 days credit, but customers take, on average, 90 days to pay, which is what is reflected in the cash flow forecast. No increases in selling prices are planned. Suppliers, on average, are paid in 60 days. Production is evenly scheduled throughout the year and finished goods are stored for the peak season; opening inventory on 01 January 2022 is 1.25 million and closing inventory on 31 December 2022 is estimated to be 0.90 million. Wages and operating costs are paid in the month incurred. The capital expenditure forecast for 2022 is 0.85 million in February for new plant to increase capacity and 0.35 million in June for new delivery vehicles. Further capital expenditure is planned in 2023 to meet expected demand. Depreciation on assets already owned by CPP on 01 January will be 0.85 million in 2022; the company's depreciation policy is 25% straight line, with a full year depreciation charged in the year of acquisition. . Sales in October 2022, November 2022 and December 2022 are expected to be 2.82million, 2.11 million and 1.99 million respectively. Purchases for November 2022 and December 2022 are expected to be 1.01 million and 0.88 million respectively. CPP's revenues are seasonal, with a peak in the autumn during the lead up to Christmas. The current banking facility (all overdraft) is 1.75million and interest at 6% on any of the facility used. In a recent meeting the company's bank, the Board of Directors was informed that the bank will not increase the existing facility without a material increase in the interest rate. The Board of Directors comprises five directors who between them own 70% of the ordinary shares but have no money to invest any more money in 2022 or 2023. The remaining 30% of the ordinary shares are owned by a variety of individuals that have little interest in participating in company operations and are satisfied just to continue to receive dividends at the levels currently being paid. 1. Calculate CPP's estimated profit before taxation for the year to 31 December 2022. Show all workings. (5 marks) Coconut Palm PLC (CPP') is an unlisted business that manufactures training shoes. The company was founded five years ago and has grown steadily since then. Major expansion is planned for 2022 and 2023. The 'Coconut Palm' brand has grown very quickly. The company's training shoes are seen on television and social media being worn by well-known personalities advertising home fitness equipment. The company sells mainly in Europe but has in place a licence deal with a company in the US that will manufacture and distribute the 'Coconut Palm' branded training shoes in North America in return for a quarterly licence fee. The Board of Directors is concerned that this growth in demand will create cash flow problems and so they have prepared a cash flow forecast to identify any issues with the proposed expansion. Oct Nov Jan m Feb m Mar m Apr m May m Jun m Jul m Aug m Sep m Dec m m m 1.41 Cash in: Customer receipts Licence receipts Total cash in 1.88 0.00 1.88 0.00 1.00 0.50 1.50 0.75 0.00 0.75 0.55 0.00 0.55 0.60 0.50 1.10 0.65 0.00 0.65 0.70 0.00 0.70 0.95 0.50 1.45 1.65 0.00 1.65 2.19 0.00 2.19 2.45 0.50 2.95 1.41 Cash out: Supplier payments Wages Operating costs Interest Corporate taxation Dividends Capital expenditure Total cash out: 0.53 0.53 0.25 0.00 0.00 0.00 0.00 1.31 0.41 0.53 0.25 0.00 0.00 1.00 0.85 3.04 0.35 0.53 0.25 0.00 0.00 0.00 0.00 1.13 0.23 0.53 0.28 0.00 0.00 0.00 0.00 1.04 0.15 0.55 0.28 0.01 0.00 0.00 0.00 0.99 0.15 0.57 0.28 0.02 0.00 0.00 0.35 1.37 0.20 0.57 0.32 0.02 0.00 0.00 0.00 1.11 0.23 0.57 0.32 0.03 0.00 0.00 0.27 0.57 0.35 0.04 0.65 0.00 0.00 1.88 0.53 0.53 0.37 0.04 0.00 0.00 0.00 1.47 0.75 0.53 0.39 0.03 0.00 0.00 0.00 1.70 1.03 0.53 0.40 0.02 0.00 0.00 0.00 1.98 0.00 1.15 Net cash flow Opening cash Closing cash 0.57 (1.63) 0.37 0.50 1.07 (0.56) 1.07 (0.56) (0.19) (0.29) (0.44) (0.27) (0.46) (0.45) (0.43) (0.19) (0.48) (0.92) (1.19) (1.65) (2.10) (0.48) (0.92) (1.19) (1.65) (2.10) (2.53) 0.18 0.49 0.97 (2.53) (2.35) (1.86) (2.35) (1.86) (0.89) The cash flow forecast is based on the following key assumptions: . All sales are on 60 days credit, but customers take, on average, 90 days to pay, which is what is reflected in the cash flow forecast. No increases in selling prices are planned. Suppliers, on average, are paid in 60 days. Production is evenly scheduled throughout the year and finished goods are stored for the peak season; opening inventory on 01 January 2022 is 1.25 million and closing inventory on 31 December 2022 is estimated to be 0.90 million. Wages and operating costs are paid in the month incurred. The capital expenditure forecast for 2022 is 0.85 million in February for new plant to increase capacity and 0.35 million in June for new delivery vehicles. Further capital expenditure is planned in 2023 to meet expected demand. Depreciation on assets already owned by CPP on 01 January will be 0.85 million in 2022; the company's depreciation policy is 25% straight line, with a full year depreciation charged in the year of acquisition. . Sales in October 2022, November 2022 and December 2022 are expected to be 2.82million, 2.11 million and 1.99 million respectively. Purchases for November 2022 and December 2022 are expected to be 1.01 million and 0.88 million respectively. CPP's revenues are seasonal, with a peak in the autumn during the lead up to Christmas. The current banking facility (all overdraft) is 1.75million and interest at 6% on any of the facility used. In a recent meeting the company's bank, the Board of Directors was informed that the bank will not increase the existing facility without a material increase in the interest rate. The Board of Directors comprises five directors who between them own 70% of the ordinary shares but have no money to invest any more money in 2022 or 2023. The remaining 30% of the ordinary shares are owned by a variety of individuals that have little interest in participating in company operations and are satisfied just to continue to receive dividends at the levels currently being paid. 1. Calculate CPP's estimated profit before taxation for the year to 31 December 2022. Show all workings