Question

The Fridge-Air Company's preferred stock pays a dividend of $4.50 per share annually. If the required...

The Fridge-Air Company's preferred stock pays a dividend of $4.50 per share annually. If the required rate of return on comparable quality preferred stocks is 14 percent, calculate the value of Fridge-Air's preferred stock.

Please Kindly Show Step By Step Using EXCEL Formula Thank you

Homework Answers

Answer #1

Calculate the value of the preferred stock as follows:

Return = Dividend / Value of preferred stock

14% = $4.50 / Value of preferred stock

Value of preferred stock = $32.14

Therefore, the value of preferred stock is $32.14.

-----------------------------------------------------------------

Open --> Excel --> Formulas --> PV function:

Calculation in Excel as follows:

Value is $32.14.

Note: Nper is assumed because it is a perpetual payment. Nper may be 100 or 1000.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The preferred stock of Company A pays a constant $1.00 per share dividend. The common stock...
The preferred stock of Company A pays a constant $1.00 per share dividend. The common stock of Company B just paid a $1.00 dividend per share, but its dividend is expected to grow at 4 percent per year forever. Company C common stock also just paid a dividend of $1.00 per share, but its dividend is expected to grow at 10 percent per year for five years and then grow at 4 percent per year forever. All three stocks have...
(Preferred stock value) McDonald’s Corp. preferred stock pays an annual dividend of $5 per share. Calculate...
(Preferred stock value) McDonald’s Corp. preferred stock pays an annual dividend of $5 per share. Calculate the value of one share to an investor who requires a rate of return of: (USING EXCEL) a. 6% b. 9% c. 12% d. 15%
1. What is the price of a share of preferred stock that has a dividend of...
1. What is the price of a share of preferred stock that has a dividend of $3 if the cost of preferred (rp) is 15% 2. What would you pay for a share of common stock if you expect the next dividend to be $3 and you expect to sell it in one year for $25, assuming the cost of equity (re) is 15%. 3. MBV is a cruise line which announced that dividends are expected to grow by 3.5...
A share of preferred stock has a par value of $20.  It pays a 4% dividend. If...
A share of preferred stock has a par value of $20.  It pays a 4% dividend. If the required return is 7%​, what is the price of the​ stock?  (Round to the nearest​ cent.)
​ Haney, Inc.'s preferred stock is selling for ​$20.7520.75 per share in the market and pays...
​ Haney, Inc.'s preferred stock is selling for ​$20.7520.75 per share in the market and pays a ​$3.503.50 annual dividend. a. What is the expected rate of return on the​ stock? b. If an​ investor's required rate of return is 99 ​percent, what is the value of the stock for that​ investor? c. Should the investor acquire the​ stock?
Mack Industries just paid $1.00 per share dividend (i.e., D0=$1.00). Analysts expect the company's dividend to...
Mack Industries just paid $1.00 per share dividend (i.e., D0=$1.00). Analysts expect the company's dividend to grow 20 percent this year (i.e., D1=1$1.20), and 15 percent in the following year. After two years the dividend is expected to grow at a constant rate of 5 percent. The required rate of return on the company's stock is 12 percent. What should be the current price of the company's stock? Show answer using excel.
City Movers announced its next annual dividend will be $.60 a share. The following dividends will...
City Movers announced its next annual dividend will be $.60 a share. The following dividends will be $.75, and $.95 a share annually for the following two years, respectively. After that, dividends are projected to increase by 4.5 percent per year. How much is one share of this stock worth at a rate of return of 12.5 percent? (Show your formula/ equation/ calculations) Kindly provide me with the formula/method of getting the answer, thank you!
4. Burnett Corp. pays a constant $29 dividend on its stock. The company will maintain this...
4. Burnett Corp. pays a constant $29 dividend on its stock. The company will maintain this dividend for the next 15 years and will then cease paying dividends forever. If the required return on this stock is 14 percent, what is the current share price? $203.06 $187.03 $178.12 $174.56 $435.00 11. CDB stock is currently priced at $77. The company will pay a dividend of $5.37 next year and investors require a return of 11.8 percent on similar stocks. What...
The preferred stock of Dragons Inc. pays a $1 dividend. What is the value of the...
The preferred stock of Dragons Inc. pays a $1 dividend. What is the value of the stock if your required rate of return is 10 percent? Mosser Corporation, Inc. paid a $4 dividend last year. At a constant growth rate of 6 percent, what is the value of the common stock if the investors require a 10 percent rate of return? HomeNet Inc. paid a $3 last year and the stock is currently selling for $60. If investors require a...
Herro Corp. preferred stock is selling for $55 per share in the market. This preferred stock...
Herro Corp. preferred stock is selling for $55 per share in the market. This preferred stock has a par value of $40 and a dividend rate of 14 percent. Answer the following: 1.What is the current yield on the stock? 2. If an investor has a required rate of return of 18 percent, what is the value of the stock for that investor? 3. Should the investor acquire the stock? Explain. 4. Explain why preferred stock is referred to as...