Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

need help with creation of an investment analysis worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brucer - 11 Oct 2007 19:09 GMT
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"

Signature

Thanks,
Santal

Gary''s Student - 13 Oct 2007 12:03 GMT
In D1 enter the Initial value:
$10,000.00

In C1 enter the sales commision:
$900.00

In A1 the current value:
=D1-C1 which will show:
$9,100.00

Use the rest of column A to record the current value as time goes on.

Finally in B1 enter:
=IF(A1/$D$1<1,A1/$D$1,TEXT(A1/$D$1,"0.00%") & " broke even")
and copy down the column.

Here is a sample of what will may see:

$9,100.00     91.00%      $900.00      $10,000.00
$9,282.00     92.82%       
$9,467.64     94.68%       
$9,656.99     96.57%       
$9,850.13     98.50%       
$10,047.14  100.47% broke even       
$10,248.08  102.48% broke even       
$10,453.04  104.53% broke even       
$10,662.10  106.62% broke even       
$10,875.34  108.75% broke even       
$11,092.85  110.93% broke even       
$11,314.71  113.15% broke even       
$11,541.00  115.41% broke even       
$11,771.82  117.72% broke even       

Signature

Gary''s Student - gsnu200749

> Excel 2002
> Scenario: I want to calculate when I begin to make money on an investment.
[quoted text clipped - 10 lines]
> IF current balance is > or = to Initial Invenstment + commission
> THEN PRINT "you have now reached the break even point"
Brucer - 15 Oct 2007 18:13 GMT
Thank you for your help. I appreciate you taking the time to answer my
question.
Signature

Bruce

> In D1 enter the Initial value:
> $10,000.00
[quoted text clipped - 43 lines]
> > IF current balance is > or = to Initial Invenstment + commission
> > THEN PRINT "you have now reached the break even point"
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.