SOLVE USING EXCEL:

A wealth management firm specializing in purchasing "value" stocks $($i$.$e$.,$ stocks trading well below their intrinsic value$)$ recently hired you as an analyst. The firm evaluates stocks using the dividend$-$growth model. You are tasked with evaluating a common stock in a newly public blockchain company. It currently pays a $$2$ dividend with a $5\%$ growth rate and required return of $10\%.$ The stock is priced at $$43\mathrm{.}10.$ Determine the current stock value and whether it is properly valued.

a$.$ $$42\mathrm{.}00,$ undervalued

b$.$ $$44\mathrm{.}00,$ overvalued

c$.$ $$44\mathrm{.}00,$ undervalued

d$.$ $$42\mathrm{.}00,$ overvalued