Macrosoft (MS) is a computer software company. Use the template below to calculate the requested values. GREEN Cells are assumptions. Do not change these numbers BLUE Cells are calculations. These cells should only contain cell references and/or formulas. Points will be deducted if numbers are entered into blue cells. Assumption Block: MS is a Constant Growth Company D.= $ 3.00 5% MS's Beta = 1.2 2% Im= 11% 4. Calculate MS's intrinsic value as of year one (P-hatz) P-hat, = 5. Calculate MS's expected dividend yield in year 1 DY1 = 6. Calculate MS's expected capital gains yield in year 1 CGY,= 7. Calculate MS's expected total return in year 1 TR = 8. Calculate MS's intrinsic value as of year three (P-hatz) P-haty =