Show example on ratio calculations, Financial Accounting

Assignment Help:

Q. Show example on Ratio calculations?

The current gearing of Springbank plc = 100 × (3·5m/4m) = 87·5%

Total debt after issuing $3·4m of debt = 3·5m + 3·4m = $6·9m

New level of gearing = 100 × (6·9m/4m) = 172·5%

Current annual debenture interest = $350,000 (3·5m × 0·1)

Current interest on overdraft = 400,000 - 350,000 = $50,000

Annual interest on new debt = $272,000 (3·4m × 0·08)

Expected annual interest = 400,000 + 272,000 = $672,000

Current profit before interest and tax = $1·5m

Current interest cover = 3·75 (1·5m/0·4m)

Presume straight line depreciation additional depreciation = $600000 per year Expected profit before interest and tax = 1·5 + 1·43 - 0·6 = $2·33m

Expected interest cover = 3·47 (2·33/0·672)

This is lower than the current interest cover as well as assumes no change in overdraft interest. As a result Springbank's gearing is expected to rise from slightly below the sector average of 100% to significantly more than the sector average. Springbank's interest cover is probable to remain at a level lower than the sector average of four times and will be slightly reduced assuming no change in overdraft interest.

(ii) Ratio calculations

1490_Show example on Ratio calculations.png

The return on capital employed of Springbank has decline as a result of both falling net profit margin and falling asset turnover while comparable with the sector average of 25% in 2001 it is well lower the sector average in 2002. The difficulty here is that turnover has remained static while both cost of sales and investment in assets have increased.

Despite the fall in prosperity both current ratio and quick ratio have improved in the main because of the increase in inventory levels and the decline in current liabilities the composition of which is unknown. The current ratio remains lower the sector average however. The raise in both inventory levels and inventory days together with the fact that inventory days is now 53% above the sector average may perhaps indicate that current products are becoming harder to sell a conclusion supported by the failure to increase turnover as well as the reduced profit margin. The expected rise in sales volume is therefore likely to be associated with a new product launch since it isn't likely that an increase in capacity alone will be able to generate increased sales. There is as well the possibility that the static sales of existing products may herald a decline in sales in the future.

The diminish in the receivables' ratio is an encouraging sign however the interpretation of the decreased sales/working capital ratio is uncertain. While the diminish could indicate less aggressive working capital management it could as well indicate that trade payables are less willing to extend credit to Springbank, or that inventory management is poor.

The gearing of the company has fallen but merely because reserves have been increased by retained profit. The interest cover has refused since interest has increased and operating profit has fallen. Given the steady long-term debt the increase in interest although small could indicate an increase in overdraft finance.

Ratio analysis tenders evidence that the financial performance of Springbank plc has been disappointing in terms of sales profitability and inventory management. It possibly that the management of Springbank see the increase in capacity as a cure for the company's declining performance.

(iii)

Ever since the investment has a positive NPV it is acceptable in financial terms. The threat highlighted by the analysis of recent financial performance is that existing sales may generate a declining contribution towards meeting interest payments in the future. Nevertheless sensitivity analysis illustrates the proposed expansion is robust in terms of sales volume since a 31% reduction in forecast sales is needed to eliminate the positive NPV. The proposed expansion is thus acceptable but the choice of financing is critical.

Springbank must be able to meet future interest payments if the cash flow forecasts for the increase in capacity are sound. But no account has been taken of expected inflation and both sales prices and costs will be expected to change. There is as well an underlying assumption of constant sales volumes when changing economic circumstances and the actions of competitors make this assumption not likely to be true. More detailed financial predicts are needed to give a clearer indication of whether Springbank is able to meet the additional interest payments arising from the new debentures. There is as well a danger that managers may focus more on the short-term require to meet the increased interest payments or on the longer-term need to replace the machinery and redeem the debentures rather than on increasing the wealth of shareholders.

Financial risk has risen from a statement of financial position point of view and this is likely to have a negative effect on how financial markets view the company. The cost of increasing additional finance is likely to rise while the increased financial risk may lead to downward pressure on the company's share price. The current debentures signify 54% of fixed assets and after the new issue of debentures this will rise to 73% of fixed assets. The assets available for contribution as security against new debt issues will therefore decrease and continue to decrease as fixed assets depreciate.

No information has been presented as to the maturity of the new debenture issue. If the identical principle is applied a medium term maturity of five to six years is indicated. Though the 10% debentures are due for redemption in 2007 and it would be unwise to have two significant redemption calls so close to each other.

On the base of the above discussion careful thought needs to be given to the maturity of any new issue of debentures and it perhaps advisable to use debt finance to meet only part of the financing need of the proposed capacity expansion. Substitute sources of finance such as equity and leasing should be considered.


Related Discussions:- Show example on ratio calculations

Revenue and expense accounts, Are revenue and expense accounts permanent ac...

Are revenue and expense accounts permanent accounts and should not be closed at the end of the accounting period?

Consignment, A of Surat consign goods to B of Jaipur to be sold at or abov...

A of Surat consign goods to B of Jaipur to be sold at or above invoice price. B is entiled to get a commission of 8% on sales at invoice price plus 25% of any surplus price reali

Defence of trustee-breach of trust-trusts laws, Defence of trustee   1) He...

Defence of trustee   1) He may be relieved from liability if, in the opinion of the court, he acted honestly and reasonably and ought to be excused; 2) He may also be released

Calculate the initial selling price of the product, Question: (a) The f...

Question: (a) The following output levels and production costs have been recorded over the last three periods: Required: Using the high-low method, estimate the: (i

UNDERSTANDING bUSINESS, I NEED HELP in business ratios for two company.Ido...

I NEED HELP in business ratios for two company.Ido not know how to do the formulas. Can you help.

Prepare journal entries to record the transactions, On January 1, 2010, And...

On January 1, 2010, Anderson Corporation had 60,000 shares of $1 par value common stock issued and outstanding. During the year, the following transactions occurred: Mar. 1 Issued

Assignment, 1- Journalize May transactions. Entry: 1. May 1 Owner H.Hadi...

1- Journalize May transactions. Entry: 1. May 1 Owner H.Hadi invested $40,000 in the business. 2. May 4 Equipment was purchased at a cost of $7,000; a three-month, 10% note pa

Case Study, I have a case study due in one of my classes. There are 3 pages...

I have a case study due in one of my classes. There are 3 pages of information about the company in the case, and there are 12 questions I must complete. Each question is basically

Adjustments, provide for depreciation at 10%p.a at cost for equipment and 1...

provide for depreciation at 10%p.a at cost for equipment and 15% at book value for vehicles

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd