Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Ten Commandments To A Financial Healing

Authors: Ms. Kemberley J Washington

1st Edition

1499607261, 978-1499607260

More Books

Students also viewed these Finance questions