In: Finance
KADS, Inc., has spent $400,000 on research to develop a new computer game. The firm is planning to spend $200,000 on a machine to produce the new game. Shipping and installation costs of the machine will be capitalized and depreciated; they total $50,000. The machine has an expected life of three years, a $75,000 estimated resale value, and falls under the MACRS 7-year class life. Revenue from the new game is expected to be $600,000 per year, with costs of $250,000 per year. The firm has a tax rate of 21percent, an opportunity cost of capital of 15 percent, and it expects net working capital to increase by $100,000 at the beginning of the project. what will the cash flows for this projects be?
The Net cash flows are as below
| Year | Initial cash flow | OCF | Working capital | Salvage | Net cash flows | 
| 0 | -250000 | -100000 | -350000 | ||
| 1 | $284,002.25 | 284002.25 | |||
| 2 | $289,357.25 | 289357.25 | |||
| 3 | $285,682.25 | 100000 | 82208.25 | 467890.5 | 
NOTES:
Amount spent on research will be ignored since it is sunk cost. Initial capital = 200000+50000=250000.
First we will compute the Operating cash flows
| OCF | MACRS 7 year | |||||
| Year | Cash flows | Depreciation | EBIT | Tax | PAT | OCF | 
| 1 | 350000 | -35725 | 314275 | -65997.75 | 248277.25 | 284002.3 | 
| 2 | 350000 | -61225 | 288775 | -60642.75 | 228132.25 | 289357.3 | 
| 3 | 350000 | -43725 | 306275 | -64317.75 | 241957.25 | 285682.3 | 
| Salvage | |
| Purchase price | 250000 | 
| Less: Depreciation | -140675 | 
| Closing book value | 109325 | 
| Selling price | 75000 | 
| Gain/(loss) | -34325 | 
| Tax/ Saving | 7208.25 | 
| Net salvage | 82208.25 | 
WORKINGS
