Question

Proposal Year 0 Year 3 IRR Year 1 Year 2 60.0% $30 $153 $88 A -$100 $206 $95 55.6% $37 50.2% -$100 S0

Find the missing values and calculate NPV for proposals A, B, and C. What proposal should be chosen?

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

Proposal A has all the values

Proposal B:

IRR is the rate of return that makes Cash outflow equal to present value of cash inflow

Year 0 = 0 + 206 / (1 + 0.556)2 + 95 / (1 + 0.556)3

Year 0 = 0 + 85.08 + 25.217

Year 0 = -$110

Proposal C:

100 = 37 / (1 + 0.502)1 + 0 + Year 3 / (1 + 0.502)3

100 = 24.634 + Year 3 / 3.38852

Year 3 = 255

Discount rate is missing in the question. If you have the discount rate, please put it in comments

NPV:

Proposal A:

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

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

NPV = -100 + 27.27 + 126.45 + 66.12

NPV = $120

Proposal B:

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

NPV = -110 + 0 / (1 + 0.1)1 + 206 / (1 + 0.1)2 + 95 / (1 + 0.1)3

NPV = -110 + 0 + 170.25 + 71.37

NPV = $132

Proposal C:

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

NPV = -100 + 37 / (1 + 0.1)1 + 0 / (1 + 0.1)2 + 255 / (1 + 0.1)3

NPV = -100 + 33.64 + 0 + 191.59

NPV = $125

Proposal B should be chosen as it has the highest NPV

Add a comment
Know the answer?
Add Answer to:
Find the missing values and calculate NPV for proposals A, B, and C. What proposal should be chosen? Proposal Year 0 Ye...
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
  • You have just started your summer​ internship, and your boss asks you to review a recent analysis that was done to compa...

    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,...

  • Ans: a) IRR=33.33% b)please solve b with calculations details (16.16%) c) The initial pro should be...

    Ans: a) IRR=33.33% b)please solve b with calculations details (16.16%) c) The initial pro should be chosen as it has a higher IRR d)Please draw the graph to show where is cross over rate e)Please solve f)Please explain 4. (40%) You have two office-block proposals. You initially intended to invest $300,000 in the building and then sell it at the end of the year for $400,000. Under the revised proposal, you planned to rent out the offices for 3 years...

  • 1. Calculate the net present value (NPV) for both projects, and determine which project should be...

    1. Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar. 2. Calculate the internal rate of return (IRR) for both projects, and determine which project should be accepted based on IRR. 3. Calculate the net present value (NPV) for both projects using the crossover rate as your discount rate. Round both NPVs to the nearest dollar. Please show all work. Thank you. Use...

  • Year 0 Year 1 Year 2 Year 3 Year 4 Cashflow for S -100 40 50...

    Year 0 Year 1 Year 2 Year 3 Year 4 Cashflow for S -100 40 50 30 30 Cashflow for L -100 10 10 50 90 WACC NPV(S) NPV(L) 5% 10% 15% 20% 25% Which of the following statements is correct? (Hint: complete the NPV profile) a. The crossover rate should be larger that 20% b. The crossover rate should be smaller that 5% c. The crossover rate should be between 5% and 10% d. If the WACC is smaller...

  • (NPV calculation​) Calculate the NPV given the following free cash​ flows, YEAR   CASH FLOWS 0   -50...

    (NPV calculation​) Calculate the NPV given the following free cash​ flows, YEAR   CASH FLOWS 0   -50,000 1   30,000 2   30,000 3   30,000 4   -30,000 5   30,000 6   30,000 if the appropriate required rate of return is 12 percent. Should the project be​ accepted? What is the​ project's NPV​?

  • This assignment supports the following objectives: Calculate IRR, NPV and Payback Period Analyze the cash flows...

    This assignment supports the following objectives: Calculate IRR, NPV and Payback Period Analyze the cash flows generated by mutually exclusive projects Formulate a recommendation using IRR, NPV and Payback Period as the criteria Background Suppose that your firm is considering the following two mutually exclusive projects. Both projects have the same initial cost of $312,500 and the resulting annual cash flows for the first five years are as shown in the table below: Year Alpha Beta 0 $ (312,500) $...

  • 1) Suppose that you calculate the NPV of a project, and obtain a value of $100...

    1) Suppose that you calculate the NPV of a project, and obtain a value of $100 million dollars. After completing your analysis, you find out that the corporate tax rate will change from 40% to 30%. If nothing else changes, what is the effect of this tax change on the NPV you had calculated? Assume that your company has no debt. a) The new NPV will be lower than $100 b) The new NPV will be higher than $100 c)...

  • Calculate the missing values on the chart: Replace all the “?” marks. F A B C...

    Calculate the missing values on the chart: Replace all the “?” marks. F A B C D E Calculate the missing values: replace all the ? Production and Cost Functions B C D Wage = 6 E AFC MC MPTPLAPVCI 0 0 - 16 ? 2.0 4 2.0 5 2. 3 .0 5.5 23 28 1.1 2.0 3.1 GWN- 16 7 0.6 LE22.1 - 20 4.0 40 2.0 2 6 3.8 36 0.4 1.6 Immo-ID888888 25 7 3 .6 ?...

  • Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year....

    Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the year Lemon Baker​, staff analyst at Hafners​ is preparing an analysis of the three projects under consideration by Corey Hafners​, the​ company's owner. Projected cash outflow   Project A Project B Project C Net initial investment $3,000,000 $2,100,000 $3,000,000 Projected cash inflows Year 1 $1,200,000 $1,200,000 $1,700,000 Year 2 1,200,000 600,000 1,700,000 Year 3 1,200,000 500,000...

  • Your firm is considering two projects with the following cash flows: Cash flows from project B...

    Your firm is considering two projects with the following cash flows: Cash flows from project B (£000) (500) 200 250 170 25 30 Year Cash flows from project A (£000) 0(500) 167 180 160 100 100 4 1. Calculate the ARR and payback rule 2. If the appropriate discount rate is 12%, rank the two projects 3. Which project is preferred if you rank by IRR? 4. Calculate the discount rate (r) for which the NPVs of both projects are...

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