Please help with this assignment. I have the document attached. Thank you!

Goal 5 Applying Excel Horizontal Analysis Vertical Analysis The goal of this assignment is for students to demonstrate their ability to use Microsoft Excel both proficiently and professionally. Requirements: You will be uploading TWO files to the Assignment box. One that shows your Vertical & Horizontal Analysis with AMOUNTS. One that shows your Vertical & Horizontal Analysis with FORMULAS. 1. Complete a Horizontal Analysis and a Vertical Analysis using the financials below. You may use separate tabs to best organize your work; this is your option. 2. Round all percentages to the tenth decimal place. 3. Format your spreadsheets exactly like the Exhibits in the chapter material. (but do not include the * legends) 4. Save this file as Your Name Analysis. (this is your V/H Analysis with Amounts) 5. Save this file again as Your Name Formulas. (this is your V/H Analysis with Formulas) 6. You will now complete the FORMUALS files by showing the formulas, properly sizing the rows and columns and viewing and printing to be certain you have an efficient printable document. Then SAVE IT. Make sure your name is on it. Print out each tab of data to verify. 7. Place your name at the top left corner of each spreadsheet in your workbook. 8. Review the PRINT AREA of each spreadsheet so they will print most effectively. Following each of the above requirements will be factored into the grading of this assignment. Additional Information and Hints: Complete this assignment by properly and professionally formatting your spreadsheet. Use formulas to complete the computational components of this assignment. There are many formulas that can be used to obtain the desired results, however, you are to demonstrate your ability to choose the most \"efficient\" formula. I have provided links in the Competence in Technology content section of D2L to assist you. To show the formulas, you will save your work in as new file (Your Name Formulas) and then choose the show formulas feature, (CTRL tilde) or (CTRL ~) or go to the help feature and search for the SHOW FORMULAS instructions or go to Google and search for SHOW FORMULAS on UTube. Properly format this spreadsheet for easy viewing and printing, and SAVE it. You will need to SAVE AS TYPE of file in the \"Excel 97 - 2003 Workbook\" to get your formulas to be there when you re-open a file. To check that this format was saved properly, you should close and reopen your file to review it. Working with others and/or sharing files: The purpose of this assignment is to determine each student's competence in using technology. All students have completed courses in this topic area and all students have access to resources in order to demonstrate their ability to apply their knowledge. Working with others and/or sharing files (continued): As such, helping others or working with others must be done with academic integrity. What this means is that each student will assume responsibility for their work and the materials submitted in fulfillment of these requirements. All work must represent each student's own efforts. Academic dishonesty includes but is not limited to: Copying work submitted by another student. Material copied directly from an online or printed source without reference. Allowing a friend or classmate to complete part of your coursework. You are expected to be honest in completing this assignment. Please remember, sharing any file is prohibited and you will receive a zero and be turned into the Office of Student Conduct and Conflict Resolution for further consequences. Here are the financial statements that you are to use. STARTER COMPANY Income Statement For the Years Ended December 31 2016 Revenues Sales (net) Other revenues $ 318,000 22,000 2015 $ 146,000 25,000 Total revenues Expenses Cost of goods sold Selling, general, and administrative Research and development expense Other expenses 340,000 171,000 145,000 14,000 22,000 47,000 62,000 5,000 9,000 22,000 Total expenses Income before income tax Income tax expense 228,000 112,000 25,000 98,000 73,000 21,000 Net income $ 87,000 $ 52,000 STARTER COMPANY Balance Sheets As of December 31 2016 Assets Current assets Cash Marketable securities Accounts receivable (net) Inventories Prepaid items Total current assets Investments Plant (net) Land Total assets Liabilities and Stockholders' Equity Liabilities Current liabilities Accounts payable Notes payable Salaries payable Total current liabilities Noncurrent liabilities Bonds payable Other Total noncurrent liabilities Total liabilities Stockholders' equity Common stock (No par; 50,000 shares authorized; 10,000 shares issued) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ $ $ $ 427,000 50,000 104,000 160,000 25,000 766,000 52,000 379,000 29,000 1,226,000 33,000 15,000 21,000 69,000 2015 $ $ $ 349,000 24,000 96,000 143,000 10,000 622,000 20,000 288,000 24,000 954,000 46,000 9,000 15,000 70,000 200,000 24,000 224,000 293,000 200,000 27,000 227,000 297,000 80,000 853,000 933,000 80,000 577,000 657,000 1,226,000 $ 954,000