Jack is the only shareholder of XYZ Corporation. At year-end, XYZ had $200 of current year earnings and profits and $600 of accumulated earnings and profits. If XYZ distributes cash of $200 to Jack, what is Jacks tax liability on the dividend, if any? Assume Jack has a basis of $10 in XYZ shares. How does this result change if XYZ only has $50 of current earnings and profits and $100 of accumulated earnings and profits?

Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet.