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
|