Questions & AnswersFinancial Accounting

   Summary of business Founded in 1981, FLT is an Australian...

Question
Answered step-by-step
Asked by DeaconThunderFish33 on coursehero.com

   Summary of business Founded in 1981, FLT is an Australian...

 

 Summary of business

Founded in 1981, FLT is an Australian based travel agency headquartered in Brisbane, Queensland. The Company had its IPO in 1995 and had a revenue of AUD 2.64B for FY2016. The company has almost 3000 stores in 14 countries. Although the bulk of FLT's revenues come from airline ticket sales, it also generates revenues from a number of other services within the travel industry, such as cruise lines, car hires, and hotel accommodation.

APPENDIX A

Flight Centre Ltd (AU)

 

 

 

 

In Millions of $AUD

FY 2014

FY 2015

FY 2016

Revenue

2,212.40

2,367.40

2,640.30

  - COGS

1,818.00

2,009.90

2,278.20

Gross Profit

394.40

357.60

362.20

  + Other Operating Revenue

90.85

86.99

94.44

  - Depreciation & Amortization

53.80

54.10

66.10

  - Other Operating Expenses

3.50

3.10

1.40

EBIT

427.95

387.39

389.14

  - Interest Expense

29.50

24.30

28.10

  - Foreign Exchange Losses (Gains)

15.00

-5.10

-3.80

  - Net Non-Operating Losses (Gains)

3.50

3.10

-1.40

Pre-tax Income

379.95

365.09

366.24

  - Income Tax Expense

116.86

109.74

100.49

Net Income (loss)

263.09

255.34

265.75

    

In Millions of $AUD

FY 2014

FY 2015

FY 2016

Assets

 

 

 

  + Cash & Near Cash Items

1,261.70

1,378.00

1,316.00

  + Short-Term Investments

41.20

75.70

204.50

  + Accounts Receivable

537.60

635.50

672.20

  + Inventories

47

63.6

70.5

Total Current Assets

1,887.50

2,152.80

2,263.20

  + Net Fixed Assets

161.00

196.30

216.30

    + Gross Fixed Assets

383.10

465.60

533.30

    - Accumulated Depreciation

222.10

269.30

317.00

  + Other Long-Term Assets

361.90

438.90

521.80

Total Long-Term Assets

522.90

635.20

738.10

Total Assets

2,410.40

2,788.00

3,001.30

 

 

 

 

Liabilities & Shareholders' Equity

 

 

 

  + Accounts Payable

1040.5

1056.2

1487.1

  + Short-Term Borrowings

42.90

32.80

76.80

Total Current Liabilities

1261.20

1452.50

1566.70

  + Long-Term Borrowings

51.4

65.30

88.60

Total Long-Term Liabilities

51.40

65.30

88.60

Total Liabilities

1312.60

1517.80

1655.40

  + Share Capital

363.76

432.64

423.35

  + Retained Earnings

734.04

837.49

922.60

Total Equity

1097.80

1270.12

1345.95

Total Liabilities & Equity

2410.39

2787.97

3001.32

    

Cash Flow Information (inflows in positive & outflows in negative)

In Millions of $AUD

FY 2014

FY 2015

FY 2016

Capital Expenditures

-55.43

-82.85

-103.79

Disposal of Fixed Assets

0.00

0.00

17.20

Additional Long Term Debt

3.13

33.32

33.30

Cash Dividends Paid - Total

-146.78

-153.11

-158.35

Reduction In Long Term Debt

-1.48

-17.43

-10.00


Table below contains information on the historic earnings per share (EPS) and dividend per share (DPS) for the company. Using the information in the table, calculate the expected dividend growth rate of the company. Answer in the box provided (10 MARKS).
 

 

(A) Historical growth rate (5 marks)

PER SHARE DATA

EPS

Dividend

Y2016

2.42

1.52

Y2015

2.55

1.52

Y2014

2.06

1.52

Y2013

2.46

1.37

Y2012

2.00

1.12


 

 

 

(B)   Sustainable Growth Rate for 2016 (5 marks)

Assuming that the Return on Equity (ROE) for Flight Centre is 18.7% for the year 2016, calculate what is sustainable growth rate of the company? Answer in the box provided.


Calculate Beta (β) for Flight Centre. Answer in the box provided (5 marks).

Assume standard deviation of market returns = 0.25, standard deviation of FLT stock's returns is 0.45 and correlation coefficient of market returns and returns on FLT stock is 0.69.

 

Calculate required rate of return for the stock using CAPM Model and the following information. Answer in the box provided (5 marks).

Assume that the market risk premium is 7.25 %. The 10-year Treasury bond rate is 3.00%. Use beta you calculated in answering Question 2.


In this section you are required to do financial ratio and cash flow analysis using the balance sheet, income statement and summary cash flow information provided in Appendix A.

 

Financial Ratio and Cash Flow Analysis.

 (A) Calculate the following financial ratios for 2016. Use only year-end values (DO NOT use average values) (30 marks).

LIQUIDITY            

Quick Ratio (QR)

Current Ratio (CR)

 

ASSET UTILIZATION

Total Assets Turnover (TAT)

Inventory Turnover (IT)

Receivables Turnover (RT)

 

LEVERAGE

Debt-Equity Ratio (D/E)

Interest Coverage (INT Cov)

 

PROFITABILITY

Operating Profit Margin (OPM)

Net Profit Margin (NPM)

Return on Equity (ROE)

 


 

 

(B) Calculate the ROE for FLT using the DuPont model. Clearly show your workings (3 marks).

(C) Measures of Cash Flow (12 marks)Using the financial statements calculate the following two measures of cash flows for 2016. Answer in the box provided by clearly showing your workings. Use a tax rate of 30%.

Free Cash flow to the Firm (FCFF) (6 marks)

Free Cash Flow to the Equity (FCFE) (6 marks)

 

Valuation

(A) Using the multi-stage dividend discount model (DDM), calculate the value of FLT shares. Use scrap paper for your workings (15 MARKS).

Assume that dividends in the next three years (starting from year 2017) will grow at a rate of 13% annually. Further, it is assumed that dividends will grow at a rate of 11% for the next four years (year 4 to 7). Thereafter it is assumed that the company will grow at a constant growth rate of 7% per annum. The last dividend paid (for 2016) is $1.52. Assume a required rate of return of 12%.

Clearly show the following:

 

Present Value of First Stage (4 marks)

 

Present Value of Second Stage (5 marks)

 

Present Value with constant growth rate (5 marks)

Stock Intrinsic Value (1 marks)

 

(B) Using the following data, calculate the equity value of FLT share (value per share). Answer in the box provided (10 MARKS).

Assume that FLT has FCFF of $ 150 million and FCFE of $ 200 million for the last financial year (since the last financial year had many unusual items, we ignore the FCFF/FCFF calculated earlier and use projected values instead). Both FCFF and FCFE are expected to grow at a constant rate of 7% per annum indefinitely. FTL's required rate of return of equity is 12% and the before tax cost of debt is 7%. The company expects a target capital structure consisting of 20% debt financing and 80% equity financing. The tax rate is 30%.  Use book value of long-term debt. FLT has 100 million outstanding common shares.

 

Clearly show the following:
 

 

 

FCFE (4 Marks)

 

FCFF (6 Marks)

 

(C) P/E Valuation

The EPS for Flight Centre for 2016 was $2.42 and dividend payment - $1.52. Using fundamental trailing P/E multiple method, calculate the value of the stock by assuming that earnings will grow at a constant rate of 8% per annum indefinitely. FTL's required rate of return is 12% and before tax cost of debt is 7%. Assume that FLT will maintain the current dividend pay-out ratio. (5 marks)


STOCK RECOMMENDATION

Based on the stock value calculated in question 5 (A), 5(B), and 5(C), estimate your target price for FLT Share. Considering the current market price, briefly justify your investment recommendation for FLT. Write your answer in the box provided (5 MARKS).

The current market price of the stock is $35.68.

Please show:

 

 

Target Price (3 Marks)

 

Recommendation (2 Marks)

Answer & Explanation

Solved by verified expert
Answered by JusticeHare1116 on coursehero.com

sectetur adipiscing elit. Nam lacinia pu

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consec
CliffsNotes Logo

Unlock access to this and over
10,000 step-by-step explanations

Unlock Explanation

Have an account? Log In

<p>sectetur adipiscing elit. Nam lacinia pu</p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consec

Step-by-step explanation

sec

sectetur adipisecsectetursectetur adipiscing
sectesectsects
sectesectsectsectetur adipisc
sectesectsectsectetur adipisc
sectesectsectsectetur adipiscing
sectesectsectsectetur adipiscing e

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur l

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laor

sectetur adipiscing e

sectetur adi

sectetur

 

sectetur adipiscing elit. Nam lacini

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec

secte

sectetur ad

sectetur adipiscing elit. Nam lacinia pulvinar to

sectetur adip

sectet

sectetur a

sectetur adipiscing elit. Nam lacinia pulvin

sectetur adipi

sesecte

 

 

sectetur adipiscing elit. Nam lacinia
sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laore
sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellen

  • sect
  • sectetur adipiscing elisectet
  • secte
  • sectetur adipiscisecte

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laore
sectetur adipiscing elit. N
sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapib

  • sectetur adipiscing esectetur

sectetur adipiscing elit. Nam lacinia p

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesqu

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consect

 

sectetur adipiscing elit. Na

  • sectetur adipisc

sectetur adipiscing elit. Nam lacinia pulvinar t

  • sectetur adipiscing elit. Nam lacinia pulvinar
    sectetur adipiscing elit. Nam lacinia pu
    sectetur adipiscing elit.
    sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapib
  • sectetur adipiscing elit. Nam lacinia pulvinar
  • sectetur adipiscing elit. Nam lacinia pul

sectetur adipiscing elit. Nam lacinia pulvinar torto

  • sectetur adipiscing elit. Nam lacinia pu
    sectetur adipiscing elit. Nam lacinia pulvinar
  • sectetur adipiscing elit. Nam lacinia pulvi

sectetur adipiscin
sectetur adipiscing elit. Nam lacinia pulvinar tortor nec faci

  • sectetur adipiscing elit. Nam lacinia
    sectetur adipiscing elit. Nam la
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facil
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis.
  • sectetur adipiscing elit. Nam lacinia p
    sectetur adipiscing elit.
  • sectetur adipiscing elit. Nam lacinia pulvinar torto

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellent

  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. P
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibu
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor

sectetur

  • sectetur adipiscing elit. Nam lacinia pulvinar tortor
  • sectetur adipiscing elit. Nam l
    sectetur adipiscing elit. Nam lacinia pul
  • sectetur adipiscing elit. Nam lacinia pulvinar t
  • sectetur adipiscing elit. Nam lacinia pulvinar to
  • sectetur adipiscing eli
    sectetur adipiscing elit. Nam laci
  • sectetur adipiscing elit. Nam lacinia pulvinar tor

sectetur adip

  • sectetur adipiscing elit. Nam lacinia pulvinar tortor
  • sectetur adipiscing elit. Nam lacinia pulv
    sectetur adipiscing elit. Nam
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facil
  • sectetur adipiscing elit. Nam lacinia pu
  • sectetur adipiscing elit. Nam
    sectetur adipiscing elit. Na
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor
  • sectetur adipiscing elit. Nam
    sectetur adipiscing elit. Nam lacinia pul
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor ne

 

sectetur adipiscing elit.
36972351

  • sectetur adipiscing el
  • sectetu

sectetur adipiscing elit. Nam

  • sectetur adipiscing elit. Nam lacinia pulvinar to
    sectetur adipisc
    sectetur
  • sectetur adipiscing elit. N
  • sectetur adipiscing elit.
    sectetur adi
  • sectetur adipiscing elit. Nam la
    sectetur adipiscing elit. Nam lacinia pulvinar tortor
    sectetur adipiscing elit. Nam lac
    sectetur a

sectetur

sectetur sectetur adipiscing elit. Nam la  
sectetur adipsectsectsect 
sectetur adipiscing elit. Nam lacinia pulvinar tortor necsectetur adipiscisectetur adipiscingsectetur adipiscing 
sectetur adipiscing elit. Nam lassectetur adipiscing esectetur adipiscing e 
sectetur adipiscing elit. Nam lsectetur adipiscisectetur adipiscingsectetur adipiscing 
sectetur adipiscing elit. Nam laciniasectetur adipisci   
     
sectetur adipisectsectsectsect
sectetur adipiscing elit. Nam lacinia pulvinar tortor nsectetur adipiscisectetur adipiscingsectetur adipiscingsectetur adipiscing e
sectetur adipiscing elit. Nam lasectesectesectesecte
sectetur adipiscing elit. Nam lsectetur adipiscisectetur adipiscingsectetur adipiscingsectetur adipiscing e
sectetur adipiscing elit. Nam laciniasectetur adipisci   

 

sectetur adipiscing elit. Namsectetur a
sectetur adipiscing 
sectetur adipiscing elit 
sectetur adipiscing elit. Nam lacinia pusectet
sectetur adipiscing esecte
sectetur adipiscing elsectetur adipisci
sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dsectetur adipisci

 

sectetur 
sectetur adi 
sectetur adipisci 
sectetur adipiscing elit. Nam la 
sectetur adipiscing elit 
sectetur adipiscing elit. Nam lacinia psectetur adipiscing
sectetur adipiscing elit. Nam lasect
sectetur adipiscing elit. Nam laciniasec
sectetur adipiscing elit. Nasectetur adipisci

 

sectetur adi 
sectetur adipisc 
sectetur adipiscing e 
sectetur adipis 
sectetur adipiscing elit. Nam lacinia p 
sectetur adi 
sectetur adipiscing 
sectetur adipiscing elit 
sectetur adipiscing elit. Nam lacinia pulv 
sectetur adipiscing elit. Nam lacinia 
sectetur adipiscing elit. Nam lacinia pusectetur adipisc
sectetur adipiscing elit. N 

 

 

sectetur 
sectetur ad 
sectetur adipiscing elit. Nam lacinia 
sectetur adipiscing elit 
sectetur adipiscing elit 
sectetur adipiscing elit. Nam lacinia pulvinar tosecte
sectetur adipiscing elit 
sectetur adipiscing elit. Nam lacinia pulvisectet

 

 

1 attachment
Subscribe to unlock attachment
JPG

Get unstuck with a CliffsNotes subscription

Example CliffsNotes Question and Answer
Unlock every step-by-step explanation, download literature note PDFs, plus more.Get Access

Related Q&A