Mortgage Calculator

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.

17 comments

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

    Reply
  2. Thank you so much!

    Reply
  3. Awesome tutorial brother

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

    Reply
  5. Thanks for your help!

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

    Reply
  7. thank u dear u made my day

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

    Reply
  9. can you do monthly and quaterly

    Reply
  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 ?

    Reply
  11. thanks a lot….

    Reply
  12. You're a lifesaver

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

    Reply
  14. Very helpful. Thank you

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

    Reply
  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

    Reply
  17. Excellent

    Reply

Leave a Reply