Question

McGilla Golf has decided to sell a new line of golf clubs. The clubs will sell for $935 per set and have a variable cost of $463 per set. The company has spent $280,000 for a marketing study that determined the company will sell 88,000 sets per year for seven years. The marketing study also determined that the company will lose sales of 9.000 sets per year of its high-priced clubs. The high-priced clubs sell at $1,365 and have variable costs of $685. The company will also increase sales of its cheap clubs by 11,600 sets per year. The cheap clubs sell for $372 and have variable costs of $165 per set. The fixed costs each year will be $15,150,000. The company has also spent $2,300,000 on research and development for the new clubs. The plant and equipment required will cost $52,500,000 and will be depreciated on a straight-line basis. The new clubs will also require an increase in net working capital of $4,025,000 that will be returned at the end of the project. The tax rate is 23 percent, and the cost of capital is 11 percent. Calculate the payback period, the NPV, and the IRR. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Enter your IRR answer as a percent.) years Payback period Net present value Internal rate of relurn

Answer 1

111 x fix =IRR(L2:L9) D E F G Depreciati on PBT Tax@23% PAT A B C Relevant 1 Year contribution Fixed costs 2 0 3 1 37,817,200 15,150,000 4 2 37,817,200 15,150,000 3 37,817,200 15,150,000 6 4 37,817,200 15,150,000 7 5 37,817,200 15,150,000 8 6 37,817,200 15,150,000 9 7 37,817,200 15,150,000 10 7,500,000 7,500,000 7,500,000 7,500,000 7,500,000 7,500,000 7,500,000 5 15,167,200 15,167,200 15,167,200 15,167,200 15,167,200 15,167,200 15,167,200 3,488,456 3,488,456 3,488,456 3,488,456 3,488,456 3,488,456 3,488,456 H I J K L M N O Depreciatio Operating Total cash Cumulative cash flows NWC Investment flows PVIF@11% Present value cash flows (4,025,000) (52,500,000)| (56,525,000) 1.000 $ (56,525,000.00) (56,525,000) 7,500,000 19,178,744 19,178,744 0.901 $ 17,278,147.75 (37,346,256) 7,500,000 19,178,744 19,178,744 0.812 $ 15,565,898.87 (18,167,512) 7,500,000 19,178,744 19,178,744 0.731 $ 14,023,332.32 1,011,232 7,500,000 19,178,744 19,178,744 0.659 $ 12,633,632.72 20,189,976 7,500,000 19,178,744 19,178,744 0.593 $ 11,381,651.10 39,368,720 7,500,000 19,178,744 19,178,744 0.535 $ 10,253,739.73 58,547,464 7,500,000 19,178,744 4,025,000 23,203,744 0.482 $ 11,176,278.46 81,751,208 11,678,744 11,678,744 11,678,744 11,678,744 11,678,744 11,678,744 11,678,744 IRR 28.38% NPV $ 35,787,680.94 Payback period 13 14 15 Contribution from sale of golf club sales 16 Less: Contribution from loss sale of high priced clubs 17 Add: Contribution from increased sale of cheap clubs 18 19 Relevant contribution $ 41,536,000 $ 6,120,000 $ 2,401,200 =88000*1935-463) =9000*(1365-685) =11600* (372-165) 2.947 =2+18167512/19178744 37,817,200

*Please rate thumbs up