Coconut Palm PLC ('CPP') is an unlisted business that manufactures training shoes. The company was founded...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec £m £m £m £m £m £m £m £m £m £m £m £m Cash in: Customer receipts Licence receipts 0.65 0.00 1.88 1.41 1.00 0.75 0.55 0.70 0.60 0.50 0.95 1.65 2.19 2.45 0.00 0.70 0.00 0.00 0.50 0.00 0.00 0.50 0.00 0.00 0.50 Total cash in 1.88 1.41 1.50 0.75 0.55 1.10 0.65 1.45 1.65 2.19 2.95 Cash out: Supplier payments Wages Operating costs Interest 0.53 0.41 0.35 0.23 0.15 0.15 0.20 0.23 0.27 0.53 0.75 1.03 0.53 0.53 0.53 0.53 0.55 0.57 0.57 0.57 0.57 0.53 0.53 0.53 0.25 0.25 0.25 0.28 0.28 0.28 0.32 0.32 0.35 0.37 0.39 0.40 0.00 0.00 0.00 0.00 0.01 0.02 0.02 0.03 0.04 0.04 0.03 0.02 Corporate taxation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.65 0.00 0.00 0.00 Dividends 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Capital expenditure Total cash out: 0.00 0.85 0.00 0.00 0.00 0.35 0.00 0.00 0.00 0.00 1.31 3.04 1.13 1.04 0.99 1.37 1.11 1.15 1.88 1.47 1.70 1.98 Net cash flow 0.57 (1.63) 1.07 0.37 (0.29) (0.44) (0.27) (0.19) (0.48) (0.92) (1.19) (0.46) (0.45) (0.43) 0.18 0.49 0.97 Opening cash Closing cash (2.10) (2.53) (2.35) (1.86) (2.35) (1.86) (0.89) 0.50 (0.56) 1.07 (0.56) (0.19) (0.48) (0.92) (1.19) (1.65) (1.65) (2.10) (2.53) 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. 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 CPP's 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 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. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec £m £m £m £m £m £m £m £m £m £m £m £m Cash in: Customer receipts Licence receipts 0.65 0.00 1.88 1.41 1.00 0.75 0.55 0.70 0.60 0.50 0.95 1.65 2.19 2.45 0.00 0.70 0.00 0.00 0.50 0.00 0.00 0.50 0.00 0.00 0.50 Total cash in 1.88 1.41 1.50 0.75 0.55 1.10 0.65 1.45 1.65 2.19 2.95 Cash out: Supplier payments Wages Operating costs Interest 0.53 0.41 0.35 0.23 0.15 0.15 0.20 0.23 0.27 0.53 0.75 1.03 0.53 0.53 0.53 0.53 0.55 0.57 0.57 0.57 0.57 0.53 0.53 0.53 0.25 0.25 0.25 0.28 0.28 0.28 0.32 0.32 0.35 0.37 0.39 0.40 0.00 0.00 0.00 0.00 0.01 0.02 0.02 0.03 0.04 0.04 0.03 0.02 Corporate taxation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.65 0.00 0.00 0.00 Dividends 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Capital expenditure Total cash out: 0.00 0.85 0.00 0.00 0.00 0.35 0.00 0.00 0.00 0.00 1.31 3.04 1.13 1.04 0.99 1.37 1.11 1.15 1.88 1.47 1.70 1.98 Net cash flow 0.57 (1.63) 1.07 0.37 (0.29) (0.44) (0.27) (0.19) (0.48) (0.92) (1.19) (0.46) (0.45) (0.43) 0.18 0.49 0.97 Opening cash Closing cash (2.10) (2.53) (2.35) (1.86) (2.35) (1.86) (0.89) 0.50 (0.56) 1.07 (0.56) (0.19) (0.48) (0.92) (1.19) (1.65) (1.65) (2.10) (2.53) 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. 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 CPP's business. (20 marks - 700 maximum word limit)
Expert Answer:
Answer rating: 100% (QA)
1 A Cash Flow Statement is a statement that is maintained and prepared by the company to measure the cash dealings of the company that how much cash a company is generating and spending In this statem... View the full answer
Related Book For
Accounting and Finance An Introduction
ISBN: 978-1292088297
8th edition
Authors: Peter Atrill, Eddie McLaney
Posted Date:
Students also viewed these accounting questions
-
3. 2017 2018 2019 2020 2021 + H/C + H/C + - H/C + H/C + JAN 10 15 217 15 10 206 10 15 217 15 10 212 0 10 223 FEB 9 12 214 12 9 209 12 9 220 12 11 213 0 3 220 MAR 10 14 210 14 10 213 10 14 216 12 13...
-
The Sun Co. was founded five years ago by three former Moon Company employees. The three founders own 100% of the Sun Companys stock which has a market value of $5 per share. Below is the Balance...
-
A C corporation was formed five years ago and is a fiscal-year taxpayer with a June 30 year-end. The A C Corporation wants to make an S election for its tax year beginning in the current year. The...
-
On July 31, 2023, Magnuss Muffins paid $18,000 for business insurance for the next year. Record the entries for the purchase of the insurance by recording it as an expense and then making a year-end...
-
How important to your health are regular vacations? In a study a random sample of men and women were asked how frequently they take vacations. The men and women were divided into two groups each. The...
-
When all costs are considered, which public policy tool for curbing the consumption of bads would be the most costly to administer for a given amount of consumption reduction among consumers?
-
Use random numbers to simulate tossing a coin 100 times. Let 0 represent heads, and let 1 represent tails. How many times did you obtain each number? Are the results what you expected?
-
Steritech Co., a furniture wholesaler, sells merchandise to Butler Co. on account, $86,000, terms 2/10, n/30. The cost of the merchandise sold is $51,600. Steritech Co. issues a credit memorandum for...
-
Some enterprising physics students working on a catapult decide to have a water balloon fight in the school hallway. The ceiling is of height 3 . 4 m, and the balloons are launched at a velocity of 9...
-
Top Quality Appliance-Long Beach has just purchased a franchise from Top Quality Appliance (TQA). TQA is a manufacturer of kitchen appliances. TQA markets its products via retail stores that are...
-
An annuity pays $500 per year for the next 25 years. If the present value of the annuity is $7,500 today what is the annual rate of return promised by the annuity?
-
Comment on the role of state sovereignty in international law. What are some benefits and risks of allowing state sovereignty to trump other factors in the development and application of...
-
How does international law (treaties or CIL) become part of domestic law? What are the benefits and problems of international law being viewed as binding precedent in domestic courts?
-
What are the various sources of international law? In what ways does international law resemble national law and in what ways is it different? Give a current example of an international legal dispute...
-
Balkin (2005) explained the relationship between customary international law and municipal (domestic) law in the context of Australia: "In the absence of a definitive exposition by the Australian...
-
1. What constitutes State practice? 2. Explain the requirements of consistency and uniformity of State practice for the creation of an international custom. 3. What does the phrase opinio juris imply...
-
Kate thinks if the separation becomes permanent, she will be able to pay the debt with the 50% her best friend told her she should get from a property settlement with Mark. What Kate didn't tell her...
-
Consider the function f and its graph. a. Estimate the zeros of the area function b. Estimate the points (if any) at which A has a local maximum or minimum. c. Sketch a graph of A, for 0 x 10,...
-
Arkwright Mills plc is considering expanding its production of a new yarn, code name X15. The plant is expected to cost £1 million and have a life of five years and a nil residual value. It...
-
Dirk plc has recently created a new male fragrance ?Sirocco? at a total development cost of ?0.4 million. The business is now considering producing the fragrance, which will require an immediate...
-
Distinguish between a sunk cost and an opportunity cost.
-
Presented below is selected information related to Tsui Repairs at December 31, 2025. Tsui reports financial information monthly (amounts in thousands). a. Determine the total assets of Tsui Repairs...
-
Explain the career opportunities in accounting.
-
Collins Computer Timeshare entered into the following transactions during May 2025. 1. Purchased computers for R\($20,000\) from Digital Equipment on account. 2. Paid R\($4,000\) cash for May rent on...
Study smarter with the SolutionInn App