Limited Time OfferFLAT 20% off & $20 bonus sign up. Order Now
New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now
RBL’s Finance Director provided you with the following statement of financial position and income statement information which included actual figures for years ending 31 December 2013 to 2015, with estimated figures for 2016.
RBL produces gadgets. This was once a fairly profitable industry but both the size and profitability of the industry in Australia have declined significantly in recent years due to advanced technology and replacement products (which RBL is unable to produce with its existing plant and equipment). Over recent years a number of its competitors and customers have closed down and existing tariffs, quotas and import duties on imported gadgets have been scheduled to be abolished at the beginning of 2016.
RBL’s factory closed in late November, pending the resolution of an industrial dispute (factory workers demanding a 15% wage rise and reduced hours). It is unlikely that work will resume prior to the Christmas shutdown and consequently the estimated figures for 2016 are not, in the opinion of the Finance Director, expected to change.
| ROB_PROB LIMITED INCOME STATEMENT | |||||
| 2013 $'000 | 2014 $'000 | 2015 $'000 | 2016 $'000 | ||
Revenue COGS Depreciation Amortisation Interest - Expense (net) | 112,500 90,000 2,000 750 2,400 | 115,875 98,494 2,000 750 2,000 | 108,923 98,031 2,000 750 1,800 | 92,584 86,103 2,000 750 1,500 | ||
Other expenses | 1,850 | 1,850 | 1,850 | 1,850 | ||
NPBT | 15,500 | 10,781 | 4,492 | 381 | ||
Tax expense | 6,045 | 4,204 | 1,752 | 149 | ||
NPAT | 9,455 | 6,577 | 2,740 | 232 | ||
ROB_PROB LIMITED BALANCE SHEET AS AT | ||||||
| 2013 $'000 | 2014 $'000 | 2015 $'000 | 2016 $'000 | ||
Current assets Cash Receivables Inventories Other |
630 21,171 19,784 517 |
500 24,347 22,752 517 |
450 27,999 26,164 517 |
150 33,598 31,397 517 | ||
Total Current Assets | 42,102 | 48,116 | 55,130 | 65,662 | ||
Non-Current assets Investments Property, plant & equipment Intangibles Other |
87 25,921 15,349 1,115 |
87 23,977 14,582 1,115 |
87 22,179 13,852 1,115 |
87 20,515 13,160 1,115 | ||
Total Non Current Assets | 42,472 | 39,761 | 37,233 | 34,877 | ||
Total assets | 84,574 | 87,877 | 92,363 | 100,539 | ||
Current liabilities Creditors Borrowings Provisions |
9,267 5,000 11,772 |
10,657 0 12,361 |
12,256 2,500 12,978 |
14,707 4,000 13,627 | ||
| 26,039 | 23,018 | 27,734 | 32,334 | ||
Non-current liabilities Creditors Borrowings Provisions |
1,338 5,000 1,531 |
1,137 5,000 1,479 |
94 3,000 1,552 |
1,360 5,000 1,630 | ||
| 7,869 | 7,616 | 4,646 | 7,990 | ||
Total liabilities | 33,908 | 30,634 | 32,380 | 40,324 | ||
Net assets | 50,666 | 57,243 | 59,983 | 60,215 | ||
Shareholders, equity Share capital Reserves Retained profits |
26,202 11,187 13,277 |
26,202 11,187 19,854 |
26,202 11,187 22,594 |
26,202 11,187 22,826 | ||
Total shareholders, equity | 50,666 | 57,243 | 59,983 | 60,215 |
Required
(A) The responsible partner for accepting new clients has requested you to prepare a preliminary analytical review on the information provided by RBL’s Finance Director. The partner suggests that as a minimum you should provide him with the following information bearing in mind that any change above 10% is material.
(A:1) Horizontal analysis for 2016 and 2015.
(A:2) Calculate 2 liquidity ratios, 2 activity ratios, 4 profitability ratios and 2 solvency ratios over the period 2013 to 2016. Use the ratios to assess if the company has a going concern problem.
(B) List four areas of high inherent risk based on your findings in (a) above and explain how they could affect the financial statements of 2016.
A1: Horizontal analysis of income statement and balance sheet.
COMPARITIVE INCOME STATEMENT | |||
PARTICULARS | 2016 | 2015 | AMOUNT |
Revenue | 92584 | 108923 | -16339 |
Cost of goods sold | 86103 | 98031 | -11928 |
GROSS PROFIT | 6481 | 10892 | -4411 |
Depreciation | 2000 | 2000 | 0 |
Amortisation | 750 | 750 | 0 |
Interest expense | 1500 | 1800 | -300 |
Other expense | 1850 | 1850 | 0 |
PROFIT BEFORE TAX | 381 | 4492 | -4111 |
Tax | 149 | 1752 | -1603 |
PROFIT AFTER TAX | 232 | 2740 | -2508 |
COMPARITIVE BALANCE SHEET | ||||
PARTICULARS | 2016 | 2015 | INCREASE/DECREASE | |
Current assets | 65662 | 55130 | 10532 | 19.10 |
Plant | 20515 | 22179 | -1664 | -7.50 |
Intangibles | 13,160 | 13852 | -692 | -5.00 |
Total asset | 1,00,539 | 92363 | 8176 | 8.85 |
Current liabilities | 32334 | 27734 | 4600 | 16.59 |
Noncurrent liabilities | 7990 | 4646 | 3344 | 71.98 |
Total liabilities | 40324 | 32380 | 7944 | 24.53 |
Retained earning | 22826 | 22594 | 232 | 1.03 |
Total shareholders’ equity | 60215 | 59983 | 232 | 0.39 |
Note: All the amounts are in thousands.
1.LIQUIDITY RATIO | ||||
1. Current ratio | 2013 | 2014 | 2015 | 2016 |
Current asset | 42102 | 48116 | 55130 | 65662 |
Current liability | 26039 | 23018 | 27734 | 32334 |
Current ratio | 1.62 | 2.09 | 1.99 | 2.03 |
2. Quick ratio | 2013 | 2014 | 2015 | 2016 |
Current asset | 42012 | 48116 | 55130 | 65662 |
Less: Inventories | 19784 | 22752 | 26164 | 31397 |
Current liabilities | 26039 | 23018 | 27734 | 32334 |
Quick ratio | 0.85 | 1.10 | 1.04 | 1.06 |
The liquidity ratio is the calculated in order to determine the ability of the company to pay off the short term debts of the company (Piper, 2015). The current ratio is calculated to see that whether the company is able to pay off the current liabilities of the company using the current assets. The most favourable current ratio is considered to be 2. Here, it can be observed that the current ratio is expected to be the higher in the year 2016 which is a good sign. The company’s current ratio was the best in 2014 and in 2015 there was a decline (Izhar & Hontoir, 2001). Since, the 2016 figures are estimated we can say if the estimations are correct then the current ratio is very good.
The quick ratio is another type of liquidity ratio but in this it excludes inventories. As we know, that inventories do not fetch us the cash instantly. So, many times it is excluded from the aspect of current assets. The trend of quick ratio is also similar to that of current ratio.
ACTIVITY RATIO | |||
1. Total asset turnover ratio | 2014 | 2015 | 2016 |
Sales | 115875 | 108923 | 92584 |
Total asset | 87877 | 92363 | 100539 |
Total asset turnover ratio | 1.32 | 1.18 | 0.92 |
2. Inventory turnover ratio | 2014 | 2015 | 2016 |
Cost of goods sold | 98494 | 98031 | 86103 |
Average inventory | 21268 | 24458 | 28780.5 |
Inventory turnover ratio | 4.63 | 4.01 | 2.99 |
Average inventor is the average of opening and closing inventory. However, we donot have the information of opening inventory of 2013.
There is a requirement of various assets in the company in order to carry out operations. It becomes difficult for the company to have higher returns if there is an obsolete technology and no replacement of old machineries. The assets should be used in the best possible manner to higher the turnover of the company (Loughran, 2011). It has been observed that the total asset turnover of the company is declining which is considered to be unfavourable. It is also dependent on the efficiency of the management and therefore, activity ratios are also called efficiency ratio.
The inventory turnover ratio is calculated to see how many times the inventory is sold during a given time span. This ratio is considered higher the better. The 2016 figure shows a great fall which is unfavourable for the company as it indirectly shows the fall in the revenue of the year (Harrison, Horngren & Thomas, n.d.).
PROFITABILITY RATIO | ||||
1. Gross profit ratio (%) | 2013 | 2014 | 2015 | 2016 |
Gross profit | 22500 | 17381 | 10892 | 6481 |
Sales | 112500 | 115875 | 108923 | 92584 |
Gross profit ratio | 20.00 | 15.00 | 10.00 | 7.00 |
2.Net profit ratio (%) | 2013 | 2014 | 2015 | 2016 |
Net profit | 9455 | 6577 | 2740 | 232 |
Sales | 112500 | 115875 | 108923 | 92584 |
Net profit ratio | 8.40 | 5.68 | 2.52 | 0.25 |
3. Return on assets | 2013 | 2014 | 2015 | 2016 |
Net income | 9455 | 6577 | 2740 | 232 |
Total assets | 84574 | 87877 | 92363 | 100539 |
Return on asset | 0.111796 | 0.074843 | 0.029666 | 0.002308 |
4. Return on equity | 2013 | 2014 | 2015 | 2016 |
Net income | 9455 | 6577 | 2740 | 232 |
Total equity | 50666 | 57243 | 59983 | 60215 |
Return on equity | 0.186614 | 0.114896 | 0.04568 | 0.003853 |
The primary of a company is to earn profits. We can see from the above profitability ratios that the gross profit and net profit ratios are falling drastically which mean that the performance of the company is getting deteriorated. The performance of the company may be because of the inefficiency of the management along with the obsolete technology. A company needs to make maximum utilisation of its assets which the company is failing and which have been depicted quantitatively through the return on asset ratio. Hence, the falling profitability of the company creates a doubt of its existence (Spiceland, Thomas & Herrmann, n.d.).
SOLVENCY RATIO | ||||
1. Equity ratio | 2013 | 2014 | 2015 | 2016 |
Total equity | 50666 | 57243 | 59983 | 60215 |
Total asset | 84574 | 87877 | 92363 | 100539 |
Equity ratio | 0.60 | 0.65 | 0.65 | 0.60 |
2. Debt ratio | 2013 | 2014 | 2015 | 2016 |
Total Liabilities | 33908 | 30634 | 32380 | 40324 |
Total assets | 84574 | 87877 | 92363 | 100539 |
Debt ratio | 0.40 | 0.35 | 0.35 | 0.40 |
In order to survive in the long run, the company has to pay off the short term and long term liabilities of the company. The ability or the inability to pay off its debts is determined by calculating the solvency ratios. However, there are not much variation in the ratio but the increase in the liabilities may question the going concern of the company. Logically speaking, it is difficult for a company to pay off its obligations if it has decreasing profits (Kimmel, Weygandt & Kieso, n.d.).
The four areas where I could see the inherent risk in my finding are:
Harrison, W., Horngren, C., & Thomas, C. Financial accounting.
Ittelson, T. (2009). Financial statements. Franklin Lakes, NJ: Career Press.
Izhar, R., & Hontoir, J. (2001). Accounting, costing, and management. Oxford: Oxford University Press.
Kimmel, P., Weygandt, J., & Kieso, D. Financial Accounting.
Libby, R., Libby, P., & Short, D. (2014). Financial accounting. New York, NY: McGraw-Hill/Irwin.
Loughran, M. (2011). Financial accounting for dummies. Hoboken (NJ): Wiley.
Piper, M. (2015). Accounting made simple. [United States]: [CreateSpace Pub.].
Spiceland, J., Thomas, W., & Herrmann, D. Financial accounting.
Warren. (2015). Financial Accounting. Cengage Learning.
Weygandt, J., Kieso, D., & Kimmel, P. Financial accounting.
No matter how close the deadline is, you will find quick solutions for your urgent assignments.
All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.
Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.
We offer academic help services for a wide array of subjects.
We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.
15,000+ happy customers and counting!