Question

In: Finance

The Berndt Corporation expects to have sales of $13 million. Costs other than depreciation are expected...

The Berndt Corporation expects to have sales of $13 million. Costs other than depreciation are expected to be 60% of sales, and depreciation is expected to be $2.6 million. All sales revenues will be collected in cash, and costs other than depreciation must be paid for during the year. Brendt's federal-plus-state tax rate is 35%. Berndt has no debt. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

  1. Set up an income statement. What is Berndt's expected net cash flow? Enter your answer in dollars. For example, an answer of $1.2 million should be entered as 1,200,000. Round your answer to the nearest dollar.

    $  

  2. Suppose Congress changed the tax laws so that Berndt's depreciation expenses doubled. No changes in operations occurred. What is Berndt's expected net cash flow? Round your answer to the nearest dollar.

    $  

  3. Now suppose that Congress changed the tax laws such that, instead of doubling Berndt’s depreciation, it was reduced by 50%. What is Berndt's expected net cash flow? Round your answer to the nearest dollar.

    $  

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

Solutions

Expert Solution

a.

Therefore, Berndt's Expected net cash flow is 4,290,000 .

b.

Therefore, Berndt's Expected net cash flow is 5,200,000 .

C.

Therefore, Berndt's Expected net cash flow is 3,835,000 .

D.

as we can see from the above 3 excel sheets. the net cash flow increased and tax reduced when depreciation was doubled both of which are favorable.

Therefore I would prefer Congress to cause my depreciation expense to be doubled.


Related Solutions

The Berndt Corporation expects to have sales of $12 million. Costs other than depreciation are expected...
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. a. Set up an income statement. What is Berndt’s expected net income? Its expected net...
The Berndt Corporation expects to have sales of $15 million. Costs other than depreciation are expected...
The Berndt Corporation expects to have sales of $15 million. Costs other than depreciation are expected to be 75% of sales, and depreciation is expected to be $1.875 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. Set up an income statement. What is Berndt's expected net income? Enter your answer in dollars. For example, an answer of...
The Berndt Corporation expects to have sales of $12 million. Costs other than depreciation are expected...
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. a. Set up an income statement. What is Berndt’s expected net income? Its expected net...
The POP Corporation had sales of $60 million in 2016. Costs other than depreciation and amortization...
The POP Corporation had sales of $60 million in 2016. Costs other than depreciation and amortization were 60 percent of sales, and depreciation and amortization expenses were $19.6 million. It had $120 million debt with 5 % annual interest. All sales revenues were collected in cash, and costs other than depreciation and amortization must be paid for during the year. The corporate tax rate is 35 percent. a. Set up an income statement for the above information. b. Compute the...
Rao Construction recently reported $28.00 million of sales, $12.60 million of operating costs other than depreciation,...
Rao Construction recently reported $28.00 million of sales, $12.60 million of operating costs other than depreciation, and $3.00 million of depreciation. It had $8.50 million of bonds outstanding that carry a 7.0% interest rate, and its federal-plus-state income tax rate was 25%. What was Rao's operating income, or EBIT, in millions? a. $14.54 b. $16.56 c. $11.09 d. $16.70 e. $14.40
A company reported $750,000 of sales, 75% of operating costs other than depreciation, and $7,500 of...
A company reported $750,000 of sales, 75% of operating costs other than depreciation, and $7,500 of depreciation. It had $75,000 of bonds that carry a 7.5% interest rate, and its tax rate was 25%. How much was its net cash flow?
Pancake Village had sales of $1.5 million with depreciation of $350,000 and other operating costs that...
Pancake Village had sales of $1.5 million with depreciation of $350,000 and other operating costs that ran 35% of sales. They paid $180,000 in dividends with a tax rate of 40% and interest expense of $280,000. What was their Net Cash Flow? A. $449,000 B. $767,000 C. $557,000 D. $872,000
Houston Pumps recently reported $172,500 of sales, $140,500 of operating costs other than depreciation, and $9,250 of depreciation.
Houston Pumps recently reported $172,500 of sales, $140,500 of operating costs other than depreciation, and $9,250 of depreciation. The company had $35,250 of outstanding bonds that carry a 6.75% interest rate, and its federal-plus-state income tax rate was 25%. In order to sustain its operations and thus generate future sales and cash flows, the firm was required to spend $15,250 to buy new fixed assets and to invest $6,850 in net operating working capital. What was the firm's free cash...
AT&T recently reported (in millions) $8,250 of sales, $5,750 of operating costs other than depreciation, and...
AT&T recently reported (in millions) $8,250 of sales, $5,750 of operating costs other than depreciation, and $1,100 of depreciation. The company had $3,200 of outstanding bonds that carry a 5% interest rate, and its federal-plus-state income tax rate was 35%. In order to sustain its operations and thus generate future sales and cash flows, the firm was required to make $1,250 of capital expenditures on new fixed assets and to invest $300 in net operating working capital. By how much...
Sales is $18 million, VC is 82% of Sales and Fixed Costs are 3 million. Depreciation...
Sales is $18 million, VC is 82% of Sales and Fixed Costs are 3 million. Depreciation will be $0.5 million a year. The project is for 5 years. Opportunity cost of capital is 8% What is the accounting breakeven revenue? What is the NPV breakeven?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT