Explore BrainMass

Explore BrainMass

    Project NPV Scenario Analysis

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

    Scenario Analysis. The most likely outcomes for a particular project are estimated as follows :

    Unit price: $50
    Variable cost: $30
    Fixed cost: $300,000
    Expected sales: 30,000 units per year

    However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10 percent higher or 10 percent lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1 million, which will be depreciated straight-line over the project life to a final value of zero. The firm's tax rate is 35 percent and the required rate of return is 12 percent. What is project NPV in the "best-case scenario," that is, assuming all variables take on the best possible value? What about the worst-case scenario?

    © BrainMass Inc. brainmass.com October 9, 2019, 8:09 pm ad1c9bdddf

    Solution Preview

    See the attached file (Excel file). The solution pasted here is not complete. You can see the formulas in cell in excel file.

    First of all make the Normal Projections
    Year Initial Investment Sales Revenue Variable Cost Fixed Cost Depreciation Taxable Income Tax Net Cash Flow ...

    Solution Summary

    The solution examines project NPV scenario analysis.