Q No. 2: Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

1) The Walgreens Boots alliance Company has recently paid dividend D₀ =$3, and growth is expected to remain 5% throughout. The required rate  of return is 10%. Calculate dividend streams for the next 2 years, &their PVs?

2) You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return? 

3) Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year? 

Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

1. The Walgreens Boots alliance Company has recently paid dividend D₀ = $3, and growth is expected to remain 5% throughout. The required rate of return is 10%. Calculate dividend streams for the next 2 years, and their PVs? 
2. You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return? 
3. Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year? 

Show the calculations

Q No. 2: Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

Part a) The Walgreens Boots alliance Company has recently paid dividend D₀ = $3, and growth is expected to remain 5% throughout. The required rate of return is 10%. Calculate dividend streams for the next 2 years, and their PVs? 

Part b) You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return? 

Part c) Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year?

Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

1. The Walgreens Boots alliance Company has recently paid dividend D₀ = $3, and growth is expected to remain 5% throughout. The required rate of return is 10%. Calculate dividend streams for the next 2 years, and their PVs?
2. You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return? 

Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year?

: Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

1. The Walgreens Boots alliance Company has recently paid dividend D₀ = $3, and growth is expected to remain 5% throughout. The required rate of return is 10%. Calculate dividend streams for the next 2 years, and their PVs?
2. You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return? 

Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year?

: Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

1. The Walgreens Boots alliance Company has recently paid dividend D₀ = $3, and growth is expected to remain 5% throughout. The required rate of return is 10%. Calculate dividend streams for the next 2 years, and their PVs? 
2. You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return? 

Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year?

 Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

1. The Walgreens Boots alliance Company has recently paid dividend D₀ = $3, and growth is expected to remain 5% throughout. The required rate of return is 10%. Calculate dividend streams for the next 2 years, and their PVs?
2. You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return?
3. Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year?

Being a newly appointed analyst at Credit Suisse, one of your prime role is to facilitate the Global head of valuations in providing detailed and timely analysis. The next meeting is being scheduled for the upcoming Saturday, and you are required to calculate the price of a few stocks and provide their valuations. The information is mentioned below:

1. The Walgreens Boots alliance Company has recently paid dividend D₀ = $3, and growth is expected to remain 5% throughout. The required rate of return is 10%. Calculate dividend streams for the next 2 years, and their PVs? 
2. You have forecasted NIKE dividends of $5, $5.70, and $5.95 over the next three years respectively. After the end of three years the anticipated selling market price of NIKE will be $135. What is NIKE stock price provided a 7% expected rate of return? 
3. Merck & Co. is predicted to pay Rs. 1.70 dividend in one year. Further, the market is forecasting a growth in the company’s dividend by 3% per year. Given rate of return of 8% in this category, what is stock price of Merck & Co. to be in the third (3) year? 

Show the calculations and results on excel.