Storico Co$.$ just paid a dividend of $$1\mathrm{.}35$ per share. The company will increase its dividend by $24$ percent next year and will then reduce its dividend growth rate by $6$ percentage points per year until it reaches the industry average of $6$ percent dividend growth, after which the company will keep a constant growth rate forever. If the stock price is $$44\mathrm{.}39,$ what required return must investors be demanding on the company's stock? $($Hint: Set up the valuation formula with all the relevant cash flows, and use trial and error to find the unknown rate of return.$)($Do not round intermediate calculations and enter your answer as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$ This was solved by someone else on Chegg using excel and its solver function. I would like to have an explanation for the info in the initial graph before they use the solver $($the top one$).$ How did they get the value in B$6$ "share price in $3$ years"? How did they get the values in column C $($what are the calulations for PVIF used in those cells$)?$ Why they are using $18\%$ for the PVIF? And how they got the PV values in column D$?$ Thank you for the help I am having alot of difficulty with this problem.