Skip to main content
Personal Finance & Money

Return to Answer

Post Undeleted by user 32135421 م
I forgot to add the interest to the principles, so i deleted the post, recalculated then undeleted
Source Link
user 32135421 م
user 32135421 م
  • 156
  • 4

Thanks to @D Stanley for the hint

+------------------+-----------+--------------+--------------+---------+---------------------+
|      -      | deposits/principals  | interest  |deposits   |principals**  |interest rate ||interest*|accumulated interest *| |
+------------------+-----------+--------------+--------------+---------+---------------------+
|2nd half 2010|2010 100    |100        |100           |0.07          |3.53     |3.53062553                 |
|1st half 2011|2011 200    |200        |203.53        |0.07           |7.0612519     |10.72                |
|2nd half 2011|2011 300    |300        |310.72        |0.07           |10.59187597    |21.69                |
|1st half 2012|2012 400    |400        |421.69        |0.07           |14.122589    |36.57                |
|2nd half 2012|2012 500    |500        |536.57        |0.07          |18.94 |17   |55.65312552                |
|1st half 2013|2013 600    |600        |655.52        |0.07          |23.14 |21   |78.1837566                |
|2nd half 2013|2013 800    |800        |878.66        |0.05          |22.10 |20   |100.12577               |
|1st half 2014|2014 1000    |1000       |1100.77       |0.05          |27.69    |25|128.1562546               |
|2nd half 2014|2014 3200    |3200       |3328.46       |0.06          |100.60   |96|229.7206               |
|1st half 2015|2015 3400    |3400       |3629.06       |0.06          |109.69  |102 |338.76575               |
|2nd half 2015|2015 3600    |3600       |3938.75       |0.06          |119.05 |108  |457.8180               |
|1st half 2016|2016 3800    |3800       |4257.80       |0.06          |128.69 |114  |586.85549               |
|2nd half 2016|2016 4000    |4000       |4586.49       |0.06          |138.63   |120|725.912               |
|1st half 2017|2017 4200    |4200       |4925.12       |0.06          |148.86  |126 |873.94598               |
|2nd half 2017|2017 4400    |4400       |5273.98       |0.06          |159.41 |132  |1033.9938              |
|1st half 2018|2018 4600    |4600       |5633.38       |0.06          |170.27 |139  |1203.03565              |
|2nd half 2018|2018 4800    |4800       |6003.65       |0.06          |181.46  |145 |1385.0811              |
+-------------+----------------------+---------------+-----------+
|sum of interest                                     |1207.524375|
+-------------------+--------------+---------+----------+-----------+

interest = (principal * (1 + (interest rate / 4) ) ^ (0.5 * 4) ) - principalsprincipal
 0.5 is a half of a year
 4 is the number of compounding periods

** principals are the deposits + accumulated interest till the beginning of the period

According to my calculations he is supposed to has 60076185.52437511 (4800 + 1207.524375) in his account by the end of 2018

  • 6185.11 = 4800 + 1385.11
  • 6185.11 = 6003.65 + 181.46
+-------------+----------------------+---------------+-----------+
|      -      | deposits/principals  | interest rate | interest *| 
+-------------+----------------------+---------------+-----------+
|2nd half 2010| 100                  |0.07           |3.530625   |
|1st half 2011| 200                  |0.07           |7.06125    |
|2nd half 2011| 300                  |0.07           |10.591875  |
|1st half 2012| 400                  |0.07           |14.1225    |
|2nd half 2012| 500                  |0.07           |17.653125  |
|1st half 2013| 600                  |0.07           |21.18375   |
|2nd half 2013| 800                  |0.05           |20.125     |
|1st half 2014| 1000                 |0.05           |25.15625   |
|2nd half 2014| 3200                 |0.06           |96.72      |
|1st half 2015| 3400                 |0.06           |102.765    |
|2nd half 2015| 3600                 |0.06           |108.81     |
|1st half 2016| 3800                 |0.06           |114.855    |
|2nd half 2016| 4000                 |0.06           |120.9      |
|1st half 2017| 4200                 |0.06           |126.945    |
|2nd half 2017| 4400                 |0.06           |132.99     |
|1st half 2018| 4600                 |0.06           |139.035    |
|2nd half 2018| 4800                 |0.06           |145.08     |
+-------------+----------------------+---------------+-----------+
|sum of interest                                     |1207.524375|
+----------------------------------------------------+-----------+

interest = (principal * (1 + (interest rate / 4) ) ^ (0.5 * 4) ) - principals
 0.5 is a half of a year
 4 is the number of compounding periods

According to my calculations he is supposed to has 6007.524375 (4800 + 1207.524375) in his account by the end of 2018

Thanks to @D Stanley for the hint

+------------------+-----------+--------------+--------------+---------+---------------------+
|                  |deposits   |principals**  |interest rate |interest*|accumulated interest |
+------------------+-----------+--------------+--------------+---------+---------------------+
|2nd half 2010     |100        |100           |0.07          |3.53     |3.53                 |
|1st half 2011     |200        |203.53        |0.07          |7.19     |10.72                |
|2nd half 2011     |300        |310.72        |0.07          |10.97    |21.69                |
|1st half 2012     |400        |421.69        |0.07          |14.89    |36.57                |
|2nd half 2012     |500        |536.57        |0.07          |18.94    |55.52                |
|1st half 2013     |600        |655.52        |0.07          |23.14    |78.66                |
|2nd half 2013     |800        |878.66        |0.05          |22.10    |100.77               |
|1st half 2014     |1000       |1100.77       |0.05          |27.69    |128.46               |
|2nd half 2014     |3200       |3328.46       |0.06          |100.60   |229.06               |
|1st half 2015     |3400       |3629.06       |0.06          |109.69   |338.75               |
|2nd half 2015     |3600       |3938.75       |0.06          |119.05   |457.80               |
|1st half 2016     |3800       |4257.80       |0.06          |128.69   |586.49               |
|2nd half 2016     |4000       |4586.49       |0.06          |138.63   |725.12               |
|1st half 2017     |4200       |4925.12       |0.06          |148.86   |873.98               |
|2nd half 2017     |4400       |5273.98       |0.06          |159.41   |1033.38              |
|1st half 2018     |4600       |5633.38       |0.06          |170.27   |1203.65              |
|2nd half 2018     |4800       |6003.65       |0.06          |181.46   |1385.11              |
+------------------+-----------+--------------+--------------+---------+---------------------+

interest = (principal * (1 + (interest rate / 4) ) ^ (0.5 * 4) ) - principal
 0.5 is a half of a year
 4 is the number of compounding periods

** principals are the deposits + accumulated interest till the beginning of the period

According to my calculations he is supposed to has 6185.11 in his account by the end of 2018

  • 6185.11 = 4800 + 1385.11
  • 6185.11 = 6003.65 + 181.46
Post Deleted by user 32135421 م
Post Undeleted by user 32135421 م
Post Deleted by user 32135421 م
deleted 3 characters in body
Source Link
user 32135421 م
user 32135421 م
  • 156
  • 4

According to my calculations he is supposed to havehas 6007.524375 (4800 + 1207.524375) in his account by the end of 2018

According to my calculations he is supposed to have 6007.524375 (4800 + 1207.524375) in his account by the end of 2018

According to my calculations he is supposed to has 6007.524375 (4800 + 1207.524375) in his account by the end of 2018

Source Link
user 32135421 م
user 32135421 م
  • 156
  • 4

+-------------+----------------------+---------------+-----------+
|      -      | deposits/principals  | interest rate | interest *| 
+-------------+----------------------+---------------+-----------+
|2nd half 2010| 100                  |0.07           |3.530625   |
|1st half 2011| 200                  |0.07           |7.06125    |
|2nd half 2011| 300                  |0.07           |10.591875  |
|1st half 2012| 400                  |0.07           |14.1225    |
|2nd half 2012| 500                  |0.07           |17.653125  |
|1st half 2013| 600                  |0.07           |21.18375   |
|2nd half 2013| 800                  |0.05           |20.125     |
|1st half 2014| 1000                 |0.05           |25.15625   |
|2nd half 2014| 3200                 |0.06           |96.72      |
|1st half 2015| 3400                 |0.06           |102.765    |
|2nd half 2015| 3600                 |0.06           |108.81     |
|1st half 2016| 3800                 |0.06           |114.855    |
|2nd half 2016| 4000                 |0.06           |120.9      |
|1st half 2017| 4200                 |0.06           |126.945    |
|2nd half 2017| 4400                 |0.06           |132.99     |
|1st half 2018| 4600                 |0.06           |139.035    |
|2nd half 2018| 4800                 |0.06           |145.08     |
+-------------+----------------------+---------------+-----------+
|sum of interest                                     |1207.524375|
+----------------------------------------------------+-----------+

*The formula used to calculate the interest column is

interest = (principal * (1 + (interest rate / 4) ) ^ (0.5 * 4) ) - principals
 0.5 is a half of a year
 4 is the number of compounding periods

According to my calculations he is supposed to have 6007.524375 (4800 + 1207.524375) in his account by the end of 2018