(Almost) Tight bounds and existence theorems for single-commodity confluent flows