Will upvote for excel formulas with explanations green cells are needed

B B D E A 1 2 Dividend (constant) 3 Cost of equity capital re 4 Current stock price 5 $0.80 8.3% $15.00 End of 2020 End of 2021 End of 2022 Terminal period $0.80 $0.80 $0.80 $0.80 6 7 Scenario 1 8 Anticipated dividends 9 Present value as of start of 2020 10 Cumulative present value 11 12 Scenario 2 Present value of a perpetuity ($0.80) 13 as of start of 2020 14 15 Overpriced or underpriced