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
equity share capital rs 10 200 10% preference share capital 80 15% debenture 20 profit before interest and taxes 60 proposed dividend 20 provision fo

i need to prepare a steep analysis report for kathmandu

Ordinary Income - One of two classes of income (other being CAPITAL GAINS) taxed under the INTERNAL REVENUE CODE. Factually, ordinary income is taxed at a higher rate than capital

Home Inc. is considering buying a new piece of equipment, which will cost $715,000 and has an economic life of 5 years, in order to make a new line of product.  The company suppose

Calculate the present value and determine the npv, Financial Management. Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently em

The intestate leaves no spouse but children The net estate devolves upon the surviving children and is divided equally between them. If any child has not, at the time of intest

inventory ratio of 4 compared to 7.1

the role of international accounting toward promotion of generally accepted accounting principle

Illustration regarding profit that head office can claim E Ltd sets up a branch in Nyeri on 1 July 2001. Goods are sent to branch at an invoice price which is 10% above cost. S