Explore BrainMass

Explore BrainMass

    NPV and IRR for SBS Automated Materials-Handling System

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

    SBS Automated Materials-Handling System
    Skanda Business Solution., (SBS) is an established manufacturer of microwavable frozen foods. In a bid to control costs and increase efficiency at its Western Plant, SBS is considering acquiring an automated materials-handling system. The plan involves replacing the current stock of forklift trucks with a computer-controlled conveyor belt system that feeds directly into the refrigeration units. This automation will eliminate the need for a number of personnel in the materials-handling department, and it will increase the output capacity of the plant.

    Automated Materials-Handling System Projections
    Projected useful life 10 years
    Purchase and installation of equipment $4,500,000
    Working capital investment required 1,000,000
    Increase in annual operating costs (exclusive of depreciation) 200,000
    Equipment repairs to maintain productive efficiency (end of year 5) 800,000
    Increase in annual sales revenue 700,000
    Reduction in annual manufacturing costs 500,000
    Reduction in annual maintenance costs 300,000
    Estimated salvage value of automated materials-handling system at end of useful life 850,000

    The forklift trucks currently have a net book value of $500,000. They are being depreciated on a straight-line basis with a 5-year remaining useful life and zero salvage value. If the Automated Materials-Handling System were purchased now, the forklifts could be sold today for $100,000.

    The equipment for the automated materials-handling system will be depreciated over 10-year useful life, also by the straight-line method, but assuming a salvage value of $850,000. (Disregard the half-year convention and assume a full yearâ??s depreciation is recorded in each of the 10 years.) SBS uses the same depreciation methods and assumptions both for book purposes and for tax purposes, so there are no deferred taxes. SBS has a 40% tax rate. For purposes of this analysis, assume that all cash flows and the related tax effects from the initial investment (acquisition of the new system and disposal of the old equipment) occur immediately. All other cash flows and tax effects are assumed to occur at the end of each period.

    1. Assume that SBS requires a minimum return of 12% on any capital investment. Determine the Net Present Value (NPV) of this proposal.
    2. Compute the Internal Rate of Return (IRR) for this proposal.
    3. Should SBS undertake this project?

    © BrainMass Inc. brainmass.com June 4, 2020, 12:44 am ad1c9bdddf

    Solution Summary

    This solution provides the calculations for NPV in an attached Word document.