Trellis Ltd is a small start-up business hoping to grow and diversify in future, currently engaged...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Trellis Ltd is a small start-up business hoping to grow and diversify in future, currently engaged in the bespoke manufacture of one product, a decorative garden fence. The company's overdraft limit is £15,000 and the directors wish to ensure that this is not exceeded between 1 October 2022 and 31 January 2023, as it wants to prove to its lenders that it can manage its cashflow. I 4 Each fence has the following selling price and direct costs per unit: £ - Selling price Direct material Direct labour Variable production expenses" Variable selling expenses Contribution Predicted sales quantities for the next 4 months are:< Sales Units P 4 October 2022 November 2022 December 2022- January 2023 200--> (120)** (20) (10) (20) 250 280 300- 340 £30 O fe 4² e P De om DE Extracts from the latest financial statements, as at 30 September 2022 included the following: ¹ 41 el Trade receivables + T Inventory Utilities bill (payable in October 2022) 4 4 Bank overdraft (trading bank account)" # Trade payables- + Variable selling expense accrual . ● The following information is also relevant:< 40% of sales each month are expected to be for cash (received immediately) and the remaining sales will be on 1 month's credit. ● 15,000- 17,000+¹ 400- 2,000+ 25,000+ 2,200 . de W de توله Purchases of direct material are made in the month of sale and Trellis Ltd takes, on average, one month's credit from its suppliers before payment.+¹ Direct labour cost and variable production expenses are paid for in the month in which they are incurred. The variable selling expenses are paid in the following month. Fixed expenses of £4,500 are paid each month as they are incurred.< Trellis I td has an £8.000 loan from a private source received on 1 January 2022.00. . . b) . ● they are Trellis Ltd has an £8,000 loan from a private source received on 1 January 2022 on which interest of 10% is payable after a year, on 31 December each year. The funds from the loan were deposited into its trading bank account on 1 January 2022. The company is planning to purchase additional machinery on 1 October 2022 at a cost of £9,000 payable in two equal instalments in October 2022 and December 2022. The company is planning to purchase space at a local Garden Centre to show off its garden fences and future products. A payment of £3,000 will be paid in full in November 2022 to secure the space for 2023, which is often in high demand. • Taxation owed from the previous period is £8,000 and will be paid in November 2022.< d An inventory of finished goods is kept for emergency orders. This is not expected to change throughout the period. Required: a) Prepare a month-by-month cash flow budget for Trellis Ltd using a tabular format, showing the closing balance expected each month, for the four months from 1 October 2022 to 31 January 2023.< (17 Marks)< Calculate the current ratio and 'acid test' quick ratio as at 31 January 2023. (5 Marks) Based on your answer to part a) and b), advise the directors on whether they need to take action and, if so, what action they might take to manage their cash position. (8 Marks)+ Trellis Ltd is a small start-up business hoping to grow and diversify in future, currently engaged in the bespoke manufacture of one product, a decorative garden fence. The company's overdraft limit is £15,000 and the directors wish to ensure that this is not exceeded between 1 October 2022 and 31 January 2023, as it wants to prove to its lenders that it can manage its cashflow. I 4 Each fence has the following selling price and direct costs per unit: £ - Selling price Direct material Direct labour Variable production expenses" Variable selling expenses Contribution Predicted sales quantities for the next 4 months are:< Sales Units P 4 October 2022 November 2022 December 2022- January 2023 200--> (120)** (20) (10) (20) 250 280 300- 340 £30 O fe 4² e P De om DE Extracts from the latest financial statements, as at 30 September 2022 included the following: ¹ 41 el Trade receivables + T Inventory Utilities bill (payable in October 2022) 4 4 Bank overdraft (trading bank account)" # Trade payables- + Variable selling expense accrual . ● The following information is also relevant:< 40% of sales each month are expected to be for cash (received immediately) and the remaining sales will be on 1 month's credit. ● 15,000- 17,000+¹ 400- 2,000+ 25,000+ 2,200 . de W de توله Purchases of direct material are made in the month of sale and Trellis Ltd takes, on average, one month's credit from its suppliers before payment.+¹ Direct labour cost and variable production expenses are paid for in the month in which they are incurred. The variable selling expenses are paid in the following month. Fixed expenses of £4,500 are paid each month as they are incurred.< Trellis I td has an £8.000 loan from a private source received on 1 January 2022.00. . . b) . ● they are Trellis Ltd has an £8,000 loan from a private source received on 1 January 2022 on which interest of 10% is payable after a year, on 31 December each year. The funds from the loan were deposited into its trading bank account on 1 January 2022. The company is planning to purchase additional machinery on 1 October 2022 at a cost of £9,000 payable in two equal instalments in October 2022 and December 2022. The company is planning to purchase space at a local Garden Centre to show off its garden fences and future products. A payment of £3,000 will be paid in full in November 2022 to secure the space for 2023, which is often in high demand. • Taxation owed from the previous period is £8,000 and will be paid in November 2022.< d An inventory of finished goods is kept for emergency orders. This is not expected to change throughout the period. Required: a) Prepare a month-by-month cash flow budget for Trellis Ltd using a tabular format, showing the closing balance expected each month, for the four months from 1 October 2022 to 31 January 2023.< (17 Marks)< Calculate the current ratio and 'acid test' quick ratio as at 31 January 2023. (5 Marks) Based on your answer to part a) and b), advise the directors on whether they need to take action and, if so, what action they might take to manage their cash position. (8 Marks)+
Expert Answer:
Answer rating: 100% (QA)
Here is my analysis of the cash flow budget and financial position for Trellis Ltd a Monthbymonth cash flow budget for Trellis Ltd Trellis Ltd Cash Fl... View the full answer
Related Book For
Corporate Finance and Investment decisions and strategies
ISBN: 978-1292064062
8th edition
Authors: Richard Pike, Bill Neale, Philip Linsley
Posted Date:
Students also viewed these accounting questions
-
The following facts pertain to a non-cancelable lease agreement between Marin Leasing Company and Cullumber Company, a lessee. Commencement date May 1. 2020 Annual lease payment due at the beginning...
-
Wildhorse Corporation purchased an asset at a cost of $60,000 on March 1, 2020. The asset has a useful life of 8 years and a salvage value of $4,800. For tax purposes, the MACRS class life is 5...
-
On January 1, 2020, Carla Vista Corp., which uses IFRS, signs a 10-year, non-cancellable lease agreement to lease a specialty lathe from Liu Inc. The following information concerns the lease...
-
A partially completed flowchart showing some of the major documents commonly used in the purchasing function of a merchandise business is presented below. Identify documents 1, 3, and4. Purchase Order
-
To what extent should the liquidity measures revisions be considered if LIFO were to be eliminated from U.S. GAAP? Provide examples of those likely measures that would be affected.
-
How does affiliate marketing at Amazon work? How Amazon's business partners get paid? Who can sign up for this service? Make research on the Internet, and check other affiliate marketing programs....
-
State a conclusion. Exercises 49 refer to the following data: Electric motors are assembled on four different production lines. Random samples of motors are taken from each line and inspected. The...
-
If a computer system does not have relocation hardware yet it implements swapping, then the memory manager will have to use a loader to recomputed the executable image from the absolute image. Would...
-
A 21-tooth pinion rotating at 1500 rpm meshes with a 35-tooth gear in a spur gear reducer. Both pinion and gear are manufactured to a quality level of 9. A reliability of 0.9 has been specified and...
-
The current assets and liabilities sections of the comparative balance sheets of Regent Inc., a private entity reporting under ASPE, at December 31 are presented below, along with the income...
-
Design a clamper circuit to perform functions indicated?
-
Given the matrices in Problems 24-27, perform elementary row operations to obtain a 1 in the second row, second column without changing the entries in the first column....
-
In Problems 55-59, consider the following situation. A political party holds a national convention with 1,100 delegates. At the convention, five persons (which we will call \(\mathrm{A}, \mathrm{B},...
-
Zeno's paradoxes remind us of an argument that might lead to an absurd conclusion: Suppose I am playing baseball and decide to steal second base. To run from first to second base, I must first go...
-
Outline a procedure for finding the limit of a sequence.
-
Given the matrices in Problems 20-23, perform elementary row operations to obtain zeros under the 1 in the first column. Answers may vary. \([D]=\left[\begin{array}{rrr:r}1 & 5 & 3 & 2 \\ 2 & 3 & -1...
-
What is a cmdlet in Powershell? Explain with three different examples and with the snapshot of its use on your PC.
-
Quality Chicken grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2012 is: Joint cost of production in July 2012 was $50. A...
-
The directors of Mylo Ltd are currently considering two mutually exclusive investment projects. Both projects are concerned with the purchase of new plant. The following data are available for each...
-
Raiders Ltd is a private limited company financed entirely by ordinary shares. Its effective cost of capital, net of tax, is 10 per cent p.a. The directors are considering the company's capital...
-
The main principles of financial management may be applied to most organisations. However, the role of the financial manager may be affected by the type of organisation in which he or she works....
-
Under what conditions can WTO members not use MFN when dealing with one another?
-
What does most favored nation (MFN) mean?
-
How do the various forms of economic integration differ?
Study smarter with the SolutionInn App