Question
In: Finance
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,300 | $730 | $860 | $1,030 | $680 | $480 |
Solutions
Expert Solution
| rate | 6.0000% | |
| Cash flows | Year | Discounted CF= cash flows/(1+rate)^year |
| (3,300.00) | 0 | (3,300.00) |
| 730.00 | 1 | 688.68 |
| 860.00 | 2 | 765.40 |
| 1,030.00 | 3 | 864.81 |
| 680.00 | 4 | 538.62 |
| 480.00 | 5 | 358.68 |
NPV = -83.81
PI = 1 - 83.81/3300 = 0.97
jeff jeffy answered 2 years agoRelated Solutions
Compute the payback statistic for Project A if the appropriate cost of capital is 8 percent...
Compute the payback statistic for Project A if the appropriate
cost of capital is 8 percent and the maximum allowable payback
period is four years. (Round your answer to 2 decimal
places.)
Project A
Time:
0
1
2
3
4
5
Cash flow:
–$1,600
$590
$660
$640
$420
$220
Should the project be accepted or rejected?
Compute the NPV statistic for Project Y if the appropriate cost of capital is 12 percent....
Compute the NPV statistic for Project Y if the appropriate cost
of capital is 12 percent. (Negative amount should be
indicated by a minus sign. Do not round
intermediate calculations and round your final answer to 2 decimal
places.)
Project Y
Time:
0
1
2
3
4
Cash flow:
–$9,200
$3,590
$4,420
$1,760
$540
NPV:
Should the project be accepted or rejected?
accepted
rejected
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.
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 MIRR % Should
the project be accepted or rejected?
Compute the NPV statistic for Project U if the appropriate cost of capital is 9 percent....
Compute the NPV statistic for Project U if the appropriate cost
of capital is 9 percent. (Negative amount should be
indicated by a minus sign. Do not round intermediate calculations
and round your final answer to 2 decimal places.)
Project U
Time:
0
1
2
3
4
5
Cash
flow
–$1,050
$370
$1,530
–$530
$320
–$110
Compute the NPV statistic for Project Y if the appropriate cost of capital is 11 percent....
Compute the NPV statistic for Project Y if the appropriate cost
of capital is 11 percent. (Negative amount should be
indicated by a minus sign. Do not round
intermediate calculations and round your final answer to 2 decimal
places.)
Project Y
Time:
0
1
2
3
4
Cash flow:
–$8,100
$3,370
$4,200
$1,540
$320
Compute the NPV statistic for Project U if the appropriate cost of capital is 10 percent....
Compute the NPV statistic for Project U if the appropriate cost
of capital is 10 percent. (Do not round intermediate
calculations and round your final answer to 2 decimal
places.)
Project U
Time:
0
1
2
3
4
5
Cash flow:
–$1,000
$350
$1,480
–$520
$300
–$100
show how to do this in excel and the excel formulas
You have to show what the excel formulas are pls
Compute the MIRR statistic for Project J if the appropriate cost of capital is 10 percent....
Compute the MIRR statistic for Project J if the appropriate cost
of capital is 10 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:
−$1,000
$350
$1,480
−$520
$300
−$100
MIRR ______ %
Should the project be accepted or rejected?
Compute the discounted payback statistic for Project C if the appropriate cost of capital is 6...
Compute the discounted payback statistic for Project C if the
appropriate cost of capital is 6 percent and the maximum allowable
discounted payback period is three years. (Do not round
intermediate calculations. Round your final answer to 2 decimal
places.) Project C Time: 0 1 2 3 4 5 Cash flow –$2,900 $1,240
$1,050 $1,090 $680 $480 Discounted payback period years Should the
project be accepted or rejected? Rejected Accepted
Compute the discounted payback statistic for Project C if the appropriate cost of capital is 8...
Compute the discounted payback statistic for Project C if the
appropriate cost of capital is 8 percent and the maximum allowable
discounted payback period is three years.
Time:
0
1
2
3
4
5
Cash flow:
–$1,000
$480
$480
$520
$300
$100
Calculate discounted payback period in years
Compute the discounted payback statistic for Project C if the appropriate cost of capital is 8...
Compute the discounted payback statistic for Project C if the
appropriate cost of capital is 8 percent and the maximum allowable
discounted payback period is three years.
(Do not round intermediate calculations
and round your final answer to 2 decimal places.)
Project C
Time:
0
1
2
3
4
5
Cash flow:
–$2,200
$960
$840
$880
$540
$340
Should the project be accepted or rejected?
accepted
rejected
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Part A. Outline and explain all the VARIABLES and FACTORS that determine valuation and valuation analysis...
- Study the file polygon.h. It contains the header file for a class of regular polygons. Implement...
- what challenges can myths and stereotypes create for american indians?
- Date accuracy is very important because dates are used for discounts, payment terms and many reports....
- How many milliliters of concentrated hydrochloric acid solution (36.0% HCl by mass, density = 1.18 g/mL)...
- How does the rotating membership of the FOMC work? Why does the president of New York's...
- A gym owner is considering opening a location on the other side of town. The new...
ADVERTISEMENT