# Microsoft Excel lesson two – compound fascination calculator (complete referencing, fill down)

In this lesson we make a compound fascination calculator to estimate how a great deal fascination the bank will pay back you if you save a selected sum of dollars in the bank. We chat about complete referencing employing dollar symptoms and what occurs when you fill down by dragging the corner dot down the screen.

1. Thank you for your HELP, and for explaining it so simply. Thanks again.

2. Thank you so much!

3. Awesome tutorial brother

4. Thank you very much dude!!!! helped me a lot

6. This was a great video. Thanks for the help

7. thank u dear u made my day

8. Thank brother Monk, you helped me out a lot today!!!
I learned a good strategy, keep up the good work.

9. can you do monthly and quaterly

10. 1
2
4
8
16
32
64
128
256
512
1024
2046
4092
8184
16368
32736
65472
130944
261888
523776
1047552
2095104
4190208
8380416
16760832
33521664
67043328
134086656
268173312
536346624
1072693248
2145386496
4290772992
8581545984
17163091968
34326183936
68652367872
1.37305E+11
2.74609E+11
5.49219E+11
1.09844E+12
2.19688E+12
4.39375E+12
8.7875E+12
1.7575E+13
3.515E+13
7.03E+13
1.406E+14
2.812E+14
5.624E+14
1.1248E+15
2.2496E+15
4.4992E+15
8.9984E+14
1.79968E+16
3.59936E+16
7.19872E+16
1.44E+17
2.88E+17
5.76E+17
1.15E+18
2.30E+18
4.61E+18
9.21E+18

what does the 9.21E+18 actually mean ?

11. thanks a lot….

12. You're a lifesaver

13. Thanks a lot , perfect explanation by simple way, i am appreciated 🙂

15. Thank you very much. This is an excellent lesson.

16. Compound interest calculator

Principal 2300
Interest rate p.a 5%

Year Principal Interest e.o.y.principal
1 2300 115 2415
2 2415 12075% 253575%
3
why is it not calculating properly on the second line.  I am using excel 2013