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 $402,656.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 | $61.40 | $61.40 |
| Units sold | 19,812.00 | 11,852.00 |
| COGS | 41.00% of sales | 41.00% of sales |
| Selling and Administrative | 19.00% of sales | 19.00% of sales |
Calloway has a 14.00% cost of capital and a 40.00% tax rate. The
firm expects to sell the equipment after 2 years for a NSV of
$145,713.00.
What is the project cash flow for year 1?
| Tax rate | 40% | ||||||
| Year-0 | Year-1 | Year-2 | |||||
| Units | 19,812 | 11,852 | |||||
| Sale Price | 61.40 | 61.40 | |||||
| variable cost-60% | 36.84 | 36.84 | |||||
| Sale | 1,216,457 | 727,713 | |||||
| Less: Operating Cost | 729,874 | 436,628 | |||||
| Contribution | 486,583 | 291,085 | |||||
| Less: Depreciation as per table given below | 80,531 | 128,850 | |||||
| Profit before tax | 406,052 | 162,235 | |||||
| Tax | 162,421 | 64,894 | |||||
| Profit After Tax | 243,631 | 97,341 | |||||
| Add Depreciation | 80,531 | 128,850 | |||||
| Cash Profit After tax | 324,162 | 226,191 | |||||
| Cost of macine | 402,656 | ||||||
| Depreciation | 209,381 | ||||||
| WDV | 193,275 | ||||||
| Sale price | 145,713 | ||||||
| Profit/(Loss) | (47,562) | ||||||
| Tax | (19,025) | ||||||
| Sale price after tax | 164,738 | ||||||
| Depreciation | Year-1 | Year-2 | Total | ||||
| Cost | 402,656 | 402,656 | |||||
| Dep Rate | 20.00% | 32.00% | |||||
| Deprecaition | 80,531 | 128,850 | 209,381 | ||||
| Calculation of NPV | |||||||
| 14.00% | |||||||
| Year | Captial | Operating cash | Annual Cash flow | PV factor | Present values | ||
| 0 | (402,656) | (402,656) | 1.000 | (402,656) | |||
| 1 | 324,162 | 324,162 | 0.877 | 284,353 | |||
| 2 | 164,738 | 226,191 | 390,929 | 0.769 | 300,807 | ||
| Net Present Value | 182,504 | ||||||