please show the work

Macrosoft (MS) is a computer software company. Use the template below to calculate the requested values: GREEN Cells are assumptions. Do not chang Buive Cells are calculations. TI 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) 4. Calculate MS's expected dividend yield in year 1 4. Calculate MS's expected dividend yield in year 1 5. Calculate MS's expected capital gains yield in year 1 6. Calculate MS's expected total return in year 1 7. Calculate MS's intrinsic value as of year three (P3)