Income and Cash Flow Analysis The Berndt Corporation expects to have sales of $13 million Costs other than depreciation are expected to be 80 of sales, and depreciation is expected to be $1 3 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 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 $ 2145000 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 $ 2600000 Now suppose that Congress changed the tax laws such that, instead of doubling Berndts depreciation, it was reduced by 50 What is Berndt's expected net cash flow Round your answer to the nearest dollar $ 19175000 If this were your company, would you prefer Congress to cause your depreciation expense to be doubled or halved If this is my company, I want Congress to double the depreciation, because it will give me more cash flow Free Cash Flows The data for Rhodes Corporation's has been collected in the Microsoft Excel Online file below Open the spreadsheet and perform the required analysis to answer the questions below What is the net operating profit after taxes (NOPAT) for 2018 Enter your answer in millions For example, an answer of $1 2 million should be entered as 1 2, not 1,200,000 Do not round intermediate calculations Round your answer to one decimal place $ 875 2 million What are the amounts of net operating working capital for both years Enter your answers in millions For example, an answer of $1 2 million should be entered as 1 2, not 1,200,000 Do not round intermediate calculations Round your answers to one decimal place $ 1587 0 million 2017 $ 1260 0 million What are the amounts of total net operating capital for both years Enter your answers in millions For example, an answer of $1 2 million should be entered as 1 2, not 1,200,000 Do not round intermediate calculations Round your answers to one decimal place $ 3501 0 million 2017 $ 3000 million Balance Sheet Analysis Consider the following financial data for J White Industries Total assets turnover 1 2 Gross profit margin on sales (Sales Cost of goods sold) Sales 26 Total liabilities to assets ratio 55 Quick ratio 0 85 Days sales outstanding (based on 365 day year) 38 days Inventory turnover ratio 5 0 Open Excel spreadsheet and perform the required analysis to answer the questions below Complete the balance sheet and sales information in the table that follows for J White Industries Do not round intermediate calculations Round your answers to the nearest whole dollar Partial Income Statement Information Sales $ Cost of goods sold $ Balance Sheet Cash $ Accounts payable $ Accounts receivable $ Long term debt $ 50,000 Inventories $ Fixed assets $ Total assets $

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 09, 2024

Income and Cash Flow Analysis The Berndt Corporation expects to have sales of $13 million. Costs other than depreciation are expected to be 80% of

Income and Cash Flow Analysis

The Berndt Corporation expects to have sales of $13 million. Costs other than depreciation are expected to be 80% of sales, and depreciation is expected to be $1.3 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.

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.

$ 2145000

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.

$ 2600000

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

$ 19175000_

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

_If this is my company, I want Congress to double the depreciation, because it will give me more cash flow.

Free Cash Flows

The data for Rhodes Corporation's has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

What is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to one decimal place.

$ 875.2 million

What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.
1. $ 1587.0 million

2017 $ 1260.0 million

What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.
1. $ 3501.0 million

2017 $ 3000 million

Balance Sheet Analysis

Consider the following financial data for J. White Industries:

Total assets turnover: 1.2

Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 26%

Total liabilities-to-assets ratio: 55%

Quick ratio: 0.85

Days sales outstanding (based on 365-day year): 38 days Inventory turnover ratio: 5.0

Open Excel spreadsheet and perform the required analysis to answer the questions below.

Complete the balance sheet and sales information in the table that follows for J. White Industries. Do not round intermediate calculations. Round your answers to the nearest whole dollar.

Partial Income

Statement Information

Sales $

Cost of goods sold $

Balance Sheet

Cash $ Accounts payable $

Accounts receivable $ Long-term debt $ 50,000

Inventories $

Fixed assets $

Total assets $