Finance Questions must be answered in excel. (Book used isFinancial Management: Theory and Practice 14e.) (Problems 2-4, 2-11, 2-12 attached)

2-4 Talbot Enterprises recently reported an EBITDA of $8million and net income of $2.4million. It had $2.0 million of interest expense, and its corporate tax rate was 40%. What was its charge for depreciation and amortization?

2-11

The Berndt Corporation expects to have sales of $12 million. Costs other than depreciation are expected to be 75% of sales, and depreciation is expected to be $1.5 million. All sales revenues will be collected in cash, and costs other than depreciation must be paid for during the year. Berndts federal-plus-state tax rate is 40%. Berndt has no debt.

a. Set up an income statement. What is Berndts expected net cash flow?

b. Suppose Congress changed the tax laws so that Berndts depreciation expenses doubled. No changes in operations occurred. What would happen to reported profit and to net cash flow?

c. Now suppose that Congress changed the tax laws such that, instead of doubling Berndts depreciation, it was reduced by 50%. How would profit and net cash flow be affected?

d. If this were your company, would you prefer Congress to cause your depreciation expense to be doubled or halved? Why?