Haslem, Inc. has 3 million shares of common stock outstanding, 1 million shares of preferred stock, and 80,000 bonds. The common stock is selling for $50 per share, the preferred stock is selling for $33 per share, and the bonds are 25 year, 8.5%, $1,000 bonds that are presently selling for $1,080 (semiannual interest). The preferred stock pays an annual dividend of $2.70, and the common dividend paid in the year just ended was $2.40. The dividend on the common stock is projected to grow at a rate of 6% indefinitely

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding