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

Amortization table, On November 1, 2011, Leetch Ltd. borrows $400,000 cash ...

On November 1, 2011, Leetch Ltd. borrows $400,000 cash from a bank by signing a five-year installment note bearing 8% interest. The note needs equal total payments every year on Oc

Acquisition Project , Do you have anyone on staff that understands acquisit...

Do you have anyone on staff that understands acquisition accounting procedures?

Balance sheet and income statement, 1) The detailed information is on the s...

1) The detailed information is on the second tab marked "Financials". Enter summarized Balance Sheet and Income Statement information for Cummins into the template on the "Summary

Google, how do i find info about google inc

how do i find info about google inc

What is the average rate of return on investment, a company is evaluating a...

a company is evaluating a project requiring capital expenditure of 620,000. estimated life of project is four years and no salvage value. estimated net income and net cash flow fro

Effects of the appointment of the receiver-bankruptcy, Effects of the appoi...

Effects of the appointment of the receiver Floating charges: these crystallise on the appointment of a receiver and become fixed on the assets then in the hands of the compan

Shorter compounding period, In our discussion so far, we have supposed that...

In our discussion so far, we have supposed that the compounding is done yearly, here let us see the case where compounding is complete more often.  In such case the equation (1) is

How to determine the depreciation, How to determine the depreciation To...

How to determine the depreciation To determine depreciation in straight-line method, take cost of the asset, less the trade-in value, and divide by the estimated years of usefu

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