Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot table creation in shared worksheet | Excel Discussion (Misc queries) | |||
Action Item Worksheet Creation | Excel Worksheet Functions | |||
Property Analysis Worksheet | Excel Discussion (Misc queries) | |||
Setting up a worksheet for LOG LOG analysis | Excel Worksheet Functions | |||
Investment analysis template | Excel Discussion (Misc queries) |