Excel File Edit View Insert Format Tools Data Window Help AutoSave ABAD C Home Insert Draw Page Layout Formulas Data Review View Automate Calibri (Body) 11 A A = = = ab V Paste v v = = = = = = A1 A x fx Inputs for Toyota B C D E F G H J 1 Inputs for Toyotal Year Dividend Div growth Term value Investor CF 2 beta 0.8 2022 4.45 4.45 3 mkt_prem 0.08 2023 4.82 4.82 4 rf 0.02 2024 5.18 5.18 5 k_equity 0.0840 2025 5.55 5.55 6 term gwth 0.050 2026 5.97 0.0764 5.97 7 2027 6.41 0.0738 6.41 8 2028 6.87 0.0711 6.87 9 2029 7.34 0.0685 7.34 10 2030 7.82 0.0658 7.82 11 2031 8.32 0.0632 8.32 12 Value line 2032 8.82 0.0606 8.82 13 forecasts of 2033 9.33 0.0579 9.33 14 annual dividends 2034 9.85 0.0553 9.85 15 2035 10.37 0.0526 10.37 16 2036 10.89 0.0500 10.89 17 Transitional period 2037 11.43 0.0500 353.03 364.46 18 with slowing dividend 19 growth 20 21 Beginning of constant growth period E17 (1+ F17)/(B5 - F17) 157.00 =PV of CF NPV(B5,H2:H17) 22 23 24 25 Sprd 18.1 + Ready Accessibility: Investigate 18' 19 20 21 22 23 24 25 26 Ready Sheet1 + Accessibility: Good to go B