LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table creation in shared worksheet dave in Toronto Excel Discussion (Misc queries) 1 August 9th 07 11:58 PM
Action Item Worksheet Creation Kevin M[_2_] Excel Worksheet Functions 0 February 26th 07 09:16 PM
Property Analysis Worksheet tpsgirl2006 Excel Discussion (Misc queries) 1 December 24th 06 04:44 PM
Setting up a worksheet for LOG LOG analysis David Stamm Excel Worksheet Functions 1 September 14th 06 07:39 PM
Investment analysis template jazz Excel Discussion (Misc queries) 1 January 28th 05 12:39 PM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"