You are planning to save for retirement over the next 35 years. To do this, you will invest $740 per month in a stock account and $340 per month in a bond account. The return of the stock account is expected to be 9.4 percent, and the bond account will pay 5.4 percent. When you retire, you will combine your money into an account with a return of 6.4 percent. How much can you withdraw each month from your account assuming a 30-year withdrawal period

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?

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

On january 1, 2017, pharoah company issued 10-year, $2,020,000 face value, 6% bonds, at par. each $1,000 bond is convertible into 16 shares of pharoah common stock. pharoah’s net income in 2017 was $317,000, and its tax rate was 40%. the company had 97,000 shares of common stock outstanding throughout 2017. none of the bonds were converted in 2017. (a) compute diluted earnings per share for 2017. (round answer to 2 decimal places, e.g. $2.55.) diluted earnings per share