Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the summary quote and financial highlights below of Microsoft Corporation: Estimate a discount rate for Microsoft Corporation assuming the Treasury bill rate equal to
Given the summary quote and financial highlights below of Microsoft Corporation:
- Estimate a discount rate for Microsoft Corporation assuming the Treasury bill rate equal to the first number of your ID (from the left) and the stock market risk premium equal to the total of 4- digit numbers of your ID (from the left).
Example: Suppose your ID=20167021, then the Treasury bill rate=2 and the stock market risk premium =10 (7+0+2+1)
2. estimate the sustainable growth rate.
3. Calculate the expected stock price using the constant dividend growth rate model.
Previous Close 235.77 1.823T Open 238.47 0.81 Market Cap Beta (5Y Monthly) PE Ratio (TTM) EPS (TTM) 241.45 x 800 36.03 Bid Ask 241.46 x 800 6.71 238.05 - 242.06 Day's Range 52 Week Range Earnings Date Forward Dividend & Yield Ex-Dividend Date Apr 26, 2021- May 02, 2021 2.24 (0.95%) 150.36 - 246.13 Volume 18,845,480 May 18, 2021 Avg. Volume 30,542,073 1 y Target Est 272.71
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started