help me out please
Part 1 (approximately 2 hours): In this part of the assignment, you will apply the concepts leamed in Chapter 14 using real data pulled from the internet. (Note: Questions 4B, C, D, E, H, I, AND J are similar to what you could expect as an exam problem only you will be given the income statement or balance sheet.) 1. Identify two companies that you want to know more about their financial performance. 2. Go to finance.yahoo.com 3. Type each company's name in the search box, click on "financials" (found in the blue line of choices below the company's current stock price). 4. Complete the following by hand for one company and in Excel for the other company. Hint: Format both company's statements as if you were presenting the information to your boss and knew the presentation was important to your receiving a promotion and pay raise! A. Pull up the income statements for both companies B. Prepare a HORIZONTAL ANALYSIS of both companies' income statements for the most recent two years. ONLY INCLUDE THE FOLLOWING ACCOUNTS (as named in the finance.yahoo income statements): Total Revenue or Sales Revenue, Cost of Revenue (Cost of Goods Sold), Gross Profit. Operating Expenses, and Operating Income. C. What observations can you make about the two companies based on this analysis? For example, has the Cost of Revenue (Cost of Goods Sold) increased proportionately with sales, or not? D. Compute TREND PERCENTAGES for Total Revenue and Operating Income for a minimum of three years using 2017 as the base year for both companies. Are the companies growing or contracting? Is Operating Income growing/contracting at the same rate as Total Revenue? Do you have any concerns about either company? Why or why not? E. Prepare a COMMON-SIZE INCOME STATEMENTfor one of the two companies. You can do this in either Excel or by hand, depending on your comfort level with Excel. F. What observations can you make from this analysis? G. Pull up the balance sheets for both companies. H. Prepare a COMMON-SIZE BALANCE SHEET for the other company? 1. Calculate WORKING CAPITAL, the CURRENT RATIO, and the ACINTECT DATIA company's current stock price). 4. Complete the following by hand for one company and in Excel for the other company. Hint: Format both company's statements as if you were presenting the information to your boss and knew the presentation was important to your receiving a promotion and pay raise! A. Pull up the income statements for both companies. B. Prepare a HORIZONTAL ANALYSIS of both companies'income statements for the most recent two years. ONLY INCLUDE THE FOLLOWING ACCOUNTS (as named in the finance.yahoo income statements): Total Revenue or Sales Revenue, Cost of Revenue (Cost of Goods Sold), Gross Profit, Operating Expenses, and Operating Income. C. What observations can you make about the two companies based on this analysis? For example, has the Cost of Revenue (Cost of Goods Sold) increased proportionately with sales, or not? D. Compute TREND PERCENTAGES for Total Revenue and Operating Income for a minimum of three years using 2017 as the base year for both companies. Are the companies growing or contracting? Is Operating Income growing/contracting at the same rate as Total Revenue? Do you have any concerns about either company? Why or why not? E. Prepare a COMMON-SIZE INCOME STATEMENT for one of the two companies. You can do this in either Excel or by hand, depending on your comfort level with Excel F. What observations can you make from this analysis? G. Pull up the balance sheets for both companies H. Prepare a COMMON-SIZE BALANCE SHEET for the other company? 1. Calculate WORKING CAPITAL the CURRENT RATIO, and the ACID-TEST RATIO for both companies. If you do not have enough information to complete the acid-test ratio, write the formula for the ratio and tell me specifically what information you were unable to access. 3. Do you have any concerns about the liquidity of either company? Why or why not? Part 2 (45 minutes): Open your textbook and complete the Ethics Challenge in the Building Your Skills section at the end of Chapter 14 The easiest way to navigate to this section if you are using the eBook is to go to the Table 6+ Contents Chapter 14 and scroll down to Building Your Skills If you are using a contracting? Is Operating Income growing/contracting at the same rate as Total Revenue? Do you have any concerns about either company? Why or why not? E. Prepare a COMMON-SIZE INCOME STATEMENT for one of the two companies. You can do this in either Excel or by hand, depending on your comfort level with Excel. F. What observations can you make from this analysis? G. Pull up the balance sheets for both companies. H. Prepare a COMMON-SIZE BALANCE SHEET for the other company? 1. Calculate WORKING CAPITAL, the CURRENT RATIO, and the ACID-TEST RATIO for both companies. If you do not have enough information to complete the acid-test ratio, write the formula for the ratio and tell me specifically what information you were unable to access. J. Do you have any concerns about the liquidity of either company? Why or why not? Part 2 (45 minutes): Open your textbook and complete the Ethics Challenge in the Building Your Skills section at the end of Chapter 14. The easiest way to navigate to this section if you are using the eBook is to go to the Table of Contents/Chapter 14 and scroll down to "Building Your Skills." If you are using a hard copy of the text, it should be on pages 695 and 696. It is the first problem in this section. Complete by hand, Note: Seeing Canvas is new to most of us, I am going to give you two chances to upload this assignment correctly. In the future, you will only have ONE opportunity unless we learn that Canvas works differently than Blackboard did when the same assignment is uploaded more than once. I'll let you know! Assignment #3 Criteria Ratings Pts Attepted all problems in tha 10 to > 9.0 pts Full Marks 9 to > 8.0 pts Professionalism All assignments 8 to >3.0 pts Assignment Incomplete 3 to 1.0 pts Assignment turned in but 1 to 50 pts Assignment not tumed All Part 1 (approximately 2 hours): In this part of the assignment, you will apply the concepts leamed in Chapter 14 using real data pulled from the internet. (Note: Questions 4B, C, D, E, H, I, AND J are similar to what you could expect as an exam problem only you will be given the income statement or balance sheet.) 1. Identify two companies that you want to know more about their financial performance. 2. Go to finance.yahoo.com 3. Type each company's name in the search box, click on "financials" (found in the blue line of choices below the company's current stock price). 4. Complete the following by hand for one company and in Excel for the other company. Hint: Format both company's statements as if you were presenting the information to your boss and knew the presentation was important to your receiving a promotion and pay raise! A. Pull up the income statements for both companies B. Prepare a HORIZONTAL ANALYSIS of both companies' income statements for the most recent two years. ONLY INCLUDE THE FOLLOWING ACCOUNTS (as named in the finance.yahoo income statements): Total Revenue or Sales Revenue, Cost of Revenue (Cost of Goods Sold), Gross Profit. Operating Expenses, and Operating Income. C. What observations can you make about the two companies based on this analysis? For example, has the Cost of Revenue (Cost of Goods Sold) increased proportionately with sales, or not? D. Compute TREND PERCENTAGES for Total Revenue and Operating Income for a minimum of three years using 2017 as the base year for both companies. Are the companies growing or contracting? Is Operating Income growing/contracting at the same rate as Total Revenue? Do you have any concerns about either company? Why or why not? E. Prepare a COMMON-SIZE INCOME STATEMENTfor one of the two companies. You can do this in either Excel or by hand, depending on your comfort level with Excel. F. What observations can you make from this analysis? G. Pull up the balance sheets for both companies. H. Prepare a COMMON-SIZE BALANCE SHEET for the other company? 1. Calculate WORKING CAPITAL, the CURRENT RATIO, and the ACINTECT DATIA company's current stock price). 4. Complete the following by hand for one company and in Excel for the other company. Hint: Format both company's statements as if you were presenting the information to your boss and knew the presentation was important to your receiving a promotion and pay raise! A. Pull up the income statements for both companies. B. Prepare a HORIZONTAL ANALYSIS of both companies'income statements for the most recent two years. ONLY INCLUDE THE FOLLOWING ACCOUNTS (as named in the finance.yahoo income statements): Total Revenue or Sales Revenue, Cost of Revenue (Cost of Goods Sold), Gross Profit, Operating Expenses, and Operating Income. C. What observations can you make about the two companies based on this analysis? For example, has the Cost of Revenue (Cost of Goods Sold) increased proportionately with sales, or not? D. Compute TREND PERCENTAGES for Total Revenue and Operating Income for a minimum of three years using 2017 as the base year for both companies. Are the companies growing or contracting? Is Operating Income growing/contracting at the same rate as Total Revenue? Do you have any concerns about either company? Why or why not? E. Prepare a COMMON-SIZE INCOME STATEMENT for one of the two companies. You can do this in either Excel or by hand, depending on your comfort level with Excel F. What observations can you make from this analysis? G. Pull up the balance sheets for both companies H. Prepare a COMMON-SIZE BALANCE SHEET for the other company? 1. Calculate WORKING CAPITAL the CURRENT RATIO, and the ACID-TEST RATIO for both companies. If you do not have enough information to complete the acid-test ratio, write the formula for the ratio and tell me specifically what information you were unable to access. 3. Do you have any concerns about the liquidity of either company? Why or why not? Part 2 (45 minutes): Open your textbook and complete the Ethics Challenge in the Building Your Skills section at the end of Chapter 14 The easiest way to navigate to this section if you are using the eBook is to go to the Table 6+ Contents Chapter 14 and scroll down to Building Your Skills If you are using a contracting? Is Operating Income growing/contracting at the same rate as Total Revenue? Do you have any concerns about either company? Why or why not? E. Prepare a COMMON-SIZE INCOME STATEMENT for one of the two companies. You can do this in either Excel or by hand, depending on your comfort level with Excel. F. What observations can you make from this analysis? G. Pull up the balance sheets for both companies. H. Prepare a COMMON-SIZE BALANCE SHEET for the other company? 1. Calculate WORKING CAPITAL, the CURRENT RATIO, and the ACID-TEST RATIO for both companies. If you do not have enough information to complete the acid-test ratio, write the formula for the ratio and tell me specifically what information you were unable to access. J. Do you have any concerns about the liquidity of either company? Why or why not? Part 2 (45 minutes): Open your textbook and complete the Ethics Challenge in the Building Your Skills section at the end of Chapter 14. The easiest way to navigate to this section if you are using the eBook is to go to the Table of Contents/Chapter 14 and scroll down to "Building Your Skills." If you are using a hard copy of the text, it should be on pages 695 and 696. It is the first problem in this section. Complete by hand, Note: Seeing Canvas is new to most of us, I am going to give you two chances to upload this assignment correctly. In the future, you will only have ONE opportunity unless we learn that Canvas works differently than Blackboard did when the same assignment is uploaded more than once. I'll let you know! Assignment #3 Criteria Ratings Pts Attepted all problems in tha 10 to > 9.0 pts Full Marks 9 to > 8.0 pts Professionalism All assignments 8 to >3.0 pts Assignment Incomplete 3 to 1.0 pts Assignment turned in but 1 to 50 pts Assignment not tumed All
