Domco manufactures small gasoline engines for the home gardening power tool industry. Their production line for 8hp engines is very labor intensive. The company has an opportunity to produce 8hp engines for all of Sears CraftsmanⓇ small garden power products that require an 8 horsepower rating. In order to increase production Domco will have to install a new automated production line. The engineering estimate for the cost of the new production facility is $12,500,000. If the new production line is installed, it is estimated that Domco will save $1,000,000 per year in direct labor cost. All other variable cost per unit will remain the same. The Sear's contract is for 5 years and will be renewed at the end of that time if both parties agree. The Sear's contract will increase sales in 8hp engines by 30% per year. The current sales price per engine is $48 with a total volume of 800,000 units sold per year. Variable cost amount to 32% of the sales price per engine exclusive of direct labor cost. If the new production line is installed the old production line will be dismantled and scraped (sold) for $45,000 and will have a realize loss for tax purposes of $280,000. If the old line were not sold today it could be sold for $25,000 at the end of its life in five years. The old production line was put into servers 10 years ago at a cost of $975,000 and was being depreciate over a 15 year life using straight line depreciation without taking salvage value into consideration. The new production line will be depreciated over 5 years using straight line depreciation without taking salvage value into consideration. If Domco goes ahead with the project, the company will use funds currently available to pay for the new line. The new production line can be scraped (sold) for $175,000 five years from today. Since no salvage value has been use in the depreciation calculation for the equipment the entire amount a taxable gain, Required: Use the provided Excel spreadsheet to calculate the after tax cash flows assuming a 48% marginal tax bracket for Domco. Do not total the cash flows and do not calculate the present values of the after-tax cash flows A B C D E F G H 1 PROB.2 2 Tax rate 48% 3 4 CASH IN FLOWS CFBT CFAT TODAY YR1 YR2 YR3 YR4 YR5 5 3 6 7 8 3 9 10 11 3 3 12 13 14 CASH OUT FLOWS 15 16 17 18 19 21 3 $ 45,000 22 CALCULATION OF GAIN OR LOSS ON SALE OF OLD EQUIP CASH REC WHEN SOLD: LESS BOOKVALUE OF OLD EQUIP. S 325,000 975,000-((975000/15)*10) 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 40 41 42 43 45 47 48 LOSS $ (280,000) 3 3 3 3 K M N + R S LIST OF CASH FLOWS AND THEIR AFTER-TAX EFFECT ITEM OF CASH FLOW AFTER TAX EFFECT A. CASH IN FLOWS-ACTUAL CASH: 1 Increase to a revenueX (1-TR) 2 Decrease to an experX (1-TR) 3 Sale of an Asset: X 4 Avoid an cX 1 5 Avoid an cx (1-TR) 6 Decrease X 1 B. CASH IN FLOWS-TAX GENERATED: 1 Increase in depreciat X (TR) 2 Loss on sale of Assel X (TR) 3 Investmen 1 4 Tax saved from gain on future sale of an asset that X (TR) C. CASH OUT FLOWS-ACTUAL CASH: 1 Investment (cash from non intr bearing source): X 1 2 Repaymer X 1 3 Interest on debt: X (1-TR) 4 Increase in expenses X (1-TR) 5 Loss of sale of asset: X 6, Increase ir X D. CASH OUT FLOWS-TAX GENERATED: 1 Tax on gai X (TR) 2 Loss of de (TR) 3 Loss of de X (TR)