help me fill out this spread sheet instructin and scenario below.

141 Heading 3 11 Normal 1 No Spac. Heading 1 Heading 2 Heading 4 Title Subtitle Subtle Em.. Emphasis Styles Demonstration Problem 1-1 The events below apply to Computer Services Company (CSC). Assume that all transactions involve receiving or paying cash. Transactions for the year 2010: 1. CSC was started when it acquired $9,000 cash by issuing common stock. 2. The company borrowed $5,000 from a bank. 3. The company provided services to customers and received $4,000. 4. The company paid operating expenses of $2,900. 5. The company paid $500 in dividends to its stockholders. Transactions for the year 2011: 1. The company issued additional common stock for $4,500 2. The company paid $2,000 to reduce its liabilities. 3. The company provided services to customers and received $6,700. 4. The company paid operating expenses of $4,300. 5. The company paid $700 in dividends to its stockholders. Transactions for the year 2012: 1. The company issued additional common stock for $2,500 2. The company borrowed an additional $1,000 from creditors. 3. The company provided services to customers and received $7,400. 4. The company paid operating expenses of $7,900. 5. The company paid $300 in dividends to its stockholders. 6. The company paid $9,000 to purchase land. Required a. Record the events using the horizontal financial statements model. b. Prepare an income statement, statement of changes in stockholders' equity, balance sheet and statement of cash flows for each year. 141 Heading 3 11 Normal 1 No Spac. Heading 1 Heading 2 Heading 4 Title Subtitle Subtle Em.. Emphasis Styles Demonstration Problem 1-1 The events below apply to Computer Services Company (CSC). Assume that all transactions involve receiving or paying cash. Transactions for the year 2010: 1. CSC was started when it acquired $9,000 cash by issuing common stock. 2. The company borrowed $5,000 from a bank. 3. The company provided services to customers and received $4,000. 4. The company paid operating expenses of $2,900. 5. The company paid $500 in dividends to its stockholders. Transactions for the year 2011: 1. The company issued additional common stock for $4,500 2. The company paid $2,000 to reduce its liabilities. 3. The company provided services to customers and received $6,700. 4. The company paid operating expenses of $4,300. 5. The company paid $700 in dividends to its stockholders. Transactions for the year 2012: 1. The company issued additional common stock for $2,500 2. The company borrowed an additional $1,000 from creditors. 3. The company provided services to customers and received $7,400. 4. The company paid operating expenses of $7,900. 5. The company paid $300 in dividends to its stockholders. 6. The company paid $9,000 to purchase land. Required a. Record the events using the horizontal financial statements model. b. Prepare an income statement, statement of changes in stockholders' equity, balance sheet and statement of cash flows for each year. B 11_Week 1. Demonstration Problem 1-1 Format IP File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing A1 > DEMONSTRATION PROBLEM 1-1: STATEMENTS MODEL APPROACH D F 1 2 F H DEMONSTRATION PROBLEM 1-1: STATEMENTS MODEL APPROACH Computer Services Company (CSC) Effect of Transactions on the Financial Statements for 2010 Balance Sheet Income Statement Liabilities + Common Retained Liberties Stock Earnings Revenue Expenses - Net Income 0 0 Assets Equity Statement of Cash Flows Type of Cash Flow Flow Cash Land 0 4 5 Event No 7 Bal 8 1 2 10 3 11 4 12 5 O- - 14 Assets 15 16 17 18 Event 19 No 20 Ball 21 22 23 3 4 Effect of Transactions on the Financial Statements for 2011 Balance Sheet Income Statement - - Equity Common Retained Liabilities Stock Earnings Revenge Expenses - Net Income Statement of Cash Flows Type of Cash Flow Flow Cash Land 5 25 Tota 27 29 29 30 31 Effect of Transactions on the Financial Statements for 2012 Talance Sheet Income Statement Liabetes Equity Common Reed Liables Stock Earnings Revenge Expenses - Net Income Event Statement of Cash Flows Type of Cash Flow Flow Cash Land 4 35 36 37 40 Total 43 44 Model Format Statements Format Type here to search e 6