Analysis of Financial Statement by the Use of Solved Example of Financial Ratios:
John Brown is running a business which manufactures nuts and bolts which are then sold to local industrial units. The abridged accounts for 2014 and 2015 are given below:
Income Statement for the year ending 30 September 2014 and 2015
John Brown Balance Sheet
As at 30 September 2014 and 2015
(a) Use the following ratios to compare the financial performance from 2014 and 2015 of John Brown.
(ii) Net profit ratio
(iv) Fixed asset turnover or non current asset turnover
(v) Inventory turnover (times) or inventory turnover ratio
(vi) Average collection period or trade receivable collection period
(vii) Current ratio
(viii) Liquid ratio
Give your answer ta a maximum of two decimal places.
(b) Also write a short report to John Brown giving your observations on the results for the year and the comparison with the previous year.
(i) Gross profit ratio:
(ii) Net profit ratio:
(iii) Return on capital employed ratio:
(iv) Non-current assets turnover ratio:
(v) Inventory turnover ratio:
(vi) Average collection period:
(vii) Current ratio:
(viii) Liquid ratio:
To, John Brown
From, ABC and Co. (financial analyst)
Subject, Analysis of financial statements
After going through the financial statements of Brown, we can withdraw the following conclusion:
The profitability position has slightly improved in 2014 as reflected from the increase in gross profit ratio, net profit ratio and return on capital employed by 2.74%, 1.22% and by 0.78% respectively. The credit for this improvement may be given to an apparent shift from labor intensive operations to capital intensive operations. This can be verified from the decrease in wage expense ratio (may be due to right sizing) and the increase in factory overheads in proportion to sale (more use of oil, fuel and increased depreciation, insurance and repairs cost on new machines) and the increased investment in plant and equipment.
In contrast to the profitability ratios, the assets utilization ratios show a downward trend. From the calculations given, we can observe that non-current assets are ratio has decreased from 2.67 to 2.44 times which reveals an under utilization of non-current assets in the year 2015 as compared to 2014 (mainly due to new huge investment in plant and machinery, the full benefit not being realized for). However, a complete picture can only be seen if the results of 2016 are evaluated.
Inventory turnover ratio manifests decrease in the frequency of inventory with which it is turn into sales; its marginal deterioration is result of increase in average inventory level from $190000 to $225000. This increase was mainly expected due increase in scale of production due to new huge investment in plant items. Average collection period has increased from 25 days to 28 days which indicates poor credit management. It may prove to be a good policy provided, there is a corresponding increase in sales in the years to come.
Unfavorable turnover ratios of working capital items and new enormous investment in plant results in lower liquidity position as evidenced by decrease in current ratio. Current ratio, however, is still at a reasonable level; in 2014, it was probably too high. However, as we know that current ratio does not consider quality of current assets so liquid ratio has been calculated which also decreased in 2015, however it is still satisfactory but need to be carefully monitored to avoid further dilution, special efforts must be made to improve cash balance which becomes negative in 2015 indicating a decrease of $65000.