View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frank Situmorang[_2_] Frank Situmorang[_2_] is offline
external usenet poster
 
Posts: 65
Default #num error using IRR

Hi Jerek, as I mentioned this is my own money, so there is 300,000 plus and
there is 300,000 minus result in zero in the 1st year. I made this on
purpose, because it is tricky, we always think that having deposited in the
bank is always better, but it seems to me that total money we will have,
especially if we then sell it, it is better to invest.

How can we make it to show the IRR with my assumption.

Thanks very much
--
H. Frank Situmorang


"Jarek Kujawa" wrote:

should be -300,000 in the 1st line cause this yr expenditure
this is how IRR function works