If HDD and CD are on the same cable make sure the jumper on each are set, one to master and the other to slave.
If this is not the case, a bad component can keep the system from booting properly. Try another CD drive, you can find them new for under $20, or find a used one. If you still have issues, you are probably right about the power supply. Easy to replace, if you can find another one.