Question

In: Accounting

Section A: NMD Retail is a company that manufactures and sells tables. Using the company’s financial...

Section A:

NMD Retail is a company that manufactures and sells tables. Using the company’s financial information provided below, construct their Income Statement and then the Statement of Financial Position for the year ending 31st March 2018.

                                                                        £’000

  • Bank overdraft                                        150
  • Cash and cash equivalents                     220
  • Cost of goods sold                                 34,020
  • Dividends                                               200
  • Financing costs                                      21,046
  • Fixtures and fittings                                2,875
  • Interest received                                     559
  • Inventories                                             8,500
  • Land and buildings                                 18,718
  • Loans                                                     27,946
  • Long term investments                           8,514
  • Operating expenses                               15,256
  • Other receivables                                   10
  • Plant                                                      15,012
  • Short term investments                           160
  • Short term Loans                                    1,310
  • Taxation due                                          7,850
  • Taxation paid                                         4,782
  • Trade payables                                      8,520
  • Trade receivables                                   8,420
  • Turnover                                                83,254
  • Vehicles                                                 1,235
  • Year beginning retained earnings           2,256

Note: The dividend amount is outstanding and expected to be paid soon. The shareholders’ equity is not listed, but should be inferred after calculating other amounts.

There is a maximum of 20 marks available for this question, 10 for each of the statements.

Solutions

Expert Solution

Income Statement of NMD Retail for the year ending 31st March 2018.

Particulars Amount
Sales/Turnover 83254
(-) Cost of Goods Sold -34020
Gross Profit/Gross Margin 49,234
(-) Operating Expenses -15256
Operating Income 33978
Other Incomes & Expenses
Finance Costs -21046
Interest received 559
Dividends -200
Profit Before Tax 13291
(-) Taxation Due -7850
Profit After Tax 5441

Balance Sheet of  of NMD Retail for the year ending 31st March 2018.

Particulars Amount
ASSETS
Current Assets
Cash and Cash Equivalents 200
Inventories 8500
Other Receivables 10
Short term Investments 160
Trade Receivables 8420
Total Current Assets 17290
Non-Current Assets
Fixtures & Fittings 2875
Land & Building 18718
Long Term Investments 8514
Plant 15012
Vehicles 1235
Total Non- Current Assets 46354
TOTAL ASSETS 63644
LIABILITIES
Current Liabilities
Loans 27946
Bank Overdraft 150
Short Term Loans 1310
Total Current Liabilities 29406
Non -Current Liabilties --
Total Liabilities 29406
Shareholder's Equity
Common Shareholder's Equity 26341
Retained Earnings
Beginning 2256
Profit for the year 5441
Total Shareholders Equity 34038
Total Liabilities + Stock 63644

Notes:

  1. As per the information given, the turnover amount is accounted as Sales in the Income Statement
  2. The Dividend treatment in the accounts is different. Dividends on common stock are usually not reported on the income statement since they are not expenses. However, dividends on preferred stock will appear on the income statement as a subtraction from net income in order to report the earnings available for common stock. Here, for ease of calculation it is assumed as preferred stock. It can be done either way, since the balance in the Balance Sheet of the Company’s Shareholder’s Equity remains the same.
  3. Retained Earnings include balance at the beginning as well as the profit for current year.
  4. Rest of the transactions are normal in Income Statement and Balance Sheet

Related Solutions

California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest. Because of...
California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest. Because of an increase in demand for its products, California Cabinets is considering hiring subcontractors to complete its current backlog of orders. The following information is available for each subcontractor: Subcontractor 1 Subcontractor 2 Subcontractor 3 Hours required to complete wood tables 50 42 30 Hours required to complete steel tables 60 48 35 Hours available 40 30 35 Cost per hour $36 $42 $55 For...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 20 Direct labor $ 13 Variable manufacturing overhead $ 4 Variable selling and administrative $ 3 Fixed costs per year: Fixed manufacturing overhead $ 320,000 Fixed selling and administrative expenses $ 70,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 29 Direct labor $ 15 Variable manufacturing overhead $ 3 Variable selling and administrative $ 2 Fixed costs per year: Fixed manufacturing overhead $ 320,000 Fixed selling and administrative expenses $ 70,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Haas Company manufactures and sells one product. The following information pertains to each of the company’s...
Haas Company manufactures and sells one product. The following information pertains to each of the company’s first three years of operations: Variable costs per unit: Manufacturing: Direct materials $ 28 Direct labor $ 20 Variable manufacturing overhead $ 4 Variable selling and administrative $ 3 Fixed costs per year: Fixed manufacturing overhead $ 210,000 Fixed selling and administrative expenses $ 150,000 During its first year of operations, Haas produced 60,000 units and sold 60,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 24 Direct labor $ 13 Variable manufacturing overhead $ 5 Variable selling and administrative $ 4 Fixed costs per year: Fixed manufacturing overhead $ 240,000 Fixed selling and administrative expenses $ 50,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Haas Company manufactures and sells one product. The following information pertains to each of the company’s...
Haas Company manufactures and sells one product. The following information pertains to each of the company’s first three years of operations: Variable costs per unit: Manufacturing: Direct materials $ 30 Direct labor $ 22 Variable manufacturing overhead $ 6 Variable selling and administrative $ 2 Fixed costs per year: Fixed manufacturing overhead $ 540,000 Fixed selling and administrative expenses $ 240,000 During its first year of operations, Haas produced 60,000 units and sold 60,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 21 Direct labor $ 14 Variable manufacturing overhead $ 2 Variable selling and administrative $ 1 Fixed costs per year: Fixed manufacturing overhead $ 240,000 Fixed selling and administrative expenses $ 80,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Harris Company manufactures and sells a single product. A partially completed schedule of the company’s total...
Harris Company manufactures and sells a single product. A partially completed schedule of the company’s total costs and costs per unit over the relevant range of 52,000 to 92,000 units is given below: Required: 1. Complete the schedule of the company’s total costs and costs per unit as given in the relevant tab below. 2. Assume that the company produces and sells 82,000 units during the year at a selling price of $9.55 per unit. Prepare a contribution format income...
Ogilvy Company manufactures and sells one product. The following information pertains to each of the company’s...
Ogilvy Company manufactures and sells one product. The following information pertains to each of the company’s first three years of operations: Variable cost per unit: Direct materials $ 30 Fixed costs per year: Direct labor $ 1,702,000 Fixed manufacturing overhead $ 836,000 Fixed selling and administrative expenses $ 290,000 The company does not incur any variable manufacturing overhead costs or variable selling and administrative expenses. During its first year of operations, Ogilvy produced 74,000 units and sold 74,000 units. During...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 21 Direct labor $ 11 Variable manufacturing overhead $ 5 Variable selling and administrative $ 4 Fixed costs per year: Fixed manufacturing overhead $ 320,000 Fixed selling and administrative expenses $ 90,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT