Explore BrainMass

Explore BrainMass

    Net Present Value of Eight Projects

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

    (Please see the attached file for the complete problem explanation)
    There are 8 projects and there are two questions that must be asked of all of them:
    1. Assume that the projects are replicable and discount rate is 10%! Choose only one method to rank the projects. Clearly mention why you chose that method and which assumptions you made to choose that method. Remember there are 8 mutually exclusive projects!
    2. Is your method sensitive to discount rate?(use 12% discount rate)

    © BrainMass Inc. brainmass.com June 4, 2020, 4:38 am ad1c9bdddf
    https://brainmass.com/business/financial-ratios/net-present-value-eight-projects-571931

    Attachments

    Solution Preview

    (Please see the attached file for the complete solution in Excel format).

    NPV - 2 ($90.08) ($128.79) ($173.04) ($30.41) ($92.96) ($35.71) $99.35 ($72.25)
    Rank - 2 5 7 8 2 6 3 1 ...

    Solution Summary

    This solution provides examples of the net value present (NPV) for 8 projects.

    $2.19

    ADVERTISEMENT