NPV and Payback Period Assignment | Homework For You
This case contains the following information regarding the XYZ FASHION project :
1. The life of the XYZ FASHION project was expected to be six years. Assume the analysis took place at the end of 2012.
2. The suggested retail price of the dress was $190. Gross margins for high-end fashion averaged about 40% at the retail level, meaning each dress sold would net XYZ $115.
3. The global fashion market in 2011 totalled approximately $74.5 billion and was expected to grow at a CAGR of 1.8% from 2011 to 2018, reaching $84.4 billion by 2018.3 Based on market research and analysis of other recent endorsements, the XYZ marketing division estimated the following sales volumes for XYZ 2013:
Year 2013 2014 2015 2016 2017 2018
Dresses sold (mio)1.2 1.6 1.4 2.4 1.8 0.9
The 2016 number assumed an influencer participated in the next ten fashion shows.
4. For the first two years, the introduction of XYZ FASHION would reduce sales of existing XYZ dresses as follows:
Lost sales: 2013: $35 million 2014: $15 million Assume the lost revenue had the same margins as XYZ 2013.
5. In order to produce the dress, the firm needed to build a factory in Indonesia. This required an immediate outlay of $150 million, to be depreciated on a 39-year MACRS5 basis. Depreciation percentages for the first six years respectively were: 2.6%, 5%, 4.7%, 4.5%, 4.3%, and 4.0%. The firm’s analysts estimated the building would be sold for $102 million at project termination. This “salvage value” has not been taken into consideration when computing annual depreciation charges.
6. The company must immediately purchase equipment costing $15 million. Freight and installation of the equipment would cost $5 million. The cost of equipment and freight/installation was to be depreciated on a five-year MACRS basis. Depreciation percentages for the six years respectively were: 20%, 32%, 19%, 12%, 11%, and 6%. It was believed the equipment could be sold for $3 million upon project termination.
7. In order to manufacture XYZ FASHION, two of the firm’s working capital accounts were expected to increase immediately. Approximately $15 million of inventory would be needed quickly to fill the supply chain, and accounts payable were expected to increase by $5 million. By the end of 2013, the accounts receivable balance would be 8% of project revenue; the inventory balance would be 25% of the project’s variable costs; and accounts payable would be 20% of the project’s variable costs. All working capital would be recovered at the end of the project by the end of the sixth year.
8. Variable costs were expected to be 55% of revenue.
9. Selling, general, and administrative expenses were expected to be $7 million per year.
10. An influencer would be paid $2 million per year for his endorsement of XYZ, with an additional $1 million bonus in 2016.
11. Other advertising and promotion costs were estimated as follows:
Year 2013 2014 2015 2016 2017 2018
A&P Expense $25 mio $15 $10 $30 $25 $15
12. XYZ had already spent $2 million in research and development on the project.
13. The XYZ FASHION project was to be financed using a combination of equity and debt. The interest costs on the debt were expected to be approximately $1.2 million per year. The XYZ discount rate for new projects such as this was 11%.
14. XYZ’s effective tax rate was 40%.
Evaluate the project (including calculations of NPV and payback period) and advice. Get Finance homework help today
