Please, I need the answers worked in Excel.

Preparing the company's financial statements Following are the amounts of the assets and liabilities of Glenmorangie Consultants Agency at December 31, 2012, the end of the current year, and its revenue and expenses for the year. The capital of Kris Taber, owner, was $120,000 on January 1, 2012, the beginning of the current year. During the current year, Kris withdrew $10,000. 1. Prepare an income statement for the current year ended December 31,2012. 2. Prepare a statement of owner's equity for the current year ended December 31, 2012. 3. Prepare a balance sheet as of December 31, 2012. 4. What item appears on both the statement of owner's equity and the balance sheet