Author Topic: Excel Help  (Read 4449 times)

Jake

  • Jackass In Charge
  • Posts: 8650
  • Karma: +83/-18
Excel Help
« on: February 23, 2015, 10:44:46 PM »
I want to create a 3 year pro-forma return on investment line graph with a clear break even point. Here is the data I have:

x: Annual ROI
y: Total investment

from these two values I calculate the break even point (z) with this calculation where J47 is y and J42 is x

z=INT(J47/J42) & " years  " & INT(((J47/J42)-INT(J47/J42))*12) & " months"

So, here are some real numbers

x: 292,500
y: 250,000
z: 10 months

I want to generate a graph with 36 months on the x-axis and $$$ on the y-axis. I haven't played around with this too much yet, but if anyone can help I would appreciate it!
Do not follow where the path may lead. Go instead where there is no path and leave a trail.

Jake

  • Jackass In Charge
  • Posts: 8650
  • Karma: +83/-18
Re: Excel Help
« Reply #1 on: February 23, 2015, 11:30:22 PM »
I just set up a table like pictured below and then made a graph. Their seems to be an easier solution, but you guys are way smarter than me and maybe you can come up with it
Do not follow where the path may lead. Go instead where there is no path and leave a trail.

JaWiB

  • definitelys definately no MacGyver
  • Jackass V
  • Posts: 1443
  • Karma: +57/-4
Re: Excel Help
« Reply #2 on: February 23, 2015, 11:45:07 PM »
I feel like I'm missing something about what you want to do, but it sounds like you already figured it out. How exactly could it be easier?

Jake

  • Jackass In Charge
  • Posts: 8650
  • Karma: +83/-18
Re: Excel Help
« Reply #3 on: February 24, 2015, 12:00:47 AM »
Basically it is a graph of a payback period on an investment along with a 3 year ROI.

Do not follow where the path may lead. Go instead where there is no path and leave a trail.

kermi3

  • ?
  • Ass Wipe
  • Posts: 5513
  • Karma: +56/-22
Re: Excel Help
« Reply #4 on: February 26, 2015, 06:16:41 PM »
I think what you're trying to do is plotting - and I'm not sure excel is the best software for that - but it looks like you have a good solution!
govtcheez03:  i kind of look for it - i seek out stupidity and annoy it until it either gets better, gets banned, or goes away on its own