For the cash flows in the previous below, what is he NPV at a discount rate of zero percent? What If the discount rate is 10 percent? If it is 20 percent? If it is 30 percent?
Year Cash Flow
See the attached file.
You could use NPV function in Excel for this purpose.
The NPV function is pretty simple to use. Just type:
=NPV(rate, free cash flow1, free cash flow 2, ... free cash flow n) to run the calculation. Please see the attached Excel file for results.
Just like DCFs and any sort of ...
The solution provides detailed explanations and calculations for the problem, including calculation in the Excel file.