You are hired by Advance Auto Parts to see if their new project is worthwhile or not.

Advance Auto Parts is considering opening 500 new stores that would represent an increase in sales of 8% (for the first year) over their last year-end figures. After the 1^st year revenues are expected to grow at a 5% per year.

They would need to invest on average $150,000 per store. The investment would depreciate in 7 years (use MACRS schedule Table 9-7). After the 5 years, only part of their investment can be sold for $ 10,000,000. Net Working Capital to start will be 100,000 per store and then it will be 10% of the increase of Sales of all 500 new stores.

Estimate the Revenues for the stand-alone project (not for the whole company) for the next 5 years. Use the last year end information that you find to calculate the first year revenue.

Estimate the costs of your project. A good proxy would be to use the same proportion of Cost of Goods Sold and Selling General and Administrative expenses to Sales of the Company as a whole. (look at the last 10-K report and calculate the common size income statement to look at the costs as a % of sales. Apply the same % to calculate the costs of your project). Use year end numbers.

Calculate the EBIT for the next 5 years for the project.

Calculate the companys Marginal Tax rate (Use table 2.4 from your book as reference) and use this tax rate to calculate the tax effect on your operating cash flows.

Calculate operating and the total cash flows.

Using the WACC calculated in Part 1, calculate the projects NPV and IRR. Is this something that should be perused? What is the relationship between IRR and WACC? What do these numbers tell you

What happens if you missed your cost estimate by +10% or -10% of your initial estimate? What is the NPV and IRR of your project.

You are hired by Advance Auto Parts to see if their new project is worthwhile or not. Advance Auto Parts is considering opening 500 new stores that would represent an increase in sales of 8% (for the first year) over their last year-end figures. After the 1^st year revenues are expected to grow at a 5% per year. They would need to invest on average $150,000 per store. The investment would depreciate in 7 years (use MACRS schedule Table 9-7). After the 5 years, only part of their investment can be sold for $10,000,000. Net Working Capital to start will be 100,000 per store and then it will be a 10% of the increase of Sales of all 500 new stores. a. Estimate the Revenues for the stand-alone (only the protect and not for the whole company) for the next 5 years. After the 1^st year revenues are expected to grow at a 5%/year. b. Estimate the costs of your project. A good proxy would be to use the same proportion of Total Costs to Sales of the Company as a whole. (look at the last 10-K report and calculate the common size income statement to look at the costs as a % of sales Apply the same % to calculate the costs of your project). c. Calculate the EBIT for the next 5 years for the project. d. Calculate the company's Marginal Tax rate (Use table 2.4 from your book as reference) and use this tax rate to calculate the tax effect on your operating cash flows. e. Calculate operating and the total cash flows. f. Using the WACC calculated in Part 1, calculate the project's NPV and IRR. Is this something that should be perused? What is the relationship between IRR and WACC? What do these numbers tell you. g. What happens if you missed your cost estimate by + 10% or -10% of your initial estimate? What is the NPV and IRR of your project. You are hired by Advance Auto Parts to see if their new project is worthwhile or not. Advance Auto Parts is considering opening 500 new stores that would represent an increase in sales of 8% (for the first year) over their last year-end figures. After the 1^st year revenues are expected to grow at a 5% per year. They would need to invest on average $150,000 per store. The investment would depreciate in 7 years (use MACRS schedule Table 9-7). After the 5 years, only part of their investment can be sold for $10,000,000. Net Working Capital to start will be 100,000 per store and then it will be a 10% of the increase of Sales of all 500 new stores. a. Estimate the Revenues for the stand-alone (only the protect and not for the whole company) for the next 5 years. After the 1^st year revenues are expected to grow at a 5%/year. b. Estimate the costs of your project. A good proxy would be to use the same proportion of Total Costs to Sales of the Company as a whole. (look at the last 10-K report and calculate the common size income statement to look at the costs as a % of sales Apply the same % to calculate the costs of your project). c. Calculate the EBIT for the next 5 years for the project. d. Calculate the company's Marginal Tax rate (Use table 2.4 from your book as reference) and use this tax rate to calculate the tax effect on your operating cash flows. e. Calculate operating and the total cash flows. f. Using the WACC calculated in Part 1, calculate the project's NPV and IRR. Is this something that should be perused? What is the relationship between IRR and WACC? What do these numbers tell you. g. What happens if you missed your cost estimate by + 10% or -10% of your initial estimate? What is the NPV and IRR of your project