Requirements: 1. Complete only one Excel file with four spreadsheets (TABS) as follows: Horizontal Analysis Show formulas for Horizontal spreadsheet Vertical Analysis Show formulas for Vertical spreadsheet 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. Place your name at the top left corner of each spreadsheet in your workbook. 5. 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 to copy your assignment to a new tab and then choose the show formulas feature, then properly format this spreadsheet for easy viewing and printing, and SAVE it. 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 students 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 students 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. PLANTER COMPANY Statements of Income and Retained Earnings For the Years Ended December 31 2015 2014 Revenues Sales (net) $ 440,000 $ 480,000 Other revenues 22,000 25,000 Total revenues 462,000 505,000 Expenses Cost of goods sold 240,000 250,000 Selling, general, and administrative 95,000 110,000 Interest expense 15,000 16,000 Income tax expense 44,000 36,000 Total expenses 394,000 412,000 Net earnings (net income) 68,000 93,000 Retained earnings, January 1 108,000 96,000 Less: Preferred stock dividends 1,000 1,000 Common stock dividends 1,500 2,000 Retained earnings, December 31 $ 173,500 $ 186,000 PLANTER COMPANY Balance Sheets As of December 31 2015 2014 Assets Current assets Cash $ 46,000 $ 50,000 Marketable securities 50,000 24,000 Accounts receivable (net) 104,000 96,000 Inventories 160,000 143,000 Prepaid items 25,000 10,000 Total current assets 385,000 323,000 Investments 52,000 20,000 Plant (net) 320,000 355,000 Land 29,000 24,000 Total assets $ 786,000 $ 722,000 Liabilities and Stockholders' Equity Liabilities Current liabilities Notes payable $ 15,000 $ 9,000 Accounts payable 96,200 100,000 Salaries payable 21,000 15,000 Total current liabilities 132,200 124,000 Noncurrent liabilities Bonds payable 200,000 200,000 Other 24,000 27,000 Total noncurrent liabilities 224,000 227,000 Total liabilities 356,200 351,000 Stockholders' equity Preferred stock (par value $5, 4% cumulative, non-participating; 10,000 shares authorized and issued) 50,000 50,000 Common stock (No par; 50,000 shares authorized; 10,000 shares issued) 80,000 80,000 Retained earnings 299,800 241,000 Total stockholders' equity 429,800 371,000 Total liabilities and stockholders' equity $ 786,000 $ 722,000

Please help!