Question

In: Finance

You have just started your summer? internship, and your boss asks you to review a recent...

You have just started your summer? internship, and your boss asks you to review a recent analysis that was done to compare three alternative proposals to enhance the? firm's manufacturing facility. You find that the prior analysis ranked the proposals according to their? IRR, and recommended the highest IRR? option, Proposal A. You are concerned and decide to redo the analysis using NPV to determine whether this recommendation was appropriate. But while you are confident the IRRs were computed? correctly, it seems that some of the underlying data regarding the cash flows that were estimated for each proposal was not included in the report. For Proposal? B, you cannot find information regarding the total initial investment that was required in Year 0. And for Proposal? C, you cannot find the data regarding additional salvage value that will be recovered in Year 3. Here is the information you have? (in $? millions):

Proposal

IRR

Year 0

Year 1

Year 2

Year 3

A

60.0 %

negative $ 100

$ 30

$ 153

$ 88

B

57.3 %

question mark?

$ 0

$ 206

$ 95

C

55.8 %55.8%

negative $ 100

$ 37

$ 0

$204+?

a. Fill in the missing values.

b. Suppose the appropriate cost of capital for each alternative is

10 %

Using this? information, determine the NPV of each proposal. Which project should the firm?choose?

c. Can the IRR rule be used in this? situation? Justify.

Solutions

Expert Solution

IRR is the rate of return that makes initial investment equla to present value of cash inflows

a)

Proposal B:

Initial investment = 0 + 206 / ( 1 + 0.573)2 + 95 / ( 1 + 0.573)3

Initial investment = 0 + 83.254895 + 24.408295

Initial investment = $107.67

Proposal C:

100 = 37 / ( 1 + 0.558) + 0 + 204 / ( 1 + 0.558)3 + X / ( 1 + 0.558)3

100 = 23.748395 + 0 + 53.942095 + X/ 3.781833

22.30951 = X/ 3.781833

X = 84.3708

Salvage value is $84.307

b)

NPV = Present value of cash inflows - present value of cash outflows

NPV of project A = -100 + 30 / ( 1 + 0.1)1 + 153 / ( 1 + 0.1)2 + 88 / ( 1 + 0.1)3

NPV of project A = $119.8347

NPV of project B = -107.67+ 0 + 206 / ( 1 + 0.1)2 + 95 / ( 1 + 0.1)3

NPV of project B = $133.953

NPV of project C = -100 + 37 / ( 1 + 0.1)1 + 0 + 204 / ( 1 + 0.1)3 + 84.307 / ( 1 + 0.1)3

NPV of project C = $150.294

As per NPV method, we should choose project C as it has the highest NPV.

c)

When the projects are mutually exclusive projects, we always go by the NPV rule.

NPV of project C = $133.953


Related Solutions

You have just started your summer internship, and your boss asks you to review a recent...
You have just started your summer internship, and your boss asks you to review a recent analysis that was done to compare three alternative proposals to enhance the firm's manufacturing facility. You find that the prior analysis ranked the proposals according to their IRR and recommended the highest IRR option, Proposal A. You are concerned and decide to redo the analysis using NPV to determine whether this recommendation was appropriate. But while you are confident the IRRs were computed correctly,...
You have just landed your dream summer internship, and your boss asks you to analyze a...
You have just landed your dream summer internship, and your boss asks you to analyze a project that has an investment cost of $2,000,000, to be paid today (t = 0), and will generate a cash-flow of $200,000 in the first year (t = 1). The cash-flow will then grow at 10% per year for the next six years (the last time the cash-flow grows at 10% is from t = 6 to t = 7). Afterwards, as competition increases,...
You have just landed your dream summer internship, and your boss asks you to analyze a...
You have just landed your dream summer internship, and your boss asks you to analyze a project that has an investment cost of 3,500,000, to be paid today (t = 0), and will generate a cash-flow of 350,000 in the first year (t = 1). The cash-flow will then grow at 12% per year for the next eight years (the last time the cash-flow grows at 12% is from t = 8 to t = 9). Afterwards, as competition increases,...
Using Python You just started your summer internship with NU Bank as part of its growing...
Using Python You just started your summer internship with NU Bank as part of its growing development team. Your first assignment is to design and build two classes that are to be utilized in both the banks website and internal applications. The first is a loan class representing a loan contract. The second is a customer class representing the individual receiving the loan. You will be building the business logic classes, so you don’t have to worry about forms for...
You have just started an internship with Frode Laursen and you have spent your first day...
You have just started an internship with Frode Laursen and you have spent your first day together with a Key Account Manager (KAM), who handles transactions with three different customer segments (A, B and C). He proudly tells you that his focus is on serving the A customers since they yield the highest contribution margin per transaction. Then come the B customers, and if there is time left, he also serves the C customers. Upfront, his argument sounds logical, but...
You have just begun your summer internship at Tmedic. The company supplies sterilized surgical instruments for...
You have just begun your summer internship at Tmedic. The company supplies sterilized surgical instruments for physicians. To expand sales, Tmedic is considering paying a commission to its sales force. The controller, Jane Hewitt, asks you to compute (1) the new breakeven sales figure and (2) the operating profit if sales increase 15% under the new sales commission plan. She thinks you can handle this task because you learned CVP analysis in your accounting class.                 You spend the next...
Your boss asks you to review an option to lease an equipment storage facility that the...
Your boss asks you to review an option to lease an equipment storage facility that the firm needs. You are to compare it with the purchase of the facility. The following information are pertinent to your decision:   a) The facility will be needed for nine years     b) If the facility is leased, the lessor will conduct all maintenance; if purchased, your firm must conduct maintenance c) Facility maintenance is expected to cost $66000 per year   d) The cost to lease...
You have an internship this summer for the Cook County Department of Public Health. Your job...
You have an internship this summer for the Cook County Department of Public Health. Your job is to work with the West Nile Virus group. You need to identify possible reservoirs, vectors, and determine how many people have been infected this year. Discuss which three types of organisms you will be examining and why.
You have just passed ACST1001 and started a summer internship at Harrison Bank, with Peter as your supervisor. As your first task, Peter has given you some client accounts and asked you to verify some of the details.
You have just passed ACST1001 and started a summer internship at Harrison Bank, with Peter as your supervisor. As your first task, Peter has given you some client accounts and asked you to verify some of the details.The first file is for a client named Mary, who has a mortgage with the bank. You go through the file and note the following information for Mary's mortgageInitial loan: $640,000Term of loan: 25 yearsRepayment frequency. End of each fortnightInterest rate on loan:...
You apply for a summer internship with a startup company, and your chance of getting an...
You apply for a summer internship with a startup company, and your chance of getting an offer is 80% if you well prepare for an interview. Otherwise, you will only get 20% chance for an offer. Suppose that the likelihood of your preparation going well is 30%. What is the probability that you get the internship?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT