Could someone assist with this problem? Thank you.

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 in the analysis.

Betas Past Performance

Last year, Beta had the following financial data.

Sales $30,000,000

Cost of Goods Sold 18,000,000

Gross Profit 12,000,000

Selling and Administrative Expenses 3,000,000

Depreciation Expense 4,000,000

Earnings before Taxes 5,000,000

Taxes (30%) 1,500,000

Plus Depreciation 4,000,000

Cash Flow $ 7,500,000

Debras Projections

Sales +11%

Cost of Goods Sold +8%

Selling and Administrative Expenses +20%

Depreciation +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.

Project cash flow for the 1^st year after the merger.

Based on the 12 percent growth rate, project cash flow for the remaining 9 years. Round to the nearest dollar.

Discount back each of the 10 years of the cash flow at 10 percent. Round to the nearest dollar. Compute the total present value.

Discount back the aftertax sales price proceeds after 10 years. Round to the nearest dollar.

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?