Analysis of potential arrangement with supplier, Financial Accounting

At current the working capital cycle is

Receivables days $0.4m/$10m * 365 = 15 days

Inventory days $0.7m/$8m * 365 = 32 days (cost of sales = $10m - $2m)

Payables days $1.5m/$8m * 365 = (68 days)

Total (21 days)

Clearly Keswick is exceptionally resourceful in its use of working capital.

The planned arrangement would shorten payables days in relation to half of cost of sales to 15 days. The effect is to inferior the average to

(½ * 68 days) + (½ * 15 days) = 41.5 days

Overall this will rise cycle time to

[15 + 32 - 41.5 days] that is to 5.5 days

Interest cover

At present interest cover earnings prior to interest and tax divided by interest is $2m/$0.5m

= 4.0 times this appears safe.

The advanced payment will increase interest costs but will generate savings via the discount. The discount relate to half of cost of sales that is ½ × $8m × 5% = $0.2m. The EBIT will rise accordingly.

The net advanced payment of ($4m - $0.2m) = $3.8m will have to be financed for an extra (68 - 15) days generating interest costs of

[$3.8m × 12% × 53/365] = $66,214

The interest covers somewhat declines to

[$2.0m + $0.2m]/[$0.50m + $0.066m] = 3.89 times

Profit after tax, ROE and EPS

The "before" and "after" income statements seems thus

1036_Analysis of potential arrangement with supplier.png

The proposal seems beneficial to Keswick in terms of the effect on profitability measures that is EPS, EBIT, PAT, and ROE. But it does have a slightly harmful effect on its interest cover. It as well lengthens its working capital cycle and turns it into a net demander of working capital. This suggests an raise in its capital gearing.

Prior to the adjustment gearing at book values (overdraft/shareholder's funds) was

$3.0m/$2m = 150%

The overdraft will raise by

($3.8m × 53/365] = $0.55m

Ignoring the helpful effect on equity, gearing after the adjustment becomes

$3.55m/$2m = 178%

This appears rather dangerous considering the short-term nature of much of the debt and Keswick's low liquidity. May be Keswick must reconsider its policy regarding long-term borrowing although whether prospective lenders would oblige is probably doubtful.

Posted Date: 7/12/2013 1:09:44 AM | Location : United States







Related Discussions:- Analysis of potential arrangement with supplier, Assignment Help, Ask Question on Analysis of potential arrangement with supplier, Get Answer, Expert's Help, Analysis of potential arrangement with supplier Discussions

Write discussion on Analysis of potential arrangement with supplier
Your posts are moderated
Related Questions
FV of Bond 20000, CR 0.045, MR 0.059, Remaining payments 32. Answer

Mason Co. issued $860,000 of 5 year, 13% with interest payable semiannually, at a market (efffective) interest rate of 12% Determine the present value of the bonds payable, using t

ORDER OF PAYMENTS The bankrupt’s estate must be distributed in the following order. 1. Cost and charges: Costs and charges properly incurred in administering the estate mu

Question A The key functions of financial system are to provide a link between savers and investors. What are the key functions of financial market Question B Describe the me

Pooling of Interest - Used to account for acquisition of another company when acquiring company exchanges its voting COMMON STOCK for voting common stock of the attained company wh

Valuing Callable Bonds: Bowdeen Manufacturing intends to issue callable, perpetual bonds with annual coupon payments. The bonds are callable at $1,350. One-year interest rates

Assets                                                       2011                                                                        2010 Non Current Assets

Since 1968, Dracula Limited has traded in Doncaster, South Yorkshire as a manufacturer of fancy-dress and theatrical costumes. It produces a wide range of general theatrical costum

Determine out the future value of Rs.1000 compounded yearly for 10 years at an interest rate of 10 percent. Solution: The future value 10 years thus would be FV = PV (1+k)

Can I send you my homework?