Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5. Conduct a probabilistic sensitivity analyses of the following project. But change the MARR to 20% The project life is 7 years and the MARR

image text in transcribed
image text in transcribed
5. Conduct a probabilistic sensitivity analyses of the following project. But change the MARR to 20% The project life is 7 years and the MARR is 15%. The initial investment is given by a uniform distribution between $200,000 and $300,000. The annual profit is given by a triangular distribution that has a minimum value of $55,000/year, a mode of $67,500/year, and a maximum value of $85,000/year. The salvage value of the investment is given by a triangular distribution that has a minimum value of $60,000, a mode of $75,000, and a maximum value of $85,000. a. Complete the table page 4. b. Create cumulate probability curves for the IRR and NPV. salvage NPV IRR (%) Interation 1 investment profit 290535 76502 71086 2 217583 81539 73882 3 225745 69517 70203 4 213054 81820 69588 5 212821 79453 Random# 0.90535 0.86245 0.32775 0.17583 0.97718 0.51387 0.25745 0.54338 0.27762 0.13054 0.98074 0.24362 0.12821 0.94139 0.85951 0.76882 0.7251 0.34264 0.57665 0.87442 0.57899 0.15276 0.27172 0.38432 0.20103 0.82686 0.25673 0.93764 0.86922 0.3435 79074 6 276882 72987 71335 7 257665 76880 74735 8 215276 65094 72005 9 220103 75466 69812 10 293764 76714 71350

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Principles And Issues

Authors: Michael H. Granof, Philip W. Bell

4th Edition

013321852X, 978-0133218527

More Books

Students also viewed these Accounting questions

Question

How did Spinoza and Descartes challenge beliefs in witchcraft?

Answered: 1 week ago