Question

Maxwell Feed & Seed is considering a project that has the following cash flow data. What...

Maxwell Feed & Seed is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be less than the WACC (and even negative), in which case it will be rejected.

Year 0 1 2 3 4 5
Cash flows -$6,750 $2,000 $2,025 $2,050 $2,075 $2,100
a. 15.61%
b. 17.17%
c. 13.74%
d. 12.96%
e. 15.45%

Homework Answers

Answer #1
Year Cash flows
0 -6750
1 2000
2 2025
3 2050
4 2,075
5 2100

Method 1: IRR Calculation using ba ii plus calculator

Input the following values in a ba ii plus calculator

CF0 = -6750

C01 = 2000, F01 = 1

C02 = 2025, F02 = 1

C03 = 2050, F03 = 1

C04 = 2075, F04 = 1

C05 = 2100, F05 = 1

IRR -> CPT [Press IRR and then press CPT]

we get, IRR = 15.6104758

IRR = 15.61%

Method 2: IRR calculation using Excel

We can calculate the IRR of a project using the IRR function in Excel as shown below:

=IRR(B2:B7) = 15.61%

IRR = 15.61%

Answer -> 15.61% (Option a)

Know the answer?
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
Similar Questions
Maxwell Feed & Seed is considering a project that has the following cash flow data. What...
Maxwell Feed & Seed is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be less than the WACC (and even negative), in which case it will be rejected. Year 0 1 2 3 4 5 Cash flows -$6,750 $2,000 $2,025 $2,050 $2,075 $2,100 a. 13.74% b. 12.96% c. 15.45% d. 17.17% e. 15.61%
Maxwell Feed & Seed is considering a project that has the following cash flow data. What...
Maxwell Feed & Seed is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be less than the WACC (and even negative), in which case it will be rejected. Year 0 1 2 3 4 5 Cash flows -$6,750 $2,000 $2,025 $2,050 $2,075 $2,100 a. 15.61% b. 17.17% c. 12.96% d. 15.45% e. 13.74%
Maxwell Feed & Seed is considering a project that has the following cash flow data. What...
Maxwell Feed & Seed is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be less than the WACC (and even negative), in which case it will be rejected. Year 0 1 2 3 4 5 Cash flows −$9,500 $2,000 $2,025 $2,050 $2,075 $2,100 a. 2.31% b. 2.82% c. 3.10% d. 2.08% e. 2.57%
Boca Center Inc. is considering a project that has the following cash flow and WACC data....
Boca Center Inc. is considering a project that has the following cash flow and WACC data. What is the project's NPV? Note that a project's expected NPV can be negative, in which case it will be rejected. WACC: 14.00% Year 0 1 2 3 4 Cash flows -$1,200 $400 $425 $450 $475 Group of answer choices 62.88 41.25 45.84 50.93 56.59 103.95 110.02 36.65 Flag this Question Question 123.13 pts Maxwell Feed & Seed is considering a project that has...
Siblene Penn is considering a project that has the following cash flow data. What is the...
Siblene Penn is considering a project that has the following cash flow data. What is the discounted payback using a 11.2% cost of capital? Year 0 1 2 3 4 5 Cash flows -$6,750 $2,000 $2,025 $2,050 $2,075 $2,100
Siblene Penn is considering a project that has the following cash flow data. What is the...
Siblene Penn is considering a project that has the following cash flow data. What is the discounted payback using a 11.2% cost of capital?      Year 0 1 2 3 4 5 Cash flows -$6,750 $2,000 $2,025 $2,050 $2,075 $2,100 a. 3.88 years b. 3.33 years c. 4.38 years d. 4.67 years e. 3.62 years
Datta Computer Systems is considering a project that has the following cash flow data. What is...
Datta Computer Systems is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be less than the WACC (and even negative), in which case it will be rejected. Year       0   1 2 3   Cash flows          -$1,050 $450      $470      $490
Kiley Electronics is considering a project that has the following cash flow data. What is the...
Kiley Electronics is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's IRR can be less than the WACC (and even negative), in which case it will be rejected. Year 0 1 2 3 Cash Flows -$1,100 $250 $470 $490
Sam Corp. is considering a project that has the following cash flow data.  What is the project's...
Sam Corp. is considering a project that has the following cash flow data.  What is the project's IRR (Internal Rate of Return)? Note that a project's projected IRR can be less than the weighted average cost of capital (WACC) or negative, in both cases it will be rejected. Show work. Year                           0                1                2               3           4   Cash flows            -$1,900        $600          $825           $950   -$50 Helmand Inc. is considering a project that has the following cash flow and WACC data.  What is the project's MIRR?  Note that a project's projected MIRR can be less than...
Kiley Electronics is considering a project that has the following cash flow data. What is the...
Kiley Electronics is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's IRR can be less than the cost of capital (and even negative), in which case it will be rejected. Year 0 1 2 3 Cash flows −$1,100 $450 $470 $490