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
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.)
1. In the more complex situation discussed in the Gapenski article about Monte Carlo simulation, in...
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 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 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 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 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 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 - 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 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 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 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...