Piles have been widely used as foundations to resist lateral loads. For the design of a laterally loaded pile, one of the most important inputs is the ultimate soil resistance (<i>p</i><sub>ult</sub>=<i>K</i><sub>ult</sub><i>D</i>σ<sub>v</sub><sup>’</sup>, <i>K</i><sub>ult</sub> is the ultimate lateral soil resistance coefficient, <i>D</i> is pile diameter, σ<sub>v</sub><sup>’</sup> is the vertical effective stress). However, great discrepancy can be found in the existing design equations for piles in sand. To provide new insights and clarify the discrepancy in previous studies, this technical note performed a series of numerical simulations on piles of different configurations using the finite element model validated by centrifuge pile tests. The computed results suggest that <i>K</i><sub>ult</sub> is a function of depth ratios <i>z/D</i> and <i>z/L</i> for the flexible and rigid piles, respectively (where, <i>z</i> is absolute depth, <i>L</i> is pile length) and all existing design equations failed to reproduce the magnitude and distribution of <i>K</i><sub>ult</sub>. Additionally, <i>K</i><sub>ult</sub> of horizontally translated fixed-head rigid piles exhibit the same pattern as flexible piles, suggesting that the difference between free-head flexible and rigid piles is caused by the change of failure modes.