B
Brucer
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"
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"