1.The life of the 2013 Sneaker project was expected to be six years. Assume the analysis took place at the end of 2012. 2.The suggested retail price of the shoe was $190. Gross margins for high-end athletic footwear averaged about 40% at the retail level, meaning each pair sold would net Bew Nalance $115. 3.The global athletic footwear market in 2011 totaled 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. Based on market research and analysis of other recent athlete endorsements, the Bew Nalance marketing division estimated the following sales volumes for 2013 Sneaker: Year 2013 2014 2015 2016 2017 2018 Pairs sold (millions) 1.2 1.6 1.4 2.4 1.8 0.9 The 2016 number assumed Jirani Kames participated in the 2016 games in Rio de Janeiro, Brazil, and won at least one medal. 4. For the first two years, the introduction of 2013 Sneaker would reduce sales of existing Bew Nalance shoes as follows: Lost sales: 2013: $35 million 2014: $15 million Assume the lost revenue had the same margins as 2013 Sneaker. 5.In order to produce the shoe, the firm needed to build a factory in Vietnam. This required an immediate outlay of $150 million, to be depreciated on a 39-year MACRS basis. Depreciation percentages for the first six years respectively were: 2.6%, 5%, 4.7%, 4.5%, 4.3%, and 4.0%. The firms 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 2013 Sneaker, two of the firms 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 projects variable costs; and accounts payable would be 20% of the projects 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. Jirani Kames would be paid $2 million per year for his endorsement of 2013 Sneaker, with an additional $1 million Olympic bonus in 2016. 11. Other advertising and promotion costs were estimated as follows: Year 2013 2014 2015 2016 2017 2018 A&P Expense (millions) $25 $15 $10 $30 $25 $15 12. Bew Nalance had spent $2 million in research and development on 2013 Sneaker. 13. The 2013 Sneaker 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 Bew Nalance discount rate for new projects such as this was 11%. 14. Bew Nalances effective tax rate was 40%. Rodriguez was worried about the marketing approach for 2013 Sneaker targeting 12-to 18-year-old males. Recent market data showed the average age of athletic footwear purchasers to be just over 27 years, up from 24 three years earlier. This trend was expected to continue as the population aged. Success would depend on an effective marketing and advertising campaign which targeted not only the younger consumer, but which reached the ultimate purchaser who was more likely to be a parent. Address the following issues: 1. Produce a projected capital budgeting cash flow statement for the 2013 Sneaker project by answering the following: a. What is the projects initial (year 0) investment outlay? b. What are the projects annual (years 2013-2018) net operating cash flows? c. What is the projects terminal (2018) non-operating net cash flow? d. Does 2013 Sneaker appear viable from a quantitative standpoint? To answer this question, estimate the projects payback, net present value, and internal rate of return