Question: please solve it with excel formula and show me the calculation please Given the summary quote below of Microsoft Corporation: Previous Close 235.77 1.823T Open


please solve it with excel formula and show me the calculation please
Given the summary quote below of Microsoft Corporation: Previous Close 235.77 1.823T Open 238.47 Market Cap Beta (5Y Monthly) PE Ratio (TTM) 0.81 Bid 241.45 x 800 36.03 Ask 241.46 x 800 EPS (TTM) 6.71 Day's Range 238.05 - 242.06 Apr 26, 2021 - May 02, 2021 Earnings Date Forward Dividend & Yield 52 Week Range 150.36-246.13 2.24 (0.95%) Volume 18,845,480 Ex-Dividend Date May 18, 2021 Avg. Volume 30,542,073 1y Target Est 272.71 Source: finance.yahoo.com (2021) 1-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)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
