. We have two mutually exclusive investments with the following cash flows: Year Investment A Investment B 0 –$100 –$100 1 10 50 2 30 40 3 50 30 4 70 20 b. Calculate the NPV profile for each investment, using the discount rates of 0%, 5%, 10%, 15%, 20%, and 25%. Perform this task in an Excel spreadsheet. Cautionary note: If you use the =NPV() function in Excel to calculate the NPVs, it will provide incorrect answers. The NPV() function actually calculates the present value of all cash inflows. The NPV should be calculated as =NPV(all cash inflows) – initial cash outflow.

. We have two mutually exclusive investments with the following cash flows: Year Investment A Investment B 0 –$100 –$100 1 10 50 2 30 40 3 50 30 4 70 20 b. Calculate the NPV profile for each investment, using the discount rates of 0%, 5%, 10%, 15%, 20%, and 25%. Perform this task in an Excel spreadsheet. Cautionary note: If you use the =NPV() function in Excel to calculate the NPVs, it will provide incorrect answers. The NPV() function actually calculates the present value of all cash inflows. The NPV should be calculated as =NPV(all cash inflows) – initial cash outflow.

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter8: Risk And Rates Of Return

Section: Chapter Questions

Problem 7PROB

See similar textbooks

Similar questions

A3 4a. We have two mutually exclusive investments with the following cash flows: Year Investment A Investment B 0 –$100 –$100 1 10 50 2 30 40 3 50 30 4 70 20 a. Using a financial calculator, calculate the IRR for each of the investments. State your answers in percentages rounded to two decimal places.
A3 4b We have two mutually exclusive investments with the following cash flows: Year Investment A Investment B 0 –$100 –$100 1 10 50 2 30 40 3 50 30 4 70 20 b. Calculate the NPV profile for each investment, using the discount rates of 0%, 5%, 10%, 15%, 20%, and 25%. Perform this task in an Excel spreadsheet. Cautionary note: If you use the =NPV() function in Excel to calculate the NPVs, it will provide incorrect answers. The NPV() function actually calculates the present value of all cash inflows. The NPV should be calculated as =NPV(all cash inflows) – initial cash outflow.
You found an investment with the following cash flows:End of year Cash Received1 $5002 $5503 $600What is the most you are willing to pay if you believe investments of this risk warrant a 7% return?
$1897 mibns 000,0062 sw I Y al coles a bl 6) The Kaufmann Group is considering a $364,000 investment with the following net cash flows. Kauffman requires a 12% return on its investments. Annual Net Cash Flows Present Value of $1 at 12% Initial investment 1.0000 Year 1 $ 124,000 0.8929 Year 2 84,000 0.7972 Year 3 144,000 0.7118 Year 4 s istos bas 000,00 254,000 svenistot 008,20 0.6355 by Year 5 74,000 0.5674 The present value of this investment is: A) B) C) D) E) $483,588. $161,576. $119,588. $230,308. $281,005.
What is the NPV of the following cash flows if the required rate of return is 0.09? Year 0 1 2 3 4 CF -3,935 687 1,937 3,189 968 Enter the answer with 2 decimals (e.g. 1000.23).
Given the information above, what amount is the firm’s 2023 free cash flow (FCF)? A. $20.50 B. $25.45 C. $30.00 D. $36.05
23. Simms Corp. is considering a project that has the following cash flow data. The project's IRR is_______ %. Show 2 decimals in your answer. Year 0 1 2 3 Cash Flows -$1,000 $380 $475 $450
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $131 $131 $131 $131 $131 $131 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ Project B: $ What is each project's IRR? Round your answer to two decimal places. Project A: % Project B: % What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations. Project A: % Project B: % From your answers to parts a-c, which project would be selected? _________Project…
A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $134 $134 $134 $134 $134 $134 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ fill in the blank 2 Project B: $ fill in the blank 3 What is each project's IRR? Round your answer to two decimal places. Project A: fill in the blank 4% Project B: fill in the blank 5% What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations.…
6.Wainright Co. has identified an investment project with the following cash flows. Year Cash Flow 1 $ 720 2 930 3 1,190 4 1,275 If the discount rate is 10 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) Present value $ What is the present value at 18 percent? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) Present value $ What is the present value at 24 percent? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) Present value $
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Year 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $133 $133 $133 $133 $133 $133 $0 Open spreadsheet What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ fill in the blank 2 Project B: $ fill in the blank 3 What is each project's IRR? Round your answer to two decimal places. Project A: fill in the blank 4% Project B: fill in the blank 5% What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations. Project A: fill in the blank 6% Project B: fill in the blank 7%…
Use the same CMO as in the previous question and suppose that in month 10, the beginning balance on tranche A is $2,733,990.91 and the beginning balance on tranche B is X$3,000,000. How much cash flow do investors in tranche A receive in month 10? 4 Selected Answer: 191,554 BE O ENG 40 11:36 PM 11/15/2023