IRR Formula
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.
In article ,
Toby wrote:
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
|