Financial ratios and performance analysis
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.
Buy Financial ratios and performance analysis Answers Online
Talk to our expert to get the help with Financial ratios and performance analysis to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
Get Online Support for Financial ratios and performance analysis Assignment Help Online
Resources
- 24 x 7 Availability.
- Trained and Certified Experts.
- Deadline Guaranteed.
- Plagiarism Free.
- Privacy Guaranteed.
- Free download.
- Online help for all project.
- Homework Help Services
Testimonials
Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak: Sheryl. Read More