60.1K

Verified Solution

Link Copied!

Step 1: Select your companie. 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 things, the 10-K includes a public company's financial statements under Item 8 in the table of contents. They are available at sec.gov. We will have a class session that walks 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 Bacel document, Perform vertical analysis of each company for both years. The process for doing this will be discussed in class Perform a horizontal analysis of each company for the most recent year. The procen for doing this will be discussed in clan. Obtain camines per share (LPS) EPS is the amount of net income earned per share of the company's common work. You will not have to calculato lips are because they we provided at the end of the company's income statement, Use the figure identified as "Basic TPS" for all operation Calculate the price caming (PE) ratio for the most recent two year. To do this, po to Google Finance and search for historical stock prices for your company. Une the closing date for the company auch an December 31, 2020) the closing date is not a day when markets are open, use the first day available before the closing date. The information on calculating and analyzing the Pirates on page 426 and 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 sets to current liabilities. Your book offer information about the current ratio on page 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 discussed on page 158 in your en 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 62 NOTE 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 Step 1: Select your companie. 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 things, the 10-K includes a public company's financial statements under Item 8 in the table of contents. They are available at sec.gov. We will have a class session that walks 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 Bacel document, Perform vertical analysis of each company for both years. The process for doing this will be discussed in class Perform a horizontal analysis of each company for the most recent year. The procen for doing this will be discussed in clan. Obtain camines per share (LPS) EPS is the amount of net income earned per share of the company's common work. You will not have to calculato lips are because they we provided at the end of the company's income statement, Use the figure identified as "Basic TPS" for all operation Calculate the price caming (PE) ratio for the most recent two year. To do this, po to Google Finance and search for historical stock prices for your company. Une the closing date for the company auch an December 31, 2020) the closing date is not a day when markets are open, use the first day available before the closing date. The information on calculating and analyzing the Pirates on page 426 and 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 sets to current liabilities. Your book offer information about the current ratio on page 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 discussed on page 158 in your en 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 62 NOTE 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

Answer & Explanation Solved by verified expert

See Answer