title: Simplyfying FV with monthly payment calculation
body: <ul>
  <li>7000  </li>
  <li>10008.54  </li>
  <li>13665.45  </li>
  <li>18110.44  </li>
  <li>23513.35  </li>
  <li>30080.62  </li>
  <li>38063.19  </li>
  <li>47766.04  </li>
  <li>59559.92  </li>
  <li>73895.45  </li>
  <li>91320.39  </li>
  <li>112500.50 </li>
  </ul>
  
  <p>In the above list, 7000 is stationary. From 10,008.54 to downwards, I have the following formula pulled down with $N$27 containing 1500 (does not change)</p>
  
  <blockquote>
    <p>=((((M27*1.05)*1.05)*1.05)*1.05)+$N$27</p>
  </blockquote>
  
  <p>This essentially calculates 7000 compounded 4 times monthly with  1500 added at the end of period. In excel I was able to come up with this</p>
  
  <blockquote>
    <p>=FV(P32,P29,-N27)+(P31*POWER((1+P32),P29))</p>
  </blockquote>
  
  <ul>
  <li>P32 = .05</li>
  <li>P29 = 48</li>
  <li>N27 = 1500</li>
  </ul>
  
  <p>First FV calculates the FV of 1500 end of 48 periods with interest rate of 5%</p>
  
  <p>The second part simplifies the table above. However the results differ by huge margin.</p>
  
  <p>Question being: How else can I show my list above in short simple formula. I want the beginning of the month value compounded 4 times/weekly the following month + a payment added at the end of the month for up to 1 year. </p>
  
  <p>Any leads and your time is appreciated.</p>