What is the approximate IRR for a project that cost $200,000 and provide cash inflows of...

What is the approximate IRR for a project that cost $200,000 and provide cash inflows of $40,000 for 6 years.

Please do not use excel

Solutions

Expert Solution

The simple method of calculating IRR without MS Excel is Annuity Table:

Cost of the Project = 200,000

Annual Inflows = 40,000

Life of the Project = 6 years

Step 1: Calculate the payback period of the project

Payback Period = Initial Investment / Annual Inflows

= 200000/40000 = 5 years

Step 2: Now use the Present Value Annuity Table, and locate that at what rate for 6 years, the present value is 5 or around 5.

You will find that at the rate 5%, for 6 years, PV is 5.07569 and at 5.5%, for 6 years, PV is 4.99553. So, it means IRR lies between 5 to 5.5%.

Step 3: Use following formula to calculate exact IRR

= 5.47%

The IRR for the project is 5.47%

Please don't forget to rate, if this solution is really helpful to you. .........

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

IRR A project has an initial cost of $55,000, expected net cash inflows of $11,000 per...

IRR A project has an initial cost of $55,000, expected net cash inflows of $11,000 per year for 10 years, and a cost of capital of 14%. What is the project's IRR? Round your answer to two decimal places.

Internal Rate of Return (IRR) IRR Project L costs $48,422.38, its expected cash inflows are $10,000...

Internal Rate of Return (IRR) IRR Project L costs $48,422.38, its expected cash inflows are $10,000 per year for 10 years, and its WACC is 13%. What is the project's IRR? Round your answer to two decimal places. ——-%

Consider a project with a cost of $1000, with the following expected cash inflows, and a...

Consider a project with a cost of $1000, with the following expected cash inflows, and a WACC of 16%. YEAR 1 $300--Year 2 $400- year 3 $300- Year 4 $500 Show your calculations by way of formulas, numerical values and if you like also by EXCEL for the following. A. Calculate the present value of cash inflows. B. Calculate the net present value of cash inflows. C. Calculate the internal rate of return IRR. D. Calculate the modified internal rate...

A new machine will provide the following net annual cash inflows. If the cost of the...

A new machine will provide the following net annual cash inflows. If the cost of the machine is $12,000, what is the payback period? What is the discounted payback period if the discount rate is 10%? Year Cash Inflow 1 $ 1,345 2. 2,605 3 4,509 4 5,219 5 4,481 6 3,823 7 3,500

A project has an initial cost of $350. The project has annual cash inflows of $200,...

A project has an initial cost of $350. The project has annual cash inflows of $200, $160, $100, and $150, for the next four years, respectively. The discount rate is 25%. What is the discounted payback period of the project? a. the project never pays back b. 1 year c. 2 years d. 3 years e. 4 years

A project has an initial cost of $148,400 and is expected to produce cash inflows of...

A project has an initial cost of $148,400 and is expected to produce cash inflows of $56,500, $69,540, and $97,867 over the next three years, respectively. What is the discounted payback period if the required rate of return is 10 percent? A. 2.12 years B. 2.54 years C. 2.91 years D. 1.88 years

IRR Project L costs $56,993.01, its expected cash inflows are $11,000 per year for 11 years,...

IRR Project L costs $56,993.01, its expected cash inflows are $11,000 per year for 11 years, and its WACC is 11%. What is the project's IRR? Round your answer to two decimal places. %

Calculate the IRR for the following project: a. An initial outflow of $15,220 followed by inflows...

Calculate the IRR for the following project: a. An initial outflow of $15,220 followed by inflows of $5,000, $6,000, and $6,500 b. An initial outflow of $47,104 followed by inflows of $16,000, $17,000, and $18,000.

A project has an initial cost of $14,500 and produces cash inflows of $4,600, $6,100, and...

A project has an initial cost of $14,500 and produces cash inflows of $4,600, $6,100, and $8,500 over the next three years, respectively. What is the discounted payback period if the required rate of return is 15 percent? a. 2.36 years b. 2.45 years c. 2.55 years d 2.62 years e. never

A four year project that has an initial cost of $60,000. The future cash inflows are...

A four year project that has an initial cost of $60,000. The future cash inflows are $40,000 00,$30,000,$20,000, and $10,000, respectively Given this informationwhat what is the IRR for?

Subjects