In: Finance
Suppose that Calloway golf would like to capitalize on Phil Michelson winning the Open Championship in 2013 by releasing a new putter. The new product will require new equipment for $411,913.00 that will be depreciated using the 5-year MACRS schedule. The project will run for 2 years with the following forecasted numbers:
Year 1 | Year 2 | |
---|---|---|
Putter price | $62.19 | $62.19 |
Units sold | 18,951.00 | 11,500.00 |
COGS | 41.00% of sales | 41.00% of sales |
Selling and Administrative | 21.00% of sales | 21.00% of sales |
Calloway has a 13.00% cost of capital and a 37.00% tax rate. The
firm expects to sell the equipment after 2 years for a NSV of
$134,289.00.
What is the NPV of the project?
Annual cashflows | ||||||
Year-1 | Year-2 | |||||
Units sold | 18951 | 11500 | ||||
Selling price | 62.19 | 62.19 | ||||
Total Sales | 1178563 | 715185 | ||||
CM ratio (100-41-21) | 38% | 38% | ||||
Total Contribution | 447853.8 | 271770.3 | ||||
Less: Dep | 82382.6 | 131812.2 | ||||
(411913*20%) | (411913*32%) | |||||
Before tax income | 365471.2 | 139958.1 | ||||
Less: tax | 135224.4 | 51784.51 | ||||
After tax income | 230246.9 | 88173.63 | ||||
Add: Depreciation | 82382.6 | 131812.2 | ||||
Annual cashflows | 312629.5 | 219985.8 | ||||
After tax salvage value | ||||||
Sales value | 134289 | |||||
Book Value (411913*48%) | 197718.2 | |||||
Loss on sale | 63429.24 | |||||
Tax shield n loss @ 37% | 23468.82 | |||||
After tax salvage value | 157757.8 | |||||
NPV: | ||||||
Year-0 | Year-1 | Year-2 | ||||
Initial investment | -411913 | |||||
Annual cashflows | 312629.5 | 219985.8 | ||||
After tax salvage | 157757.8 | |||||
Net cashflows | -411913 | 312629.5 | 377743.6 | |||
PVF at 13% | 1 | 0.884956 | 0.783147 | |||
Present value of CF | -411913 | 276663.3 | 295828.6 | |||
NPV | 160579 | |||||