Spectral theory approach for a class of radial indefinite variational problems