Please show me on excel.

Interest versus dividend income Last year, Shering Corporation had pretax earnings from operations of $490,000. In addition, it received $20,000 in income from interest on bonds it held in Zig Manufacturing and received $20,000 in income from dividends on its 5% common stock holding in Tank Industries, Inc. Shering faces a flat 21% tax rate and is eligible for a 50% dividend exclusion on its Tank Industries stock.

1. Calculate the firms tax on its operating earnings only.

2. Find the tax and the after-tax amount attributable to the interest income from Zig Manufacturing bonds.

3. Find the tax and the after-tax amount attributable to the dividend income from the Tank Industries, Inc., common stock.

4. Compare, contrast, and discuss the after-tax amounts resulting from the interest income and dividend income calculated in parts b and c.

5. What is the firms total tax liability for the year?