Option #1: Earnings and Profits

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. This means that you must use formulas and links so that the thought process can be examined. Make effective use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file for grading.