Excel graph with several variables

[slenois]

I am new to this forum and I have returned to college after being out of school for more than 20 plus years. It is both exciting and challenging, which is what I would definitely call my Corporate Finance class - extremely challenging. I have a graphing challenge in Excel that I have spent several hours now deliberating on and still no closer on how to do it and would appreciate any advice, which is what has brought me to this site. I have to compare the timing of the cash flow of three separate projects relative to its NPV (net present value), which would include another variable, its modified internal rate of return (see below).
NPV MIRR
Project A $219.47 10.34%
Project B $262.69 11.30%
Project C $241.08 10.83%

I found two separate images online on what I am looking for but there was no instructions on how to create it.

46_-3307_50.pngpaybackmath.jpg

[roki4]

Ok, what you described is a 3D graph that has an x, y, and z axis and unless specifically stated, I doubt that your corporate finance class requires a 3D graph. My 4th year econometrics class did not require 3D graphs. Have I misunderstood?

It looks like you should be doing a graph of NPV vs MIRR for each of the projects. That is, three separate graphs. Based on the slope and intercept of the line, corporate finance has it's own formulas for what each area under the curve stands for. I am also fairly sure that you have to compare the values between the three projects (graphs) at some point in the assignment.

Have I missed something? Happy to help.