HW #9 - Stock Valuation - Excel Samarth J Patel suo - AutoSave Off File Home S S R Insert Draw P age Layout Xi o Formulas Data Review View Help Tell me what you want to do Share * * Arial Arial V 12 V A = = = a Wrap Text General y H D D x Auto Sum47 0 BIU - - - A- B Merge & Center - $ % 08 Insert Delete Format Fill- Clear Conditional Format as Cell Formatting Table Styles Styles Ideas Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Cells Ideas D9 - K L M N O P Q R S L A E F G H I J HECTORITIS CORPORATION (Textbook page 538, Q7) 2 Current FCF 13,000,000 Based on the data presented here, what should be the share value of 3 Anticipated growth rate, years 1-5 12% the company? (B26) 4 Beta. 1.5 37 6 ELIMI 7 WACC 247 8 Long-term growth rate, after year 5 9 Number of shares outstanding 8,000,000 5 14%. Anticipated FCF Year 2 3 18 Terminal value calculation: 19 FCF in year 5 20 Terminal value 22 Valuing Hectoritis Corporation 23 Present value of FCFs, years 1-5 24 Present value of terminal value 25 Value of Hectoritis 26 Per share value 28 HW #9 @ J -_ 78% a H _ + 11:49 AM 4/30/2020 Type here to search o Be - A 9 x W