Thread: IRR Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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