Question

1.Project L costs $35,000, its expected cash inflows are $13,000 per year for 9 years, and its WACC is 9%. What is the project's NPV? Do not round intermediate calculations. Round your answer to the nearest cent.

2.Project L costs $50,011.04, its expected cash inflows are $12,000 per year for 8 years, and its WACC is 11%. What is the project's IRR? Round your answer to two decimal places

3.Project L costs $60,000, its expected cash inflows are $15,000 per year for 8 years, and its WACC is 10%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places

4.Project L costs $35,000, its expected cash inflows are $15,000 per year for 8 years, and its WACC is 12%. What is the project's payback? Round your answer to two decimal places.

5.Project L costs $60,000, its expected cash inflows are $14,000 per year for 8 years, and its WACC is 13%. What is the project's discounted payback? Do not round intermediate calculations. Round your answer to two decimal places.

Answer 1

for -SUM(F756:F765) F766 BC 1) Project L Year E 754 755 756 _ 758 $ 759 760 761 762 763 ashflow(in million $ (35,000.00) $ 13,000.00 13,000.00 13,000.00 13,000.00 13,000.00 13,000.00 13,000.00 13,000.00 $ 13,000.00 Pv@9% 1 $ 0.917431193 $ 0.841679993 $ 0.77218348 $ 0.708425211 $ 0.649931386 $ 0.596267327 $ 0.547034245 $ 0.50186628 $ 0.46042778$ NPV $ Pvcf (35,000.00) 11,926.61 10,941.84 10,038.39 9,209.53 8,449.11 7,751.48 7,111.45 6,524.26 5,985.56 42,938.21 764 $ 765 766 767 768 769
​​​​​​
Detined Names Formula Auditing Function Library fc =SUM(F756:F765) F766 c 754 1) Project L 755 Year Cashflow(in millions) Pv@9% =1 756 757 758 759 760 -35000 13000 13000 13000 13000 13000 13000 13000 13000 13000 =E756/1.09 =E757/1.09 =E758/1.09 =E759/1.09 =E760/1.09 =E761/1.09 =E762/1.09 =E763/1.09 =E764/1.09 Pvcf T=D756*E756 =D757*E757 =D758*E758 =D759*E759 =D760*E760 =D761*E761 =D762*E762 =D763*E763 =D764*E764 =D765*E765 =SUM(F756:F765) 762 763 764 765 766 767 768 NPV 769 770