Photo AI

Interpretation of Accounts The following figures have been extracted from the final accounts of Robinson plc, a company involved in the home renovation and insulation industry for the year ended 31/12/2019 - Leaving Cert Accounting - Question 5 - 2020

Question icon

Question 5

Interpretation-of-Accounts-The-following-figures-have-been-extracted-from-the-final-accounts-of-Robinson-plc,-a-company-involved-in-the-home-renovation-and-insulation-industry-for-the-year-ended-31/12/2019-Leaving Cert Accounting-Question 5-2020.png

Interpretation of Accounts The following figures have been extracted from the final accounts of Robinson plc, a company involved in the home renovation and insulatio... show full transcript

Worked Solution & Example Answer:Interpretation of Accounts The following figures have been extracted from the final accounts of Robinson plc, a company involved in the home renovation and insulation industry for the year ended 31/12/2019 - Leaving Cert Accounting - Question 5 - 2020

Step 1

The opening stock if the rate of stock turnover is 8 based on average stock

96%

114 rated

Answer

To find the opening stock based on the rate of stock turnover, we need to use the formula:

Stock Turnover Ratio=Cost of SalesAverage Stock\text{Stock Turnover Ratio} = \frac{\text{Cost of Sales}}{\text{Average Stock}}

Given that the Cost of Sales is €536,000 and the stock turnover is 8:

8=536,000Average Stock8 = \frac{536,000}{\text{Average Stock}}

From this, we can calculate Average Stock:

Average Stock=536,0008=67,000\text{Average Stock} = \frac{536,000}{8} = 67,000

The next step is to calculate the opening stock. Using the formula for average stock:

Average Stock=Opening Stock+Closing Stock2\text{Average Stock} = \frac{\text{Opening Stock} + \text{Closing Stock}}{2}

Given the closing stock is €75,000:

67,000=Opening Stock+75,000267,000 = \frac{\text{Opening Stock} + 75,000}{2}

After rearranging to find the opening stock:

134,000=Opening Stock+75,000134,000 = \text{Opening Stock} + 75,000 Opening Stock=134,00075,000=59,000\text{Opening Stock} = 134,000 - 75,000 = 59,000

Step 2

Interest cover

99%

104 rated

Answer

To calculate the interest cover, we use the formula:

Interest Cover=Profit before Interest and TaxInterest\text{Interest Cover} = \frac{\text{Profit before Interest and Tax}}{\text{Interest}}

The profit before interest and tax is €120,000, and interest is €16,000:

Interest Cover=120,00016,000=7.5\text{Interest Cover} = \frac{120,000}{16,000} = 7.5

Step 3

Return on Shareholders’ funds

96%

101 rated

Answer

The Return on Shareholders' Funds is calculated using the formula:

Return on Shareholders’ Funds=Net ProfitPreference DividendShareholders’ Funds×100\text{Return on Shareholders' Funds} = \frac{\text{Net Profit} - \text{Preference Dividend}}{\text{Shareholders' Funds}} \times 100

The net profit for the year is €104,000, with preference dividends of €12,000 and shareholders' funds of €582,000:

Return on Shareholders’ Funds=104,00012,000582,000×100=15.81%\text{Return on Shareholders' Funds} = \frac{104,000 - 12,000}{582,000} \times 100 = 15.81\%

Step 4

The market price if the price earnings ratio is 6

98%

120 rated

Answer

To find the market price based on the price earnings ratio (P/E ratio), we use:

Price Earnings Ratio=Market PriceEarnings per Share\text{Price Earnings Ratio} = \frac{\text{Market Price}}{\text{Earnings per Share}}

Given the P/E ratio is 6, and Earnings per Share is calculated as follows: Earnings per Share=Net ProfitNumber of Ordinary Shares=104,000460,000=0.22610.23\text{Earnings per Share} = \frac{\text{Net Profit}}{\text{Number of Ordinary Shares}} = \frac{104,000}{460,000} = 0.2261 \approx 0.23

Now substituting in the P/E ratio formula:

6=Market Price0.23Market Price=6×0.23=1.386 = \frac{\text{Market Price}}{0.23} \Rightarrow \text{Market Price} = 6 \times 0.23 = 1.38

Step 5

Dividend yield

97%

117 rated

Answer

The dividend yield is calculated with the formula:

Dividend Yield=Dividend per ShareMarket Price per Share×100\text{Dividend Yield} = \frac{\text{Dividend per Share}}{\text{Market Price per Share}} \times 100

From the data:

  • Dividends paid: €48,000
  • Number of Ordinary Shares: 460,000

Thus: Dividend per Share=48,000460,000=0.10430.10\text{Dividend per Share} = \frac{48,000}{460,000} = 0.1043 \approx 0.10

And from the earlier market price calculation: Market Price per Share=1.38\text{Market Price per Share} = 1.38

Then: Dividend Yield=0.101.38×1007.25%\text{Dividend Yield} = \frac{0.10}{1.38} \times 100 \approx 7.25\%

Step 6

Indicate if the ordinary shareholders would be satisfied with the performance, state of affairs and prospects of Robinson plc.

97%

121 rated

Answer

The shareholders would not be satisfied with the overall performance and state of affairs of the company for several reasons:

Profitability

  • The Return on Capital Employed has decreased slightly to 9.8%, indicating inefficiencies in resource usage.
  • The Return on Shareholders' Funds of 15.81% is low compared to expectations.

Dividend Policy

  • The dividend per share has diminished slightly from €0.10 to €0.09, raising concerns about income reliability for shareholders.
  • The Dividend Yield stands at 7.25%, which, while reasonable, is less appealing compared to other investments.

State of Affairs

  • The liquidity position has weakened as indicated by the current ratio declining slightly, making timely payments a concern.
  • Gearing has improved; however, the firm remains somewhat heavily reliant on debt, which poses risks during market fluctuations.

Investment Policy

  • Current investments are valued significantly below acquisition costs, indicating potential management inefficiencies.

Prospects

  • Sector uncertainty due to economic factors may affect housing renovations adversely. Overall, shareholders may perceive future growth prospects as limited.

Step 7

Explain how a faster stock turnover can increase the profitability of a business.

96%

114 rated

Answer

A faster stock turnover can enhance profitability in several ways:

Reduced Holding Costs

  • Lower inventory levels mean reduced costs associated with storage, insurance, and deterioration risk.

Increased Cash Flow

  • Faster sales mean quicker cash generation, which can be reinvested in other profitable ventures or reduce debt.

Improved Inventory Management

  • A faster turnover rate indicates better inventory management, which ensures that the stock remains relevant and minimizes unsold outdated products.

Competitive Advantage

  • Businesses able to turn over inventory quickly can be more responsive to market changes, thus capturing a larger market share.

Overall, improving stock turnover creates a more efficient operation that significantly contributes to increased profitability.

Join the Leaving Cert students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;