Financial assessment of mk robe-stones limited business plan

Assignment Help Financial Management

Reference no: EM13399

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.

31^st 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.

Reference no: EM13399

Questions Cloud

Explain the short and the long-run effects on real output : Explain the short and the long-run effects on real output, price, and unemployment

Global reporting initiative : Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

Write a profile : Write a profile on bishop poleni.

Model a discrete-time system : To understand dierent signal models To be able to model a discrete-time system and design simple signal processing algorithms.

Financial assessment of mk robe-stones limited business plan : Financial Assessment of MK Robe-Stones Limited Business Plan.

Generate descriptive statistics : Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

Supply chain network design for cwc : This assignment explain the supply chain management process of cwc. What is the current annual supply chain cost?

Determine the necessary shell temperature : In a shell-and-tube heat exchanger, one fluid passes through a central tube while another fluid flows through an outer shell in the opposite direction. The purpose is to heat the fluid passing through the central tube.

Hydraulic behaviour in open channel : Describe how test flumes and associated equipment are used to assess and confirm hydraulic behaviour in open channel

User Account

All Pages