AutoSave OF A v G... A Spreadsheet assignment 2 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 w v P A a Wraa Text V Number Insert v ' X LE v Ayo Delete Paste BIU A - Merge & Center Y $ % , Sensitivity Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Analyze Data y Find & Select A28 . fx =SUMIA24:26) A B D E F G H I J K L M How 32 33 b. Now assume that CCC's period of nonconstant growth is to last for 5 years rather than 2 years. 34 would this affect its price? 35 36 Find the price today. 37 38 D. $2.50 39 rs 12.0% 40 gs 30% Short-run g; for Years 1-5 only. 41 GL 7% Long-run g; for Year 6 and all following years. 42 30% 7% 43 Year 0 1 2 3 4 5 44 Dividend 45 46 PV of dividends 47 48 49 50 51 + + 6 + 52 = D x(1+g) =D 53 Horizon value = P. = 54 = PO =rs - 9 55 56 Ch 5-20 Build a Model Solution + Ready + 18.4% AutoSave AIB G ... Spreadsheet assignment 2 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 w v P A a Wraa Text V Number Insert v ' X LE v Ayo Delete Paste BIU A - Merge & Center Y $ % , Sensitivity Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Analyze Data y Find & Select A28 . fx =SUMIA24:26) A B D E F G H I J K L M How 32 33 b. Now assume that CCC's period of nonconstant growth is to last for 5 years rather than 2 years. 34 would this affect its price? 35 36 Find the price today. 37 38 D. $2.50 39 rs 12.0% 40 gs 30% Short-run g; for Years 1-5 only. 41 GL 7% Long-run g; for Year 6 and all following years. 42 30% 7% 43 Year 0 1 2 3 4 5 44 Dividend 45 46 PV of dividends 47 48 49 50 51 + + 6 52 = D.x(1+g) =D 53 Horizon value = P, = = P. = 's - 9 54 55 56 Ch 5-20 Build a Model Solution + Ready + 184%