In: Finance
Dog Up! Franks is looking at a new sausage system with an installed cost of $662,692. This cost will be depreciated straight-line to 23,962 over the project's 7-year life, at the end of which the sausage system can be scrapped for $95,309. The sausage system will save the firm $222,899 per year in pretax operating costs, and the system requires an initial investment in net working capital of $51,567. If the tax rate is 0.37 and the discount rate is 0.09, what is the total cash flow in year 7? (Make sure you enter the number with the appropriate +/- sign)
| Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||
| Cost of new machine | -662692 | ||||||||||
| Initial working capital | -51567 | ||||||||||
| =Initial Investment outlay | -714259 | ||||||||||
| 100.00% | |||||||||||
| Savings | 222899 | 222899 | 222899 | 222899 | 222899 | 222899 | 222899 | ||||
| -Depreciation | (Cost of equipment-salvage value)/no. of years | -91247.1429 | -91247.1429 | -91247.1429 | -91247.14286 | -91247.14 | -91247.14 | -91247.1429 | 23962 | =Salvage Value | |
| =Pretax cash flows | 131651.8571 | 131651.8571 | 131651.8571 | 131651.8571 | 131651.86 | 131651.86 | 131651.8571 | ||||
| -taxes | =(Pretax cash flows)*(1-tax) | 82940.67 | 82940.67 | 82940.67 | 82940.67 | 82940.67 | 82940.67 | 82940.67 | |||
| +Depreciation | 91247.14286 | 91247.14286 | 91247.14286 | 91247.14286 | 91247.143 | 91247.143 | 91247.14286 | ||||
| =after tax operating cash flow | 174187.81 | 174187.81 | 174187.81 | 174187.81 | 174187.81 | 174187.81 | 174187.81 | ||||
| reversal of working capital | 51567 | ||||||||||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 60044.67 | |||||||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 8865.94 | |||||||||
| =Terminal year after tax cash flows | 120477.61 | ||||||||||
| Total Cash flow for the period | -714259 | 174187.81 | 174187.81 | 174187.81 | 174187.81 | 174187.81 | 174187.81 | 294665.42 | |||
Year 7 CF = 294665.42