Is there a way to do this on a spreadsheet? If so, please show me.
Fuel, Inc., has an issue of preferred stock outstanding that pays a $4.50 dividend every year, in perpetuity. If this issue currently sells for $46 per share, what is the required return?
The solution computes the problem without the use of Excel by explaining a simple method to arrive at the answer.