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 value of Old Maid Company's common stock. The most recent annual dividend paid by the company was $3 per share. The analyst expects dividends to increase 8% per year for the next 3 years and then drop to a 4% growth rate starting in year 4 and remain at that growth rate for the forseeable future. The required rate of return used for the analysis is 10% a) What are the expected dividends for each of the next 4 years? $3.24 b) What is the value of the stock attributable to the first 3 years of dividends? (use NPV function) $3.50 c) What is the value of the stock at the end of year 3? (use constant-growth model) $3.78 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) $3.93 e) What is the total value of the stock? 2 points Question 6b Question 6c Question 6d Question 6e 4 points $8.68 65.50 * $49.21 $57.89 * or 65.51 Question 7 A music company is considering creating the world's largest piano. Cost and cash flow details are listed to Cost of Project ($2,500,000 to the right. What is the internal rate of return of the project? (round to two decimal places) Yr 1 cash flow (300,000) 14 11.69% Yr 2 cash flow (150,000) 15 3 points Yr 3 cash flow 50,000 16 Yr 4 cash flow 250,000 47 Yr 5 cash flow 800,000 48 Yr 6 cash flow 1,200,000 49 Yr 7 cash flow 3,500,000 50 Directions Questions to Complete 10:55 P O 12/1/202