IRR Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My TI BA Real Estate calculator comes up with 15.6556% IRR for the following
scenario

Present Value: -$40,000
Future Value: $72,000
Term: 5 years
Cash Flow: $167.00/month ($10,000 over life of investment)

My formula was this: =IRR(e68:e70)

e68 represented -40,000
e70 represented 10,000 (cashflow over life of the loan)

Any ideas on what i am doing wrong? I get the
 
See your other thread.

Please don't post the same question multiple times. It just fragments
any answers you get, and potentially wastes the time of those trying to
answer a question that already has a solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR Calculation 2
IRR, with cash flows in non-adjacent cells 6
#num error using IRR 4
Working with arrays as arguments 6
IRR function when the cash flows are not in array? 2
IRR Problem 2
NPV IRR MIRR 3
Unexplainable XIRR #NUM! Error 3

Back
Top