DCF template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
WIC Valuation Model
2
Company Ticker:MSFT
3
https://www.bloomberg.com/markets/rates-bonds/government-bonds/us
4
WACC Assumptions
Input Competitors' Tickers:
NameCouponPriceYield1 Month1 YearTime (EST)
5
Risk-free rate (10 year treasury):1.92%1.)aaplApple Inc.
GB3:GOV
3 Month
01.491.52%-3-891:31 PM
6
Beta (3 year daily):1.362.)orclOracle Corporation
GB6:GOV
6 Month
01.51.54%-2-1001:01 PM
7
Market Return:9.00%
GB12:GOV
12 Month
01.511.55%-2-1141:32 PM
8
Cost of Equity:11.57%GT2:GOV
2 Year
1.599.781.61%+1-1141:32 PM
9
GT5:GOV
5 Year
1.599.211.67%+3-1091:32 PM
10
Tax Rate:10.18%
GT10:GOV
10 Year
1.7599.191.84%+1-1051:32 PM
11
Average Interest Rate: 3.89%
GT30:GOV
30 Year
2.381022.28%-3-881:32 PM
12
Cost of Debt:3.50%
13
14
Outstanding Shares (Millions): 7628.806
15
Share Price: $151.41
16
Market Cap (Millions):$1,155,077.516315.16
17
Average Debt Maturity (years, keep fixed):
10DateClose
18
Total Debt (input, millions):$69,000.0012/12/1994 16:00:0045.34
19
Interest Expense (millions): $2,686.00
20
Market Value of Debt: $71,274.75
21
22
WACC 11.08%
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
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
Loading...