Call/WhatsApp/Text: +44 20 3289 5183

Question: As of November 2022, the tech industry is going through an extremely turbulent period. Major technology firms including Meta (Facebook) and Amazon have been laying off a significant portion of their workforces on concerns of profitability

08 Dec 2022,2:42 AM

 

As of November 2022, the tech industry is going through an extremely turbulent period. Major technology firms including Meta (Facebook) and Amazon have been laying off a significant portion of their workforces on concerns of profitability, and general investor pressure. From a financial point of view, the employer and the employee are bound by a contract (the job contract), which reflects the expectations that they have of each other. Nominally, the duration of the contract runs until that point when the company and the employee have outlived the mutual benefits that they derive from each other. They are thus, long-lived contracts with no set expiration date. Note: A financial contract is different from a legal contract. A legal contract for a worker might include a specific end date (“contractual” employees) or none (“employment at will”). The above discussion refers to the financial contract and not the legal contract.

A widespread layoff within a firm, in the contracting sense, is akin to the company cancelling its long-dated contracts early. By doing so, the company releases itself from the commitment of paying wages and salaries to its employees, which are fixed in levels and in time. This is because the company knows exactly how much salary it pays its employees, and salary payout always happens in a fixed schedule (once a month or twice a month). Having taken the very excellent Fixed Income course at Tulane, you know that the employment contract is not the only form of long-dated contracts that a firm can take up. Another common form of a contract that has fixed cash outflows in fixed durations in time is a debt instrument, or simply a bond!

The basic intuition of this exercise is as follows: if tech firms are facing difficulties in maintaining their employment-related long-term contracts, we are going to try and understand if the same set of factors also affect their alternative form of long-term contracts, i.e., bonds. The easiest measure of the quality of bonds is to investigate the credit rating of the company. The following set of questions will guide in ultimately judging how the firms’ bond evaluations are changing on the back of widespread job layoffs.

  1. Consider the set of the largest technology firms in the U.S. – the FAANG (or, MAANG) firms. These are specifically, Facebook (Meta Inc.), Apple Inc., Amazon.com Inc., Netflix Inc. and Google (Alphabet Inc.). First, identify the stock tickers for each of these firms using Capital IQ. (You can find detailed instructions on how to set up a Capital IQ here). Alternately, you may choose to do this on Refinitiv or Bloomberg – the choice is yours, pick a source that you are most comfortable with.

Clearly state which source you are using, and the tickers for each of these stocks.

 

  1. Now, we need a “baseline” set of companies to compare the above companies against. The baseline refers to a set of firm that would be outside the tech industry, and therefore not subject to the same problems that the tech industry is facing. By seeing how the tech firms compare against these non-tech firms, we can attempt to see how the tech firms are different from these non-tech firms. We will use the largest non-tech firms, which are included in the Dow Jones Industrial Average as our baseline. Pick any five non- technology firms from the list of DJIA constituents.

State here the companies that you choose, their tickers, and why you choose them (1 or 2 sentences for each company that you choose).

 

  1. Now we have a set of 10 companies (5 tech and 5 non-tech). Using your preferred data source, for each of these companies, compute the following financial measures using the latest available financial statements. You can use the built-in financial ratios tool in Capital IQ to these financial ratios, or you can choose to do them on your own..

For each measure, state the inputs and the final computed value (you may choose to present this as a table).

    1. EBIT Interest Coverage
    2. EBITDA Interest Coverage
    3. FFO/Total Debt
    4. Free operating cash flow/total debt
    5. Return on Capital
    6. Operating Income/Sales
    7. Long-term debt/capital
    8. Total debt/capital

 

  1. Briefly discuss the key differences that you find between the ratios for each of the 10 companies. Which metric varies the most? Which metric varies the least?

 

  1. Now, based on each of the above measures, we are in a position to impute the credit rating that should be, even if the actual rating has not yet changed to reflect the companies’ financial conditions. To do this, use Table 1 that links the financial ratios to the credit rating.

Based on each ratio that you compute, for each firm, what is the expected credit rating? You may present you answer in the form of a table, like below, e.g.,

 

Firm/Metric

EBIT Interest Coverage

EBITDA Interest Coverage

FFO/Total Debt

Apple

Rating=?

Rating=?

Rating=?

Amazon

Rating=?

Rating=?

Rating=?

Netflix

Facebook

Google

 
  1. As you computed the ratios above, you would have noticed that each ratio might imply a different rating for each firm. As the fixed income expert, it is your job to decide which one of these ratings makes the most sense for a particular firm.

Condense the various ratings to one single “best applicable” rating for each, explaining how you do this. For example, you can think of an “average” of all ratings, or most commonly occurring. The choice is yours, but justify your answers.

 

  1. Finally, discuss how the credit rating varies across tech and non-tech firms. In particular,
  1. Estimate the bond yields for 10-year and 30-year bonds issued by each firms, using data in Table 2. You can obtain the treasury rates from the Treasury website. Discuss which firms face the highest costs in issuing debt, and which firms are at particularly increased risk of default.
  2. Based on your calculations above, what is your opinion on the level of overlap between forces that drive firms to layoff employees and the factors that lead them to abstain from issuing bonds? Do you think the two go hand-in-hand?
 

Table 1: Key financial ratios by rating category

 

 

AAA

AA

A

BBB

BB

B

CCC

EBIT Interest Coverage

23.4

13.3

6.3

3.9

2.2

1.0

0.1

EBITDA Interest Coverage

25.3

16.9

8.5

5.4

3.2

1.7

0.7

FFO/Total Debt (%)

214.2

65.7

42.2

30.6

19.7

10.4

3.2

Free operating cash flow/total debt (%)

156.6

33.6

22.3

12.8

7.3

1.5

-2.8

Return on Capital (%)

35.0

26.6

18.1

13.1

11.5

8.0

1.2

Operating Income/Sales (%)

23.4

24.0

18.1

15.5

15.4

14.7

8.8

Long-term debt/capital (%)

-1.1

21.1

33.8

40.3

53.6

72.6

78.3

Total debt/capital (%)

5.0

35.9

42.6

47.0

57.5

75.1

91.7

 

Table 2: Credit Spreads by rating category and maturity

 

 

 

Maturity (years)

 

Investment Grade PBR Credit Rating

Aaa/AA

A

Aa1/AA

+

 

Aa2/AA

Aa3/AA

-

 

A1/A+

 

A2/A

 

A3/A-

Baa1/BB

B+

Baa2/BB

B

Baa3/BB

B-

 

1

 

21.41

 

32.35

 

43.30

 

58.33

 

73.36

 

88.39

 

105.66

 

122.94

 

140.21

 

185.90

 

2

 

27.15

 

39.85

 

52.54

 

70.21

 

87.88

 

105.55

 

122.75

 

139.94

 

157.14

 

194.37

 

3

 

32.90

 

47.34

 

61.78

 

82.09

 

102.40

 

122.70

 

139.83

 

156.95

 

174.08

 

202.83

 

4

 

38.65

 

54.84

 

71.03

 

93.97

 

116.92

 

139.86

 

156.91

 

173.96

 

191.01

 

211.30

 

5

 

53.77

 

66.99

 

80.22

 

103.23

 

126.25

 

149.27

 

166.37

 

183.47

 

200.56

 

216.08

 

6

 

68.89

 

79.15

 

89.41

 

112.50

 

135.59

 

158.69

 

175.83

 

192.97

 

210.12

 

220.85

 

7

 

74.09

 

85.07

 

96.05

 

118.60

 

141.15

 

163.71

 

183.26

 

202.82

 

222.38

 

226.98

 

8

 

79.30

 

91.00

 

102.69

 

124.71

 

146.72

 

168.73

 

190.70

 

212.67

 

234.64

 

233.11

 

9

 

79.71

 

91.84

 

103.97

 

127.23

 

150.49

 

173.75

 

193.87

 

213.98

 

234.10

 

232.84

 

10

 

80.12

 

92.68

 

105.25

 

127.74

 

150.24

 

172.74

 

193.01

 

213.28

 

233.56

 

232.57

 

11

 

80.53

 

93.53

 

106.52

 

128.26

 

149.99

 

171.72

 

192.16

 

212.59

 

233.02

 

232.30

 

12

 

80.95

 

94.37

 

107.80

 

128.77

 

149.74

 

170.71

 

191.30

 

211.89

 

232.47

 

232.03

 

13

 

81.36

 

95.22

 

109.07

 

129.28

 

149.49

 

169.70

 

190.44

 

211.19

 

231.93

 

231.76

 

14

 

81.77

 

96.06

 

110.35

 

129.80

 

149.24

 

168.69

 

189.59

 

210.49

 

231.39

 

231.49

 

15

 

82.18

 

96.90

 

111.63

 

130.31

 

148.99

 

167.68

 

188.73

 

209.79

 

230.85

 

231.22

 

16

 

82.59

 

97.75

 

112.90

 

130.82

 

148.74

 

166.66

 

187.88

 

209.09

 

230.31

 

230.95

 

17

 

83.01

 

98.59

 

114.18

 

131.33

 

148.49

 

165.65

 

187.02

 

208.39

 

229.77

 

230.68

 

18

 

83.42

 

99.44

 

115.45

 

131.85

 

148.24

 

164.64

 

186.17

 

207.70

 

229.23

 

230.41

 

19

 

83.83

 

100.28

 

116.73

 

132.36

 

147.99

 

163.63

 

185.31

 

207.00

 

228.68

 

230.14

 

20

 

84.24

 

101.12

 

118.00

 

132.87

 

147.74

 

162.61

 

184.46

 

206.30

 

228.14

 

229.87

 

21

 

84.66

 

101.97

 

119.28

 

133.39

 

147.49

 

161.60

 

183.60

 

205.60

 

227.60

 

229.59

 

22

 

85.07

 

102.81

 

120.56

 

133.90

 

147.24

 

160.59

 

182.75

 

204.90

 

227.06

 

229.32

 

23

 

85.48

 

103.66

 

121.83

 

134.41

 

146.99

 

159.58

 

181.89

 

204.20

 

226.52

 

229.05

 

24

 

85.89

 

104.50

 

123.11

 

134.93

 

146.75

 

158.56

 

181.03

 

203.51

 

225.98

 

228.78

 

25

 

86.30

 

105.34

 

124.38

 

135.44

 

146.50

 

157.55

 

180.18

 

202.81

 

225.43

 

228.51

 

26

 

86.72

 

106.19

 

125.66

 

135.95

 

146.25

 

156.54

 

179.32

 

202.11

 

224.89

 

228.24

 

 

27

 

87.13

 

107.03

 

126.94

 

136.47

 

146.00

 

155.53

 

178.47

 

201.41

 

224.35

 

227.97

 

28

 

87.54

 

107.88

 

128.21

 

136.98

 

145.75

 

154.51

 

177.61

 

200.71

 

223.81

 

227.70

 

29

 

87.95

 

108.72

 

129.49

 

137.49

 

145.50

 

153.50

 

176.76

 

200.01

 

223.27

 

227.43

 

30

 

88.36

 

109.56

 

130.76

 

138.01

 

145.25

 

152.49

 

175.90

 

199.31

 

222.73

 

227.16

 

Average

 

74.83

 

90.40

 

105.97

 

122.71

 

139.45

 

156.18

 

176.96

 

197.73

 

218.51

 

225.05

 

 

 

Maturity (years)

Below Investment Grade PBR Credit Rating and Moody's/S&P Ratings

 

Ba1/BB+

 

Ba2/BB

 

Ba3/BB-

 

B1/B+

 

B2/B

 

B3/B-

Caa1/C

CC+

Caa2/C

CC

Caa3/C

CC-

 

Ca/CC

 

1

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

2

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

3

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

4

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

5

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

6

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

7

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

8

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

9

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

10

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

11

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

12

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

13

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

14

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

15

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

16

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

17

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

18

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

19

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

20

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

21

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

 

22

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

23

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

24

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

25

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

26

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

27

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

28

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

29

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

30

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

Average

 

231.59

 

298.44

 

365.28

 

432.13

 

498.97

 

742.85

 

986.73

 

1,230.61

 

1,474.48

 

1,718.36

 

Table 3: Definitions of Financial Ratios

 

 

Ratio

Numerator

 

Denominator

EBIT

Interest

Coverage

Earnings before Interest and Taxes

 

÷

Gross Interest incurred before subtracting capitalized interest and income

EBITDA

Interest

Coverage

Earnings before Interest, Taxes and D&A

 

÷

Gross Interest incurred before subtracting capitalized interest and income

FFO/Tota l Debt

Net Income plus D&A, deferred income taxes and other noncash

items

 

÷

Long-term debt plus current maturities, commercial paper and short-term

borrowings.

Free operatin g cash flow/tota

l debt

FFO-CapEx-(+) increase(decrease) in working capital (excluding changes in cash, marketable securities, and short-term debt)

 

 

÷

 

Long-term debt plus current maturities, commercial paper and short-term borrowings.

Return on Capital

 

Earnings before Interest and Taxes

 

÷

Average capital between beginning and end of year (including ST debt, current maturities, LT debt, noncurrent deferred

taxes, minority interest and equity

Operatin g Income/

Sales

 

Sales - COGS (before D&A), SG&A and R&D

 

÷

 

Sales

Long- term debt/capi

tal

 

Long-term debt

 

÷

 

LT debt + shareholder's equity + minority interest

Total debt/capi

tal

Long-term debt plus current maturities, commercial paper and

short-term borrowings.

 

÷

LT debt + shareholder's equity + minority interest

 

Expert answer

 

This Question Hasn’t Been Answered Yet! Do You Want an Accurate, Detailed, and Original Model Answer for This Question?

 

Ask an expert

Stuck Looking For A Model Original Answer To This Or Any Other
Question?


Related Questions

What Clients Say About Us

WhatsApp us