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

Expert Solution

Ans $ 293.45

Year	Project Cash Flows (i)	DF@ 10%	DF@ 10% (ii)	PV of Project U ( (i) * (ii) )
0	-1000	1	1	(1,000.00)
1	350	1/((1+10%)^1)	0.909	318.18
2	1480	1/((1+10%)^2)	0.826	1,223.14
3	-520	1/((1+10%)^3)	0.751	(390.68)
4	300	1/((1+10%)^4)	0.683	204.90
5	-100	1/((1+10%)^5)	0.621	(62.09)
		NPV		293.45

jeff jeffy answered 1 year ago

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

Compute the NPV for Project M 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 M Time: 0 1 2 3 4 5 Cash flow: –$1,200 $390 $520 $560 $640 $140 NPV? Should it be accepted or rejected

Question