a)
Nper = 10
PMT = 50000
PV = 304600
FV = 0
IRR can be calculated by using the following excel
formula:
=RATE(nper,pmt,pv,fv)
=RATE(10,50000,-304600,0)
= 10.20%
IRR = 10.20%
b)
Rate = 11%
PMT = 50000
PV = 304600
FV = 0
Number of years can be calculated by using the following excel
formula:
=NPER(rate,pmt,pv,fv)
=NPER(11%,50000,-304600,0)
= 10.63 years
Additional years = 10.63 - 10 = 0.63 years
c)
Nper = 10
PV = 304600
Rate = 11%
FV = 0
Annual cash flow can be calculated by using the following excel
formula:
=PMT(rate,nper,pv,fv)
=PMT(11%,10,-304600,0)
= $51,721.51
Annual cash flow = $51,721.51
IRR, investment life, and cash inflows Oak Enterprises accepts projects earning more than the firm's 11%...
?IRR, investment? life, and cash inflows???Oak Enterprises accepts projects earning more than the? firm's 12?% cost of capital. Oak is currently considering a 12?-year project that provides annual cash inflows of ?$30,000 and requires an initial investment of ?$242,800. ? (?Note: All amounts are after? taxes.) a.??Determine the IRR of this project. Is it? acceptable? b.??Assuming that the cash inflows continue to be ?$30,000 per? year, how many additional years would the flows have to continue to make the project...
(NPV, PI, and IRR calculations) You are considering two independent projects, project A and project B. The initial cash outlay associated with project A is $50,000 and the initial cash outlay associated with project B is $70,000. The required rate of return on both projects is 11 percent. The expected annual free cash inflows from each project are on the table below. Calculate the NPV, PI, and IRR for each project and indicate if the project should be accepted. Project...
(NPV, PI, and IRR calculations) You are considering two independent projects, project A and project B. The initial cash outlay associated with project A is $50,000 and the initial cash outlay associated with project B is $70,000. The required rate of return on both projects is 11 percent. The expected annual free cash inflows from each project are on the table below. Calculate the NPV, PI, and IRR for each project and indicate if the project should be accepted. Project...
Important: Show your solutions! QUESTION 1: Consider the following two projects: Year Cash Flow (A) Cash Flow (B) -$364,000 -$52,000 25,000 46,000 68,000 22,000 68,000 21,500 458,000 17,500 Whichever project you choose, if any, you require a return of 11 percent on your investment. 1) Suppose these two projects are independent. Which project(s) should you accept based on: a. The Payback rule? Explain. (1096) b. The Profitability Index rule? Explain. (10%) c. The IRR rule? Explain. (10%) d. The NPV...
2. Internal rate of return (IRR) The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front cost and subsequent cash flows. Consider the case of Blue Uama Mining Company: Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Sigma) that will require an initial investment of $900,000. Blue Llama Mining Company has been basing capital budgeting decisions on a project's NPV; however its new CFO...
(NPV, PI, and IRR calculations) You are considering two independent projects, project A and project B. The initial cash outlay associated with project A is $55,000, and the initial cash outlay associated with project B is $75,000. The required rate of return on both projects is 10 percent. The expected annual free cash inflows from each project are in the popup window: PROJECT A PROJECT B Initial Outlay -55,000 -75,000 Inflow year 1 16,000 17,000 Inflow year 2 16,000 ...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR. Consider the following situation: Blue Llama Mining Company is analyzing a project that requires an initial investment of $400,000. The...
Axis Corp. is considering an investment in the best of two mutually exclusive projects. Project Kelvin involves an overhaul of the existing system; it will cost $35,000 and generate cash inflows of $20,000 per year for the next 3 years. Project Thompson involves replacement of the existing system; it will cost $220,000 and generate cash inflows of $50,000 per year for 6 years. Using a cost of capital of 11%, calculate each project's NPV, and make a recommendation based on...
IRR—Mutually exclusive projects Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table: . The firm's cost of capital is 12%. a. Calculate the IRR for each of the projects. Assess the acceptability of each project on the basis of the IRRs. b. Which project is preferred? 0 Data Table a. The internal rate of return (IRR) of...
4. Internal rate of return (IRR) The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front cost and subsequent cash flows. Consider the case of Blue Llama Mining Company: Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Sigma) that will require an initial investment of $800,000. The company has been basing capital budgeting decisions on a project's NPV; however, its new CFO wants to...