We obtained the general formula for lump sum using the total from the year before to calculate the principal and interest for the next year.  This process works fine, but is too difficult to use when the number of years is large.  So we looked for a way to obtain a simplified formula.  We looked for the commonality and recognized the repeated appearance of (1+rate) after factoring.   Once we found this pattern, we used it to find a simplified formula.