Assignment Objective: Perform horizontal and vertical financial statement analysis in Excel. Perform Ratio Analysis in Excel Data Source: Income Statement and Balance Sheet. Individual/Group: Individual assignment using the financial statements from individual project. Assignment Deadline: Tuesday, March 03, 2020 Method of Submission: 1. Print out hard copies of Excel spreadsheets. 2. E-Mail Excel spreadsheets used to perform analysis. Assignment Specifics: 1. Download your company’s financial statements from Mergent in Excel format. 2. Be sure to perform your analysis on: A. Three years of Year-End Income Statements B. Three years of Year End Balance Sheets 3. Copy original spreadsheets onto another worksheet in the workbook to begin your analysis. 4. Make two more copies (one for horizontal analysis, the other for vertical analysis). 5. Perform horizontal analysis on one of the spreadsheets. 6. Perform vertical analysis on the other spreadsheet. 7. Perform ratio analysis in another spreadsheet. Factors to consider when performing assignment: 1. How is the company grouping the income, expense and balance sheet items? 2. What jumps out at you from anything on the financial statements. (Unusual items deserve more investigation.) 3. How much tax does the company report paying? (Companies that pay tax are profitable, companies that do not pay tax may not profitable.) 4. Are there any “extraordinary items” (good or bad) that are not likely to show up in the future?
We Write Essays for Students
Tell us about your assignment and we will find the best writer for your paper
Get Help Now!The post Assignment Objective: Perform horizontal and vertical financial statement analysis in Excel. Perform Ratio Analysis in Excel Data Source: appeared first on Versed Writers.
Welcome to originalessaywriters.com, our friendly and experienced essay writers are available 24/7 to complete all your assignments. We offer high-quality academic essays written from scratch to guarantee top grades to all students. All our papers are 100% plagiarism-free and come with a plagiarism report, upon request
Tell Us “Write My Essay for Me” and Relax! You will get an original essay well before your submission deadline.
