50.1K

Verified Solution

Link Copied!

please help. kind of a big question

BO DDBOD engine They she way wird Step 1: Select your companies. Target and Walmart Step 2: Locate and download (optional) your companies' form 10-K. The 10-K is an annual filing required by the Securities and Exchange Commission of all U.S. publicly traded companies Among other thing, the 10-K includes a public company's financial statements under Item 8 in the table of contents. They are available at seo goy. We will have a class session that walls you through locating form 10-K. WARNING: 10-K's may be HUNDREDS of pages long. You will only need to print a few selected pages from each item. Be careful before you hit "Print. Step 3: You will need the income statements and balance sheets for each of your companies for the most recent years available. Enter the income statements and balance sheets for your companies in an Excel spreadsheet. Use a separate worksheet for each company but only one workbook Step 4: Complete the following financial analysis tools with each clearly labeled as noted below in your Bxcel document Perform vertical analysis of each company for both years. The process for doing this will be discussed in clan Performa horizontal analysis of each company for the most recent year. The process for doing this will be discussed in class. Obtain camines per share (LPS)EPS is the amount of set income eamed per share of the company's common stock You will not have to calculate tips fure because they we provided us the end of the company's income statement. Use the figure identified as "Basic EPS" for all operations Culculate the price earnings (PH) ratio for the most recent two year. To do this, go to Google Finance and search for historical stock prices for your company. Use the closing date for the company cawch as December 31, 2020) the closing date is not a day when markets are open, use the first day available before the cloning date. The information on calculating and analyzing the 'El rates on paps 426 mnd 50% of your text. Current ratio - Calculate the current ratio for each company for both years. The current ratio measures a company's liquidity. It is a proportion of current assets to current liabilities. Your book offan information about the current ratio en pape 109 as well as on pape 500. As is shown on page 109, be sure to provide the results of your calculations to two places after the decimal point This is not a percentage Calculate the acid-test ratio for each company for both years. Similar to the current ratio, the acid test ratio also measures a company liquidity. The ratio is discused on page 158 in pour le This is not a percentage and should be expressed two places after the decimal place. On page 159, the answer for the current year for Nike would be 1.80. Calculate the debt ratio for each company for each year. The debt ratio reflects a company's ability to meet its long-term obligation Details about this ratio are provided on Pace 1 NOTE offers information about the current ratio on page 109 as well as on page 500. Asis shown on page 109, be sure to provide the result of your calculations to two places her the decimal point This is not a percentage Calculate the acid-test ratio for each company for both years. Similar to the current ratio, the acid test ratio also measures a company's liquidity. The ratio is discussed 158 in your text. This is not a percentage and should be expressed two places after the decimal place. On page 159, the answer for the current year for Nike would be 1.80 Calculate the debt ratio for each company for each year. The debt ratio reflects a company's ability to meet its long-term obligation Details about this ratio are provided on Page NOTEL The example shows a remit of 60 for the current year. That figure is really a percentage and should be reported with two place after the decimal point (09.51%). Be sure to report your debt nutio results in this format . Caleutate retum an anet (ROA) for each company for the most recent yet BOA ke mensure of how wella company was dit net to produce profit. This use to discuten Page 18 your text. Again, be sure to report your results to two places after the decimal point. The result of the calculation shown on Page 19 is 18.99% Calculate return on equity (ROE) for each company for the most recent year. ROE in a measure of the company's retum for investors. Retum on (common ockholders) equity is discused on page 504 in your text. This should be presented as a percentage to two decimal places such as 10.25% Step 5: Prepare your financial report in Word First, introduce your companies and their industry or sector Explain why you chose the companies that you did. In the body of your paper, one by one, discuss each item, what it means, and describe how each of your companies performed regarding that measure. The financial items may be discussed in the same order as listed. Reference cach companies actual ratio or analysis tool result. For the vertical and horizontal analyses, discuss the items you believe to be significant Doce all right calculations and financial measures and the companies' results have been discussed, determine which company would be a better investment and why wing the results of your analysis. Your reasoning does not have to be limited to the financial information discussed in your report. You may address other financial or non-financial factors. However, you must include discussion of the cight measures Format of your report: Provide a cover page for your roport that includes your name and the names of the companita you chose to analyze. Prepare the body of your report in Times New Roma 14 font (like this document). Use single-spacing with one-inch margins. You may use any font you wish to prepare the table within your report. When completed, your cover pupe and report must be in one Word file References I expect you to locate the information in cach company's OK, so "Google" answers are not acceptable and will result in a zero grade. In the introduction to your report, indicate the URL for each 10-K you utilid. Submit your report as an Excel document and a Word document in Black Board BO DDBOD engine They she way wird Step 1: Select your companies. Target and Walmart Step 2: Locate and download (optional) your companies' form 10-K. The 10-K is an annual filing required by the Securities and Exchange Commission of all U.S. publicly traded companies Among other thing, the 10-K includes a public company's financial statements under Item 8 in the table of contents. They are available at seo goy. We will have a class session that walls you through locating form 10-K. WARNING: 10-K's may be HUNDREDS of pages long. You will only need to print a few selected pages from each item. Be careful before you hit "Print. Step 3: You will need the income statements and balance sheets for each of your companies for the most recent years available. Enter the income statements and balance sheets for your companies in an Excel spreadsheet. Use a separate worksheet for each company but only one workbook Step 4: Complete the following financial analysis tools with each clearly labeled as noted below in your Bxcel document Perform vertical analysis of each company for both years. The process for doing this will be discussed in clan Performa horizontal analysis of each company for the most recent year. The process for doing this will be discussed in class. Obtain camines per share (LPS)EPS is the amount of set income eamed per share of the company's common stock You will not have to calculate tips fure because they we provided us the end of the company's income statement. Use the figure identified as "Basic EPS" for all operations Culculate the price earnings (PH) ratio for the most recent two year. To do this, go to Google Finance and search for historical stock prices for your company. Use the closing date for the company cawch as December 31, 2020) the closing date is not a day when markets are open, use the first day available before the cloning date. The information on calculating and analyzing the 'El rates on paps 426 mnd 50% of your text. Current ratio - Calculate the current ratio for each company for both years. The current ratio measures a company's liquidity. It is a proportion of current assets to current liabilities. Your book offan information about the current ratio en pape 109 as well as on pape 500. As is shown on page 109, be sure to provide the results of your calculations to two places after the decimal point This is not a percentage Calculate the acid-test ratio for each company for both years. Similar to the current ratio, the acid test ratio also measures a company liquidity. The ratio is discused on page 158 in pour le This is not a percentage and should be expressed two places after the decimal place. On page 159, the answer for the current year for Nike would be 1.80. Calculate the debt ratio for each company for each year. The debt ratio reflects a company's ability to meet its long-term obligation Details about this ratio are provided on Pace 1 NOTE offers information about the current ratio on page 109 as well as on page 500. Asis shown on page 109, be sure to provide the result of your calculations to two places her the decimal point This is not a percentage Calculate the acid-test ratio for each company for both years. Similar to the current ratio, the acid test ratio also measures a company's liquidity. The ratio is discussed 158 in your text. This is not a percentage and should be expressed two places after the decimal place. On page 159, the answer for the current year for Nike would be 1.80 Calculate the debt ratio for each company for each year. The debt ratio reflects a company's ability to meet its long-term obligation Details about this ratio are provided on Page NOTEL The example shows a remit of 60 for the current year. That figure is really a percentage and should be reported with two place after the decimal point (09.51%). Be sure to report your debt nutio results in this format . Caleutate retum an anet (ROA) for each company for the most recent yet BOA ke mensure of how wella company was dit net to produce profit. This use to discuten Page 18 your text. Again, be sure to report your results to two places after the decimal point. The result of the calculation shown on Page 19 is 18.99% Calculate return on equity (ROE) for each company for the most recent year. ROE in a measure of the company's retum for investors. Retum on (common ockholders) equity is discused on page 504 in your text. This should be presented as a percentage to two decimal places such as 10.25% Step 5: Prepare your financial report in Word First, introduce your companies and their industry or sector Explain why you chose the companies that you did. In the body of your paper, one by one, discuss each item, what it means, and describe how each of your companies performed regarding that measure. The financial items may be discussed in the same order as listed. Reference cach companies actual ratio or analysis tool result. For the vertical and horizontal analyses, discuss the items you believe to be significant Doce all right calculations and financial measures and the companies' results have been discussed, determine which company would be a better investment and why wing the results of your analysis. Your reasoning does not have to be limited to the financial information discussed in your report. You may address other financial or non-financial factors. However, you must include discussion of the cight measures Format of your report: Provide a cover page for your roport that includes your name and the names of the companita you chose to analyze. Prepare the body of your report in Times New Roma 14 font (like this document). Use single-spacing with one-inch margins. You may use any font you wish to prepare the table within your report. When completed, your cover pupe and report must be in one Word file References I expect you to locate the information in cach company's OK, so "Google" answers are not acceptable and will result in a zero grade. In the introduction to your report, indicate the URL for each 10-K you utilid. Submit your report as an Excel document and a Word document in Black Board

Answer & Explanation Solved by verified expert

See Answer