View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Brucer Brucer is offline
external usenet poster
 
Posts: 2
Default need help with creation of an investment analysis worksheet

Excel 2002
Scenario: I want to calculate when I begin to make money on an investment.
Invest $10.000, the commission to set up the fund is $900-, thus my starting
point is $9100-. I want to input the current investment balance and see by
percentage if I am making or loosing money. I also want to determine at what
point I offset the cost of the commission and break even.

My math:
initial investment + commission=break even point

current balance / (initial investment + comission)= percent of gain or loss

IF current balance is or = to Initial Invenstment + commission
THEN PRINT "you have now reached the break even point"

--
Thanks,
Santal