Please show answer in excel and show formulas please

2-11) The Berndt Corporation expects to have sales of $12 million. Costs other than boss depreciation are expected to be 75% of sales, and depreciation is expected to be and Cash Anal $1.5 million. All sales revenues will be collected in cash, and costs other than depreciation must be paid for during the year. Berndt's federal-plus-state tax rate is 40%. Berndt has no debt. a. Set up an income statement. What is Berndt's expected net income? Its expected net cash flow? b. Suppose Congress changed the tax laws so that Berndt's depreciation expenses doubled. No changes in operations occurred. What would happen to reported proft and to net cash flow? c. Now suppose that Congress changed the tax laws such that, instead of doubling Berndt's depreciation, it was reduced by 50%. How would profit and net cash flow be affected? If this were your company, would you prefer Congress to cause your depreciation expense to be doubled or halved? Why? d. 2-11) The Berndt Corporation expects to have sales of $12 million. Costs other than boss depreciation are expected to be 75% of sales, and depreciation is expected to be and Cash Anal $1.5 million. All sales revenues will be collected in cash, and costs other than depreciation must be paid for during the year. Berndt's federal-plus-state tax rate is 40%. Berndt has no debt. a. Set up an income statement. What is Berndt's expected net income? Its expected net cash flow? b. Suppose Congress changed the tax laws so that Berndt's depreciation expenses doubled. No changes in operations occurred. What would happen to reported proft and to net cash flow? c. Now suppose that Congress changed the tax laws such that, instead of doubling Berndt's depreciation, it was reduced by 50%. How would profit and net cash flow be affected? If this were your company, would you prefer Congress to cause your depreciation expense to be doubled or halved? Why? d