Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The current banking facility (all overdraft) is 1.75million and interest at 6% on any of the facility used. In a recent meeting the companys bank,

image text in transcribed

The current banking facility (all overdraft) is 1.75million and interest at 6% on any of the facility used. In a recent meeting the companys 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. Required: 1. Calculate CPPs estimated profit before taxation for the year to 31 December 2022. Show all workings. (5 marks) 2. Prepare a report for the Board of Directors of CPP advising of actions it may consider to improve the estimated 2022 cash flow and evaluate the impact of these actions on CPPs business. (20 marks 700 maximum word limit)

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 wom 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 concemed 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. Mar Feb m May Jun Jan m Oct Apr m Jul m Aug Sep m m Nov m m Dec Em Em Em m Cash in Customer receipts Licence receipts Total cash in 1.88 0.00 1.88 1.41 0.00 1.41 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.85 2.19 0.00 2.19 2.45 0.50 2.95 0.35 0.53 0.53 0.53 Cash out: Supplier payments Wages Operating costs Interest Corporate taxation Dividends Capital expenditure Total cash out: 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.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.00 1.15 0.27 0.57 0.35 0.04 0.05 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 Net cash flow Opening cash Closing cash 0.57 (1.83) 0.37 (0.29) (0.44) (0.27) (0.46) (0.45) (0.43) 0.18 0.49 0.97 0.50 1.07 (0.56) (0.19) (0.48) (0.92) (1.19) (1.65) (2.10) (2.53) (2.35) (1.88) 1.07 (0.56) (0.19 (0.48) (0.92) (1.19) (1.85) (2.10) (2.53) 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 milion and 1.99 million respectively. Purchases for November 2022 and December 2022 are expected to be 1.01 million and 0.88 million respectively. 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 wom 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 concemed 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. Mar Feb m May Jun Jan m Oct Apr m Jul m Aug Sep m m Nov m m Dec Em Em Em m Cash in Customer receipts Licence receipts Total cash in 1.88 0.00 1.88 1.41 0.00 1.41 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.85 2.19 0.00 2.19 2.45 0.50 2.95 0.35 0.53 0.53 0.53 Cash out: Supplier payments Wages Operating costs Interest Corporate taxation Dividends Capital expenditure Total cash out: 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.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.00 1.15 0.27 0.57 0.35 0.04 0.05 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 Net cash flow Opening cash Closing cash 0.57 (1.83) 0.37 (0.29) (0.44) (0.27) (0.46) (0.45) (0.43) 0.18 0.49 0.97 0.50 1.07 (0.56) (0.19) (0.48) (0.92) (1.19) (1.65) (2.10) (2.53) (2.35) (1.88) 1.07 (0.56) (0.19 (0.48) (0.92) (1.19) (1.85) (2.10) (2.53) 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 milion and 1.99 million respectively. Purchases for November 2022 and December 2022 are expected to be 1.01 million and 0.88 million respectively

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Telecom Audit

Authors: M S. Mastel

1st Edition

0071410546, 9780071410540

More Books

Students also viewed these Accounting questions

Question

How many sink SCCs in the above graph?

Answered: 1 week ago

Question

What are the attributes of a technical decision?

Answered: 1 week ago