Solved

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

Posted on 2010-09-21
410 Views
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
0
Question by:gregoryrsmith

LVL 24

Accepted Solution

StephenJR earned 400 total points
Help says "Values must contain at least one positive value and one negative value to calculate the internal rate of return."
0

LVL 3

Expert Comment

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

Author Closing Comment

Much thanks
0

## Featured Post

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,â€¦
Outlook Free & Paid Tools
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.