Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

QUESTION 1 Continuing with the previous question: The Renecke Co. is planning to replace their printing equipment with a new computerized version that will print more copies at lower cost. The cost of...

1 answer below »
QUESTION 1
Continuing with the previous question: The Renecke Co. is planning to replace their printing equipment with a new computerized version that will print more copies at lower cost. The cost of the new machine will be $600,000 including installation. They can sell their fully depreciated existing machine for approximately $100,000. The new machine will require net working capital of $80,000 in period 0. What initial outlay will be required in period 0 for this new equipment? Assume a tax rate of 35%.
 The new equipment is expected to increase sales by $350,000 but costs are also expected to increase by $100,000. At the end of the five-year project, they could sell the equipment for $50,000. Should they replace the printing equipment? Assume the cost of capital is 16%.
Show work in Excel
    
    
    Yes, NPV = $108,155,77
    
    
    Yes, NPV =$92,682.09
    
    
    $54,930.05
    
    
    No, NPV = 28,500.22
QUESTION 2
The previous question has been slightly modified. Note the difference in the book value of the old machine.
The Renecke Co. is planning to replace their printing equipment with a new computerized version that will print more copies at lower cost. The cost of the new machine will be $600,000 including installation. The old machine has a book value of $150,000 that is being depreciated straight-line to a zero value over five years. It can be sold cu
ently for $100,000. The new machine will require net working capital of $80,000 in period 0. What initial outlay will be required in period 0 for this new equipment? Assume a tax rate of 35%.
Show work in Excel
    
    
    -$437,500
    
    
    -$562,500
    
    
    -$482,500
    
    
    -$465000
QUESTION 3
This question follows the previous question: The Renecke Co. is planning to replace their printing equipment with a new computerized version that will print more copies at lower cost. The cost of the new machine will be $600,000 including installation. The old machine has a book value of $150,000 that is being depreciated straight-line t0 zero value over five years. It can be sold cu
ently for $100,000. The new machine will require net working capital of $80,000 in period 0.
The new equipment is expected to increase sales by $350,000 but costs are also expected to increase by $100,000. At the end of the five-year project, they could sell the equipment for $50,000. Should they replace the printing equipment? Assume the cost of capital is 16% and the tax rate is 35%.
Show work in Excel
    
    
    No, NPV = $120,765.32
    
    
    No, NPV = -28,375.45
    
    
    Yes, NPV = $160,655.77
    
    
    Yes, NPV = $ 126,275.68
Answered Same Day Oct 31, 2021

Solution

Nitish Lath answered on Nov 15 2021
137 Votes
Solution 1
        Year    0    1    2    3    4    5
        Cost of new machine    (600,000.00)
        Working capital requirement    (80,000.00)
        sale value    65,000.00
        Total initial cost    (615,000.00)
        Cash inflows
        Increase in sales        350,000.00    350,000.00    350,000.00    350,000.00    350,000.00
        Increase in costs         100,000.00    100,000.00    100,000.00    100,000.00    100,000.00
        less: depreciation         120,000.00    120,000.00    120,000.00    120,000.00    120,000.00
        Net income before tax        130,000.00    130,000.00    130,000.00    130,000.00    130,000.00
        Less: Tax@ 35%        45,500.00    45,500.00    45,500.00    45,500.00    45,500.00
        Net income        84,500.00    84,500.00    84,500.00    84,500.00    84,500.00
        Add: depreciation        120,000.00    120,000.00    120,000.00    120,000.00    120,000.00
        Net cash flow        204,500.00    204,500.00    204,500.00    204,500.00    204,500.00
        Add: Recovery of terminal value                        80,000.00
        Net cash...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here