CREATE AN INCOME STATEMENT USING MS EXCEL ATTACH YOUR MS EXCEL FILE TO THIS QUESTION. CREATE AN INCOME STATEMENT & USE FORMULAS- Bob's Your Uncle Ice Cream Shop Ter Graw Dream Your uncle Bob owns his own business selling ice cream to local restaurants and has an ice cream stand on the Great Sacandaga Lake Bob has asked you to create an income statement for his business using the following information Bob invested heavily in marketing his business and spent $4,000 on radio advertisements and a variety of print materials. Bob purchased an ice cream machine for $9,000 that he estimated would last 3 years and would have $3,000 salvage value. He also purchased an ice cream track for $15,000 that would last for 5 years with no salvage value. At the end of last year (Dec 31') he had received $107,000 in cash but was still owed $5,000 from local restaurants and groceries After reviewing the company's bank account and your uncles' general ledger you summarize the following expenditures Gas Expense $3,000 Prepaid Insurance $3,000 (Paid jaw for oncorso Salaries & Wages Expense 35,000 Utilities Expense 2,300 Rent Expense 5,500 Supplies Expense 5,600 Repairs & Maintenance Expense 3,500 Misc. Expense 1,100 Bob keeps $1,500 of supplies as assets in stock to use next year and he had not yet paid Dee's cent that he owed was $500, he also owed his employees $2,000 in wages Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All cks Mowing - Stud....xls Ren file Jacks Mowing - Stud....xls Open file Jacks Mowing Case.docx Open file Jacks Mowing Case.. Open file OPI