Question: Question 2: (5marks) Given the summary quote below of Microsoft Corporation in order to estimate a discount rate for Microsoft Corporation assuming the Treasury bill

Question 2: (5marks)

Given the summary quote below of Microsoft Corporation in order to 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)

Question 2: (5marks) Given the summary quote below of Microsoft Corporation in

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

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!

Determine the dimensions of the quantity where is density and v is speed.

Question 2: (5marks) Given the summary quote below of Microsoft Corporation: Previous Close 235.77 MarketCap 1.823T Beta (SY Open 238.47 Monthly 241.45x800 PE Ratio (TTM) 36.03 Ash 241.46 x 800 EPS...

Question 2: (5marks) Given the summary quote below of Microsoft Corporation: Previous Close 235.77 Market Cap 1.823T Open Beta (5Y 238.47 0.81 Monthly) Bid 241.45 x 800 PE Ratio (TTM) 36.03 Ask...

my id is 20181946 Question 2: (5marks) Given the summary quote below of Microsoft Corporation: Previous Close Open tid 235.77 235.47 241.45 x 100 241.46 x 300 Ask Market Cap 1.823T Beta (SY OBI...

Question 2: (5marks) Given the summary quote below of Microsoft Corporation: M 241.45 x 300 PERCITO 36.03 241.450 6.73 238.05 - 242.00 Apr 26 2021 May 02, 2023 SZ W R150.36-246.22 22400 16.545.430...

Given the summary quote below of Microsoft Corporation: Previous Close 235.77 MarketCap 1.5237 Open Besa SY 0.83 Month Bid 241.45 x 800 PER (TTM) 36.03 241.46 800 EPSITT 6.71 Days Range 230.05-242.06...

Using excel question 1 Given the summary quote below of Microsoft Corporation: Estimate a discount rate for Microsoft Corporation assuming the Treasury bill rate equal to the first number of your ID...

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...

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...

Seema plans to purchase her dream car which will require her to make a payment of $3200 at the beginning of each year for 20 years. Given the interest rate of 8%, what is the value of her loan today?...

Using EXCEL attempt the following questions: Question 2: (2.5 marks) Given the summary quote below of Microsoft Corporation: 1- Estimate a discount rate for Microsoft Corporation assuming the...

Furniture Specialties is a company that make two types of dining tables: Simple and Futuristic. There are two types of direct materials: Pine and Mahogany woods. Direct manufacturing labor workers...

Which type of endorsement is most appropriate for a business to use?

What is the beta of a U . S . Treasury bill? Multiple Choice 1 . 0 Unknown 1 . 0 0

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...