Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table 1 This data for 11/15/2018 11/15/18 11/15/19 11/15/21 Price 202.39 204.19 11/15/20 7/20/21 531.85 Stock split 1.6 1:4 305.52 beta 2.7 2.06 1.45 Risk

image text in transcribedimage text in transcribed

Table 1 This data for 11/15/2018 11/15/18 11/15/19 11/15/21 Price 202.39 204.19 11/15/20 7/20/21 531.85 Stock split 1.6 1:4 305.52 beta 2.7 2.06 1.45 Risk free Rate 0.025 0.025 0.025 0.04 expected mkt return 0.07 0.09 0.09 0.12 expected EPS growth in the next 5 years 0.32 0.125 0.1744 0.326 Current EPS 7.3 4.8 9.07 4.72 5 Considering the stock split in July 20,21, the price of NVDA om 11/15/2021 adjusting for split is 6 What would your price estimate on 11/15/2020 be if you used the 5-year growth esimate on 11/15/2021 ( in cell 142) What other assumption you recommend to changing so the estimated price of 11/15/21 in cell E57 be closer to its actual price on 7 11/15/2021 provided in your answer to question 30 Table 1 This data for 11/15/2018 11/15/18 11/15/19 11/15/21 Price 202.39 204.19 11/15/20 7/20/21 531.85 Stock split 1.6 1:4 305.52 beta 2.7 2.06 1.45 Risk free Rate 0.025 0.025 0.025 0.04 expected mkt return 0.07 0.09 0.09 0.12 expected EPS growth in the next 5 years 0.32 0.125 0.1744 0.326 Current EPS 7.3 4.8 9.07 4.72 5 Considering the stock split in July 20,21, the price of NVDA om 11/15/2021 adjusting for split is 6 What would your price estimate on 11/15/2020 be if you used the 5-year growth esimate on 11/15/2021 ( in cell 142) What other assumption you recommend to changing so the estimated price of 11/15/21 in cell E57 be closer to its actual price on 7 11/15/2021 provided in your answer to question 30

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Analysis Microsoft Excel 2010

Authors: Conrad Carlberg

1st Edition

0789747200, 9780789747204

More Books

Students also viewed these Accounting questions

Question

Define the term marketing? LO.1

Answered: 1 week ago

Question

3. Housekeeping, such as watering plants or storing personal items

Answered: 1 week ago