EXCEL SOLUTION NEEDED: EXCEL FORMULA ONLYPLEASE The internal rate of return (IRR) is the rate of returnfor
Fantastic news! We've Found the answer you've been seeking!
Question:
EXCEL SOLUTION NEEDED: EXCEL FORMULA ONLYPLEASE
The internal rate of return (IRR) is the rate of returnfor a series of cash flows that results in a zero NPV. Excel's IRRfunction easily computes the IRR for a series of cashflows.
What is the IRR for the project with the following cashflows?
t | Cash flow |
0 | $ (30,000) |
1 | 8,000 |
2 | 10,000 |
3 | 11,000 |
4 | 17,000 |
5 | 12,000 |
IRR: |
Related Book For
Entrepreneurial Finance
ISBN: 978-0538478151
4th edition
Authors: J . chris leach, Ronald w. melicher
Posted Date: