W & T Racket designs is the leading racquet company. They are known for their innovation of new technology for racquet sports. W & T is planning on implementing a new racquet into production to replace their old tour model racquet. The old model was very popular with most customers, but W & T wants to implement new technology to improve this model. The company tries to produce a new racquet every 3-8 years to try and lead industry standards. When a new racquet design is introduced, the company must invest in a new mold which includes updating the exisiting machinery.

The company has invested roughly $1 million into research and development of the new technology. The new technology implmented will be called flex-braid. Flex-Braid uses a combination of graphite, carbon, and other composite woven together to form the frame of the racquet. W & T expects to flex-braid to give the racquet more rigidity and also increases feel and control, which is what most of their clientele want.

The mold for the old racquet was produced 3 years ago at a cost of $150,000. Shipping on the old mold was $5,000. In addition, W&T incurred a set-up fee of $20,000. If the old raquet is not replaced, management estimates variable costs of $55 per racquet, fixed costs of $50,000 annually, and production capacity of 12,000 racquets annually over the the next 5 years. In addition, W&T currently has an offer of $20,000 for the old mold. If not replaced, it is estimated that the old mold will only sell for $12,000 5 years from today. For this reason, the old mold is being depreciated on a straight-line basis to a book value of $12,000 over 8 years. THe companys marginal tax rate is 35%, and its cost of capital 15%. This project is eqaually as risky as a typical company project. Therefore, the required return on this project is equal to the company's cost of capital.

The question that has risen us what type of mold should be used to produce the new raxquet? Due to the racquets ,aterial, the old mold will not be suffecient. Due to the differing qualities in the potential new molds, the revenues, expenses, initial investments, and future market valuer of the new molds can vary tremendssly. W&T has serveral options for the new mold.

One option that W & T can use is:

The cost of this mold will be $496,996. Due to the distance from the factory, shipping on this mold will be $8,821, and installation will be $31,348. It is estimated that variable production costs on this new mold will be $55 per racquet, fixed cost of $62,363 annually, and a production capacity of 12,234 racquets annually over the next 5 years. If this mold is selected, the racquet is expected to sell for $134. Sales on W & T's existing racquets are excpected to fall by $5,000 annually over the next 5 years with the introduction of this top notch racquet. The accounting department has informed you that this mold will depreciate using a 5-year MACRS depreciation schedule. It is expected that this mold will be sold at the end of 5 years for $32,848. In addition, if this mold is selected the level of inventory on hand is expected to rise by $7,442, the level of supplies on hand is expected to decrease by $840, and $1,900 of the inventory can be financed through the supplier with an increase in accounts payable.

1. Calculate the estimated Net Initial Investment and estimated incremental cash flows for the next 5 years if the existing mold is replaced with this new mold.

2. Calculate NPV, IRR, payback, discounted payback, and profitability index for your project.

AutoSave OFF HES 5 = Home Insert Draw Page Layout Formulas Data Review View Tell me Share o Comments Calibri (Body) Insert v - AP v 11 ab General = = = E ru Ou 5 Delete Paste .00 B I I U V V $ %, E E Ideas Conditional Format Cell Formatting as Table Styles # Sort & Filter Sensitivity Format Find & Select L18 X fx D E G H K L M N Do not insert, delete, move, merge or name any rows, columns, or range. Do all of your work ONLY by using formulas in the beige cells Do no work outside of those ranges, except to enter input values in the yellow cells Program each cell to show the correct sign based on the cash flow impact of the number. All subtotals MUST be a SUM. Write your formulas so that they will work for ANY numbers entered in the yellow cells. Accept/Reject should be programmed to show exactly the word Accept or Reject reflecting your decision on this project. Payback & Discounted Payback formulas do not need to work for any project, just for your project and any other that would payback in that same year. Payback & Discounted Payback should NOT be text, unless it does not payback in which case the text should read "NEVER". MACRS RATES Previous Years Acc. Depr Year 1 Year 2 Year 3 Year: Year 5 A 1 Mold 2 Original Cost of Old Asset 3 Cost of New Asset 4 Market Value New Asset Year 5 5 Market Value Old Asset Time 0 6 Market/Salvage Value Old Asset Year 5 7 Current Age of Old Equipment 8 Depreciable Life of Old Equipment 9 9 Increase Decrease) in Current Assets 10 Increase Decrease) in Current Liabilities 11 Increase (Decrease) in Revenue 12 Increase Decrease) in Expenses 13 Marginal Tax Rate 14 Required Return 15 Depreciation 16 Depreciation Old Equipment 17 Book Value Old 18 Depreciation New Equipment 19 Book Value New 20 Year 21 22 23 24 25 26 27 28 29 ATSV: Sale of Old Asset 30 Cost of New Asset 31 Increase in NWC 32 Net Initial Investment 33 [1 0 2 3 4 5 Formula Revenue Expenses Depreciation EBIT Taxes Net Income Depreciation OCF ATSV: Last Sale of Old Asset ATSV: Sale of New Asset NWC Reversal CFFA Accept/Reject? NPV IRR Profitability Index Payback Discounted Payback 34 35 36 37 38 39 + Ready 3 + 85% AutoSave OFF HES 5 = Home Insert Draw Page Layout Formulas Data Review View Tell me Share o Comments Calibri (Body) Insert v - AP v 11 ab General = = = E ru Ou 5 Delete Paste .00 B I I U V V $ %, E E Ideas Conditional Format Cell Formatting as Table Styles # Sort & Filter Sensitivity Format Find & Select L18 X fx D E G H K L M N Do not insert, delete, move, merge or name any rows, columns, or range. Do all of your work ONLY by using formulas in the beige cells Do no work outside of those ranges, except to enter input values in the yellow cells Program each cell to show the correct sign based on the cash flow impact of the number. All subtotals MUST be a SUM. Write your formulas so that they will work for ANY numbers entered in the yellow cells. Accept/Reject should be programmed to show exactly the word Accept or Reject reflecting your decision on this project. Payback & Discounted Payback formulas do not need to work for any project, just for your project and any other that would payback in that same year. Payback & Discounted Payback should NOT be text, unless it does not payback in which case the text should read "NEVER". MACRS RATES Previous Years Acc. Depr Year 1 Year 2 Year 3 Year: Year 5 A 1 Mold 2 Original Cost of Old Asset 3 Cost of New Asset 4 Market Value New Asset Year 5 5 Market Value Old Asset Time 0 6 Market/Salvage Value Old Asset Year 5 7 Current Age of Old Equipment 8 Depreciable Life of Old Equipment 9 9 Increase Decrease) in Current Assets 10 Increase Decrease) in Current Liabilities 11 Increase (Decrease) in Revenue 12 Increase Decrease) in Expenses 13 Marginal Tax Rate 14 Required Return 15 Depreciation 16 Depreciation Old Equipment 17 Book Value Old 18 Depreciation New Equipment 19 Book Value New 20 Year 21 22 23 24 25 26 27 28 29 ATSV: Sale of Old Asset 30 Cost of New Asset 31 Increase in NWC 32 Net Initial Investment 33 [1 0 2 3 4 5 Formula Revenue Expenses Depreciation EBIT Taxes Net Income Depreciation OCF ATSV: Last Sale of Old Asset ATSV: Sale of New Asset NWC Reversal CFFA Accept/Reject? NPV IRR Profitability Index Payback Discounted Payback 34 35 36 37 38 39 + Ready 3 + 85%