Explore BrainMass

Explore BrainMass

    Project Valuation and Analysis

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    5. Project Valuation and Analysis: Suppose a new machine costs $59,000 today. It will yield $11,000 in after-tax savings each year for 7 years and you sell the machine for $4,000 in the 7th year.
    a. Given an opportunity cost of capital of 8%, what is the NPV of this project?

    b. What is the IRR of this project?

    c. What is the payback period for this project?

    d. What is the discounted payback period for this project?

    e. What is the profitability index for this project?

    In excel format

    © BrainMass Inc. brainmass.com November 24, 2021, 6:01 pm ad1c9bdddf

    Solution Preview

    Cost of new machine $59,000
    After-tax savings $11,000 per year
    Term (years) 7
    Salvage value $4,000

    Opportunity cost 8%
    NPV=(After-tax savings*(1-(1/(1+Opportunity cost)^term)))/Opportunity cost)+(Salvage value/(1+opportunity cost)^term)-Cost of new ...

    Solution Summary

    IRR, payback period, discounted payback period and profitability index for a project are worked out in Excel.