# Investing - Compound Interest

by Zahra
(BRISBANE, AUSTRALIA)

if i place a number other than '1' into the first cell, i get an incorrect value in an another cell. What value should be in that cell? what is an excel formula that will ensure all values are correct regardless of the starting year?

Compound Interest
Interest Rate 5.65%
Principal \$4,800.00
Rests per Year(n) 365

Time (year) Principal (\$) Yearly Interest Total Interest
5 \$6,366.78 \$1,566.78 \$1,566.78
2 \$5,374.19 -\$992.60 \$574.19
3 \$5,686.54 \$312.36 \$886.54
4 \$6,017.06 \$330.51 \$1,217.06
5 \$6,366.78 \$349.72 \$1,566.78
6 \$6,736.83 \$370.05 \$1,936.83
7 \$7,128.39 \$391.56 \$2,328.39
8 \$7,542.71 \$414.32 \$2,742.71
9 \$7,981.10 \$438.40 \$3,181.10
10 \$8,444.98 \$463.88 \$3,644.98
11 \$8,935.82 \$490.84 \$4,135.82
12 \$9,455.19 \$519.37 \$4,655.19
13 \$10,004.74 \$549.55 \$5,204.74
14 \$10,586.24 \$581.50 \$5,786.24
15 \$11,201.53 \$615.29 \$6,401.53
16 \$11,852.58 \$651.06 \$7,052.58
17 \$12,541.48 \$688.90 \$7,741.48
18 \$13,270.42 \$728.94 \$8,470.42
19 \$14,041.72 \$771.30 \$9,241.72
20 \$14,857.85 \$816.13 \$10,057.85
21 \$15,721.42 \$863.57 \$10,921.42
22 \$16,635.18 \$913.76 \$11,835.18
23 \$17,602.05 \$966.87 \$12,802.05
24 \$18,625.12 \$1,023.07 \$13,825.12
25 \$19,707.64 \$1,082.53 \$14,907.64
26 \$20,853.09 \$1,145.45 \$16,053.09
27 \$22,065.12 \$1,212.02 \$17,265.12
28 \$23,347.58 \$1,282.47 \$18,547.58
29 \$24,704.59 \$1,357.01 \$19,904.59
30 \$26,140.47 \$1,435.88 \$21,340.47