ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABB
1
2
Dashboard
3
1
4
Key Inputs1
5
Units ($ in millions)
6
Company nameTarget
7
TickerTGT
8
Circuit breakerNo
9
Valuation date7/8/2024
10
Stub period56.9%
11
Latest shares of outstanding461,690,206
12
Md-year conventionNo
13
Recent fiscal year end2/3/2024
14
First fiscal year end2/3/2025
15
Date of latest 10K filing2/3/2024
16
Date of latest 10Q filing-
17
18
WACC Information
19
After tax cost of debt3.30%
20
Cost of equity8.95%
21
Weighted average cost of capital
7.91%
22
23
Year 1 multiples (Perpetuity Approach)
24
EV/EBITDA8.90 X
25
EV/EBIT13.28 X
26
EV/Sales0.75 X
27
28
Other assumptions
29
Effective tax rate of Target as of the latest filing
21.9%
30
Use growth or margins?
Not used in this workbook)
Margins
31
32
33
Background and operations of Target:
34
Incorporated in Minnesota in 1902, Target's revenues comprise of merchandise sale and other revenues.
35
36
37
38
39
.
40
41
42
43
44
45
46
47
Case Manager
48
49
Active CaseBase Case
50
51
52
Output:
53
Share price as of the analysis $ 147.60
54
DCF value $ 139.59
55
Price to value premium (discount)
(5.4%)
56
Analysis Overvalued
57
58
Additional notes:
59
These prices are based on my assumptions and what I think about the company. DCFs are extremely prone to
60
assumptions, and so my advice would be to put in what you think will happen and see what the value comes out to.
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100