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
SEC reporting implications i) Potentially inaccurate reporting of executive compensation in proxy statements and annual reports ii) Potential violation of securities and Law

Q. Calculation of internal rate of return? The company is accurate in its belief that NPV measures the potential increase in company value of an investment project since theore

Q. Evaluate Break-Even Production units? R.S. Manufacturing Ltd. Budgets production of 3,00,000 units at cost of Rs.10 each. The Fixed costs are Rs.20, 00,000. The selling pric

Wendy is evaluating a capital budgeting project that should last for 4 years. The project requires $ 800,000 of equipment. She is unsure what depreciation method to use in her anal

Star Corporation issued both common and preferred stock during 19X6. The stockholders' equity sections of the company's balance sheets at the end of 19X6 and 19X5 follow.

Wendy is evaluating a capital budgeting project that should last for 4 years. The project requires $ 800,000 of equipment. She is unsure what depreciation method to use in her anal

Calculating Present Value [LO1]  An investment will pay you $43,000 in 10 years.  If the appropriate discount rate is 7 percent compounded daily, what is the present value?

During it's first year of operations, Rosa Corp has these transactions pertaining to its common stock. Jan. 10 Issued 30,000 shares for cash at $5 per share July 1 Issued 60,000 sh

The three certainties A trust will be valid only if the three certainties are present i.e. certainty of words, certainty of subject, and certainty of objects.   1. Certainty

zorn conducted his professional practice through zorn, inc. the corporation uses a fiscal year ending september 30 even though the business purpose test for a fiscal year cannot be