In: Finance
| 
 Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $6.318 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $491,400. The project requires an initial investment in net working capital of $702,000. The project is estimated to generate $5,616,000 in annual sales, with costs of $2,246,400. The tax rate is 34 percent and the required return on the project is 15 percent.  | 
| Required: | |
| (a) | What is the project's year 0 net cash flow? | 
| (Click to select) -7,020,000 -6,669,000 -6,318,000 -7,722,000 -7,371,000 | |
| (b) | What is the project's year 1 net cash flow? | 
| (Click to select) 3,086,975 2,645,978 2,939,976 2,792,977 3,233,974 | 
| (c) | What is the project's year 2 net cash flow? | 
| (Click to select) 2,645,978 2,939,976 3,086,975 2,792,977 3,233,974 | 
| (d) | What is the project's year 3 net cash flow? | 
| (Click to select) 4,164,615 3,767,985 4,362,930 3,966,300 3,569,670 | 
| (e) | What is the NPV? | 
| (Click to select) 2,758,049 385,824 367,452 -1,309,807 394,627 | 
| Time line | 0 | 1 | 2 | 3 | |||
| Cost of new machine | -6318000 | ||||||
| Initial working capital | -702000 | ||||||
| =Initial Investment outlay | -7020000 | ||||||
| 100.00% | |||||||
| Sales | 5616000 | 5616000 | 5616000 | ||||
| Profits | Sales-variable cost | 3369600 | 3369600 | 3369600 | |||
| -Depreciation | Cost of equipment/no. of years | -2106000 | -2106000 | -2106000 | 0 | =Salvage Value | |
| =Pretax cash flows | 1263600 | 1263600 | 1263600 | ||||
| -taxes | =(Pretax cash flows)*(1-tax) | 833976 | 833976 | 833976 | |||
| +Depreciation | 2106000 | 2106000 | 2106000 | ||||
| =after tax operating cash flow | 2939976.00 | 2939976.00 | 2939976 | ||||
| reversal of working capital | 702000 | ||||||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 324324 | |||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||
| =Terminal year after tax cash flows | 1026324 | ||||||
| Total Cash flow for the period | a.-7020000 | b.2939976.00 | c.2939976.00 | d.3966300.000 | |||
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.15 | 1.3225 | 1.520875 | ||
| Discounted CF= | Cashflow/discount factor | -7020000 | 2556500.87 | 2223044.234 | 2607906.633 | ||
| e. NPV= | Sum of discounted CF= | 367452 | |||||