Explore BrainMass
Share

Explore BrainMass

    sensitivity analysis

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

    Determine the break even point and present worth on the cost of good sold. Thank you.

    ** Please see the attached file for the complete solution response **

    © BrainMass Inc. brainmass.com October 10, 2019, 3:24 am ad1c9bdddf
    https://brainmass.com/economics/break-even-analysis/sensitivity-analysis-cost-of-goods-sold-419247

    Attachments

    Solution Preview

    I have attached an excel spreadsheet.

    For the first part of the sensitivity analysis, look at the equation in the Cost of Goods Sold box D15 through M15. The equation takes the negative 67% of the sales revenue. In order to conduct the sensitivity analysis on 60%, 65%, and 70%, change the value in all of these boxes and observe the change in present worth in box C26.
    To see what I mean, look at Sheet 2 of the document, where I changed the values to 65%, and the present worth ...

    Solution Summary

    This posting presents sensitivity analysis clearly.

    $2.19