Year Cash Flow PV Factor Present Value
0 (500) 1 (500)
1 600 .8333 500
2 300 .6944 208
3 300 .579 174
4 200 .482 96
5 (1000) .402 (402)
NPV 76
Since NPV(Net present value is positive the investment in project should be done.
Compute the sum of the two IRRs 4. The following cash-flow pattern has two IRRs. Use...
Please use excel, need help with functions because I am only used to using a financial calculator, thanks! The following cash-flows have two IRRs. Draw a graph of the NPV of these cash flows as a function of the discount rate. Then use the IRR function to identify the two IRRs. Would you invest in this project if the opportunity cost were 20%? Year Cash Flow 0 -500 1 600 2 300 3 300 4 200 5 -1,000
Geraldine Consultants, Inc. is considering a project that has the following cash flows: Year Cash Flow 0 -$1,000 1 400 2 300 3 500 4 400 The company's WACC is 10%. What are the project's payback, internal rate of return, and net present value? Select one: a. Payback = 2.6, IRR = 21.22%, NPV = $300. b. Payback = 2.4, IRR = 21.22%, NPV = $260. c. Payback = 2.6, IRR = 24.12%, NPV = $300. d. Payback = 2.4,...
Acme Oscillators is considering an investment project that has the following rather unusual cash flow pattern. Year Cash Flow 0 $100 1 −460 2 791 3 −602.6 4 171.6 a. Calculate the project's NPV at each of the following discount rates: 0%, 5%, 10%, 20%, 30%, 40%, 50%. b. What do the calculations tell you about this project's IRR? The IRR rule tells managers to invest if a project's IRR is greater than the cost of capital. If Acme Oscillators'...
4. Consider a ten-year project with an after-tax cash flow of $11 in year t=1. You expect a constant growth rate of g=10% for the next ten years. The initial outflow is $100 in year t=0. (a) What is the internal rate of return (IRR) on the project? (b) According to the IRR rule, would you invest in this project at a cost of capital equal to 5%? (c) A project can have only one NPV but multiple IRRs. True...
Acme Oscillators is considering an investment project that has the following rather unusual cash flow pattern. Year Cash Flow 0 $100 1 −460 2 791 3 −602.6 4 171.6 a. Calculate the project's NPV at each of the following discount rates: 30%, 40%, 50%. b. What do the calculations tell you about this project's IRR? The IRR rule tells managers to invest if a project's IRR is greater than the cost of capital. If Acme Oscillators' cost of capital is...
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...
Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year....................0.............1............2............IRR Cash Flow......($200).....$850....($700)......15% What is the best decision for Project Theta (accept or reject) if the project’s required rate of return is 15% and why? a. Accept the project because the payback is short b. Accept the project because the NPV is greater than zero c. Reject the project because the IRR is less than the required rate of return d. Reject the project because...
11. Beta Co. is considering two mutually exclusive projects to invest in per the Cash Flows and IRRs below. The Discount Rate (MARR) for Beta Corp. is 18% APR compounded annually. Project #1 Year Cash Flow -$14,000 +$17,000 +$1,400 IRR: 29.17% Project #2 Y ear: Cash Flow: IRR: -$10,000 +$13,000 +S400 33.01% Which of the two Projects (if any) should Beta invest in? (Show your work and the basis for your answer. No credit for answer only!) (5 Pts)
Compute the Modified IRR (MIRR) of the following cash flow schedule using the =IRR( ) Excel function Why is your answer different than in Q4? What are you assuming about the company's project? The discount rate is 11.9% Time 0 1 2 3 4 5 6 CFs -200 -100 0 120 120 120 100
16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present Value (NPV) if the required rate of return is 12% per year? Period Cash Flow 0 $0 1 $100 2 $200 3 $300 4 $400 5 $500 Remember that Excel’s NPV function doesn't really calculate the net present value. Instead, it simply calculates the present value of...