Obtain the balance sheet and income statement from a company of your choice from their latest 10-K annual reports.
ACCT 3212 EXCEL 2 Assignment Due November 7, 2019 Obtain the balance sheet and income statement from a company of your choice from their latest 10-K annual reports. This information is found on the SEC website (www.sc.gov). Access the Quick EDGAR tutorial. Click on "Companies and other Filers. Fill in your company name one and find the 10-K. Look for companies that allow you to transfer their financial information to EXCEL (will have interactive Data"). Click on "View EXCEL Document then SAVE. Open the file saved (remember to click on the tab for the statements) Cut and paste all years shown of the balance sheet and income statement into a new EXCEL spreadsheet. Omit any extraneous information (eg, shares of stock issued outstanding, ops for other than the net income, etc.). Compute the ratios and financial analysis for each company as indicated below. 1. Horizontal analysis of the balance sheet and income statement (% change from year to year) for all the years presented. 2. Vertical analysis of the balance sheet and income statement for all years shown 3. Ratio Analysis (Illustration 5A-1 p. 232) for two years for each company a. Current ratio b. Quick ratio c. Profit Margin on Sales d. Price-Earnings ratio (you will have to google stock price on the balance sheet date) e. Debt to Assets ratio SUBMIT THE FOLLOWING: 1. Spreadsheet pages with balance sheets and income statements in landscape format 2. Ratio analysis and % change computations (may be on the spreadsheets above) 3. An analysis describing your company's health based on what you discovered in all of the analyses you performed (not just ratio analysis). ACCT 3212 EXCEL 2 Assignment Due November 7, 2019 Obtain the balance sheet and income statement from a company of your choice from their latest 10-K annual reports. This information is found on the SEC website (www.sc.gov). Access the Quick EDGAR tutorial. Click on "Companies and other Filers. Fill in your company name one and find the 10-K. Look for companies that allow you to transfer their financial information to EXCEL (will have interactive Data"). Click on "View EXCEL Document then SAVE. Open the file saved (remember to click on the tab for the statements) Cut and paste all years shown of the balance sheet and income statement into a new EXCEL spreadsheet. Omit any extraneous information (eg, shares of stock issued outstanding, ops for other than the net income, etc.). Compute the ratios and financial analysis for each company as indicated below. 1. Horizontal analysis of the balance sheet and income statement (% change from year to year) for all the years presented. 2. Vertical analysis of the balance sheet and income statement for all years shown 3. Ratio Analysis (Illustration 5A-1 p. 232) for two years for each company a. Current ratio b. Quick ratio c. Profit Margin on Sales d. Price-Earnings ratio (you will have to google stock price on the balance sheet date) e. Debt to Assets ratio SUBMIT THE FOLLOWING: 1. Spreadsheet pages with balance sheets and income statements in landscape format 2. Ratio analysis and % change computations (may be on the spreadsheets above) 3. An analysis describing your company's health based on what you discovered in all of the analyses you performed (not just ratio analysis)
