Please show Excel formula

VICCI CHIETI VIR Brous Metalworks Earnings Per Share, Time = 0 Dividend Payout Rate Return on Equity Market Capitalization Rate $2.00 0.250 0.150 0.125 Required: Using the information in the tables above, please calculate the sustainable grow intrinsic value per share. Then solve for the present value of growth opportuniti (Use cells A5 to B8 from the given information to complete this question.) Brous Metalworks Sustainable Growth Rate Dividends per share (Next Year) Intrinsic Value No-Growth Value Per Share Present Value of Growth Opportunities (PVGO)