Expand the spreadsheet of problem 13 to consider one extra source of return and one extra cost

Question:

Expand the spreadsheet of problem 13 to consider one extra source of return and one extra cost to using margin. Specifically, modify the spreadsheet to include expected dividends per share and the cost of the margin loan (stated in APR format). Assume that Broussard Corporation pays a dividend of $0.50 per share, Mattco pays an annual dividend of $0.80 per share, and the margin loan rate is 6 percent.

Corporation
A Corporation is a legal form of business that is separate from its owner. In other words, a corporation is a business or organization formed by a group of people, and its right and liabilities separate from those of the individuals involved. It may... Dividend
A dividend is a distribution of a portion of company’s earnings, decided and managed by the company’s board of directors, and paid to the shareholders. Dividends are given on the shares. It is a token reward paid to the shareholders for their...