Determining Required Return: Example Problem

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?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/determining-required-return-example-problem-2fk

Solution Preview

...the required rate of return.

The formula for calculating the required ...