Question: Case Project 2:For this project, you will examine Advance Auto Parts. Your assignment is to provide a brief analysis on your company. In your analysis,
Case Project 2:For this project, you will examine Advance Auto Parts. Your assignment is to provide a brief analysis on your company. In your analysis, I want you to get your information directly from the source, which is the Electronic Data Gathering, Analysis, and Retrieval (EDGAR) database from the Securities and Exchange Commission (SEC). You will need to pull your data directly from the firms most recent year-end report, which is called the 10-K. You will analyze your firm by answering the following questions: 1) When does the firms fiscal year end? Does your firms method of selecting an end to its fiscal year present a situation where fiscal years can have unequal lengths (i.e.52 weeks some years and 53 weeks in others)? Without actually performing the adjustments, describe how you would adjust a 53-week income statement to make it comparable to a 52-week income statement (6 points).[Learning Objectives 1-3; 1-8; 4-3]2) Identify a fiscal year with 53 weeks. Convert the 53-week income statement to a 52-week income statement using the method described in the previous question (8 points).[Learning Objectives 1-3; 1-8; 4-3]3) Compute the firms return on equity and perform a full DuPont analysis, with profit margin, asset turnover, and leverage for the last two fiscal years. Next, compute the restated return on equity, profit margin, total asset turnover, and leverage values by adjusting these figures for treasury stock for the last two years. If the last two years includes years with a 53-week fiscal year, be sure to include the adjusted income statement numbers computed from Step 2(9 points).[Learning Objectives 1-3; 1-5; 1-8; 2-1; 2-2; 3-1; 3-2; 4-3]4) Locate Exhibit 4.4 from Module 4 of the text and compute the following ratios for your firms most recently-completed fiscal year: Debt / EBITDA; EBITDA / Interest Expense; EBITDA Margin; Operating Margin; and EBITDA / Average Assets. Note that there are some typos in Exhibit 4.4 and EBITA is sometimes incorrectly used instead of EBITDA. As discussed in the Module 4 lecture, operating income is often used instead of EBIT. Therefore, for EBITDA, you can simply take operating income and add depreciation and amortization to get EBITDA. Compare the ratios for your firm to the average ratio values for various credit ratings in Exhibit 4.4. Based on Exhibit 4.4, what credit rating would you expect your firm to have from Moodys (11 points)?[Learning Objectives 1-3; 1-8; 2-1; 2-2; 4-4]5) Advance Auto Parts lists their credit ratings from Moodys and Standard Case Project 2:For this project, you will examine Advance Auto Parts. Your assignment is to provide a brief analysis on your company. In your analysis, I want you to get your information directly from the source, which is the Electronic Data Gathering, Analysis, and Retrieval (EDGAR) database from the Securities and Exchange Commission (SEC). You will need to pull your data directly from the firms most recent year-end report, which is called the 10-K. You will analyze your firm by answering the following questions: 1) When does the firms fiscal year end? Does your firms method of selecting an end to its fiscal year present a situation where fiscal years can have unequal lengths (i.e.52 weeks some years and 53 weeks in others)? Without actually performing the adjustments, describe how you would adjust a 53-week income statement to make it comparable to a 52-week income statement (6 points).[Learning Objectives 1-3; 1-8; 4-3]2) Identify a fiscal year with 53 weeks. Convert the 53-week income statement to a 52-week income statement using the method described in the previous question (8 points).[Learning Objectives 1-3; 1-8; 4-3]3) Compute the firms return on equity and perform a full DuPont analysis, with profit margin, asset turnover, and leverage for the last two fiscal years. Next, compute the restated return on equity, profit margin, total asset turnover, and leverage values by adjusting these figures for treasury stock for the last two years. If the last two years includes years with a 53-week fiscal year, be sure to include the adjusted income statement numbers computed from Step 2(9 points).[Learning Objectives 1-3; 1-5; 1-8; 2-1; 2-2; 3-1; 3-2; 4-3]4) Locate Exhibit 4.4 from Module 4 of the text and compute the following ratios for your firms most recently-completed fiscal year: Debt / EBITDA; EBITDA / Interest Expense; EBITDA Margin; Operating Margin; and EBITDA / Average Assets. Note that there are some typos in Exhibit 4.4 and EBITA is sometimes incorrectly used instead of EBITDA. As discussed in the Module 4 lecture, operating income is often used instead of EBIT. Therefore, for EBITDA, you can simply take operating income and add depreciation and amortization to get EBITDA. Compare the ratios for your firm to the average ratio values for various credit ratings in Exhibit 4.4. Based on Exhibit 4.4, what credit rating would you expect your firm to have from Moodys (11 points)?[Learning Objectives 1-3; 1-8; 2-1; 2-2; 4-4]5) Advance Auto Parts lists their credit ratings from Moodys and Standard
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
