Financial Analytics for Managerial Decisions

111 views 8:07 am 0 Comments May 26, 2023

BUSM4154 Financial Analytics for Managerial Decisions

Assessment 2

Practice Aspect of Management Semester 1 2023

This document provides the details of the case you need to analyse. This case concerns a listed company, Gillian Irene Fashion Ltd, and you will find details of the case in subsequent pages.

Scenario

Gillian Irene Fashion Limited

It is January 10, 2023, and Kim Luong sits at her desk and contemplates the work assigned to her by her manager. Kim has recently graduated from RMIT University and had been hired as a junior analyst for a business consulting firm. Her company provides financial consulting services to a range of industry clients, and Kim’s role requires her to analyse a company’s financial statements and make recommendations for financial improvement.

For this particular assignment, Kim is working with Pravin, another junior analyst in the firm. Their manager wants to arrange a session with their latest client, the Chief Operating Officer (COO) of Gillian Irene Fashion Limited, Ms Lena Roy. Gillian Irene Fashion Limited, trading as Gillian Irene, is a large business selling clothes to mature women. About 50% of sales are online, and there are retail shops in all states in Australia.

Kim has been informed by one of her colleagues that Ms. Roy is a very busy executive who likes to get to the point and Kim is eager to be well prepared and make a good first impression. As Kim reviews her client’s Financial Statements and other financial data from the last four years (see Tables 1-4), she considers how to approach her analysis. She and Pravin are expected to thoroughly assess Gillian Irene’s previous financial performance and to prepare a set of recommendations to present to the new client.

Background

Gillian Irene Fashion Limited is an Australian retail company selling clothes for the mature women. The range of clothes is quite large, including formal wear, resort wear, business attire and casual clothing.

More than thirty years ago, two friends, Gillian Young and Irene Morris were co-workers in an office in Melbourne. Both women were aged at that time in their early fifties and both were disappointed at what they were finding when they went shopping for clothes, especially clothes suitable to wear to the office. At that time Gillian’s daughter, Danielle, was studying fashion design and merchandising, and Danielle helped her mother find some clothes that were of a better standard, fit and design than Gillian was used to. Irene was very impressed with Gillian’s new wardrobe and asked Gillian if Danielle could help her to find some new clothes, too.

Irene was delighted with the clothing pieces Danielle had sourced for her, and likewise Danielle was pleased that her fashion sense and knowledge of the industry had given her the skills to make her mother and Irene so happy. Danielle quickly realised that this cohort of women, i.e. working women aged fifty and above, was an excellent market for her skills, and she began a small business, Gillian Irene Fashion naming her enterprise after the two women who gave her the impetus to start her work in fashion merchandising.

For this business, Danielle sourced a small collection of suitable business clothes and began to sell them at clothing parties. A clothing party is a get together in somebody’s home where the clothes are shown and the people there can try them on, and if they like them, they can place an order. The host invites a small group of her friends and relatives to her home, and provides some refreshments. Often the host receives a small proportion of the sales as payment for her effort. Whilst Danielle was conducting clothing parties in evenings and at the weekend, she was also working for a salary for a company selling clothes to young women.

The clothing parties Danielle conducted were a great success. Most women were delighted with the clothes, as they, like Gillian and Irene, had been finding buying clothes suitable for the work environment quite difficult. After two years, Danielle had realised that she enjoyed her work with her own little business much more that the work she was doing for a salary. She resigned from her salaried work and began to work solely on her business. She sought appropriate financial and legal advice, eventually changing her business structure from being a sole trader to a proprietary company which she named Gillian Irene Fashion Pty Ltd. She ceased to use clothing parties as her way of selling the clothes, but instead rented a small shop in her local suburban shopping centre.

In the first few years of the business, Gillian Irene sold only formal business wear, concentrating on the original market of older women. However, over the years, Danielle realised that there was other fashion sectors that this age group was eager to purchase. For many people who bought business wear at Gillian Irene’s, they had considerable disposable income as their children were grown and household expenses had lessened. Thus, the clothing range was extended to include formal wear such as for weddings, smart casual clothing, and resort wear. As well as expanding the range of clothing sold, Danielle opened three more stores, all in suburban Melbourne.

The business continued to be very successful and in 2007 to raise capital for its expansion, Gillian Irene Fashion Ltd listed on the Australian Stock Exchange (ASX). After the successful share float Gillian Irene Fashion Ltd, trading as Gillian Irene maintained it customer focus to be women aged 50 and over and set up retail stores in shopping centres across Australia. In 2018 it began to sell online. When Covid-19 hit in March 2020, Gillian Irene was able to switch to the online platform for more than 60% of its sales in the 2020 calendar year.

Industry outlook

Gillian Irene Fashion Ltd can be considered as a company operating in the retail clothing sector.

Over the next three to four years, there is expected to be some growth in this sector. However, given the economic environment, Inflationary pressures are expected to increase, with the wholesale price of clothing growing. Such a rapid increase in wholesale price might mean that retailers are not able to pass all the cost increase on to customers.

Another factor for this industry is the consideration of the green economy. While the fashion sector is growing, increasing attention has been brought to the range of negative environmental impacts that the industry is responsible for. These impacts include carbon emissions, excessive use of water resources, and the dumping of used clothing in landfill.

Gillian Irene’s operational issues

Net profit after tax dipped from $17 million after tax for the year ending June 30, 2019, to $11 million after tax for the financial year ending 30 June 2020. For the following two years, the net profit after tax has been $26 million and the $27 million. However, the net operating cash flows for the year ending June 30, 2022, was a most concerning i.e. ($62 million) whereas the amount for the previous year was $18 million, a difference of $80 million. This outflow of cash is noticeable on the balance sheet. Cash at the end of June 2021 was more than $85 million, whereas, twelve months later, the amount of cash held was only $11 million. Another worrying result is that, on June 30, 2021, receivables were $6.7 million, but by June 2022, this balance sheet item had ballooned to $13.2 million.

The stock market has reacted most unfavourably to the company since June 2022. At the end of June 2021 Gillian Irene’s share price was $6.10. and it stayed around this amount throughout the remainder of the calendar year 2021. However, by the end of June 2022 the share price had dropped to $2.20 The share price of Gillian Irene’s shares has continued to drop, with the price at the end of October 2022 being $1.60, at the end of November 2022 $0.86, and now, the beginning of January 2023, it is just $0.54.

The evaluation

Gillian Irene’s COO is becoming increasingly worried about the company’s financial performance and is particularly concerned about the ongoing decrease in the company’s share price. Ms. Roy would like some advice on how the company’s financial performance can be improved so as to improve shareholder confidence in her company.

Please note: You are required to conduct a thorough financial analysis based on the financial statements using the tools learned from the course.

ANALYSE ASSEST EFFIECIENCY RATIOS AND PROVIDE RECOMMENDATIONS.

ASSET EFFICIENCY RATIOS

 

 

 

 

 

 

 

 

 

Asset turnover

 

x times (2 decimal places)

 

 

 

 

 

 

 

 

(Sales revenue / Average total assets ) = x times

Days inventory

 

x days (2 decimal places)

 

 

 

 

 

 

 

 

(Average inventory / Cost of Sales ) * 365 = x days

Days debtors

 

x days (2 decimal places)

 

 

 

 

 

 

 

 

(Average trade debtors / Sales revenue ) * 365 = x days

Times inventory turnover

 

x times (2 decimal places)

 

 

 

 

 

 

 

 

(Cost of sales / Average inventory ) = x times

Times debtors turnover

 

x times (2 decimal places)

 

 

 

 

 

 

 

 

(Sales revenue / Average trade debtors ) = x times

Table 1. Gillian Irene Fashion Ltd

Consolidated Statement of Financial Performance for the year ended 30 June.

Item

Notes

06/19

06/20

06/21

06/22

Operating Revenue

$178,118,400

$233,390,400

$310,172,400

$443,781,600

Other Revenue

$300,000

$0

$1,371,600

$25,200

– Cost of Sales

($75,081,600)

($121,222,800)

($163,754,400)

($255,860,400)

Gross Profit

$103,336,800

$112,167,600

$147,789,600

$187,946,400

– Operating Expenses

($72,463,200)

($66,436,800)

($86,250,000)

($120,463,200)

EBITDA

$30,873,600

$45,730,800

$61,539,600

$67,483,200

– Depreciation and Amortisation

($4,730,400)

($21,081,600)

($17,254,800)

($18,244,800)

EBIT

1

$26,143,200

$24,649,200

$44,284,800

$49,238,400

– Net Interest Expense

$447,600

($482,400)

($1,324,800)

($1,858,800)

EBT

$26,590,800

$24,166,800

$42,960,000

$47,379,600

– Tax Expense

2

($5,976,000)

($9,038,400)

($11,899,200)

($12,549,600)

Net Profit after Tax Before Abnormals

$20,614,800

$15,128,400

$31,060,800

$34,830,000

– Net Abnormals

($3,496,800)

($4,136,400)

($5,193,600)

($8,097,600)

Reported NPAT After Abnormals

$17,118,000

$10,992,000

$25,867,200

$26,732,400

Table 2. Gillian Irene Fashion Ltd

Information regarding shares earnings 2019 – 2022

Item

06/19

06/20

06/21

06/22

Shares Outstanding at Period End

$230,683,345

$230,683,345

$274,395,886

$287,232,700

Weighted Average Number of Shares

$230,683,345

$230,683,345

$269,578,088

$277,629,910

EPS Adjusted (dollars/share)

$0.0897

$0.0661

$0.1138

$0.1222

EPS After Abnormals (dollars/share)

$0.0745

$0.0482

$0.0949

$0.0940

Table 3. Gillian Irene Fashion Ltd Statement of Financial Position as at 30 June

Item

Notes

06/19

06/20

06/21

06/22

Cash

$27,856,800

$25,658,400

$85,748,400

$11,943,600

Receivables

$5,488,800

$6,087,600

$6,727,200

$13,213,200

Prepaid Expenses

$1,030,800

$960,000

$6,676,800

$3,897,600

Inventories

3

$23,223,600

$45,687,600

$80,395,200

$235,123,200

Other

$556,800

$1,754,400

$1,567,200

$1,916,400

Total Current Assets

 

$58,156,800

$80,148,000

$181,114,800

$266,094,000

 

 

PP&E

4

$11,167,200

$37,435,200

$39,159,600

$49,932,000

Intangibles

5

$6,069,600

$20,072,400

$36,483,600

$39,015,600

Goodwill

$12,114,000

$26,959,200

$54,238,800

$62,583,600

Future Tax Benefit

$14,468,400

$10,393,200

$9,369,600

$8,796,000

Total NCA

 

$43,819,200

$94,860,000

$139,251,600

$160,327,200

 

 

Total Assets

 

$101,976,000

$175,008,000

$320,366,400

$426,421,200

 

 

Account Payable

$30,626,400

$45,033,600

$50,275,200

$96,390,000

Short-Term Debt (Lease)

$0

$11,031,600

$11,143,200

$10,908,000

Provisions

$12,738,000

$10,656,000

$11,865,600

$14,486,400

Other

$913,200

$92,400

$3,686,400

$5,164,800

Total Current Liabilities

 

$44,277,600

$66,813,600

$76,970,400

$126,949,200

 

 

Long-Term Debt

6

$0

$42,597,600

$22,521,600

$45,811,200

Provisions

$2,329,200

$930,000

$550,800

$506,400

Other

$2,250,000

$0

$841,200

$462,000

Total NCL

 

$4,579,200

$43,527,600

$23,913,600

$46,779,600

 

 

Total Liabilities

 

$48,856,800

$110,341,200

$100,884,000

$173,728,800

 

 

Net Assets (TA – TL)

 

$53,119,200

$64,666,800

$219,482,400

$252,692,400

 

 

Share Capital

$58,966,800

$58,966,800

$190,041,600

$218,600,400

Reserves

7

($297,600)

$2,626,800

$500,400

($34,770,000)

Retained Earnings

($5,550,000)

$3,073,200

$28,940,400

$68,862,000

Total Equity

 

$53,119,200

$64,666,800

$219,482,400

$252,692,400

Table 4. Gillian Irene Fashion Ltd

Consolidated Statement of Cash Flows for the year ended 30 June

Item

Notes

06/19

06/20

06/21

06/22

Receipts from Customers

$196,021,200

$250,780,800

$338,066,400

$482,164,800

Payments to Suppliers and Employees

($199,050,000)

($217,848,000)

($314,709,600)

($532,570,800)

Interest Received

$709,200

$66,000

$291,600

$40,800

Interest Paid

($261,600)

($708,000)

($765,600)

($1,899,600)

Tax Paid

($2,319,600)

($5,328,000)

($11,078,400)

($10,575,600)

Other Operating Cashflows

$300,000

$3,307,200

$6,379,200

$567,600

Net Operating Cashflows

 

($4,600,800)

$30,270,000

$18,183,600

($62,272,800)

 

Payment for Purchase of PPE

($12,753,600)

($6,636,000)

($7,891,200)

($13,854,000)

Payments for Purchase of Subsidiaries

$0

($30,789,600)

($48,249,600)

($5,104,800)

Other Investing Cashflows

$37,318,800

$0

$0

$0

Net Investing Cashflows

 

$24,565,200

($37,425,600)

($56,140,800)

($18,958,800)

 

Proceeds from Issues

$0

$0

$130,341,600

$0

Proceeds from Borrowings

$0

$27,000,000

$0

$16,800,000

Repayment of Borrowings

($15,432,000)

($6,000,000)

($21,000,000)

$0

Dividends Paid

($11,534,400)

($3,460,800)

$0

$0

Other Financing Cashflows

$0

($13,905,600)

($9,414,000)

($9,648,000)

Net Financing Cashflows

 

($26,966,400)

$3,633,600

$99,927,600

$7,152,000

 

Net Increase in Cash

($7,002,000)

($3,522,000)

$61,970,400

($74,079,600)

Cash at Beginning of Period

$34,714,800

$27,856,800

$25,658,400

$85,748,400

Exchange Rate Adj

$144,000

$37,200

($1,880,400)

$274,800

Other Cash Adjustments

$0

$1,286,400

$0

$0

Cash at End of Period

 

$27,856,800

$25,658,400

$85,748,400

$11,943,600

Additional Information

Notes: The financial statements have been prepared on a historical cost basis. The financial statements are presented in Australian dollars.

EBIT denotes earnings before interest and taxes.

Note that calculation of taxation expense involves the application of taxation law.

Inventories are measured at the lower cost and net realisable value.

Property, plant, and equipment are measured at cost less accumulated depreciation and accumulated impairment losses.

Intangibles exclude goodwill.

Long term debt includes Debt and longer-term portion of Lease.

Other reserves include foreign currency translation reserves arising from exchange rate differences.