Preferred stock of Fake Company Blue carries a dividend of $2.16 and analysts estimate the required return to shareholders at 5.2%. It has a current price of $36.6. How far off, in dollars, is the price based on financial theory from the current market price? Find this by starting with the given market price and subtracting out the price using intrinsic valuation from finance.

How do I do this in excel?