Can you help with these questions? Answers in Excel with visible formulas are acceptable.

1. Suppose Nabisco Corporation just issued a dividend of $1.87 per share yesterday. Subsequent dividends will grow at a constant rate of 7% indefinitely. If the required rate of return for this stock is 17.8%, what is the value of a share of common stock today? Price of stock today (to nearest cent) = 2. What is the value of a share of preferred stock that promises to pay $1.3every year,indefinitely, if you have a required rate of return of 12.1%? Price of stock today (to nearest cent) = 3. The current price of Janco stock is $29.96. Dividends are expected to grow at 5.4% indefinitely and the most recent dividend paid yesterday was $3.38. What is the required rate of return, dividend yield, and capital gains yield on Janco's stock? (show your answers to 4 decimal places. DO NOT round until after all calculations have been completed and you have reached your final answer. If your answer ends in a zero, only include 1 decimal place and omit the zero. If the answer ends in two zeros after rounding, do not use any decimal places as ANGEL does not recognize the ".00" endings and will remove points from your score.) The required rate of return = Dividend yield = Capital Gains Yield = 4. Magnetic Corporation expects dividends to grow at a rate of 15.9% for the next two years. After two years dividends are expected to grow at a constant rate of 3.4%, indefinitely. Magnetic's required rate of return is 12.9% and they paid a $2.72 dividend today. What is the value of Magnetic Corporation's common stock per share? (Show your answers to the nearest cent. Round your answer to the nearest 2 decimal places. DO NOT round until after all calculations have been completed and you have reached your final answer. If your answer ends in a zero, only include 1 decimal place and omit the zero. If the answer ends in two zeros after rounding, do not use any decimal places as ANGEL does not recognize the ".00" endings and will remove points from your score.) Dividend at end of year 1 = Dividend at end of year 2 = Dividend at end of year 3 = Price of stock at end of year 2 = Price of stock today = Magnetic Corporation expects dividends to grow at a rate of 15.9% for the next two years. After two years dividends are expected to grow at a constant rate of 3.4%, indefinitely. Magnetic's required rate of return is 12.9% and they paid a $2.72 dividend today. What is the value of Magnetic Corporation's common stock per share? (Show your answers to the nearest cent. Round your answer to the nearest 2 decimal places. DO NOT round until after all calculations have been completed and you have reached your final answer. If your answer ends in a zero, only include 1 decimal place and omit the zero. If the answer ends in two zeros after rounding, do not use any decimal places as ANGEL does not recognize the ".00" endings and will remove points from your score.) Dividend at end of year 1 = 3.15 Dividend at end of year 2 = 3.65 Dividend at end of year 3 = 3.78 Price of stock at end of year 2 = 39.77 Price of stock today = 33.29 Table for Individual Question Feedback Points Earned: 3.0/5.0 Correct Answer(s): Dividend at end of year 1 =: 3.15; Dividend at end of year 2 =: 3.65; Dividend at end of year 3 =: 3.77; Price of stock at end of year 2 =: 39.68; Price of stock today =: 36.78 Magnetic Corporation expects dividends to grow at a rate of 12.4% for the next two years. After two years dividends are expected to grow at a constant rate of 6.3%, indefinitely. Magnetic's required rate of return is 14.3% and they paid a $1.05 dividend today. What is the value of Magnetic Corporation's common stock per share? (Show your answers to the nearest cent. Round your answer to the nearest 2 decimal places. DO NOT round until after all calculations have been completed and you have reached your final answer. If your answer ends in a zero, only include 1 decimal place and omit the zero. If the answer ends in two zeros after rounding, do not use any decimal places as ANGEL does not recognize the ".00" endings and will remove points from your score.) Dividend at end of year 1 = 1.18 Dividend at end of year 2 = 3.65 Dividend at end of year 3 = 3.77 Price of stock at end of year 2 = 39.68 Price of stock today = 35.92 Table for Individual Question Feedback Points Earned: 1.0/5.0 Correct Answer(s): Dividend at end of year 1 =: 1.18; Dividend at end of year 2 =: 1.33; Dividend at end of year 3 =: 1.41; Price of stock at end of year 2 =: 17.62; Price of stock today =: 15.54 4. Magnetic Corporation expects dividends to grow at a rate of 13.8% for the next two years. After two years dividends are expected to grow at a constant rate of 5.3%, indefinitely. Magnetic's required rate of return is 11.5% and they paid a $1.01 dividend today. What is the value of Magnetic Corporation's common stock per share? (Show your answers to the nearest cent. Round your answer to the nearest 2 decimal places. DO NOT round until after all calculations have been completed and you have reached your final answer. If your answer ends in a zero, only include 1 decimal place and omit the zero. If the answer ends in two zeros after rounding, do not use any decimal places as ANGEL does not recognize the ".00" endings and will remove points from your score.) Dividend at end of year 1 = Dividend at end of year 2 = Dividend at end of year 3 = Price of stock at end of year 2 = Price of stock today = 4. Magnetic Corporation expects dividends to grow at a rate of 13.8% for the next two years. After two years dividends are expected to grow at a constant rate of 5.3%, indefinitely. Magnetic's required rate of return is 11.5% and they paid a $1.01 dividend today. What is the value of Magnetic Corporation's common stock per share? (Show your answers to the nearest cent. Round your answer to the nearest 2 decimal places. DO NOT round until after all calculations have been completed and you have reached your final answer. If your answer ends in a zero, only include 1 decimal place and omit the zero. If the answer ends in two zeros after rounding, do not use any decimal places as ANGEL does not recognize the ".00" endings and will remove points from your score.) Dividend at end of year 1 = Dividend at end of year 2 = Dividend at end of year 3 = Price of stock at end of year 2 = Price of stock today =