1. Retrieve the file HWChapter8 and solve Problem 8-8, Problem

8-10, and Problem 8-11, and Problem 8-16 using the

organizational design displayed in the worksheet file. Do not

modify the fonts, format, or cell addresses.

2. Problem 8-8: Enter an equation that solves for the value

required in Cell F7.

3. Problem 8-10: Enter equations that solve for the values

required in Cells C13, F17, F21, F25, F29.

4. Problem 8-11: Enter equations that solve for the values

required in Cells B36 and C38.

5. Problem 8-16: Enter equations that solve for the values

required in Cells E47:E50, G47:G50, E53:E54, G53:G54. Enter

either Yes or No in Cell B60.

6. Print the worksheet.

7. Retrieve the file HWChapter8Extra and enter equations that

solve for the values required in cells D24, D25, and D27.

8. Print the worksheet.

Problem 8-8 Po = D = rs = g= $80 $4.00 14% ? rs = D/P, +g Problem 8-10 $50 Par value Dps * Part a. Vps = I'ps $30 ? = Dps / Vps = Part b. Vps = Ips == $40 ? = Dps / Vps = Part c. Vps = ps $50 ? =Dos/Vos = Part d. Vps = $70 Ips ? = Dps / Vps = Problem 8-11 declining growth rate -4% $6.00 g= De = D = r = Po = 14% ? Problem 8-16 Part a. rs = Do = If g = If g = If g = If g = 13% $3.00 -5% 0% 5% we D - D - D - D = + P = Po = Po = + P = 10% Part b. If g = If g = 13% 15% + D D + P = Po = - These are not reasonable results. The formula requires that the required rate of return be greater than the expected growth rate. Part c. HWChapiler8Extra The balance sheet of a corporation is shown below. Also, Vop = Value of operations = Number of common shares = $756 20 Balance Sheet Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net plant and equipment Total assets $20 $77 $100 $200 $397 $279 $676 Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Preferred stock Common stock + paid-in capital Retained earnings Common equity Total liabilities and equity $19 $151 $51 $221 $190 $76 $100 $89 $189 $676 Total corporate value = Value of common equity = Price per share =