Question: question help with 5d and 5e pls analysts expect dividends to increase 7% per year for the nex 3 years and then drop to 3%

question help with 5d and 5e pls

analysts expect dividends to increase 7% per year for the nex 3 years and then drop to 3% starting in year 4 and remain at that rate for the foreseable future. The required rate of retur used for the analysis is 8% Students must do their own work, with no help/solutions provided by others. a) What are the expected dividends for the next 4 years? b) What is the value of the stock attributable to the first 3 years of dividends? (use NPV function) c) What is the value of the stock at the end of year 3 ? (use constant-growth model) Use a cell reference in the numerator to get an unrounded, more precise, answer figure. d) What is the value of the stock attributable to years 4 and beyond? (use pv function, where answer to part C is the fv) e) What is the total value of ABCM stock

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!

A team of analysts is using a two - stage variable growth model to estimate the value of ABCM's common stock. The most recent annual dividend paid by ABCM was $ 4 per share. The analysts expect...

Answer has been provided in grey cells, but please show me how to get this answer via EXCEL formula NOT fin. calc. two-stage variable growth model to estimate the value of common stock. The most...

Question 5a A team of analysts is using a two-stage variable growth model $4.28 to estimate the value of ABCM's common stock. The most $4.58 recent annual dividend paid by ABCM was $4 per share. The...

Answer question in yellow cell with Excel formula to match correct answer below in gray Styles Cells A B C D E F G H Question 6a An analyst uses a two-stage variable growth model to estimate the...

pls help! Phoenix Industries has pulled off a miraculous recovery. Four years ago it was near bankruptcy. Today, it announced a $3 per share dividend to be paid a year from now, the first dividend...

Question 3 As a company that was near bankruptcy four years ago, Lucky Industries has pulled off a miraculous recovery. It announced today a $2 per share dividend to be paid a year from now, the...

The last exam will cover these 3 tests plus a few small quizzes. The attached should give you a good idea of the material. Let me know if you have any questions. You can see which I got correct with...

I NEED HELP ANSWERING #2, I SEE DIFFERENT ANSWERS FOR THE SAME QUESTION, I'M CONFUSED. THANK YOU!!! 2. Later, the company is considering the purchase of machinery and equipment to set up a line to...

Let AT = -A be a real, skew-symmetric n n matrix. (a) Prove that the only possible real eigenvalue of A is = 0. (b) More generally, prove that all eigenvalues of A are purely imaginary, i.e., Re ...

2. An integral obstruction-type chip breaker has a chip-breaker height of 1 mm and a chip-breaker distance of 4 mm. It is found that the chip is broken satisfactorily when the chip thickness is 0.8...

A corporate bond trading below par value will have a higher yield to maturity than the coupon rate. a lower yield to maturity than the coupon rate. lower risk than one trading at par. higher risk...

. Lake Power Sports sells jet skis and other powered recreational equipment. Customers pay 1/3 of the sales price of a jet ski when they initially purchase the ski, and then pay another 1/3 each year...