Testing speedometer with drill

Got Barracuda on the lift and disconnected the cable housing at the trans - and the cable is twisted off. And the cable is totally seized in the housing…
When the speedometer cratered it took the cable with it.

No one locally has a new one, but Amazon did. Supposed to be here tomorrow.