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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!