The formula to calculate Net Present Value (NPV) is Present Value of expected cash inflows - Present Value of Cash Outflows.
To get the present value we use time value of money, which gives present money value of a future expected inflow.
Case 1: Where Cost of capital is 6% per year.
The equation can be termed in the following way,
NPV = Present value of cash inflows - Initial investment in today's value
NPV = (500/(1+0.06)1 + 1,500/(1+0.06)2 + 10,000/(1+0.06)10) - 10,000
Calculating this equation will give you the absolute return, which is -$2609.36
Case 2: When Cost of Capital is 2% per year.
Follow the same process, and the equation is,
NPV = (500/(1+0.02)1 + 1,500/(1+0.02)2 + 10,000/(1+0.02)10) - 10,000
Calcuate the equation.
The absolute return is $135.4322
So, the case 2 opportunity is to be selected as it gives the positive return, instead of case 1 which gives negative return.
Attached are the Images to calculate in Excel Sheet(Showing formula and without showing formula).
Problem 8-6 You have been offered a unique investment opportunity. If you invest $10,000 today, you...
Problem 8-6 You have been offered a unique investment opportunity. If you invest $10,000 today, you will receive $500 one year from now, $1,500 two years from now, and $10,000 ten years from now. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be...
Problem 86 You have been offered a unique investment opportunity. If you invest $10.000 today, you will receive $500 one year from now. $1.500 two years from now and $10.000 ten years from now Complete the steps belowing cell references to vendar previous calculations in some cases a simple cell reference is all you need to composte a formulacross a row or down a common absolute cell reference aramidal n e may be preferred Ifa specific Excel function is to...
You have been offered a unique investment opportunity. If you invest $11,800 today, you will receive $590 one year from now, $1,770 two years from now, and $11,800 in ten years. a. What is the NPV of the opportunity if the cost of capital is 6.4% per year? Should you take the opportunity? b. What is the NPV of the opportunity if the cost of capital is 2.4% per year? Should you take it now? a. What is the NPV...
You have been offered a unique investment opportunity. If you invest $10,800 today, you will receive $540 one year from now, $1,620 two years from now, and $10,800 ten years from now. a. What is the NPV of the opportunity if the cost of capital is 6.9% per year? Should you take the opportunity? b. What is the NPV of the opportunity if the cost of capital is 2.9% per year? Should you take it now? a. What is the...
You have been offered a unique investment opportunity. If you invest $ 9,100 today, you will receive $ 455 one year from now, $ 1365 two years from now, and 9100 in ten years. a. What is the NPV of the opportunity if the cost of capital is 6.1 % per year? Should you take the opportunity? b. What is the NPV of the opportunity if the cost of capital is 2.1 % per year? Should you take it...
You have been offered a unique investment opportunity. If you invest $ 11,00 today, you will receive $ 555 one year from now, $ 1,665 two years from now, and $ 11,100 in ten years. a. What is the NPV of the opportunity if the cost of capital is 6.5 % per year? Should you take the opportunity? b. What is the NPV of the opportunity if the cost of capital is 2.5 % per year? Should you take it...
You have been offered a unique investment opportunity. If you invest $10,800 today, you will receive $540 one year from n $1,620 two years from now, and $10,800 ten years from now. a. What is the NPV of the opportunity if the cost of capital is 5.5% per year? Should you take the opportunity? b. What is the NPV of the opportunity if the cost of capital is 1.5% per year? Should you take it now?
Problem 8-18 Professor Wendy Smith has been offered the following deal: A law firm would like to retain her for an up- front payment of $50,000. In return, for the next year the firm would have access to eight hours of her time every month. Smith's rate is $550 per hour and her opportunity cost of capital is 15% per year. What does the IRR rule advise regarding this opportunity? What about the NPV rule? Complete the steps below using...
You have been offered a unique investment opportunity. If you invest $ 15000 today, you will receive $750 one year from now, $2,250 two years from now, and $15,000 ten years from now. a. What is the NPV of the investment opportunity if the interest rate is 6% per year? Should you take the opportunity? b. What is the NPV of the investment opportunity if the interest rate is 2% per year? Should you take the opportunity?
1. Time Value of Money You have been offered a unique investment opportunity. If you invest $20,000 today, you will receive $1000 one year from now, $3000 two years from now, and $20,000 ten years from now. a. What is the NPV of the investment opportunity if the interest rate is 12% per year? Should you take the opportunity? b. What is the NPV of the investment opportunity if the interest rate is 2% per year? Should you take the...