Answer ALL Questions Question 1 Jazz Pic is a manufacturing company. The cash and bank balance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Answer ALL Questions Question 1 Jazz Pic is a manufacturing company. The cash and bank balance is expected to be £1,500 on 1 June 2023. From the following information, you are required to prepare a monthly cash budget for the three months ending 31¹ August 2023. Feb. Mar. Apr. May June July Aug. Sales (E) Purchases (E) Wages (£) Production (£) Selling & admin. (E) Other expenses (E) 3,000 1,800 550 250 90 70 3,250 3,500 2.000 2,400 650 250 90 70 650 275 100 75 3,750 2,250 650 275 100 75 4,000 2,300 700 275 110 90 4,250 2,500 800 300 110 90 4,500 2,600 900 300 You are further informed that • Jazz Plc allows 3 months credit on its sales. 20% of sales are for cash in the month of sale. 50% of credit sales are paid are paid on the due dates, while the other 50% are paid in the next month. 120 105 • Purchases are paid off regularly after one month. • 60% of wages are paid in the month in which they are incurred and the remainder will be paid in the following month. • Production, selling and admin. costs and other expenses will be paid in the month in which they are incurred. • Plant and machinery are to be installed in May at a cost of £18,000. This sum will be paid in monthly instalments of £500 each month from 1 June. Required: a) Produce Jazz Pic's cash budget for the three months of June to August. b) Comment on what is happening to the bank balance and why? c) Briefly discuss the main FOUR reasons why firms prepare cash budgets. • Rent of £5,000 per annum is paid quarterly in equal instalments in January, April, July and October. • Jazz Plc intends to raise capital on 1 June by issuing 5,000 ordinary shares @ £2. • Preference shares dividends @ 5% on £50,000 are to be paid on 1" August. • Income tax liability of £100 is to be paid on a monthly basis. • Water rates amounting to £1,500 will be paid in two equal instalments, in June and December. (17 marks) (4 marks) (4 marks) (Total Question 1: 25 marks) Question 2 The managing director of Ager Ltd has approached Gower Plc requesting a substantial increase in their credit facilities in order to fund an expansion programme. An Extract from the Statement of Financial Position, together with the Statement of ProfiLoss of Ager Lid for two years 2021 and 2022 Ltd is given below: Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ £ Sales Opening inventories Purchases Closing inventories Gross profit Administration & distribution expenses Operating profits interest Profit before tax Tax Profit after tax Dividend Retained profit Non-Current Assets Machinery Plant Total non-current assets Current Assets Inventories Trade receivables Cash Total current assets Total Assets Current Liabilities Corporation tax due Accruals Trade payables Total current liabilities Equity & Non-Current Liabilities 10% loan £ Ordinary shares £1 Retained profit Total equity & liabilities 1,200 5,800 1,400 £ 2,700 1,300 Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ 1,400 840 50 £ 490 110 600 9.000 5,600 3,400 2,400 1,000 250 750 150 600 £ 350 250 4,000 900 4,700 1,200 2,290 6,290 2,300 1,200 1,200 750 7,500 240 4,400 3,100 1,900 570 130 250 1,200 250 950 190 760 £ 400 360 無 3,500 2,190 5,690 1.200 2,500 790 1,800 6,290 Question 2 continues on the next page 960 2,500 790 1,450 5.690 Question 2 The managing director of Ager Ltd has approached Gower Plc requesting a substantial increase in their credit facilities in order to fund an expansion programme. An Extract from the Statement of Financial Position, together with the Statement of ProfiLoss of Ager Lid for two years 2021 and 2022 Ltd is given below: Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ £ Sales Opening inventories Purchases Closing inventories Gross profit Administration & distribution expenses Operating profits interest Profit before tax Tax Profit after tax Dividend Retained profit Non-Current Assets Machinery Plant Total non-current assets Current Assets Inventories Trade receivables Cash Total current assets Total Assets Current Liabilities Corporation tax due Accruals Trade payables Total current liabilities Equity & Non-Current Liabilities 10% loan £ Ordinary shares £1 Retained profit Total equity & liabilities 1,200 5,800 1,400 £ 2,700 1,300 Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ 1,400 840 50 £ 490 110 600 9.000 5,600 3,400 2,400 1,000 250 750 150 600 £ 350 250 4,000 900 4,700 1,200 2,290 6,290 2,300 1,200 1,200 750 7,500 240 4,400 3,100 1,900 570 130 250 1,200 250 950 190 760 £ 400 360 無 3,500 2,190 5,690 1.200 2,500 790 1,800 6,290 Question 2 continues on the next page 960 2,500 790 1,450 5.690 Question 3 The following trial balance has been extracted from the accounts of Andrew's supermarket, as at 31 March 2023. Capital Sales Purchases Inventaries (opening) Receivables Payables Wages & salaries Drawings Motor expenses & petrol Rent Rates Light & heat expenses Other expenses Motor vehicle Building Bank overdraft Total You have been given the following information: Dr £ 105.000 9,000 4,000 31,000 19,000 1,000 6,200 1,800 1,800 1,700 8.000 50,000 238,500 Dr £ 36,000 168,000 5,000 29,500 238,500 Inventory as at 31 March 2023 has been valued at £11,500. 4 months' rent has been paid in advance for the period ending 30 June 2023. The total amount of prepaid rent is £2,000. Motor expenses & petrol owing £100. An accrual of £150 is required in respect of light and heat expenses. Andrew's supermarket made credit sales of £2,000 on February 2023 and these sales have not been recorded in the supermarket accounts. Required: a) Create the Statement of Profit/Loss and Statement of Financial Position for Andrew's (19 marks) (2 marks) (4 marks) (Total Question 3: 25 marks) supermarket. b) Explain what the statement of financial position reveals about a company. c) List TWO differences between preference shares and debentures. Required: a) You need to assess the validity of this proposition by calculating the following financial ratios: i) Gross profit margin i) Operating profit margin ii) Return of capital employed iv) Current ratio v) Acid test ratio vi) Trade receivable days vi) Trade payable days vii) Inventory days (16 marks) b) Interpret the ratios computed for 2021 and 2022. Further, and using the above computed ratios, advise Gower Plc whether it could grant the request made by the managing director of Ager Ltd. (9 marks) (Total Question 2: 25 marks) Question 3 The following trial balance has been extracted from the accounts of Andrew's supermarket, as at 31 March 2023. Capital Sales Purchases Inventaries (opening) Receivables Payables Wages & salaries Drawings Motor expenses & petrol Rent Rates Light & heat expenses Other expenses Motor vehicle Building Bank overdraft Total You have been given the following information: Dr £ 105.000 9,000 4,000 31,000 19,000 1,000 6,200 1,800 1,800 1,700 8.000 50,000 238,500 Dr £ 36,000 168,000 5,000 29,500 238,500 Inventory as at 31 March 2023 has been valued at £11,500. 4 months' rent has been paid in advance for the period ending 30 June 2023. The total amount of prepaid rent is £2,000. Motor expenses & petrol owing £100. An accrual of £150 is required in respect of light and heat expenses. Andrew's supermarket made credit sales of £2,000 on February 2023 and these sales have not been recorded in the supermarket accounts. Required: a) Create the Statement of Profit/Loss and Statement of Financial Position for Andrew's (19 marks) (2 marks) (4 marks) (Total Question 3: 25 marks) supermarket. b) Explain what the statement of financial position reveals about a company. c) List TWO differences between preference shares and debentures. Answer ALL Questions Question 1 Jazz Pic is a manufacturing company. The cash and bank balance is expected to be £1,500 on 1 June 2023. From the following information, you are required to prepare a monthly cash budget for the three months ending 31¹ August 2023. Feb. Mar. Apr. May June July Aug. Sales (E) Purchases (E) Wages (£) Production (£) Selling & admin. (E) Other expenses (E) 3,000 1,800 550 250 90 70 3,250 3,500 2.000 2,400 650 250 90 70 650 275 100 75 3,750 2,250 650 275 100 75 4,000 2,300 700 275 110 90 4,250 2,500 800 300 110 90 4,500 2,600 900 300 You are further informed that • Jazz Plc allows 3 months credit on its sales. 20% of sales are for cash in the month of sale. 50% of credit sales are paid are paid on the due dates, while the other 50% are paid in the next month. 120 105 • Purchases are paid off regularly after one month. • 60% of wages are paid in the month in which they are incurred and the remainder will be paid in the following month. • Production, selling and admin. costs and other expenses will be paid in the month in which they are incurred. • Plant and machinery are to be installed in May at a cost of £18,000. This sum will be paid in monthly instalments of £500 each month from 1 June. Required: a) Produce Jazz Pic's cash budget for the three months of June to August. b) Comment on what is happening to the bank balance and why? c) Briefly discuss the main FOUR reasons why firms prepare cash budgets. • Rent of £5,000 per annum is paid quarterly in equal instalments in January, April, July and October. • Jazz Plc intends to raise capital on 1 June by issuing 5,000 ordinary shares @ £2. • Preference shares dividends @ 5% on £50,000 are to be paid on 1" August. • Income tax liability of £100 is to be paid on a monthly basis. • Water rates amounting to £1,500 will be paid in two equal instalments, in June and December. (17 marks) (4 marks) (4 marks) (Total Question 1: 25 marks) Question 2 The managing director of Ager Ltd has approached Gower Plc requesting a substantial increase in their credit facilities in order to fund an expansion programme. An Extract from the Statement of Financial Position, together with the Statement of ProfiLoss of Ager Lid for two years 2021 and 2022 Ltd is given below: Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ £ Sales Opening inventories Purchases Closing inventories Gross profit Administration & distribution expenses Operating profits interest Profit before tax Tax Profit after tax Dividend Retained profit Non-Current Assets Machinery Plant Total non-current assets Current Assets Inventories Trade receivables Cash Total current assets Total Assets Current Liabilities Corporation tax due Accruals Trade payables Total current liabilities Equity & Non-Current Liabilities 10% loan £ Ordinary shares £1 Retained profit Total equity & liabilities 1,200 5,800 1,400 £ 2,700 1,300 Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ 1,400 840 50 £ 490 110 600 9.000 5,600 3,400 2,400 1,000 250 750 150 600 £ 350 250 4,000 900 4,700 1,200 2,290 6,290 2,300 1,200 1,200 750 7,500 240 4,400 3,100 1,900 570 130 250 1,200 250 950 190 760 £ 400 360 無 3,500 2,190 5,690 1.200 2,500 790 1,800 6,290 Question 2 continues on the next page 960 2,500 790 1,450 5.690 Question 2 The managing director of Ager Ltd has approached Gower Plc requesting a substantial increase in their credit facilities in order to fund an expansion programme. An Extract from the Statement of Financial Position, together with the Statement of ProfiLoss of Ager Lid for two years 2021 and 2022 Ltd is given below: Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ £ Sales Opening inventories Purchases Closing inventories Gross profit Administration & distribution expenses Operating profits interest Profit before tax Tax Profit after tax Dividend Retained profit Non-Current Assets Machinery Plant Total non-current assets Current Assets Inventories Trade receivables Cash Total current assets Total Assets Current Liabilities Corporation tax due Accruals Trade payables Total current liabilities Equity & Non-Current Liabilities 10% loan £ Ordinary shares £1 Retained profit Total equity & liabilities 1,200 5,800 1,400 £ 2,700 1,300 Ager Ltd Statement of profit or loss for the year ended 31 December 2022 2022 2021 £ 1,400 840 50 £ 490 110 600 9.000 5,600 3,400 2,400 1,000 250 750 150 600 £ 350 250 4,000 900 4,700 1,200 2,290 6,290 2,300 1,200 1,200 750 7,500 240 4,400 3,100 1,900 570 130 250 1,200 250 950 190 760 £ 400 360 無 3,500 2,190 5,690 1.200 2,500 790 1,800 6,290 Question 2 continues on the next page 960 2,500 790 1,450 5.690 Question 3 The following trial balance has been extracted from the accounts of Andrew's supermarket, as at 31 March 2023. Capital Sales Purchases Inventaries (opening) Receivables Payables Wages & salaries Drawings Motor expenses & petrol Rent Rates Light & heat expenses Other expenses Motor vehicle Building Bank overdraft Total You have been given the following information: Dr £ 105.000 9,000 4,000 31,000 19,000 1,000 6,200 1,800 1,800 1,700 8.000 50,000 238,500 Dr £ 36,000 168,000 5,000 29,500 238,500 Inventory as at 31 March 2023 has been valued at £11,500. 4 months' rent has been paid in advance for the period ending 30 June 2023. The total amount of prepaid rent is £2,000. Motor expenses & petrol owing £100. An accrual of £150 is required in respect of light and heat expenses. Andrew's supermarket made credit sales of £2,000 on February 2023 and these sales have not been recorded in the supermarket accounts. Required: a) Create the Statement of Profit/Loss and Statement of Financial Position for Andrew's (19 marks) (2 marks) (4 marks) (Total Question 3: 25 marks) supermarket. b) Explain what the statement of financial position reveals about a company. c) List TWO differences between preference shares and debentures. Required: a) You need to assess the validity of this proposition by calculating the following financial ratios: i) Gross profit margin i) Operating profit margin ii) Return of capital employed iv) Current ratio v) Acid test ratio vi) Trade receivable days vi) Trade payable days vii) Inventory days (16 marks) b) Interpret the ratios computed for 2021 and 2022. Further, and using the above computed ratios, advise Gower Plc whether it could grant the request made by the managing director of Ager Ltd. (9 marks) (Total Question 2: 25 marks) Question 3 The following trial balance has been extracted from the accounts of Andrew's supermarket, as at 31 March 2023. Capital Sales Purchases Inventaries (opening) Receivables Payables Wages & salaries Drawings Motor expenses & petrol Rent Rates Light & heat expenses Other expenses Motor vehicle Building Bank overdraft Total You have been given the following information: Dr £ 105.000 9,000 4,000 31,000 19,000 1,000 6,200 1,800 1,800 1,700 8.000 50,000 238,500 Dr £ 36,000 168,000 5,000 29,500 238,500 Inventory as at 31 March 2023 has been valued at £11,500. 4 months' rent has been paid in advance for the period ending 30 June 2023. The total amount of prepaid rent is £2,000. Motor expenses & petrol owing £100. An accrual of £150 is required in respect of light and heat expenses. Andrew's supermarket made credit sales of £2,000 on February 2023 and these sales have not been recorded in the supermarket accounts. Required: a) Create the Statement of Profit/Loss and Statement of Financial Position for Andrew's (19 marks) (2 marks) (4 marks) (Total Question 3: 25 marks) supermarket. b) Explain what the statement of financial position reveals about a company. c) List TWO differences between preference shares and debentures.
Expert Answer:
Answer rating: 100% (QA)
1 C The main reasons why firms prepare cash budgets are to forecast 2 b Based on the ratios computed it appears that Ager Ltd has seen a slight improv... View the full answer
Related Book For
Financial Accounting and Reporting
ISBN: 978-0273744443
14th Edition
Authors: Barry Elliott, Jamie Elliott
Posted Date:
Students also viewed these accounting questions
-
Prepare a monthly sales budget for the current year, assuming that monthly sales volume (i.e., mechanic hours) will be 10 percent greater than it was in the same month last year.
-
From the information given below you are required to: (a) Prepare a standard cost sheet for one unit and enter on the standard cost sheet the costs to show sub-totals for: (i) Prime cost; (ii)...
-
You are required to prepare two written responses: 1) tax file memorandum and 2) client letter. For the tax memorandum file, use exhibit 2.9 on page 2-27 for an example
-
A restaurant records the following data over a month for its food: Opening inventory: $31,000 Purchases: $88,000 Closing Inventory: $28,000 Transfers in: $800 Transfers out: $200 Employee meals:...
-
Companies that operate in different industries may have very different financial ratio values. These differences may grow even wider when we compare companies located in different countries. Compare...
-
In an analysis of a random sample of 75 claims to an insurance company, collision repair costs are found to have a mean of $1386. From previous studies, the standard deviation is known to be $735. a)...
-
sounds coming from the north side of her three-story house. Toward the end of the second day, she examined the exterior of her house and noticed two large holes located near the roof. To inspect the...
-
Bill Darby started Darby Company on January 1, 2016. The company experienced the following events during its first year of operation: 1. Earned $16,200 of cash revenue. 2. Borrowed $12,000 cash from...
-
4. 5. A heavy particle is projected with a velocity at an angle with the horizontal into the uniform gravitational field. The slope of the trajectory of the particle varies with its horizontal...
-
Laboratory tests of a membrane for \(\mathrm{H}_{2} / \mathrm{CH}_{4}\) separation gave a permeate composition of \(80 \% \mathrm{H}_{2}\) and a \(20 \%\) cut when the feed was \(50 \%...
-
Admission to the Highland Valley Amusement Park costs $7 more for adults than for children. Admission to the museum for 4 adults and 6 children costs $378. a. Formulate the linear system of equations...
-
During 2018, Toyota Motor Company shares went from 7,500 to 6,500, while paying a dividend of 220. At the same time, the exchange rate went from $1 = 113 to $1 = 109. a. What was the total dollar...
-
Is the use of HRMS for narrowing down the list of candidates and sending form letters, including rejection letters, too impersonal? Why or why not?
-
Do you think that using flextime, telecommuting, job sharing, or compressed workweeks is really going to motivate employees? Why or why not?
-
Harris Corporation has $243 million in cash and 147 million shares outstanding. Suppose the corporate tax rate is 35% and investors pay no taxes on dividends, capital gains, or interest income....
-
During the year, the price of British gilts (government bonds) went from 102 to 106, while paying a coupon of 9. At the same time, the exchange rate went from 1:$1.40 to 1:$1.25. What was the total...
-
Use the following information Kelly's Salary $47,000 Nicks Salary $38,000 Interest on: Savings account 110 Bonds of Beta Corporation 70 Food 10,804 Personal care 1,256 Primary residence mortgage...
-
Using a graphing utility, graph y = cot -1 x.
-
Beta Ltd had the following changes during 20X1: 1 January 1,000,000 shares of 50c each 31 March 500,000 shares of 50c each issued at full market price of $5 per share 30 April Bonus issue made of 1...
-
Ham plc acquired 100% of the common shares of Burg plc on 1 January 20X0 and gained control. At that date the statements of financial position of the two companies were as follows: Notes: 1 The fair...
-
(a) Assume that on 1 January 20X7 Parent Ltd acquired all the ordinary shares in Daughter Ltd for £10,800 cash. The fair value of the net assets in Daughter Ltd was their book value. (b) The...
-
What is the Standard Industrial Classification (SIC)? In what ways might such a classification system be useful? Can you think of any limitations or problems such a system might have over time?
-
1. In what ways did the defence industries respond to the ending of the Cold War? 2. Using an Internet search, find out how the defence and security industries have responded to the threat of...
-
Explain why the business objectives of owners and managers are likely to diverge. How might owners attempt to ensure that managers act in their interests and not in the managers own interests?
Study smarter with the SolutionInn App