Please kindly help me with this question. It is highly important to use only excel PLEASE. Also, the cell reference or formula is very important so that I can under the route to the answer. PLEASE

(7-10) Nick's Enchiladas has preferred stock outstanding that pays a dividend of $5 at the end of Preferred Stock each year. The preferred stock sells for $50 a share. What is the stock's required rate of Rate of Return return? (Assume the market is in equilibrium with the required return equal to the expected return.)