many factors, as Shaun said. one would like to keep it from being the weak link in the driveline - a sticky clutch (which should be the weak link) and slicks and hammering gears can make the trans the weak link real quick.
FWIW, trannies (and some clutches) are usually rated by torque, not HP.
good luck.