Question

1. In the more complex situation discussed in the Gapenski article about Monte Carlo simulation, in...

1. In the more complex situation discussed in the Gapenski article about Monte Carlo simulation, in addition to the throughput variable, the following second uncertain variable was analyzed:

a. project horizon

b. discount rate

c. accounts payable

d. salvage value

2. Suppose a project has cash flows of (-20, 5, 16, 5, 9, 2) in years (0, 3, 4, 5, 6, 7) respectively. What is IRR?
a. 53.86%

b. 27.98%

c. 17.32%

d. 14.44%

3. Suppose a project has cash flows of (-20, 5, 16, 5, 9, 2) in years (0, 3, 4, 5, 6, 7) respectively. What is Payback?

a. 6

b. 3

c. 4

d. 2

0 0
Add a comment Improve this question Transcribed image text
Answer #1

2. ANSWER = D)14.44 %

Year Cash flow PVF (14%) PV (14%) PVF (15%) PV (14%)
0 -20 1 -20 1 -20
1 0 0.87719 0 0.86957 0
2 0 0.76947 0 0.75614 0
3 5 0.67497 3.3748576 0.65752 3.287581
4 16 0.59208 9.4732844 0.57175 9.148052
5 5 0.51937 2.5968433 0.49718 2.485884
6 9 0.45559 4.1002789 0.43233 3.890948
7 2 0.39964 0.7992746 0.37594 0.751874
0.3445389 -0.43566

IRR = Where NPV of the project is equal to zero

Using trial and error method, we get

IRR = 14 % + (0.3445389 - 0) / [0.3445389 - (-0.43566)]

= 14 % + 0.4416

= 14.4416 % or 14.44%

3.

ANSWER= C) 4 YEARS

YEAR Cash flow Cumulative cashflow
1 0 0
2 0 0
3 5 5
4 16 21
5 5 26
6 9 35
7 2 37

Payback period = 3 + ( 5 -20 ) / (5-21)

= 3 + 0.9375

= 4 years (approx.)

Add a comment
Know the answer?
Add Answer to:
1. In the more complex situation discussed in the Gapenski article about Monte Carlo simulation, in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. While using Monte Carlo simulation in capital budgeting, if a variable such as the unit...

    1. While using Monte Carlo simulation in capital budgeting, if a variable such as the unit cost of production is relatively certain, one would use a random distribution to simulate its values. True or False? 2. While using Monte Carlo simulation in capital budgeting in the year 2018 circa, if one were to use a personal computer, the following number of random drawings/calculations would probably be appropriate: a. Tens b. Thousands c. Billions d. Trillions

  • 5. Given the loaded (unfair) dice probabilities below, use Monte Carlo simulation to simulate the sum...

    5. Given the loaded (unfair) dice probabilities below, use Monte Carlo simulation to simulate the sum of five rolls of the dice. roll die 1 die 2 | 1 0 .1 0.3 2 0.1 0.1 3 0.2 0.2 4 0.3 0.1 5 0.2 0.05 6 0.1 0.25

  • 3. Gregg wants to analyze the risk of the project using sensitivity analysis and Monte Carlo...

    3. Gregg wants to analyze the risk of the project using sensitivity analysis and Monte Carlo simulation. a. Explain to Baldwin Inc. how the two risk analysis models can be used to analyze risk of the project. 4. Gregg has estimated the fixed costs (including depreciation) of the Ohio project to be $1.5 million, sales price is $130, and the variable cost is $70, giving a contribution margin of $60. What is the break-even quantity for this project? 5. Baldwin...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

  • 1. (10 points A Monte Carlo analysis can be used for optimization. For example, the trajectory...

    1. (10 points A Monte Carlo analysis can be used for optimization. For example, the trajectory of a ball can be computed with 2vo cos2 Go where y is the achieved height in meters (m), 6% is the initial angle (radians), is the horizontal distance (m), g is the gravitational acceleration (-9.81 m/s2), vo is the initial velocity (m/s), and yo is the initial height. Given yo 1 m, vo 25 m/s, and 500 (or T/180 x 50 rad), determine...

  • market premium 5.4 25P20 101 pdf - Adobe Acrobat Reader DC indow Help 5 Chapter 13...

    market premium 5.4 25P20 101 pdf - Adobe Acrobat Reader DC indow Help 5 Chapter 13 - The C.. Engineering-Econo... Interest Tables (Ind.. Excel Problem Set.. * calculations directly in the excer cells.) Question 4 (based on Chapter 12) Angola Superheros, Inc. is considering launching a production of a new superhero toy. The production and sales are expected to last 4 years. The project would require a new machine, with a cost of $1,000,000. The machine would be depreciated using...

  • Suppose your firm is considering investing in a project with the cash flows shown below, that...

    Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 9 percent, and that the maximum allowable payback and discounted payback statistics for the project are 2.0 and 3.0 years, respectively. Time: 0 1 2 3 4 5 6 Cash flow: –$4,700 $1,130 $2,330 $1,530 $1,530 $1,330 $1,130 Use the discounted payback decision rule to evaluate this project. (Round your answer to...

  • Assignment Specifications We are going to use the Monte Carlo Method to determine the probability of...

    Assignment Specifications We are going to use the Monte Carlo Method to determine the probability of scoring outcomes of a single turn in a game called Pig. Your Task For this assignment you will simulate a given number of hold?at?N turns of a game called Pig, and report the estimated probabilities of the possible scoring outcomes. You are NOT implementing the game of Pig, only a single turn of this game. The value of N will be acquired via user...

  • Suppose your firm is considering investing in a project with the cash flows shown below, that...

    Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 13 percent, and that the maximum allowable payback and discounted payback statistic for the project are 2 and 3 years, respectively. Use the payback decision rule to evaluate this project; should it be accepted or rejected? Suppose your firm is considering investing in a project with the cash flows shown below, that...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT