Calculate Compound Interest and Future Value of Principal 451,824.00 (Dollar, Euro, Pound). Duration: 5 Years. Annual Interest Rate: 10.00%. Compounded Monthly. Regular Contribution: 197.00, Monthly, Added to the Balance at the End of Compounding Period
Calculation method used. Calculation formula. Used notations.
[1] Calculation method used: 30 / 360
Number of days in a month
30
Number of days in a year
360
Number of months in a year
12
[2] Future Investment Value, FV
Calculation formula:
For a full compounding period:
FV = P × (1 + r/n)1
For a partial compounding period:
FV = P × (1 + r/n)(np ÷ nt)
np - number of days in the partial period
nt - number of days in the full period
[3] Used notations:
- FV, Future Investment Value
- P, Balance at the beginning of the compounding period
- r, Annual compound interest rate, r = 10.00%
- n, Number of times the interest compounds during a year
Compound frequency: monthly (12 times a year)
n = 12 - r/n = 10.00%/12 = (10.00 ÷ 100)/12 = 10.00/(100 × 12)
r/n = 0.008333333333
» Compound Interest: what is it, how is it calculated?
Duration of the investment. Number of compounding periods
[4] Duration of the investment, t
t = 5 years
The investment duration period, in days:
5 years × 360 days / year
t = 1,800 days
[5] Number of compounding periods
Interest compounded: monthly (12 times a year).
Compounding period duration, dcp:
360 ÷ 12 = 30 days (one month).
Number of compounding periods:
t ÷ dcp = 1,800 ÷ 30 = 60
There are 60 full compounding periods.
Calculation: Future investment Value. Compound Interest
[6] Project Breakdown..
Calculations steps and the summary table
Interest compounded: monthly
Contribution frequency: monthly
Contribution added to the balance
at the end of each compounding period
There are 60 compounding periods in total.
Below, the calculations for some of them.
The first three compounding periods:
Start month 1.
Duration: 30 days = a full compounding period.
Calculate the Future investment Value
at the end of the compounding period:
451,824.00 × (1 + 0.008333333333)1 =
451,824.00 × 1.008333333333 =
455,589.20
Add the periodic contribution to the balance:
455,589.20 + 197.00 =
455,786.20
Start month 2.
Duration: 30 days = a full compounding period.
Calculate the Future investment Value
at the end of the compounding period:
455,786.20 × (1 + 0.008333333333)1 =
455,786.20 × 1.008333333333 =
459,584.42
Add the periodic contribution to the balance:
459,584.42 + 197.00 =
459,781.42
Start month 3.
Duration: 30 days = a full compounding period.
Calculate the Future investment Value
at the end of the compounding period:
459,781.42 × (1 + 0.008333333333)1 =
459,781.42 × 1.008333333333 =
463,612.93
Add the periodic contribution to the balance:
463,612.93 + 197.00 =
463,809.93
And the process goes along,
as detailed in the steps above.
The last two compounding periods:
Start month 59.
Duration: 30 days = a full compounding period.
Calculate the Future investment Value
at the end of the compounding period:
745,768.27 × (1 + 0.008333333333)1 =
745,768.27 × 1.008333333333 =
751,983.00
Add the periodic contribution to the balance:
751,983.00 + 197.00 =
752,180.00
Start month 60.
Duration: 30 days = a full compounding period.
Calculate the Future investment Value
at the end of the compounding period:
752,180.00 × (1 + 0.008333333333)1 =
752,180.00 × 1.008333333333 =
758,448.17
Add the periodic contribution to the balance:
758,448.17 + 197.00 =
758,645.17
[7] Project Summary. Monthly
Interest compounded: monthly
Contribution frequency: monthly
Contribution added to the balance
at the end of each compounding period
| Month | Days | Deposits | Total deposits | Interest | Total interest | Balance |
|---|---|---|---|---|---|---|
| 0 | -- | 451,824.00 | 451,824.00 | -- | -- | 451,824.00 |
| 1 | 30 | 197.00 | 452,021.00 | 3,765.20 | 3,765.20 | 455,786.20 |
| 2 | 30 | 197.00 | 452,218.00 | 3,798.22 | 7,563.42 | 459,781.42 |
| 3 | 30 | 197.00 | 452,415.00 | 3,831.51 | 11,394.93 | 463,809.93 |
| 4 | 30 | 197.00 | 452,612.00 | 3,865.08 | 15,260.01 | 467,872.01 |
| 5 | 30 | 197.00 | 452,809.00 | 3,898.93 | 19,158.95 | 471,967.95 |
| 6 | 30 | 197.00 | 453,006.00 | 3,933.07 | 23,092.01 | 476,098.01 |
| 7 | 30 | 197.00 | 453,203.00 | 3,967.48 | 27,059.50 | 480,262.50 |
| 8 | 30 | 197.00 | 453,400.00 | 4,002.19 | 31,061.68 | 484,461.68 |
| 9 | 30 | 197.00 | 453,597.00 | 4,037.18 | 35,098.86 | 488,695.86 |
| 10 | 30 | 197.00 | 453,794.00 | 4,072.47 | 39,171.33 | 492,965.33 |
| 11 | 30 | 197.00 | 453,991.00 | 4,108.04 | 43,279.37 | 497,270.37 |
| 12 | 30 | 197.00 | 454,188.00 | 4,143.92 | 47,423.29 | 501,611.29 |
| 13 | 30 | 197.00 | 454,385.00 | 4,180.09 | 51,603.39 | 505,988.39 |
| 14 | 30 | 197.00 | 454,582.00 | 4,216.57 | 55,819.96 | 510,401.96 |
| 15 | 30 | 197.00 | 454,779.00 | 4,253.35 | 60,073.31 | 514,852.31 |
| 16 | 30 | 197.00 | 454,976.00 | 4,290.44 | 64,363.74 | 519,339.74 |
| 17 | 30 | 197.00 | 455,173.00 | 4,327.83 | 68,691.57 | 523,864.57 |
| 18 | 30 | 197.00 | 455,370.00 | 4,365.54 | 73,057.11 | 528,427.11 |
| 19 | 30 | 197.00 | 455,567.00 | 4,403.56 | 77,460.67 | 533,027.67 |
| 20 | 30 | 197.00 | 455,764.00 | 4,441.90 | 81,902.57 | 537,666.57 |
| 21 | 30 | 197.00 | 455,961.00 | 4,480.55 | 86,383.12 | 542,344.12 |
| 22 | 30 | 197.00 | 456,158.00 | 4,519.53 | 90,902.66 | 547,060.66 |
| 23 | 30 | 197.00 | 456,355.00 | 4,558.84 | 95,461.50 | 551,816.50 |
| 24 | 30 | 197.00 | 456,552.00 | 4,598.47 | 100,059.97 | 556,611.97 |
| 25 | 30 | 197.00 | 456,749.00 | 4,638.43 | 104,698.40 | 561,447.40 |
| 26 | 30 | 197.00 | 456,946.00 | 4,678.73 | 109,377.13 | 566,323.13 |
| 27 | 30 | 197.00 | 457,143.00 | 4,719.36 | 114,096.49 | 571,239.49 |
| 28 | 30 | 197.00 | 457,340.00 | 4,760.33 | 118,856.82 | 576,196.82 |
| 29 | 30 | 197.00 | 457,537.00 | 4,801.64 | 123,658.46 | 581,195.46 |
| 30 | 30 | 197.00 | 457,734.00 | 4,843.30 | 128,501.75 | 586,235.75 |
| 31 | 30 | 197.00 | 457,931.00 | 4,885.30 | 133,387.05 | 591,318.05 |
| 32 | 30 | 197.00 | 458,128.00 | 4,927.65 | 138,314.70 | 596,442.70 |
| 33 | 30 | 197.00 | 458,325.00 | 4,970.36 | 143,285.06 | 601,610.06 |
| 34 | 30 | 197.00 | 458,522.00 | 5,013.42 | 148,298.47 | 606,820.47 |
| 35 | 30 | 197.00 | 458,719.00 | 5,056.84 | 153,355.31 | 612,074.31 |
| 36 | 30 | 197.00 | 458,916.00 | 5,100.62 | 158,455.93 | 617,371.93 |
| 37 | 30 | 197.00 | 459,113.00 | 5,144.77 | 163,600.70 | 622,713.70 |
| 38 | 30 | 197.00 | 459,310.00 | 5,189.28 | 168,789.98 | 628,099.98 |
| 39 | 30 | 197.00 | 459,507.00 | 5,234.17 | 174,024.14 | 633,531.14 |
| 40 | 30 | 197.00 | 459,704.00 | 5,279.43 | 179,303.57 | 639,007.57 |
| 41 | 30 | 197.00 | 459,901.00 | 5,325.06 | 184,628.63 | 644,529.63 |
| 42 | 30 | 197.00 | 460,098.00 | 5,371.08 | 189,999.71 | 650,097.71 |
| 43 | 30 | 197.00 | 460,295.00 | 5,417.48 | 195,417.20 | 655,712.20 |
| 44 | 30 | 197.00 | 460,492.00 | 5,464.27 | 200,881.46 | 661,373.46 |
| 45 | 30 | 197.00 | 460,689.00 | 5,511.45 | 206,392.91 | 667,081.91 |
| 46 | 30 | 197.00 | 460,886.00 | 5,559.02 | 211,951.93 | 672,837.93 |
| 47 | 30 | 197.00 | 461,083.00 | 5,606.98 | 217,558.91 | 678,641.91 |
| 48 | 30 | 197.00 | 461,280.00 | 5,655.35 | 223,214.26 | 684,494.26 |
| 49 | 30 | 197.00 | 461,477.00 | 5,704.12 | 228,918.38 | 690,395.38 |
| 50 | 30 | 197.00 | 461,674.00 | 5,753.29 | 234,671.67 | 696,345.67 |
| 51 | 30 | 197.00 | 461,871.00 | 5,802.88 | 240,474.55 | 702,345.55 |
| 52 | 30 | 197.00 | 462,068.00 | 5,852.88 | 246,327.43 | 708,395.43 |
| 53 | 30 | 197.00 | 462,265.00 | 5,903.30 | 252,230.73 | 714,495.73 |
| 54 | 30 | 197.00 | 462,462.00 | 5,954.13 | 258,184.86 | 720,646.86 |
| 55 | 30 | 197.00 | 462,659.00 | 6,005.39 | 264,190.25 | 726,849.25 |
| 56 | 30 | 197.00 | 462,856.00 | 6,057.08 | 270,247.32 | 733,103.32 |
| 57 | 30 | 197.00 | 463,053.00 | 6,109.19 | 276,356.52 | 739,409.52 |
| 58 | 30 | 197.00 | 463,250.00 | 6,161.75 | 282,518.27 | 745,768.27 |
| 59 | 30 | 197.00 | 463,447.00 | 6,214.74 | 288,733.00 | 752,180.00 |
| 60 | 30 | 197.00 | 463,644.00 | 6,268.17 | 295,001.17 | 758,645.17 |
| Month | Days | Deposits | Total deposits | Interest | Total interest | Balance |
[8] Compound Interest amount, CI
Calculation formula:
CI = FV - (P + Tot. Contrib.)
CI - Compound Interest amount
FV - Future investment Value
P - Principal (initial amount)
Tot. Contrib. - Total value of contributions
Calculate the Compound Interest amount:
CI =
758,645.17 - (451,824.00 + 11,820.00) =
758,645.17 - 463,644.00 =
295,001.17
Answer:
Principal (initial amount)
451,824.00
Deposits
11,820.00
Principal + Deposits
463,644.00
Future investment Value
758,645.17
Compound Interest amount
295,001.17