complete either through excelDisplay formula process

34. Carter's preferred stock pays a dividend of $1.00 per quarter. If the price of the stock is $45.00, what is its nominal (not effective) annual rate of return? 35, Nachman Industries just paid a dividend of Do = $1.32. Analysts expect the company's dividend to grow by 30% this year, by 10% in Year 2, and at a constant rate of 5% in Year 3 and thereafter. The required return on this low-risk stock is 9.00%. What is the best estimate of the stock's current market value