13. Sway's Back Store is considering a project which will require the purchase of $1.5 million in new equipment. The equipment will be depreciated straight-line to a zero book value over the 5-year life of the project. Annual sales from this project are estimated at $950,000. The variable cost is 40% of the annual sales and there is an annual fixed cost of $100,000. Sway's Back Store will sell the equipment at the end of the project for 20% of its original cost. New net working capital equal to 10% of sales will be required to support the project. All of the new net working capital will be recouped at the end of the project. The firm desires a minimal 12% rate of return on this project. The tax rate is 40%. What is the projects NPV? You can use the following tables to construct the cash flows necessary for the NPV calculation. Please calculate the projects NPV when sales drop by10%. And also the sensitivity of NPV in response to percentage change of sales. Create a sensitivity diagram with percentage change of variable as the horizontal axis and percentage change of NPV as the vertical axis.

Please answer like you would in the textbox as shown.

13. Sway's Back Store is considering a project which will require the purchase of $1.5 million in new equipment. The equipment will be depreciated straight-line to a zero book value over the S-year life of the project. Annual sales from this project are estimated at $950,000. The variable cost is 40% of the annual sales and there is an annual fixed cost of $100,000. Sway's Back Store will sell the equipment at the end of the project for 20% of its original cost. New net working capital equal to 10% of sales will be required to support the project . All of the new net working capital will be recouped at the end of the project. The firm desires a minimal 12% rate of retum on this project. The tax rate is 40%. What is the project's NPV? You can use the following tables to construct the cash flows necessary for the NPV calculation. (20 points) Please calculate the project's NPV when sales drop by 10%. And also the sensitivity of NPV in response to percentage change of sales. Create a sensitivity diagram with percentage change of variable as the horizontal axis and percentage change of NPV as the vertical axis. (10 points) Year 1 Year 2 Year 3 Year 4 Year 5 Revenues Variable Costs Fixed Costs Depreciation EBIT Tax (40%) Net Income Year o Year 1 Year 2 Year 3 Year 4 Year 5 Capital Expenditure A in NWC Oper CF Salvage CF Free CFs ***Straight-line depreciation expense = (Beginning Value - Ending Value) / life expectancy ***Operating Cash Flow = EBIT - Taxes + Depreciation