Anita Vasquez received $237,000 from her mother's estate. She placed the funds in the hands of a broker, who purchased the following securities on Vasquez's behalf: a. Common shares were purchased at a cost of $120,000. The shares paid no dividends, but they were sold for $180,000 at the end of three years. b. Preferred shares were purchased at their par value of $45,000. The shares paid a 9.0% dividend (based on par value) each year for three years. At the end of three years, the shares were sold for $31,000. c. Bonds were purchased at a cost of $72,000. The bonds paid $4,320 in interest every six months. After three years, the bonds were sold for $77,500. (Note: In discounting a cash flow that occurs semi-annually, the procedure is to halve the discount rate and double the number of periods. Use the same procedure in discounting the proceeds from the sale.) The securities were all sold at the end of three years so that Vasquez would have funds available to start a new business venture. The broker stated that the investments had earned more than a 12% return annually, and he gave Vasquez the following computation to support his statement: Common shares: Gain on sale ($180,000 - $120,000) Preferred shares: Dividends paid (9.0% * $45,000 > 3 years) Loss on sale ($31,000 - $45,000) Bonds: Interest paid ($4,320 x 6 periods) Gain on sale ($77,500 - $72,000) $ 60,000 12,150 (-14,000) 25,920 5,500 Net gain on all investments $ 89,570 Return: $89,570 + 3) = $237,000 = 12.6% Required: (Ignore income taxes.) 1-a. Using a 12% discount rate, compute the net present value of each of the three investments. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Negative amounts should be indicated by a minus sign. Do not round your intermediate calculations and round final answers to the nearest dollar amount.) Net Present Value Common stock Preferred stock Bonds 1-b. On which investment did Anita earn a 12% rate of return? Common stock Preferred stock Bonds None 2. Considering all three investments together, did Anita earn a 12% rate of return? o Yes O No 3. Anita wants to use the $288,500 in proceeds ($180,000 + $31,000 + $77,500 = $288,500) from sale of the securities to open a fast- food franchise under a 9-year contract. What net annual cash inflow must the store generate for Anita to earn a 12% return over the 9- year period? Anita will not receive back her original investment at the end of the contract. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Do not round your intermediate calculations and round final answer to the nearest dollar amount.) Annual net cash inflow Anita Vasquez received $237,000 from her mother's estate. She placed the funds in the hands of a broker, who purchased the following securities on Vasquez's behalf: a. Common shares were purchased at a cost of $120,000. The shares paid no dividends, but they were sold for $180,000 at the end of three years. b. Preferred shares were purchased at their par value of $45,000. The shares paid a 9.0% dividend (based on par value) each year for three years. At the end of three years, the shares were sold for $31,000. c. Bonds were purchased at a cost of $72,000. The bonds paid $4,320 in interest every six months. After three years, the bonds were sold for $77,500. (Note: In discounting a cash flow that occurs semi-annually, the procedure is to halve the discount rate and double the number of periods. Use the same procedure in discounting the proceeds from the sale.) The securities were all sold at the end of three years so that Vasquez would have funds available to start a new business venture. The broker stated that the investments had earned more than a 12% return annually, and he gave Vasquez the following computation to support his statement: Common shares: Gain on sale ($180,000 - $120,000) Preferred shares: Dividends paid (9.0% * $45,000 > 3 years) Loss on sale ($31,000 - $45,000) Bonds: Interest paid ($4,320 x 6 periods) Gain on sale ($77,500 - $72,000) $ 60,000 12,150 (-14,000) 25,920 5,500 Net gain on all investments $ 89,570 Return: $89,570 + 3) = $237,000 = 12.6% Required: (Ignore income taxes.) 1-a. Using a 12% discount rate, compute the net present value of each of the three investments. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Negative amounts should be indicated by a minus sign. Do not round your intermediate calculations and round final answers to the nearest dollar amount.) Net Present Value Common stock Preferred stock Bonds 1-b. On which investment did Anita earn a 12% rate of return? Common stock Preferred stock Bonds None 2. Considering all three investments together, did Anita earn a 12% rate of return? o Yes O No 3. Anita wants to use the $288,500 in proceeds ($180,000 + $31,000 + $77,500 = $288,500) from sale of the securities to open a fast- food franchise under a 9-year contract. What net annual cash inflow must the store generate for Anita to earn a 12% return over the 9- year period? Anita will not receive back her original investment at the end of the contract. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Do not round your intermediate calculations and round final answer to the nearest dollar amount.) Annual net cash inflow