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.
Clearly state which source you are using, and the tickers for each of these stocks.
State here the companies that you choose, their tickers, and why you choose them (1 or 2 sentences for each company that you choose).
For each measure, state the inputs and the final computed value (you may choose to present this as a table).
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 |
… |
… |
… |
… |
|
… |
… |
… |
… |
|
… |
… |
… |
… |
… |
… |
… |
… |
… |
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.
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 |
This Question Hasn’t Been Answered Yet! Do You Want an Accurate, Detailed, and Original Model Answer for This Question?
Copyright © 2012 - 2024 Apaxresearchers - All Rights Reserved.