"lisarain" wrote:
I built up a model to calculate shipping investment return.
However if I input too low a charter rate or too high an
operating cost, it returns DIV/0 - does this mean it's too
negative? Is there a way to fix this?

Ostensibly, #DIV/0! is another way that IRR indicates that a "guess"
argument is needed to help it do the computation.

Although that could be reasonable, usually it indicates either an incorrect
or unrealistic cash flow model. Also, based on your vague description, I
suspect you might not need IRR in the first place.

If you want more help, post your cash flow mode and your formulas.