Please answer in excel if possible please use formulas to calculate all values in the spreadsheets.

On 2014 December 31, Perez Company, the accounting records showed the following information: Prepare the Statement of Stockholders' Equity on 2014 December 31. Statement of Stockholders' Equity Perez Company Month Ended on December 31, 2014 Perez Company, Capital Stock, January 1, 2014 (beginning balance) $100,000 Net income for the year Less: Dividends Perez Company. Capital Stock, January 1, 2014 (Ending balance)