Hi All,
I've tried Google in every combination I can think of with no luck. I'm not sure how to even phrase the problem, but I'm sure it has a solution.
I have a business model with various inputs, the two most important of which are time and price (It's always about time and money). I want to create a chart with the Y-axis showing price and the X-axis showing time which draws a line at profit break-even. For example, if I set Price to $45, then break-even will be at 9 months. At $50, it will be at 10, etc. If I set Time to 6 months, break-even will be at a Price of $40. I would like to draw that line without having to make a manual input for each data point in the chart.
If I could auto-generate a table of Time values for a series of Price inputs so that I could enter the prices I want for the Y axis, and I could generate the corresponding X values, that would be halfway to the chart.
To find a break-even point now, I use goal seek to set the profit to zero by changing either Price or Time. I just don't want to have to keep doing that over and over for each data point.
I know that I could have had half the numbers I need in the time it's taken me to post this message, but every time other parts of the model change (cost, for example), then I have to start over, since it changes break-even points.
Thanks for any help.
Bookmarks