Developing Relevant Cash Flows for Newman Upholstery

Company$$s Machine Renewal or Replacement Decision

Cosmo Kramer, chief financial officer of Newman Upholstery Company, expects the firm$$s net

profits after taxes for the next $5$ years to be as shown in the following table.

Year Net profits after

taxes

$1$ $$100,000$

$2$ $$150,000$

$3$ $$200,000$

$4$ $$250,000$

$5$ $$320,000$

Cosmo is beginning to develop the relevant cash flows needed to analyze whether to renew or

replace Newman$$s only depreciable asset, a machine that originally cost $$30,000,$ has a current

book value of zero, and can now be sold for $$20,000.($Note: Because the firm$$s only depreciable

asset is fully depreciated$---$its book value is zero$---$its expected net profits after taxes equal its

operating cash inflows.$)$ He estimates that at the end of $5$ years, the existing machine can be sold

to net $$2,000$ before taxes. Cosmo plans to use the following information to develop the relevant

cash flows for each of the alternatives.

Alternative $1$ Renew the existing machine at a total depreciable cost of $$90,000.$ The renewed

machine would have a $5-$year usable life and depreciated under MACRS using a $5-$year recovery

period. Renewing the machine would result in the following projected revenues and expenses

$($excluding depreciation$)$:

Year Revenue Expenses

$($excluding depreciation$)$

$1$ $$1,000,000$ $$801,500$

$2$ $$1,175,000$ $$884,200$

$3$ $$1,300,000$ $$918,100$

$4$ $$1,425,000$ $$943,100$

$5$ $$1,550,000$ $$968,100$

The renewed machine would result in an increased investment of $$15,000$ in net working capital.

At the end of $5$ years, the machine could be sold to net $$8,000$ before taxes.

Alternative $2$ Replace the existing machine with a new machine costing $$100,000$ and requiring

installation costs of $$10,000.$ The new machine would have a $5-$year usable life and be depreciated

under MACRS using a $5-$year recovery period. The firm$$s projected revenues and expenses

$($excluding depreciation$),$ if it acquires the machine, would be as follows:

Year Revenue Expenses$($excluding

depreciation$)$

$1$ $$1,000,000$ $$764,500$

$2$ $$1,175,000$ $$839,800$

$3$ $$1,300,000$ $$914,900$

$4$ $$1,425,000$ $$989,900$

$5$ $$1,550,000$ $$998,900$

The new machine would result in an increased investment of $$22,000$ in net working capital. At

the end of $5$ years, the new machine could be sold to net $$25,000$ before taxes. The weighted

average cost of capital is $10\%.$ The marginal tax rate for Newman is $40\%.$

Find the NPV$,$ IRR, MIRR, payback and discounted payback for both alternatives. Which

alternative should be selected? Explain.