D 1 The Vikings, Inc. has the following Information at the end of Year 1: 2 3 Cash $ 44,000 4 Accounts payable 16,000 5 Supplies 22,000 6 Service Revenue 190,000 7 Common stock 80,000 8 Advertising expense 20,000 9 Salaries expense 90,000 10 Land 90,000 11 Notes payable 40,000 12 Retained earnings (beg.) 34,000 13 Rent expense 12,000 14 Accounts receivable 40,000 15 Insurance expense 32,000 16 Dividends 10,000 17 18 Required: Using the space below, prepare an income statement and balance sheet as of Dec. 31, Year 1. Use references and formulas for ALL numbers. Use the SUM function to add more than two 19 numbers. (No numbers should be typed in.) Format your cells using accounting and no decimals. Use $ 20 at the top and very bottom of each column. Hint: highlight data cells after you use them to make sure 21 you don't forget anything. 22 23 The Vikings, Inc. 24 Income Statement 25 For the Year Ended December 31, Year 1 26 27 28 29 30 31 32 33