Financial ratios and performance analysis Sample Assignment

Statement of income for the year ended 31 December 2012

Sales Turnover (6000 x 35)

210000

Cost of sold units (6000 x 14)

(84000)

Gross Profit

126000

Other Income

Nil

Total Income

126000

Expenses:

 

Administrative and general expenses

(10000)

Sales and marketing costs (210000 x 8%)

(16800)

Depreciation

(24200)

Operating profit

75000

Interest paid

(13200)

Profit before taxation

61800

Income tax expenses

(18540)

Profit for the year (Earning After Tax)

43260

Dividend paid (43260 x ¼)

(10815)

Net profit to be transferred to retained earnings

32445

Statement of Financial Position at 31 December 2012

Assets

 

Non-Current assets

 

Net value of Fixed Assets

250000

Total Non-Current Assets (A)

250000

Current Assets

 

Inventories

8400

Trade receivables (6000 x 35 x 41/365)

23589

Cash at hand

2011

Total Current Assets (B)

34000

Total Assets (A + B)

284000

Equity and Liabilities

 

Equity

 

Share Capital (Authorized shares R100000)

20000

Retained Earnings (103207 + 32445)

135652

Total Equity (C)

155652

Non-Current Liabilities

 

Long term debt

115000

Total Non-Current Liabilities (D)

115000

Current Liabilities

 

Trade Payables

13348

Total Current Liabilities (E)

13348

Total equity and liabilities (C + D + E)

284000

Pro-forma statement of income for the year ended 31 December 2013

Sales Turnover (6200 x 35) 217000

 

Cost of sold units (6200 x 14) (86800)

130200

Sales Turnover of new product (8000 x 16) 128000

 

Cost of sold units (128000 x 65%) (83200)

44800

Gross Profit

175000

Other Income

Nil

Total Income

175000

Expenses:

 

Administrative and general expenses

(12000)

Sales and marketing costs (345000 x 8%)

(27600)

Depreciation

(24200)

Amortization of Patent (50000/5)

(10000)

Operating profit

101200

Interest paid

(7800)

Profit before taxation

93400

Income tax expenses

(28020)

Profit for the year (Earning After Tax)

65380

Dividend paid (65380 x ¼)

(16345)

Net profit to be transferred to retained earnings

49035

Pro-forma statement of Financial Position at 31 December 2013

Assets

 

Non-Current assets

 

Net value of Fixed Assets (250000 – 24200)

225800

Patent (50000 – 10000)

40000

Total Non-Current Assets (A)

265800

Current Assets

 

Inventories (8400/84000 x 170000)

17000

Trade receivables

50096

Cash at hand

2815

Total Current Assets (B)

69911

Total Assets (A + B)

335711

Equity and Liabilities

 

Equity

 

Share Capital (20000 + 20000)

40000

Share Premium (30000 – 20000)

10000

Retained Earnings (135652 + 49035)

184687

Total Equity (C)

234687

Non-Current Liabilities

 

Long term debt

70000

Total Non-Current Liabilities (D)

70000

Current Liabilities

 

Trade Payables (86800+83200)x45/365

20959

Bank Overdraft (Balancing figure)

10065

Total Current Liabilities (E)

31024

Total equity and liabilities (C + D + E)

335711

Note: Overdraft facility negotiated by Cameron amounting R10000 is not sufficient. Minimum overdraft facility to be negotiated should have been R10065.

Gross profit Percentage

For year 2012 = (126000/210000) x 100 = 60%

For yea 2013 = (175000/345000) x 100 = 50.72%

Earnings after tax percentage

For year 2012 = (43260/210000) x 100 = 20.6%

For year 2013 = (65380/345000) x 100 = 18.95%

Fixed asset turnover ratio

For year 2012 = (126000/250000) x 100 = 50.4%

For year 2013 = (345000/225800) x 100 = 152.79%

Debt to total capital employed

For year 2012 = (115000/270652) x 100 = 42.49%

For year 2013 = (70000/304687) x 100 = 22.97%

Return on net assets

For year 2012 = (75000/270652) x 100 = 27.71%

For year 2013 = (101200/304687) x 100 = 33.21%

Return on equity

For year 2012 = (43260/155652) x 100 = 27.79%

For year 2013 = (65380/234687) x 100 = 27.86%

Comment on financial ratios and performance analysis

The gross profit ratio shows the financial health of the company. If the gross profit ratio is higher, it indicates that the company is able to earn reasonable profit on sales as well as it is able to manage its cost of sales. It shows the profitability of the company. The gross profit ratio for the year 2012 is 60% whereas it reduces to 50.72% due to production and sale of new product.

Net profit ratio refers to the remaining profit obtained after deduction from sales all costs of production, financing, administration and income taxes. This ratio helps to consider the overall efficiency of the operation and performance of the business. It also indicates how well the trading activities of the company are performing. This ratio for the year 2012 is 20.6% which has been reduced to 18.95%. This reduction indicates that the manufacture and sale of new product has affected adversely on the financial performance of the company.

Fixed asset turnover ratio indicates the efficiency with which a company is generating sales from its existing fixed assets. The more the value of this ratio, the greater will the efficient use of fixed assets. This ratio does not say anything regarding the ability of the company to generate cash flows. This ratio has increased to 152.79% as compared to the year 2012 ratio of 50.4%. The increment in this ratio in the year 2013 indicates the company is using its assets more efficiency now i.e. around 3 times efficiently than the last year.

Debt to total capital employed is a measurement of the financial leverage of the company. The higher the value of this ratio, the greater will the risk of insolvency of the company. It is the liquidity ratio which indicates the proportion of debt which is used by company to finance its operation in comparison to its capital. This ratio was 42.49% in the year 2012 which shows the high risk of insolvency of the company. But it declines to 22.97% which represents the decline in the insolvency risk in the coming year.

Return on net assets is used as a measure to consider the financial performance of the company which takes the asset’s use into account. The higher the value of this ratio, the greater will be the efficient and effective use of the assets and working capital of the company. This ratio was 27.71% in the year 2012 which has increased to 33.21% in the year 2013. This increment indicates that the company is now managing its working capital and fixed asset more efficiently and effectively.

Return on equity measures the capability of the company to generate profit from the investment by the shareholders in the company. This ratio is also known as sustainable growth rate. This ratio was 27.79% in the year 2012 which more or less remained the same in the year 2013.

Suggestion to improve the financial position and future of CCC manufacturing

  • The best way to improve financial position is to reduce the expenditure of the company. The company should observe every area of business and should find cheaper alternatives for supplies, equipments and services. For larger expenses the company should arrange deferred payments so that it can keep more cash at its hand.
  • If the company increase the price of its product without losing its customers, the company may find that this is a good way in order to improve the financial position of the business.
  • The company should improve the marketing of its product by considering all the latest marketing options as well as platform like, emails, video advertising, social media etc. the company may also use the service of debt collection agency in order to improve its financial position and early realization of trade receivables.