Explore BrainMass

Explore BrainMass

    Calculating Negative Predictive Value (Statistics)

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

    Modify Acron's model (Excel filed attached) so that development lasts for an extra year. Specifically, assume that development costs of $7.2 million and $2.1 million are incurred at the beginnings of years 1 and 2, and then the sales in the current model occur one year later, that is from year two until year 21. Again, calculate the negative predictive value (NPV) discounted back to the beginning of year 1, and perform the same sensitivity analyses. What are some of the effects of this change in timing?

    © BrainMass Inc. brainmass.com June 3, 2020, 7:00 pm ad1c9bdddf
    https://brainmass.com/statistics/quantative-analysis-of-data/83040

    Attachments

    Solution Preview

    Attached to this answer, you will find the modified Excel sheet you need. I made the following changes:

    - Define range names "Development_cost_Y1" and "Development_cost_Y2", in order to separate the development costs that are incurred in the first year (Y1) and in the second one (Y2)

    - Move the cash flows one ...

    Solution Summary

    This solution includes explanations and calculations for a negative predictive value and same sensitivity analyses.

    $2.19

    ADVERTISEMENT