Question

compute the MIRR statistic for project I if the appropriate cost of capital is 13 percent...

compute the MIRR statistic for project I if the appropriate cost of capital is 13 percent (Do not round intermediate calculations and round your final answer to 2 decimal places)

Project I
Time 0 1 2 3 4
Cash flow -$11,500 $5,580 $4,430 $1,770 $2,250
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #2

MIRR is   11.79%

Working:

Year Cash Flow
0    $ -11,500.00
1    $     5,580.00
2    $     4,430.00
3    $     1,770.00
4    $     2,250.00
Finance rate 13%
Reinvestment rate 13%
MIRR =mirr(B2:B6,finance rate,reinvestment rate)
= 11.79%
Note:
B2:B6 is the value of cash flows from year 0 to year 4.
answered by: anonymous
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Compute the MIRR statistic for Project I if the appropriate cost of capital is 11 percent....
Compute the MIRR statistic for Project I if the appropriate cost of capital is 11 percent. (Do not round intermediate calculations. Round your final answer to 2 decimal places.)       Project I   Time: 0 1 2 3 4   Cash flow –$12,300 $5,980 $4,830 $2,170 $2,650
Compute the MIRR statistic for Project J if the appropriate cost of capital is 9 percent....
Compute the MIRR statistic for Project J if the appropriate cost of capital is 9 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project J Time: 0 1 2 3 4 5 Cash flow –$2,000 $650 $1,980 –$620 $600 –$200 MIRR % Should the project be accepted or rejected? Accepted Rejected
Compute the MIRR statistic for Project J if the appropriate cost of capital is 8 percent....
Compute the MIRR statistic for Project J if the appropriate cost of capital is 8 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project J Time: 0 1 2 3 4 5 Cash flow: −$2,700 $860 $2,330 −$690 $810 −$270 Should the project be accepted or rejected? accepted rejected
Compute the MIRR static for Project I if the appropriate cost of capital is 12 percent....
Compute the MIRR static for Project I if the appropriate cost of capital is 12 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project C Time 0 1 2 3 4 Cash Flow -11,000.00 5330.00 4180.00 1520.00 2000.00
Compute the PI statistic for Project Q if the appropriate cost of capital is 13 percent....
Compute the PI statistic for Project Q if the appropriate cost of capital is 13 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project Q Time: 0 1 2 3 4 Cash flow: −$11,800 $3,750 $4,580 $1,920 $2,550 Should the project be accepted or rejected? rejected accepted
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 13...
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 13 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "0" (zero).) Project D Time: 0 1 2 3 4 5 Cash flow: −$11,800 $3,430 $4,340 $1,680 $0 $1,160 Should the project be accepted or rejected? accepted rejected
Compute the PI statistic for Project Z if the appropriate cost of capital is 6 percent....
Compute the PI statistic for Project Z if the appropriate cost of capital is 6 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project Z Time: 0 1 2 3 4 5 Cash flow –$3,100 $690 $820 $990 $640 $440
Compute the PI statistic for Project Z if the appropriate cost of capital is 6 percent....
Compute the PI statistic for Project Z if the appropriate cost of capital is 6 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project Z Time: 0 1 2 3 4 5 Cash flow: −$2,500 $650 $780 $950 $600 $400
Compute the PI statistic for Project Z if the appropriate cost of capital is 6 percent....
Compute the PI statistic for Project Z if the appropriate cost of capital is 6 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project Z Time: 0 1 2 3 4 5 Cash flow: −$1,200 $390 $520 $690 $340 $140 PI=?
Compute the PI statistic for Project Q if the appropriate cost of capital is 11 percent....
Compute the PI statistic for Project Q if the appropriate cost of capital is 11 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.)      Project Q   Time: 0 1 2 3 4   Cash flow –$12,300 $4,000 $4,830 $2,170 $2,800      PI       Should the project be accepted or rejected? Accepted Rejected
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT