Hello, can I please get a step by step solution using excel? Thank you!

National Business Machine Co. (NBM) has $4.4 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 rm can invest in either Treasury bills yielding 2.2 percent or a 4.6 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 38 percent personal income tax rate, which is applied to interest income and preferred stock dividends. The personal dividend tax rate is 10 percent on common stock dividends. Suppose the company reinvests the $4.4 million and pays a dividend in three years. a-1. What is the total aftertax cash ow to shareholders if the company invests in T-bills? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) a-2. What is the total aftertax cash ow to shareholders if the company invests in preferred stock? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) Value in three years Value in three years Suppose instead that the company pays a $4.4 million dividend now and the shareholder reinvests the dividend for three years. b-1. What is the total aftertax cash ow to shareholders if the shareholder invests in T-bills? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) b-2. What is the total aftertax cash flow to shareholders if the shareholder invests in preferred stock? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.)