Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need proper and details explanation for this case study Financial statement part (i, ii & iii Area of concern) Analyse the financial statements that

I need proper and details explanation for this case study Financial statement part (i, ii & iii Area of concern)

Analyse the financial statements that have been prepared by Home Range Ltds financial director. In particular, comment on the following aspects of the company:

i. Areas of concern in financial performance, focusing mainly on information from the income statement

ii. Areas of concern in financial health, focusing on ratios dependent on the income statement and the balance sheet

iii. Areas of concern in cash flow management, focusing on information available from the cash flow statement.

Assess the value of Clare Lombardos parents recent concern that the company has not spent its significant cash resources wisely in the past year (the year to 31 December 2017). What practical steps should Clare Lombardo now undertake in order to help to maximise the value of the business for resale in about 3 years?

Case study

Home Range Ltd

Clare Lombardo comes from a family that has bought, renovated and sold or rented houses as a side-line to their main forms of employment for a number of years. This family interest has proved to be a profitable small business. Her father is an electrician by trade but has developed skills in other areas such as basic plumbing and carpentry. This has greatly reduced the cost of doing up old properties. Clares mother works as a part-time bookkeeper so she has enough spare time to keep proper financial records for the business.

Clares favourite subject at school was Art. While still at school Clare discovered a knack for helping her parents to tastefully furnish renovated properties in preparation for their sale or rent. After school Clare studied interior design while helping run her parents business.

About 20 years ago Clare was left money by a grandparent. She used this to open her first Home Range shop in an exclusive part of London. It sells high quality home furnishings and accessories to mainly wealthy customers who have limited time.

Clares luck, good taste and business acumen has proved very successful. She formed the private company Home Range Ltd 18 years ago, and it has grown to consist of a chain of 25 stores in wealthy parts of London and the south east of England. The retail outlets have been complimented by an effective and profitable website.

Clare is the majority shareholder while her parents own the remaining shares in the business. Clare has recently decided she wants to sell the business in about three years. She is conscious that her parents are growing old and she also want to spend more time with her young family.

Clares parents have decided to retire from formal employment in the next few months. They will still run their property business. While they are essentially passive shareholders in Home Range Ltd, Clare still relies on them for common sense advice she can trust.

Home Range Ltd has been particularly profitable since the global financial crash beginning in 2007. It appears to Clare and the financial director of the company that the luxury goods market has not been affected by cuts in government expenditure. In the year ending 31 December 2016 the company achieved a record return on equity of 35%. This has generated some media interest in Home Range Ltd as well as a number of serious offers to buy the company.

Clare now wants to invest more in the company to continue to make it grow in profitability for the next 3 years so she can maximise its value for the planned sale. On the 1st January 2017 the business took out a further bank loan of 1.2 million to expand the business with as little risk as possible. In the last year, Clare has relied mainly on advice of the company financial director to invest particularly in buying goods with a higher profit margin and to spend more on marketing. Her parents have recently challenged the views of the financial director and advised Clare that the company has not spent its significant cash resources wisely in the past year.

Clare now needs to properly understand the implications of the latest financial statements below to see if the company is on the right track, and if her parents recent advice is justified.

Home Range Ltd Income Statement

For the years ended 31 Dec 2017 and 2016

Year to 31 Dec 2017

Year to 31 Dec 2016

k

k

k

k

Sales revenue

106,872

88,476

Less: cost of goods sold:

Opening inventory

6,246

5,168

Purchases from wholesalers

61,256

40,626

67,502

45,794

Less closing inventory

8,792

6,246

Cost of goods sold

58,710

39,548

Gross profit

48,162

48,928

Less expenses:

Salaries and other costs

17,562

16,154

Rent and office services

636

628

Insurance

97

94

Distribution and postage costs

325

310

Marketing and advertising expenses

1,137

864

Office administration

171

164

Energy and other utilities

272

264

Depreciation

704

682

Audit, Accounting & Legal Costs

46

43

Interest on bank loan

48

12

Interest on bank overdraft

0

0

Total Expenses

20,998

19,215

Interest received

1,350

1,290

Profit before taxation

28,514

31,003

Corporation tax

5,703

6,201

Profit after taxation

22,811

24,802

Home Range Ltd Balance sheets at 31st December 2017 and 2016

Year to 31 Dec 2017

Year to 31 Dec 2016

k

k

k

k

Non-current assets

Property

13,659

14,400

Computers and equipment

412

328

Vehicles

248

234

Total non-current assets

14,319

14,962

Current assets

Inventory

8,792

6,246

Receivables

4,051

1,612

Other current assets

48

46

Cash at bank

100,158

79,188

Total current assets

113,049

87,092

Current liabilities

Payables

11,124

9,398

Corporation tax

5,703

6,201

Other tax liabilities

349

273

Bank overdraft

0

0

Total current liabilities

17,176

15,872

Net current assets/working capital

95,874

71,220

Total assets less current liabilities

110,193

86,182

Long-term liabilities

Bank loan

1,600

400

Net Assets

Total108,593

Total85,782

Equity

Share capital

1,000

1,000

Reserve: retained earnings

107,593

84,782

Total Equity

Total108,593

Total85,782

Home Range Ltd Cash Flow Statements For the years ended 31 December 2015 and 2014

Year to 31 Dec 2017

Year to 31 Dec 2016

k

k

Operating activity:

Operating profit

27,212

31,003

Interest paid on overdraft

0

0

Corporation tax paid

(6,201)

(6,485)

Add back non-cash expenses:

Depreciation

704

682

Loss/(Profit) on disposal of non-current assets

0

0

Changes in cash invested in Working Capital:

(Increase)/Decrease in Inventory

(2,546)

(1,078)

(Increase)/Decrease in Receivables

(2,439)

(472)

(Increase)/Decrease in Other current assets

(2)

8

Increase/(Decrease) in Payables

1,726

1,854

Increase/(Decrease) in Other tax liabilities

76

94

Net cash inflow/(outflow) from operating activities

18,530

25,606

Investing activity:

Purchase of non-current assets

(62)

(47)

Proceeds on disposal of non-current assets

0

0

Net cash generated (consumed) by investing activity

(62)

(47)

Financing activity:

New Bank Loan

1,200

0

Interest paid on bank loan

(48)

(12)

Interest received on bank deposit

1,350

1,290

Net cash generated (consumed) by financing activity

2,502

1,278

Change in Cash Balances

20,970

26,837

Opening cash balance (overdraft) at 1st January

79,188

52,351

Closing cash balance (overdraft) at 31st December

Total100,158

Total79,188

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Auditing And Assurance

Authors: James A. Hall, Tommie Singleton

2nd Edition

0324191987, 978-0324191981

More Books

Students also viewed these Accounting questions

Question

here) and other areas you consider relevant.

Answered: 1 week ago