only the last 3 questions, please show work!

Macrosoft (MS) is a computer software company. Use the template below to calculate the requested values. GREEN Cells are assumptions. Do not char BLUE Cells are calculations. 1. Calculate MS's expected dividend stream over the next 3 years see chapter 9 for help with problems 2 through 8 2. Calculate MS's intrinsic value as of time zero (P0) 3. Calculate MS's intrinsic value as of year one (P1) P1= 4. Calculate MS's expected dividend yield in year 1 DY1= 5. Calculate MS's expected capital gains yield in year 1 5. Calculate MS's expected total return in year 1 R1= Calculate MS's intrinsic value as of year three (P3)