I need to make a income statement and a balance sheet but I'm struggling for both questions please help me

ard Font X A B C D he Vikings, Inc. has the following information at the end of Year 1: Cash $ 44,000 Accounts payable 16,000 Supplies 22,000 Service Revenue 190,000 Common stock 80,000 Advertising expense 20,000 Salaries expense 90,000 0 Land 90,000 1 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 19 Dec. 31, Year 1. Use references and formulas for ALL numbers. Use the SUM function to 20 add more than two numbers. (No numbers should be typed in.) Format your cells using 21 accounting and no decimals. Use $ at the top and very bottom of each column. Hint: 22 highlight data cells after you use them to make sure you don't forget anything. The Vikings Ine Sheet1 (+ Read Type here to search O