Explore BrainMass

Explore BrainMass

    Cash Flows and Decision Making

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    A company has a metal bending machine and is considering a replacement for the machine. If repaired, the existing machine can be used for another 5 years. The existing machine will have no salvage value at the end of 5 years if kept for that period; however, the firm can sell the existing machine today to another firm for $4,500. If the existing machine is kept, it will require an immediate $1,000 overhaul to enable continued operation. (The overhaul will not extend the service life beyond 5 years or increase the value of the existing machine). Operating costs for the existing machine are estimated at $1,500 for the first year and will increase by $500 each year after the first.

    A new model will cost $10,000 and will have operating costs of $1,500 for the first year. For each additional year (after the first year) the new machine is used, its operating costs will increase by $750 over the previous year's operating costs. The new machine's salvage value is $7,500 after one year and declines by 15% from the previous year's salvage value each year.

    The firm's MARR is 10%. Should the existing metal bending machine be replaced now?

    © BrainMass Inc. brainmass.com October 10, 2019, 5:44 am ad1c9bdddf

    Solution Preview

    Please refer attached file for better clarity of tables.

    In attached file
    In row no. 28, "Cost of old machine as on today" should be read as "Cost of new machine as on today"
    In row no. 45, "Total present cost if old machine is used" should be read as "Total present cost if new machine is used"

    Case 1
    Continue to use existing bending machine

    Cost of old machine as on today=$4,500
    Overhaul costs= $1,000
    Total value of machine if used =$5,500

    Let us analyze cash flows

    Year End Machine Value Operating cost Salvage Net cash flow PW of Cn
    n MV OC S Cn=MV+OC+S Cn/(1+10%)^n
    0 ...

    Solution Summary

    Solution describes the steps to decide if the old machine can be replaced with the new one. Calculations are provided in MS Excel format.