Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can someone show how to set up this excel spreed sheet and have answers? Thank you so much! The Berndt Corporation expects to have sales
can someone show how to set up this excel spreed sheet and have answers? Thank you so much!
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. The federal tax rate is 21% (ignore any possible state corporate taxes). Berndt has no debt. Set up an income statement. What is Berndt's expected net income? Its expected net cash flow? Suppose Congress changed the tax laws so that Berndt's depreciation expenses doubled. No changes in operations occurred. What would happen to reported profit and to net cash flow? 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started