Instructions This assessment addresses the following course objective(s): Analyze balance sheet equity entries. Throughout this course you have been researching one of the following companies: Target (TGT) Walmart (WMT) Walgreens (WAG) CVS (CVS) Kroger (KR) You have been sharing research you have found in the weekly discussions and compiled a list of resources supporting your research and opinion. In unit 5, you submitted a reference list to support your research into the financial health of your company. In unit 6 you submitted the ratio analysis after compiling three years of data for your company. You are now ready to prepare to complete a financial analysis on the company that you have been following this term. In this assignment you will complete a 4-5 page paper discussing the company's financial health through a discussion of the ratio calculations. The ratios should be the basis for your discussion looking at the trends determining which areas are improving and eroding. Be sure to make a final conclusion as to your opinion of the overall health of your company. Your paper should be supported with at least four outside references beyond the textbook and Hoovers. Paper Outline 1. Introduction 2. Provide background about the company 3. Discussion the company's liquidity ratios 4. Discuss the company management ratios 5. Discuss the company's debt ratios 6. Discuss the company's profitability ratios 7. Discuss the company's market ratios 8. Discuss the overall assessment of the financial health of the company 9. Conclusion AC216 Final Project - Financial Analysis Report Instructions For the final of this course, you will analyze the accounting information of a company of your choice. Activities throughout this course will guide you to accurately describe the health of the company and support your conclusions with industry reports. This assessment addresses the following course objective(s): Analyze balance sheet equity entries. Throughout this course, you will be discussing financial reports from a company you choose from the following list. Target (TGT) Walmart (WMT) Walgreens (WAG) CVS (CVS) Kroger (KR) You can find information about your company by accessing the Hoover Library Database. Follow these instructions [PDF] to find the financial reports for your chosen company. Suggested Timeline Unit 1 - Chose your company. In the Unit 1 Discussion you will share with the class which of these companies you will analyze in this course Unit 2 - Complete the financial tab in the excel spreadsheet. Start collecting the financial information. You will find an open discussion board where you can post questions you may have about filling out the spreadsheet or finding appropriate information. Please use this as a collaborative forum. Feel free to ask questions. I am sure other students in the class have the same question or may have an answer. Your professor will be monitoring this forum. Unit 3 - Research your company, finding articles on the company's financial performance. Use the course discussions as a guide as your research and collect information about your company. Keep a list of all your references as you go. Unit 4 - Research your company, finding articles on the company's financial performance. Unit 5 - Research your company, finding articles on the company's financial performance. In this unit you will submit the resources you have been using in the discussion and to help you complete your analysis report. Unit 6 - Complete the ratio calculations in the excel spreadsheet template provided. In this unit you will submit your ratio calculations spreadsheet. Unit 7 - Write the paper assessing the company's financial health and submit the project. There are three deliverables for this project 1. Reference List - Unit 5 2. Ratio Calculations - Unit 6 3. Financial Analysis Report - Unit 7 Reference List The weekly discussions will guide you on your research of your chosen company. The Reference page must be properly formatted in APA style. You may find the following resources helpful in formatting your reference page. Reference List: Basic Rules (Purdue Online Writing Lab, n.d.) Purdue OWL: APA Formatting: Reference List Basics (OWLPurdue, 2012) Your reference page should contain at least 4 references beyond the textbook and Hoover. Ratio Analysis Calculations In unit 6 you will submit the ratio analysis calculations after compiling three years of data for your company in the excel template provided. Financial Analysis Report After completing your research and the ratio analysis calculations, you will be prepared to complete a financial health analysis on the company that you have been following this term. You will complete a 4-5-page paper discussing the company's financial health through a discussion of the ratio calculations. The ratios should be the basis for your evaluation of the company's financial position, note the trends determining which areas are improving and eroding. Be sure to make a final conclusion as to your opinion of the overall health of your company. After completing your discussion of the ratio analysis, briefly discuss if the press reports on your company match your numeric conclusions. Your paper should be supported with at least four outside references beyond the textbook and Hoovers. Paper Outline 1. Introduction 2. Provide background about the company 3. Discussion the company's liquidity ratios 4. Discuss the company management ratios 5. Discuss the company's debt ratios 6. Discuss the company's profitability ratios 7. Discuss the company's market ratios 8. Discuss the overall assessment of the financial health of the company 9. Conclusion (enter the yea Ratio Analysis Company CURRENT RATIO: Current assets Current liabilities Liquidity Ratios Cash + ST investments + receivables Current liabilities DEBT TO TOTAL ASSETS: Total debt Total assets DEBT TO TOTAL EQUITY: Debt ratios Total debt Total equity TIMES INTEREST EARNED: Income before tax and interest Interest charges ACCOUNTS RECEIVABLE TURNOVER: Net credit sales Average net accounts receivable Mangemen ratios INVENTORY TURNOVER: Cost of goods sold Average inventory NET PROFIT ON SALES: Net income Net sales GROSS PROFIT MARGIN Gross profit Net sales Profitabilt RETURN ON ASSETS: Net income + interest Average assets RETURN ON EQUITY: Net income - preferred dividends Average common equity Common equity Common shares BOOK VALUE: EARNINGS PER SHARE: Income available to common Average number of shares PRICE EARNINGS: Market price per share Earnings per share Market rat DIVIDEND RATE/YIELD: Annual cash dividend per share Market price per share DIVIDEND PAYOUT RATIO: Annual cash dividend per share Earnings per share (enter the year of the company's most recent financial report) 2017 2016 I20 ar of the company's most recent financial report) 2017 2016 2015 15 . L 200 25 I Ratio Analysis Company O 2017 20 15 CURRENT RATIO: QUICK RATIO: DEBT TO TOTAL ASSETS: DEBT TO TOTAL EQUITY: TIMES INTEREST EARNED: ACCOUNTS RECEIVABLE TURNOVER: INVENTORY TURNOVER: NET PROFIT ON SALES: GROSS PROFIT MARGIN RETURN ON ASSETS: RETURN ON EQUITY: BOOK VALUE: EARNINGS PER SHARE: PRICE EARNINGS: DIVIDEND RATE/YIELD: DIVIDEND PAYOUT RATIO: 3 year % change 2015 2016 20 40% 25 0 0 3 year % change Copy this spreadsheet into your paper as exhibit 1 40% Instructions This assessment addresses the following course objective(s): Analyze balance sheet equity entries. Throughout this course you have been researching one of the following companies: Target (TGT) Walmart (WMT) Walgreens (WAG) CVS (CVS) Kroger (KR) You have been sharing research you have found in the weekly discussions and compiled a list of resources supporting your research and opinion. In unit 5, you submitted a reference list to support your research into the financial health of your company. In unit 6 you submitted the ratio analysis after compiling three years of data for your company. You are now ready to prepare to complete a financial analysis on the company that you have been following this term. In this assignment you will complete a 4-5 page paper discussing the company's financial health through a discussion of the ratio calculations. The ratios should be the basis for your discussion looking at the trends determining which areas are improving and eroding. Be sure to make a final conclusion as to your opinion of the overall health of your company. Your paper should be supported with at least four outside references beyond the textbook and Hoovers. Paper Outline 1. Introduction 2. Provide background about the company 3. Discussion the company's liquidity ratios 4. Discuss the company management ratios 5. Discuss the company's debt ratios 6. Discuss the company's profitability ratios 7. Discuss the company's market ratios 8. Discuss the overall assessment of the financial health of the company 9. Conclusion AC216 Final Project - Financial Analysis Report Instructions For the final of this course, you will analyze the accounting information of a company of your choice. Activities throughout this course will guide you to accurately describe the health of the company and support your conclusions with industry reports. This assessment addresses the following course objective(s): Analyze balance sheet equity entries. Throughout this course, you will be discussing financial reports from a company you choose from the following list. Target (TGT) Walmart (WMT) Walgreens (WAG) CVS (CVS) Kroger (KR) You can find information about your company by accessing the Hoover Library Database. Follow these instructions [PDF] to find the financial reports for your chosen company. Suggested Timeline Unit 1 - Chose your company. In the Unit 1 Discussion you will share with the class which of these companies you will analyze in this course Unit 2 - Complete the financial tab in the excel spreadsheet. Start collecting the financial information. You will find an open discussion board where you can post questions you may have about filling out the spreadsheet or finding appropriate information. Please use this as a collaborative forum. Feel free to ask questions. I am sure other students in the class have the same question or may have an answer. Your professor will be monitoring this forum. Unit 3 - Research your company, finding articles on the company's financial performance. Use the course discussions as a guide as your research and collect information about your company. Keep a list of all your references as you go. Unit 4 - Research your company, finding articles on the company's financial performance. Unit 5 - Research your company, finding articles on the company's financial performance. In this unit you will submit the resources you have been using in the discussion and to help you complete your analysis report. Unit 6 - Complete the ratio calculations in the excel spreadsheet template provided. In this unit you will submit your ratio calculations spreadsheet. Unit 7 - Write the paper assessing the company's financial health and submit the project. There are three deliverables for this project 1. Reference List - Unit 5 2. Ratio Calculations - Unit 6 3. Financial Analysis Report - Unit 7 Reference List The weekly discussions will guide you on your research of your chosen company. The Reference page must be properly formatted in APA style. You may find the following resources helpful in formatting your reference page. Reference List: Basic Rules (Purdue Online Writing Lab, n.d.) Purdue OWL: APA Formatting: Reference List Basics (OWLPurdue, 2012) Your reference page should contain at least 4 references beyond the textbook and Hoover. Ratio Analysis Calculations In unit 6 you will submit the ratio analysis calculations after compiling three years of data for your company in the excel template provided. Financial Analysis Report After completing your research and the ratio analysis calculations, you will be prepared to complete a financial health analysis on the company that you have been following this term. You will complete a 4-5-page paper discussing the company's financial health through a discussion of the ratio calculations. The ratios should be the basis for your evaluation of the company's financial position, note the trends determining which areas are improving and eroding. Be sure to make a final conclusion as to your opinion of the overall health of your company. After completing your discussion of the ratio analysis, briefly discuss if the press reports on your company match your numeric conclusions. Your paper should be supported with at least four outside references beyond the textbook and Hoovers. Paper Outline 1. Introduction 2. Provide background about the company 3. Discussion the company's liquidity ratios 4. Discuss the company management ratios 5. Discuss the company's debt ratios 6. Discuss the company's profitability ratios 7. Discuss the company's market ratios 8. Discuss the overall assessment of the financial health of the company 9. Conclusion (enter the yea Ratio Analysis Company CURRENT RATIO: Current assets Current liabilities Liquidity Ratios Cash + ST investments + receivables Current liabilities DEBT TO TOTAL ASSETS: Total debt Total assets DEBT TO TOTAL EQUITY: Debt ratios Total debt Total equity TIMES INTEREST EARNED: Income before tax and interest Interest charges ACCOUNTS RECEIVABLE TURNOVER: Net credit sales Average net accounts receivable Mangemen ratios INVENTORY TURNOVER: Cost of goods sold Average inventory NET PROFIT ON SALES: Net income Net sales GROSS PROFIT MARGIN Gross profit Net sales Profitabilt RETURN ON ASSETS: Net income + interest Average assets RETURN ON EQUITY: Net income - preferred dividends Average common equity Common equity Common shares BOOK VALUE: EARNINGS PER SHARE: Income available to common Average number of shares PRICE EARNINGS: Market price per share Earnings per share Market rat DIVIDEND RATE/YIELD: Annual cash dividend per share Market price per share DIVIDEND PAYOUT RATIO: Annual cash dividend per share Earnings per share (enter the year of the company's most recent financial report) 2017 2016 I20 ar of the company's most recent financial report) 2017 2016 2015 15 . L 200 25 I Ratio Analysis Company O 2017 20 15 CURRENT RATIO: QUICK RATIO: DEBT TO TOTAL ASSETS: DEBT TO TOTAL EQUITY: TIMES INTEREST EARNED: ACCOUNTS RECEIVABLE TURNOVER: INVENTORY TURNOVER: NET PROFIT ON SALES: GROSS PROFIT MARGIN RETURN ON ASSETS: RETURN ON EQUITY: BOOK VALUE: EARNINGS PER SHARE: PRICE EARNINGS: DIVIDEND RATE/YIELD: DIVIDEND PAYOUT RATIO: 3 year % change 2015 2016 20 40% 25 0 0 3 year % change Copy this spreadsheet into your paper as exhibit 1 40%