Carlson Aires Argo ) CASE 32 Carlson Airlines Debra Simpson, the CFO of Carlson Airlines, was considering the acquisition of Beta Transport Supply Company. The asking price was $100 million. Carlson Airlines was in a 30 percent tax bracket. The purchase was to be for cash and Debra intended to use capital budgeting procedures in the analysis. Beta's Past Performance Last year, Beta had the following financial data. Sales Cost of goods sold Gross profit Selling and administrative expense Depreciation expense Earnings before taxes Taxes (30%) Earnings after taxes Plus depreciation Cash flow $30,000,000 18.000.000 $12,000,000 3,000,000 4.000.000 $5,000,000 1.500.000 $3,500,000 4,000,000 $7,500,000 Debra's Projections Sales Cost of goods sold Selling and administrative expense Depreciation +11% +8% +20% +10% She was doing a 10 year analysis and expected cash flow to grow by 12% each of the remaining 9 years. She used 10% as the discount rate. She further projected she could sell Beta Transport for $140 million after 10 years and pay 15% tax on the proceeds. Required 1. Project cash flow for the 15 year after the merger. 2. Based on the 12 percent growth rate, project cash flow for the remaining 9 years. Round to the nearest dollar. 3. Discount back each of the 10 years of cash flow at 10 percent. Round to the nearest dollar. Compute the total present value. 4. Discount back the aftertax sales price proceeds after 10 years. Round to the nearest dollar 5. Add together the answers to questions 3 and 4. Then subtract the purchase price of $100 million for Beta Transport Supply Company. Should the company be purchased