+1-415-670-9189
info@expertsmind.com
Financial assessment of mk robe-stones limited business plan
Course:- Financial Management
Reference No.:- EM13399




Assignment Help
Assignment Help >> Financial Management

MK Robe-Stones (MK-R-S) is a big manufacturing firm which was set up as a Limited company 6 years ago, in 2009, by a family organisation. The firm was originally started as a business to sell the main family business by-product which is a type of oil.  MK Robe-Stones main product is thus a by-product of this process, which is primarily involved in the Chemicals business.

At the conception the firm (MK-R-S) the initial capital for the company came from the Director of the Parent Company (Gordon Robe-Stones), his children, Jack, Lucinda and Josh Robe-Stones' and a few other individuals whom knew of the prospects of the company.  The total capital which they managed to gather via this method was £5,000,000. The company by the end of its first year trading had retained profits which accumulated to £507,000. Hence by the end of the companies first year, the Profit and Loss Statement and the Balance Sheet had the following composition.

31st January 2009

Profit and Loss Account of MK Robe-Stones Ltd.

 

 

 

 

Sales Revenue

 

 

 £        8,902,300

 

Cost of Sales

 

 £        6,870,120

Gross Profit

 

 

 £        2,032,180

 

Administration Expenses

 

 £            519,000

 

Distribution Expenses

 

 £            130,000

Operating Profit

 

 

 £        1,383,180

 

(Net) Interest

 

 £               50,500

Profit Before Tax

 

 

 £        1,332,680

 

Taxation

 

 £            466,438

Profit Attributable to Shareholders

 

 

 £            866,242

 

Dividends Paid to Shareholders

 

 £            359,242

Retained Profit C/F

 

 

 £            507,000

The subsequent years following up to the present day, the company has the Profit and Loss statements of:

Profit and Loss Entry/Year

2010

2011

2012

2013

 

Sales Revenue

£        9,549,000

£      12,342,000

£      11,350,000

£      13,890,000

Cost of Goods Sold

£        7,120,780

£        9,340,500

£        7,890,210

£        8,790,000

Gross Profit

£        2,428,220

£        3,001,500

£        3,459,790

£        5,100,000

Administration Expenses

£            980,500

£        1,023,000

£        1,009,400

£        1,279,000

Distribution Expenses

£            256,000

£            506,000

£            460,000

£            579,000

Operating Profit

£        1,191,720

£        1,472,500

£        1,990,390

£        3,242,000

(Net) Interest

£               50,500

£               75,078

£               89,450

£            104,000

Profit Before Tax

£        1,141,220

£        1,397,422

£        1,900,940

£        3,138,000

Taxation

£            365,190

£            475,123

£            684,338

£            972,780

Profit Attributable to Shareholders

£            776,030

£            922,299

£        1,216,602

£        2,165,220

Dividends

£            325,000

£            679,000

£        1,054,000

£            500,890

Retained Earnings C/F

£            451,030

£            243,299

£            162,602

£        1,664,330

The industry benchmarks for the companies which are in similar industries are as follows for the key financial ratios. The information which is presented below is the 5 year average and associated standard deviations in terms of % (or terms of reference):

Ratio

Average

Standard Deviation

Gross Profit Margin

28%

8%

Operating Profit Margin

13%

7%

Return on Capital Employed

26%

3%

Current Ratio

10.04 : 1

3.0

Asset Turnover

£1.96 : 1

£0.89

Gearing Ratio

15.6%

5%

 

The respective years' Balance Sheets are as follows:    

Balance Sheet Entry/Year

2009

2010

2011

2012

2013

Non-Current Assets

 

 

 

 

 

Property, Plant and Equipment

£        4,245,000

£        4,871,450

£        5,324,908

£        5,891,398

£        6,965,000

 

 

 

 

 

 

Current Assets

 

 

 

 

 

Stock / Inventories

£        1,589,000

£        1,439,000

£        1,345,000

£        2,330,230

£        2,840,000

Debtors / Trade Receivables

£            456,000

£            578,980

£            645,112

£            569,000

£            895,500

Cash and Near Cash Equivalents

£               42,000

£               97,900

£               74,968

£               94,891

£               50,260

 

£        6,332,000

£        6,987,330

£        7,389,988

£        8,885,519

£      10,750,760

Current Liabilities

 

 

 

 

 

Over-draft / Borrowings

£                         -

£               58,600

£               34,500

£               12,789

£                         -

Creditors / Trade Payables

£               56,000

£            101,700

£            109,560

£            129,800

£            312,500

Taxation Payable

£               89,000

£            189,000

£            248,900

£               32,000

£               48,000

 

 

 

 

 

 

Non-Current Liabilities

 

 

 

 

 

Borrowings / Debt

£            680,000

£            680,000

£            795,700

£            897,000

£            912,000

 

 

 

 

 

 

 

£        5,507,000

 

£        5,958,030

 

£        6,201,328

 

£        7,813,930

 

£        9,478,260

 

Capital

 

 

 

 

 

Ordinary Share Capital (5,000,000 @ £1  Business Conception)

£        5,000,000

£        5,000,000

£        5,000,000

£        6,000,000

£        6,000,000

Share Premium Account

£                         -

£                         -

£                         -

£            450,000

£            450,000

Retained Earnings

£            507,000

£            958,030

£        1,201,328

£        1,363,930

£        3,028,260

 

 

 

 

 

 

Capital Balance

£        5,507,000

 

£        5,958,030

 

£        6,201,328

 

£        7,813,930

 

£        9,478,260

 

The company has been providing good returns to the shareholders of the organisation over the last few years. Therefore the senior managers are having concerns since they have been aware that the firm is becoming a considerable investment in terms of their personal time. They are thinking of investing some extra money in terms of equity capital that will secure a reduction in the direct labour hours which are needed to run the firm effectively. The effect of this would be a projected saving of 7% of the Costs of Sales, for the given a given increase in the Sales Revenue Projections. This could have the conditions of a 9% increase in the Administration and Distribution Expenses.

The company has also been contacted by a local banking organisation, which has informed the Management that they are running low on cash, and have offered them a loan of £500,000, to help them with the current cash flow situation. The company would be looking at paying a Rate of Interest on the Loan of 6.5% p.a. and making no long-term capital repayments for at least 10 years.

Required;

A. As a Management Consultant, with some financial expertise you have been asked to prepare a Report to the Management of the firm which covers the Company performance over the last 5 years, in detail, including 2013's results.  This is expected to cover the key performance ratios of Profitability, Liquidity and Efficiency and Financial Structure Ratios. Where ever possible you should draw upon the Financial Information provided by the industry averages to make a comparison.

B. The Management have asked you to consider the possibility that the firm may become insolvent and assess whether the loan would help with this aspect specifically.  The Manager would like you calculate the Ratios involved in Financial Bankruptcy Projections (I.e. Altman's Z-Score and any others). You should critically appraise this model of Bankruptcy Projection stating any assumptions that you make in the report.

C. The report should also detail to the Management some of the theoretical drawbacks of the type of analysis, and generally the weaknesses of the Ratio Analysis.

D. The management would also like you to put together a projection of the company making a (in line with the average sales increase?) and an investment of £649,000 in the fixed assets of the company, which could be paid for by taking out the loan of £500,000.




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Financial Management) Materials
Broussard Skateboard's sales are expected to increase by 15% from $8 million in 2013 to $9.2 million in 2014. Its assets totaled $2 million at the end of 2013. Broussard is al
On January 1, 2012 the common stock for Collins Corporation had a market value of $28.00. At December 31, 2012, the market value had increased to $32.00. During the year, Coll
Who intended to strengthen the national government by having the national government assume the state debts owed to bondholders and foreign investors? Who believed that the na
Corporate valuation Smith Technologies is expected to generate $100 million in free cash flow next year, and FCF is expected to grow at a constant rate of 5% per year indefini
A restaurant is for sale for $200,000. It is estimated that the restaurant will earn $20,000 a year for the next 15 years. At the end of 15 years, it is estimated that the res
Ten years ago, Hailey invested $4,300 and locked in an 8 percent annual interest rate for 30 years (ending 20 years from now). Aidan can make a 20-year investment today and lo
Deeble Construction Co.’s stock is trading at $30 a share. There are also call options on the company’s stock, some with an exercise price of $25 and some with an exercise pri
(Cost of common equity) The common stock for the Hetterbrand Corporation sells for $59.17, and the last dividend paid was $2.24. Five years ago the firm paid $1.84 per share,