IF Function

  • Thread starter Thread starter sdeblaze
  • Start date Start date
S

sdeblaze

I think I am trying to use the IF function but with no luck. Maybe it
the wrong approach to the problem.

I have a row of calculated cash flows that are getting paid t
investors. After a given period of time there is a break even point.
The investors original investment will have been completly returned an
from that point forward all future cash flow will be split between m
investors and myself (60%/40%). I am trying to create an automated wa
for this to happen but have been unsuccessful up to this point an
thought someone could lend a helping hand.

Thanks in advance for any comments
 
Try using the following:

If(sum(cash flow data+cash flow data+cash flow data, etc.)<amount o
break even point, "amount of payment",amount of payment*.60 or .40
 
I have attached a simply application of what I want to try and do....

Notice in between year 6 and 7 the Limited partners have been paid bac
there original investment(100% of the cash flow for 6.5 years), at thi
point, going into year 7, the cash flow paid to the limited partner
should be automatically split between the Limited Partners and th
General Partner (Me!).40 % / 60%

If anyone can help with this I would greatly appreciate it, its drivin
me craz

+----------------------------------------------------------------
| Attachment filename: test.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=357122
+----------------------------------------------------------------
 
I think I understand what you are trying to do. I have attached anothe
example for you to view. Let me know if I am way off base with this..

+----------------------------------------------------------------
| Attachment filename: example.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=360157
+----------------------------------------------------------------
 
I owe you huge, thanks so much for the help, I really appreciate it!
Absolutely right on, and I would have never figured it out
 
Back
Top