In: Finance
P11–18 Operating cash flows: Expense reduction Miller Corporation is considering replacing a machine. The replacement will reduce operating expenses (i.e., increase earnings before interest, taxes, depreciation, and amortization) by $16,000 per year for each of the 5 years the new machine is expected to last. Although the old machine has zero book value, it can be used for 5 more years. The depreciable value of the new machine is $48,000. The firm will depreciate the machine under MACRS, using a 5-year recovery period (see Table 4.2 for the applicable depreciation percentages), and is subject to a 21% tax rate. Estimate the operating cash flows generated by the replacement. (Note: Be sure to consider the depreciation in year 6.)
I don't own a financial calculator, I have the Ti84 Plus, please show work. thanks.
Table 4.2
Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes
| 
 Percentage by recovery yeara  | 
||||
| 
 Recovery year  | 
 3 years  | 
 5 years  | 
 7 years  | 
 10 years  | 
| 
 1  | 
 33%  | 
 20%  | 
 14%  | 
 10%  | 
| 
 2  | 
 45  | 
 32  | 
 25  | 
 18  | 
| 
 3  | 
 15  | 
 19  | 
 18  | 
 14  | 
| 
 4  | 
 7  | 
 12  | 
 12  | 
 12  | 
| 
 5  | 
 12  | 
 9  | 
 9  | 
|
| 
 6  | 
 5  | 
 9  | 
 8  | 
|
| 
 7  | 
 9  | 
 7  | 
||
| 
 8  | 
 4  | 
 6  | 
||
| 
 9  | 
 6  | 
|||
| 
 10  | 
 6  | 
|||
| 
 11  | 
 4  | 
|||
| 
 Totals  | 
 100%  | 
 100%  | 
 100%  | 
 100%  | 
The formula for operating cash flow is :
[(Change in Sales - Change in Cash Operating Expenses)(1-Marginal Tax Rate)] + Change in Depreciation * Marginal Tax Rate
| Year | Cash Flow Formula | Operating Cash Flow | ||
| 1 | [(0-(-16,000))*(1-21%)] + (9,600-0) * 21% | 
 14,656  | 
||
| 2 | 
  | 
15,866 | ||
| 3 | 
  | 
14,555 | ||
| 4 | 
  | 
13,850 | ||
| 5 | 
  | 
13,850 | ||
| 6 | 
  | 
504 | 
The change in operating cash flow is a reduction of 16,000 and so the negative sign has been used.
The depreciation for each year has been calculated using the MACR table rates for each of the 6 years.
Since, the Book Value of the earlier asset is zero, the depreciation is assumed to be zero.
Note: MACRS declining balance changes to straight-line method when that method provides an equal or greater deduction.
All figures have been rounded off to two decimal places.