Question

For CB output, you should paste the forecast output in your Excel calculations file. Show the split view in all CB output.

1.   Two investments (A and B, below) have been proposed to the Capital Investment committee of your organization;

a.      The required rate of return for your company is 15%. What is the NPV for each investment? Assume the initial investments ($150k and $50k) occur at the beginning of the year and all other costs and benefits occur at the end of the year indicated. Ignore inflation.

b.     What is the payback period for each investment?

c.      Which investment would you recommend and why?

d.     Why might you recommend the other investment?

Investment A	Year 1	Year 1	Year 2	Year 3	Year 4	Year 5
Costs:	$150,000	$5,000	$5,000	$5,000	$5,000	$5,000
Benefits:	-	$75,000	$55,000	$35,000	$20,000	$65,000
Investment B	Year 1	Year 1	Year 2	Year 3	Year 4	Year 5
Costs:	$50,000
Benefits:		$30,000	$15,000	$10,000	$10,000	$15,000

2.     Unfortunately, the Capital Investment Committee refused to approve your recommendation (Problem 1) since you did not consider the uncertainty inherent in these types of investments. You pull out your very dog-eared notes from PMAN 635 and repeat your analysis, this time using Crystal Ball and the following information:

Investment A:

                                                    i.     Year 0 Investment cost: Triangular distribution (optimistic: $125,000; most likely: $150,000; pessimistic: $200,000)

                                                  ii.     Year 1-5 operating cost: Normal distribution (mean of $5,000, standard deviation of $500)

                                                iii.     Year 1 Benefits: Normal distribution (mean of $75,000, standard deviation of $20,000)

                                                iv.     Year 2 Benefits: Normal distribution (mean of $55,000, standard deviation of $15,000)

                                                  v.     Year 3 Benefits: Normal distribution (mean of $35,000, standard deviation of $10,000)

                                                vi.     Year 4 Benefits: Normal distribution (mean of $20,000, standard deviation of $5000)

                                               vii.     Year 5 Benefits: Uniform distribution (Minimum: $60,000; Maximum: $70,000)

Investment B:

                                             viii.     Year 0 Investment cost: Uniform distribution (Minimum: $40,000; Maximum: $60,000)

                                                ix.     Year 1 Benefits: Normal distribution (mean of $30,000, standard deviation of $3,000)

                                                  x.     Year 2 Benefits: Normal distribution (mean of $15,000, standard deviation of $5,000)

                                                xi.     Year 3 Benefits: Normal distribution (mean of $10,000, standard deviation of $3,000)

                                               xii.     Year 4 Benefits: Normal distribution (mean of $10,000, standard deviation of $3,000)

                                             xiii.     Year 5 Benefits: Normal distribution (mean of $15,000, standard deviation of $5,000)

a.      If the IRR is still 15%, use Crystal Ball to calculate the median NPV for each investment. Would you still prefer the same investment you recommended in question 1.c?

b.      What is the probability that Investment B will be better than Investment A (financially)?

Be sure to show all work.

3.     Using the forward and backward pass method, identify the Critical Path and total duration for the following network. Show all work.

Task	Duration	Predecessor
a	5
b	10	a
c	10	a
d	3	b
e	5	c
f	10	d, e

Answer 1

An answer to part 1

subpart a.

subpart b.

subpart c.

Investment B would be recommended over Investment A, the reason being IRR on investment B is higher as compared to Investment A. Whenever we select a project we select it on the basis of IRR, not on the basis of NPV, the reason being NPV does not shows the effect of initial cash outflow in a particular project. subpart d. Other investment would be suggested on the basis of it's of IRR, payback period. Higher the IRR and earlier payback period makes a particular project more attractive and more profitable for the company.