Analysis of potential arrangement with supplier, Financial Accounting

Assignment Help:

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.


Related Discussions:- Analysis of potential arrangement with supplier

Accounting for lease, what are the concept of economic substance over legal...

what are the concept of economic substance over legal form under accounting for lease?

Fund accounting and preparation of financial statements, Fund accounting an...

Fund accounting and preparation of financial statements) The scenario: At the start of the year beginning January 1, 2013, Coco City's General Fund had a cash balance of $40,000, v

Bankrupt person-bankruptcy and liquidation, Bankrupt person A bankrupt ...

Bankrupt person A bankrupt is a person against whom an adjudication order has been made by the court primarily on the grounds of his insolvency. Any person (other than a body c

Derive the optimal value of loss function, Derive the Optimal Value of Loss...

Derive the Optimal Value of Loss Function A speculative attack and the consequent currency crisis may not be due to excessive money-growth or other misaligned fundamentals, bu

Dispute resolution over termination of contracts, Question: a) Show the...

Question: a) Show the different parts of a bidding document for works. b) Describe  five advantages of Dispute Resolution over Termination of Contracts. c) Show the diffe

Income statements, how to solve the question income statements

how to solve the question income statements

Use net present value and payback period method, Given the following cash f...

Given the following cash flows for projects A and B:   Year      Project A   Project B     0       -100,000     -150,000   (Project Cost)     1         25,000

Revenue recognition, Do we recognise revenue if it will be assigned to othe...

Do we recognise revenue if it will be assigned to other party ?

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