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

Idiosyncratic risk of the stock, (a)   The market considers Intel Corp (INT...

(a)   The market considers Intel Corp (INTC) of all these stocks to be the riskiest since it has the highest beta of 1.497408. No, this measure of risk does not include the idiosyn

What is the impact on net income, The Budvar Company purchases parts from a...

The Budvar Company purchases parts from a foreign customer on December 1, Year 1, with payment of 20,000 crowns 20,000 crowns to be made on March 1, Year 2.  Budvar enters into a f

Invoices before Inventory, How should I handle Booking an invoice in one mo...

How should I handle Booking an invoice in one month for Raw material that has not been received until the following month?

Prepate a flexible budget for production, with the following data for a 60 ...

with the following data for a 60 percent activity, prepare a flexible budget for production at 80 percent and 100 percent activity production at 60% activity - 6000 units

Designs income statement, Please use the information below to complete Form...

Please use the information below to complete Form 1120S and the Schedule K-1%u2019s for Form 1120S. Blank forms can be found on the Hands-On Assignment page or in Doc Sharing. If y

Rules of intestacy-one surviving spouse, The intestate leaves one surviving...

The intestate leaves one surviving spouse, but no child or children The surviving spouse is entitled to: 1. The personal and household effects of the deceased absolutely: "per

accounting, what organizations are responsible for governing financial rep...

what organizations are responsible for governing financial reporting? what is the role of each organiztion? how have the roles changed in the last 20 years? how might their roles c

NPO, #questionWise Owls, an NFPO, began operations at the beginning of 20X1...

#questionWise Owls, an NFPO, began operations at the beginning of 20X1 to provide free tutoring and homework assistance, as well as a nutrition program, to low-income immigrant chi

Estimate expected returns, Use the data from "Beating the Market Quarterly"...

Use the data from "Beating the Market Quarterly" problem. Use that data to estimate expected returns and a covariance table for the 5 stocks from that problem. Use your estimates t

FDD , fimnancial accounting system

fimnancial accounting system

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