Formulating a statement of stockholder's equity from raw data.

Crocker Corp began calendar year 2016 with stockholder's equity of $150,000 consisting of contributed capital of $120,000 and retained earnings of $30,000. During 2016, it is issued additional stock for total cash proceeds of $30,000. It also reported $50,000 of net income and paid $25,000 as a cash dividend to stockholders. Prepare the 2016 income statement of stockholder's equity for Crocker Corp. Show necessary calculations for Excel.