Trying to figure ROI, getting #DIV/0! Error in Excel

Hi,

Keep getting #DIV/0 error when trying to calculate ROI.

The top row is avg number of transactions, next is the average order size (in $), next row calculates credit card fees and a .35 cents fee per transaction, next is revenue generated and last is net cash flow for the year. No matter what my guess is I get the same error.

Thanks for All Help,
G ROI.xls
gregoryrsmithAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
StephenJRConnect With a Mentor Commented:
Help says "Values must contain at least one positive value and one negative value to calculate the internal rate of return."
0
 
JefKveCommented:
Yeah, you should have negative cash flows followed by positive ones (in an ideal world). As it stands, with all the values effectively negative (cash outflows) it cannot be calc'd.
0
 
gregoryrsmithAuthor Commented:
Much thanks
0
All Courses

From novice to tech pro — start learning today.