The managing director of Pumpkin Ltd was reviewing the results of the company for the financial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The managing director of Pumpkin Ltd was reviewing the results of the company for the financial year ended 31 March 20X0. The following summarised information was available: £ Balances as at 1 April 20X9 Issued ordinary share capital: £1 fully paid shares Share premium account Balance of retained earnings Balances as at 31 March 20X0. Net profit for year 20X9/X0 Fixed assets Bank overdraft Other net current assets Note: There were no other accounts with balances. The balances as at 1 April 20x9 had remained unchanged throughout the year. The managing director was pleased that the company had made a good-profit, but he was rather concerned that a healthy bank balance at the beginning of the year had now become a large bank overdraft. 1 Company sales - March 20x0 Cash sales Credit sales Consequently he asked the company accountant to prepare forecast information for 20X0/X1 in order that the cash situation could be improved. The following information was prepared by the accountant: Cash sales Credit sales All credit sales are settled the month after the sale. £ 30,000 65,000 In each month April to September (inclusive) the sales per month would be: £ 40,000 70,000 150,000 100,000 40,000 Purchases Purchases in April, May and June £55,000 in each month Purchases in July, August and September £45,000 In each month 70,000 300,000 150,000 210,000 2 All goods purchased are from a single supplier. The goods are purchased on credit and each month's purchases are paid for three months after the month of purchase. The following purchase schedule had been prepared for the first 9 months of 20X0: January £60,000 5 Administration charges would be incurred as follows: 20X0 February, March, April 20X0 May to September (inclusive) February £58,000 Note: The company had successfully negotiated lower prices from its supplier commencing 1 July 20x0. March £61,000 3 Dividends would be paid as follows: (1) Final ordinary dividend of 5p per share payable on 31 May 20X0 in respect of financial year 20x9/x0. £10,000 per month £13,500 per month (i) Interim ordinary dividend of 2p per share payable on 31 July 20X0 in respect of financial year 20X0/X1. 4 Selling and distribution expenses are expected to be 6 per cent of a given month's total sales. They are paid one month in arrears. Administration charges are settled two months after the month in which they were incurred, 6 The company had decided to make a bonus issue of shares of one share for every three held. The issue would be made on 30 April 20X0. The bonus shares would not qualify for the final dividend of 20XS/X0, but would qualify for the interim dividend to be paid on 31 July 20X0. Required: (a) Comment on the liquidity of the company as at 31 March 20X0 and explain to the managing director why a company can apparently make a good profit but have no cash in the bank. (b) Prepare a cash budget for each of the four months ending 31 July 20X0. (c) Comment on the forecast bank balance as shown by your cash budget. Identify ways in which the bank overdraft could be reduced over the last five months of 20X0. The managing director of Pumpkin Ltd was reviewing the results of the company for the financial year ended 31 March 20X0. The following summarised information was available: £ Balances as at 1 April 20X9 Issued ordinary share capital: £1 fully paid shares Share premium account Balance of retained earnings Balances as at 31 March 20X0. Net profit for year 20X9/X0 Fixed assets Bank overdraft Other net current assets Note: There were no other accounts with balances. The balances as at 1 April 20x9 had remained unchanged throughout the year. The managing director was pleased that the company had made a good-profit, but he was rather concerned that a healthy bank balance at the beginning of the year had now become a large bank overdraft. 1 Company sales - March 20x0 Cash sales Credit sales Consequently he asked the company accountant to prepare forecast information for 20X0/X1 in order that the cash situation could be improved. The following information was prepared by the accountant: Cash sales Credit sales All credit sales are settled the month after the sale. £ 30,000 65,000 In each month April to September (inclusive) the sales per month would be: £ 40,000 70,000 150,000 100,000 40,000 Purchases Purchases in April, May and June £55,000 in each month Purchases in July, August and September £45,000 In each month 70,000 300,000 150,000 210,000 2 All goods purchased are from a single supplier. The goods are purchased on credit and each month's purchases are paid for three months after the month of purchase. The following purchase schedule had been prepared for the first 9 months of 20X0: January £60,000 5 Administration charges would be incurred as follows: 20X0 February, March, April 20X0 May to September (inclusive) February £58,000 Note: The company had successfully negotiated lower prices from its supplier commencing 1 July 20x0. March £61,000 3 Dividends would be paid as follows: (1) Final ordinary dividend of 5p per share payable on 31 May 20X0 in respect of financial year 20x9/x0. £10,000 per month £13,500 per month (i) Interim ordinary dividend of 2p per share payable on 31 July 20X0 in respect of financial year 20X0/X1. 4 Selling and distribution expenses are expected to be 6 per cent of a given month's total sales. They are paid one month in arrears. Administration charges are settled two months after the month in which they were incurred, 6 The company had decided to make a bonus issue of shares of one share for every three held. The issue would be made on 30 April 20X0. The bonus shares would not qualify for the final dividend of 20XS/X0, but would qualify for the interim dividend to be paid on 31 July 20X0. Required: (a) Comment on the liquidity of the company as at 31 March 20X0 and explain to the managing director why a company can apparently make a good profit but have no cash in the bank. (b) Prepare a cash budget for each of the four months ending 31 July 20X0. (c) Comment on the forecast bank balance as shown by your cash budget. Identify ways in which the bank overdraft could be reduced over the last five months of 20X0.
Expert Answer:
Answer rating: 100% (QA)
ANSWER Currently the company is facing a cash crunch as it is having bank overdraft of GBP 150000 wi... View the full answer
Related Book For
Financial Accounting and Reporting
ISBN: 978-1292080505
17th edition
Authors: Barry Elliott, Jamie Elliott
Posted Date:
Students also viewed these finance questions
-
The following particulars relating to the year ended 31 March 20X3 have been extracted from the books of Heel and Toe, footwear wholesalers. All sales have been recorded in personal accounts in the...
-
The following particulars relating to the year ended 31 March 20X3 have been extracted from the books of a trader:...
-
The following figures relating to the year ended 31 March 20X3 have been extracted from the books of a manufacturer: ............................................................... Total of sales...
-
I recently heard my neighbor discussing how one of our other neighbors lost his job. My neighbor assumed that the person who lost his job was probably lazy or not smart enough for the job, without...
-
It might seem an exaggeration to say that every problem that managers tackle has a quantitative aspect. Do a review of the types of decisions made by managers, and see if you can find examples of...
-
The Farm House restaurant makes their own bread to serve in their restaurant. They have been approached by a local bakery offering to make the bread for them. The restaurant has two choices: 1)...
-
The kinematic viscosity of a certain solvent system depends on the ratio of the two solvents and the temperature. Table B. 10 summarizes a set of experimental results. a. Fit a multiple linear...
-
The 2010 oil spill in the Gulf of Mexico caused the oil firm BP and the U. S. government to greatly increase purchases of boat services, various oil-absorbing materials, and other goods and services...
-
(a) (5 points) Convert the following NFA into equivalent DFA: 92 0 10 1 90 91 93 E E Figure 1: NFA 7.a (b) (5 points) Write down the Language recognized in 7a. 94 95 25
-
Conduct a Pareto analysis for the number of minutes that flights are late in the accompanying data. Interpret the results. E Click the icon to view the Atlanta Airline Data. Conduct a Pareto analysis...
-
Suppose we declare the following variables: int count = 0; int iNumber = 1, previous = 1, product = 1; Write the while loop that do the following if product is still less than 2022 -increase count by...
-
an exception occurs in a try - catch block, the code in the finally clause Finis O a . . is not executed if the exception is caught O b . . is executed O c . . is not executed O d . . may be executed
-
A Line AB BC CA sum The azimuth of AB is given as ##12'25" where is the last two digits of the student number. Given: Interior Angle A =40, Interior Angle B= 110 and Interior Angle C = 30. Length AB=...
-
For the 2D truss of the figure: . . . Find all the support reactions (Pinned support at A and Roller at Identify all zero-force members. F). Draw the Free Body Diagram. Find the axial forces of all...
-
What is a fundamental difference between the DAC and MAC formal models? a . . Who owns subjects b . . The use of classifications and permissions to enforce access control. c . . Who owns objects. d ....
-
7. [-/1.25 Points] The O'Neill Shoe Manufacturing Company will produce a special-style shoe if the order size is large enough to provide a reasonable profit. For each special-style order, the company...
-
How can you use a digital wallet to simplify the payment process and reduce cart abandonment rates?
-
Refer to the table to answer the following questions. Year Nominal GDP (in billions) Total Federal Spending (in billions) Real GDP (in billions) Real Federal Spending (in billions) 2000 9,817 578...
-
Applying the principles of control in IFRS 10 Consolidated Financial Statements , as described in Section 22.3.2 of this chapter, you are required to consider whether certain investments of Austin...
-
On 1 January 2009 Hazell plc borrows 5 million on terms with interest of 3% fixed for the period to 31 December 2009, going to variable rate thereafter (at inception the variable rate is 6%). The...
-
Jemma Burrett is a public practitioner. Four years earlier she had set up a family trust for a major client by the name of Simon Trent. The trust is for the benefit of Simon and his wife Marie. Marie...
-
Graph the discrete probability distribution given in Table 1 from Example 2. Approach In the graph of a discrete probability distribution, the horizontal axis represents the values of the discrete...
-
Compute the mean of the discrete random variable given in Table 1 from Example 2. Approach Find the mean of a discrete random variable by multiplying each value of the random variable by its...
-
Which of the following is a discrete probability distribution? Approach In a discrete probability distribution, the sum of the probabilities must equal 1, and all probabilities must be between 0 and...
Study smarter with the SolutionInn App