Question

After-Tax Cash Flows

Warren Company plans to open a new repair service center for one of its electronic products. The center requires an investment in depreciable assets costing $480,000. The assets will be depreciated on a straight-line basis, over four years, and have no expected salvage value. The annual income statement for the center is given below.

Revenues	$360,000
Less: Cash operating expenses	(150,000)
Depreciation	(120,000)
Income before income taxes	$90,000
Less: Income taxes (@40%)	36,000
Net income	$54,000

Required:

1. Using the income approach, calculate the after-tax cash flows.
$

2. Using the decomposition approach, calculate the after-tax cash flows for each item of the income statement and show that the total is the same as the income approach. Enter cash expenses as negative amounts and noncash expenses as positive amounts.

Revenue (after tax)	$
Cash expenses (after tax)
Depreciation tax savings
Operating cash flow	$

3. What if it is desirable to express the decomposition approach in a spreadsheet format for the four years to facilitate the use of spreadsheet software packages? Express the decomposition approach in a spreadsheet format, with a column for each income item and a total column. Enter the after-tax cash expenses as negative amounts. Enter the after-tax revenues and the tax savings from noncash expenses as positive amounts.

Year	Revenue	Cash operating expenses	Noncash operating expenses	Cash flow
1	$	$	$	$
2
3
4

Answer 1

1. Calculation of after tax cash flows  

Revenues	$360,000
Less: Cash operating expenses	(150,000)
Depreciation	(120,000)
Income before income taxes	$90,000
Less: Income taxes (@40%)	36,000
Net income	$54,000

Add: Depreciation                                         $120,000

After Tax Cash Flows                                    $174,000

2 .Calculation of after tax cash flows using decomposition approach

   Revenue after tax     $216,000

   Cash Expenses after tax                          (90,000)

   Depreciation tax savings                           $48,000

   Operating cash flow                                 $174,000

3. Expression of decomposition approach in a spreadsheet format

Year	Revenue	Cash operating expenses	Non-cash operating expenses	Cash flow
1	$216,000	$ (90,000)	$48,000	$174,000
2	$216,000	$ (90,000)	$48,000	$174,000
3	$216,000	$ (90,000)	$48,000	$174,000
4	$216,000	$ (90,000)	$48,000	$174,000