Reference no: EM132467161

National Business Machine Co. (NBM) has $4.9 million of extra cash after taxes have been paid. NBM has two choices to make use of this cash. One alternative is to invest the cash in financial assets. The resulting investment income will be paid out as a special dividend at the end of three years. In this case, the firm can invest in either Treasury bills yielding 2.7 percent or a 5.1 percent preferred stock. IRS regulations allow the company to exclude from taxable income 50 percent of the dividends received from investing in another company's stock. Another alternative is to pay out the cash now as dividends. This would allow the shareholders to invest on their own in Treasury bills with the same yield or in preferred stock. The corporate tax rate is 24 percent. Assume the investor has a 28 percent personal income tax rate, which is applied to interest income and preferred stock dividends. The personal dividend tax rate is 20 percent on common stock dividends.

Suppose the company reinvests the $4.9 million and pays a dividend in three years.

Question: What is the total aftertax cash flow to shareholders if the company invests in T-bills? (please help me see how to solve this in excel too if possible)