I need help with my balance sheet based on the income statement I prepared below... (i need to compress//delete some of the accounts so that it reflects the income statement below)

Overview 1. Download 3-Years of Apple (AAPL) Income Statements & Balance Sheets from Mergent Online (2014-2016) 2. Replace all subtotals and totals on the financial statements with Excel formulas 3. Perform Horizontal Analysis on the Income Statements & Balance Sheets 4. Perform Vertical Analysis on the Income Statements & Balance Sheets 5. Perform Ratio Analysis on the Income Statements & Balance Sheets Instructions 1. Download 3-Years of Apple (AAPL) Income Statements & Balance Sheets from Mergent Online a. HSU Library Search & Locate Articles & Databases Business MerEent Onlin i. Company Search AAPL Apple Inc. 1. Company & Financials Income Statement Standardized 3-Years Download to Excel 2. Company & Financials Balance Sheet-> Standardized 3-Years Download to Excel b. Combine both Excel sheets into a single Excel workbook. c. Reformat your Excel sheets to give them a professional look. 2. Replace all subtotals and totals on the financial statements with Excel formulas a. Identify each subtotal and total on the Income Statements & Balance Sheets b. Replace each subtotal and total with an Excel formula c. nclude a subtotal line (top border) above each amount that is calculated using a formula. d. Include a total line (top and double-bottom border) for each total. 3. Perform Horizontal Analysis on the Income statements & Balance Sheets a. 2016 Change lb. 2016 Change c. 2015 $-Change d. 2015 Change 4. Perform Vertical Analysis on the Income Statements & Balance Sheets a. 2016 Common Size b. 2015 Common Size c. 2014 Common Size 5. Perform Ratio Analysis on the Income Statements & Balance Sheets a. Create a third sheet titled ARatio Analysis" b. Use links and formulas to calculate the following 2016 Ratios: i. 2016 Current Ratio ii. 2016 Total Asset Turnover iii. 2016 Debt Ratio iv. 2016 Equity Ratio v. 2016 Profit Margin Ratio vi. 2016 Return on Total Assets c. See page 603 (Exhibit 13.16) for Ratio Formulas