P$10-7$ Modified $($see problem below for revisions$)$

Wayne, Inc.$\text{'}$s outstanding common stock is currently selling in the market for $$60.$ Dividends of $$1\mathrm{.}45$ per share were paid last year, return on equity is $15\%,$ and its retention rate is $50\%.$

a$.$ What is the value of the stock to you, given a $10\%$ required rate of return?

b$.$ Should you purchase the stock? Why?

a$.$

$\backslash$table$[[D_0=,],[D_1=,],[ROE=,]$

$,[$Ret $R=,],[g=,],[r=,],[$Value $=,]]$

Please show how to solve step by step for Excel