Research Project 3 - TARGET CORP

From the text, the Weighted Average Cost of Capital is:

WACC = (E/V) x R_E + (D/V) x R_D x (1- T_C) (Eq. 14-6)

In this Research Project, the WACC for a selected company will be determined. Fill in the table to identify your selected company:

Name of Company/Stock TARGET CORP

Ticker Symbol NYSE TGT

Part 1: Cost of Debt[1]

Complete the following table to arrive at the Cost of Debt and Tax Rate.

Interest Income (Expense) last 2 years avg
Earnings Before Tax last 3 years total
Taxation last 3 years total
Corporate Tax Rate, TC[2]
Current Debt
LT Debt & Leases
Total Debt
Cost of Debt[3]

[1] The inputs from Mergent provide a close approximation to the Cost of Debt

[2] Divide the Taxation last 3 years line item by Earnings Before Tax for the last 3 years, as a percent

[3] Interest Income (Expense) last 2-year average divided by the Total Debt

Part 2: Cost of Equity and CAPM Components

Complete the table and determine the cost of equity. Show your calculations.

Beta, E
Historical Market Return, iM	Assume 9%
Risk Free Rate, if	Assume 2%
Cost of Equity, iE

Part 3: Weighted Average Cost of Capital

Draw on your work in Parts 1 and 2 to determine D/V and E/V.

Total Debt Value
Total Equity Value
Total Firm Value
Total Debt to Total Firm Value (D/V)
Total Equity to Total Firm Value (E/V)

Show your calculation of your selected companys WACC.

Suppose the company you selected embarked on a recapitalization that relied upon a 50% D/V and a 50% E/V. Assuming that the component costs stayed the same, calculate the companys WACC under this scenario. Show your calculation. Would it make sense for the company to make this change?

Part 4: Sustainable Growth

Recall from Module 1, that a firm can achieve its Sustainable Growth Rate by using internal equity financing and a constant debt ratio.

Sustainable growth rate = (ROE b) / [1-(ROE b)] (Eq. 4-3)

As defined in the text, b is the retention or plowback ratio. For your selected company, use Mergents data to calculate the Sustainable Growth Rate for the most recent period. Show your calculations. How would you interpret the result for the company you selected? Does this seem reasonable to you?

Respond: if your selected company chooses to grow at its Sustainable Growth Rate, with increases in both retained earnings and debt, how will this influence its WACC?

TARGET INFO: 3 years/Quarters in Billions units

Data for Part 1/2

Interest Income (a negative is Net Interest Expense), Earnings Before Tax, and Taxation from the Income Statement (use the Standardized version). Also include Interest Expense and Debt, consisting of Current Debt and Long Term Debt & Leases from the Balance Sheet.

Report Date	01/28/2023		01/29/2022		01/30/2021

Interest Income

(0.478)

>

(0.421)

>

(0.977)

>

Earnings Before Tax

3.418

>

8.907

>

5.546

>

Taxation

0.638

>

1.961

>

1.178

>

Current Debt

0.13

>

0.171

>

1.144

>

LT Debt & Leases

16.009

>

13.549

>

11.536

>

Data for part 3/4

Stock Price and Valuation (Data as of 11/17/2023)
Market Cap(mil)	59,958

Dividend Per Share(TTM)	4.36
Earning Per Share(TTM)	7.33

Beta

1.14

Management Effectiveness
Revenue per Employee	248,681
Net Income per Employee	6,336.00
ROA % (Net)	5.20
ROE % (Net)	23.17
ROI % (Operating)	14.31

If at all possible IF I have not provided all the necessary data needed can I get an email for the extra info needed? I apologize for asking if that's not possible. Thank you for your help.