Question

With the NPV, we are looking for a number; whereas with the IRR, we are looking...

With the NPV, we are looking for a number; whereas with the IRR, we are looking for the return. NPV can be calculated on a financial calculator, in excel, or by hand. NPV is very simply the present value (PV) of Cash inflows minus the present value (PV) of Cash outflows. Let’s look at an example. Let’s assume that you want to consider an investment of $5,000, and you are currently making 11% on that money. The payments that you will receive over the next 5 years are:

Year 1 $1500

Year 2 $1000

Year 3 $ 500

Year 4 $ 500

Year 5 $4000

Total $7500

So in total you will receive $7500.

Payments Required rate of return Formula Present Value 0 1 1500 11% =1500/(1.11) 1,351.35 2 1000 11% =1000/(1.11)(1.11) 811.62 3 500 11% =500/(1.11)(1.11)(1.11) 365.60 4 500 11% =500/(1.11)(1.11)(1.11)(1.11) 329.37 5 4000 11% =4000/(1.11)(1.11)(1.11)(1.11)(1.11) 2,373.81 5231.74 So the total present value (PV) of the cash inflows is $5,231.74. Now you need to calculate the present value of the outflows. Since the outflow happened right at the beginning, there is nothing to calculate because it is already in today’s dollars.

PV of cash inflows $5231.74

Minus PV of cash outflows (5000.00)

Net present value 231.74

So what does this mean?

When the NPV is positive, it means that the internal rate of return is greater than the required rate of return, and therefore the investment should be accepted. If our required rate of return in this example, were 15%, then the net present value would calculate out to be ($336.17) or $4663.82 minus $5000. In that case you would not accept the investment because you aren’t going to achieve your desired result.

Payments Required rate of return Present Value 0 - 1 1500 15% 1,304.35 2 1000 15% 756.14 3 500 15% 328.76 4 500 15% 285.88 5 4000 15% 1,988.71 4,663.83

In excel, you enter the formula below: ? Rate is the required rate of return ? Value1… are the payments =NPV(rate,value1,value2,value3…) =NPV(11%,1500,1000,500,500,4000) $5,231.74

Please note that excel is giving you the present value of the cash inflows, you still need to subtract the present value of the cash outflow.

Take the value calculated above and subtract the PV of the cash outflow 5231.74 -5000 NPV = 231.74

In the notes that I prepared for you in the Module 10: media and resources section, I gave you an example of calculating NPV. I want you to use that example and calculate what the PV would be if the payments were an equal amount and tell me which one is better and why? Please use the example with 11% required return.

Homework Answers

Answer #1

Calculation of NPV

Total cash inflows are $7,500 for 5 years. Hence equal annual cash inflow will be 7,500/5 = $ 1,500       

Year Cash inflow PVF(11% , 5 ) Present value of cash inflows
1 1,500 0.901 1,351.5
2 1,500 0.812 1,218
3 1,500 0.731 1,096.5
4 1,500 0.659 988.5
5 1,500 0.593 889.5
Total 5,544

NPV = Present value of cash inflows - Present value of cash outflows

= 5,544 - 5,000

= $ 544

If cash inflows are evenly spread during the period of 5 years, then NPV is $544 which is higher than the NPV when cash flows are not even. Hence when cash flows are an equal amount, it is better since higher NPV means higher wealth to the common stockholders. Higher NPV adds more to the wealth of the stockholders.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
If NPV is positive for a project, then IRR for this same project will be higher...
If NPV is positive for a project, then IRR for this same project will be higher than the required rate of return of this project. (Note this project has a conventional cash flow pattern - outflow in year 0, followed by inflows in the future years of the project). True or False
Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR)...
Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Delta is 11.3%,...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Cute Camel Woodcraft Company: Last Tuesday, Cute Camel Woodcraft Company lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Zeta is...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Cold Goose Metal Works Inc.: Last Tuesday, Cold Goose Metal Works Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project...
NPV and IRR: Equal Annual Net Cash Inflows Winter Fun Company is evaluating a capital expenditure...
NPV and IRR: Equal Annual Net Cash Inflows Winter Fun Company is evaluating a capital expenditure proposal that requires an initial investment of $68,168, has predicted cash inflows of $14,000 per year for seven years, and has no salvage value. a. Using a discounted rate of 14 percent, determine the net present value of the investment proposal. Use a negative sign with your answer, if appropriate. $Answer b. Determine the proposal's internal rate of return. (Refer to Appendix 12B if...
NPV and IRR: Equal Annual Net Cash Inflows Winter Fun Company is evaluating a capital expenditure...
NPV and IRR: Equal Annual Net Cash Inflows Winter Fun Company is evaluating a capital expenditure proposal that requires an initial investment of $61,256, has predicted cash inflows of $13,000 per year for seven years, and has no salvage value. a. Using a discounted rate of 14 percent, determine the net present value of the investment proposal. Use a negative sign with your answer, if appropriate. $Answer b. Determine the proposal's internal rate of return. (Refer to Appendix 12B if...
Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment...
Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods. Assignment Steps Resources: Corporate Finance Calculate the following time value of money problems in Microsoft Excel or Word document. You must show all of your calculations. If you want to accumulate $500,000 in 20 years, how much do you...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Delta is 11.3%, but he can’t recall how...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Delta is 11.3%, but he can’t recall how...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Delta is 11.3%, but he can’t recall how...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT