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

Expert Solution

rate	9.0000%
Cash flows	Year	Discounted CF= cash flows/(1+rate)^year
(1,050.00)	0	(1,050.00)
370.00	1	339.45
1,530.00	2	1,287.77
(530.00)	3	(409.26)
320.00	4	226.70
(110.00)	5	(71.49)

NPV = 323.17

jeff jeffy answered 1 year ago

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 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 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 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 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 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

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 NPV for Project K if the appropriate cost of capital is 7 percent. (Negative...

Compute the NPV for Project K if the appropriate cost of capital is 7 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 K Time: 0 1 2 3 4 5 Cash flow: −$11,600 $5,800 $6,800 $6,800 $5,800 −$14,600 Should the project be accepted or rejected? rejected accepted

Compute the NPV for Project M if the appropriate cost of capital is 7 percent. (Negative...

Compute the NPV for Project M if the appropriate cost of capital is 7 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 M Time: 0 1 2 3 4 5 Cash flow –$2,000 $550 $680 $720 $800 $300 NPV $ Should the project be accepted or rejected? Accepted 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

Question