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
Investment with cum.div. Quotation Investment with cum.div. Quotation will be debited to the investment account at its full value. When the dividend is subsequently received it

I have one assignment of this course (diploma Financial Planning), can you help me in doing my assignment

Consider an economy with three states which occur with probability (0.2, 0.4, 0.4). Suppose a firm has a project which generates the state dependent cash flows (100, 200, 200) at t

Comparison with Sector Averages Any conclusion relating to the signs of overtrading needs to be put in the context of the normal values of accounting ratios indicated by the se

Hi I am doing my thesis on IAS 40 and I''m sort of stuck with finding information. I need to find positive and negative international critique on the standard

what is the implication of applying accounting concepts wrongly

Holding company with a subsidiary and a sub-subsidiary Where the subsidiary company has another subsidiary company, then that subsidiary is referred to as a sub-subsidiary compan