Positive steady states of an indefinite equation with a nonlinear boundary condition: existence, multiplicity, stability and asymptotic profiles