Waren Sports Supply Proforma Balance Sheet as Of 31st December 2018 Excel Worksheet

You will be supplied with an excel file containing all the transactions of Warren Sports Supply for the year 2017. Your task is to create the following worksheets in your spreadsheet:Trial Balance – Using the 2016 Trial Balance Tab as your beginning general ledger balances, and the 2017 transaction data supplied, add columns for “2017 Debits,” “2017 Credits,” and “Trial Balance 2017.” This will give you the ending balances for all general ledger accounts at the end of 2017.Prepare the 2017 Balance Sheet and Income Statement, using subtotals and totals similar to those shown in the “Screenshots” tab for 2016 as a formatting guide for your 2017 financial statements.Add a tab, and on that tab answer the following question:How many bills were sent to vendor “Interstate Motor Freight?”Hint: consider what tools you can use to sort and/or filter data.20 days sales in receivablesRemember to “plug” any balance sheet differences between Assets = Liab + SE to a liability account called “Additional financing needed.”