Thank you sooo much! Great tutorial! Dollar sign for the win!
@KeanuKianK
Жыл бұрын
9 and a half years on and this video is still useful! Thanks :)
@melissaramirez6364
5 жыл бұрын
I watched about 10 tutorials trying to finish an Excel project - none helped. After watching yours, I was able to finish in less than five minutes. Thank you!
@hotdog1214
5 жыл бұрын
I'd been searching around for a calculation of compound interest and all the formulas I'd seen were based on yearly calculations, whereas I wanted one that is open ended. This is perfect. Thank you for the clear explanation and the bonus info about putting a dollar sign in to stop excel incrementing the cell numbers. Top marks!
@robertjuh
3 жыл бұрын
5% interest rate, imagine seeing this in 2021
@onzah3515
7 ай бұрын
Imagine seeing im 2024 lol
@denishamdiev2686
2 жыл бұрын
I know its quality content a guy sitting in his room discussing excell no intros no sponsors just old school quality contect thanks
@alexc5369
6 жыл бұрын
How would you calculate compound interest, calculated daily, paid monthly, on principal that is regularly increased
@tonytones843
5 жыл бұрын
I need the answer to this too. as my printable changes after a certain date.
@juanbaksi
2 жыл бұрын
Need an answer aswell to this inquiry
@jamesgraham8890
8 жыл бұрын
can you do monthly and quaterly
@sleeth
7 ай бұрын
That B$21 is a game changer! If I added a £3000 contribution each year, could I add to the end of C8 "+3000" ?
@tonytones843
5 жыл бұрын
HI.. great video.. I do however have a problem I'm hoping you can help me with?? i have a formula created that work compounding my initial principle at 10% but once this calculation begins and I then want to ADD another amount paid the whole calculation is revealed as if both payments where mad on the same day so the 10% compound has assumed there was only 1 original payment as apposed to a sum being added later on down the line?????? sorry could not explain this better but I hope you understand.
@faithbarrows5071
2 жыл бұрын
numbers really jumble my head but this tutorial made them enjoyable. Thank you for the dollar sign tip. Super helpful.
@JoseBYOB
2 жыл бұрын
I'm doing the same exact thing but I'm getting a different number for some reason. I'm doing a cell with $700 in it, multiplied by a cell with 10% in it, but I'm getting a result of $7000% for some reason.
@kungfu8856
8 ай бұрын
Hi, I think that this calculator is not accurate enough to use for dividends, if we are talking about compound dividends? dividends are paid every quarter, automatically every three months the principle will increase if you reinvest the dividends back...
@demateus100
7 жыл бұрын
Thank you It is a really good information. can you do a Monthly compound interest calculate something like putting $100 A Month with a compound interest thank you.
@nasikastrology
3 жыл бұрын
Can I use this calculations for daily or monthly basis except yearly for my own business pl reply or create a new video on this topic
@LawandLife
5 жыл бұрын
Excellent
@GeneralYouTube12
8 ай бұрын
OK So this is a principle amount but i want to calculate monthly amount,
@avinashbhan4056
Жыл бұрын
This was very well explained . Thanks for sharing
@mohamedbentahar3924
6 жыл бұрын
2:48 i get #value ! in 115$ how to fix that ?
@veliyevavusal
9 жыл бұрын
Thanks a lot , perfect explanation by simple way, i am appreciated :)
@stevecorrie7907
9 ай бұрын
How do you account for added monthly payments?
@MrGeorge48
9 жыл бұрын
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
@robertgunter9108
6 жыл бұрын
Best tutorial yet on this subject!
@alexandreb7683
4 жыл бұрын
Thank You my friend you helped me a lot !
@RDLV777
2 жыл бұрын
Sirji i can get this Excel copy
@JadeLao-n4q
9 ай бұрын
thanks for ur help! us stem students are thankful ❤
@magicmonk
9 ай бұрын
It's my pleasure
@LinLin-pv8kg
Жыл бұрын
Appreciate for your video!!!!
@masterthebasics4846
3 жыл бұрын
Thank you so much for your video, time and effort. Zacharie
@itsalv1
Жыл бұрын
Thanks a lot! I was too lazy to figure the formula, this video was very helpful!
@PintuKumar-fo3wh
6 жыл бұрын
Why you put dollar sing between b4. I am calcuting in rupee. What to do?
@Zackkkkk568
Жыл бұрын
Anyone know how to get monthly??
@justenelee2143
10 ай бұрын
Thank you!! Understood it much better once I watched this video.
@mikerobotgaming9687
11 ай бұрын
you are good brother, i learned a lot. thank you brother
@james2330
2 жыл бұрын
How do you find compounding interest when also adding a fixed amount each year?
@gotmikedaniels
Жыл бұрын
YOU MADE THIS SO EASY! THANK YOU! I applied it and made a RENT VS BUY with annual appreciation. Thanks!
@bhavyasreeev5152
3 жыл бұрын
Thank you very much dear Monk 🙏
@magicmonk
3 жыл бұрын
Thank you :)
@nigelpollitt5124
Жыл бұрын
completely sorted me out, and on a lot of spreadsheet basics, thanks
@ratheeshp7170
Жыл бұрын
easy step =principle*(1+interest)^years , thank me later
@maryannalcaraz
3 жыл бұрын
love it! thanks
@nasikastrology
3 жыл бұрын
Love from india❤️❤️❤️
@hadherramadhanmohammed3699
4 жыл бұрын
excelant pro exactlly what iam looking for
@apolinarioenglish
8 ай бұрын
Thank so much
@frankmoyer4519
3 жыл бұрын
how would you do for a monthly compound interest and end of year total?
@shahrintumirin4161
Жыл бұрын
thank you for the tutorial, it help me much
@ratheeshp7170
Жыл бұрын
easy step =principle*(1+interest)^years , thank me later
@nurkltoy
11 ай бұрын
Bro, this is amazing! Thank you!
@vinothkumar-db4mz
2 жыл бұрын
Very helpful and the method u r explaining is very easy and very clear to understand. Thank you so much. 👍👍
@magicmonk
2 жыл бұрын
Glad it was helpful! So nice of you to let me know buddy
@堅離地
Жыл бұрын
Thanks
@wadieseruge3523
5 жыл бұрын
Hi. Can you please make a video like this if someone wants to buy a car ??? Thank you
@endashawtilahun5252
2 жыл бұрын
thank u a lot sir for your effort and time.
@32nikhilpatel78
4 ай бұрын
thank you!!
@idahosabebeto9279
Жыл бұрын
GREAT TUTORIAL AND THANKS FOR HELPING
@871suraj
4 жыл бұрын
Very helpful video, thank you
@jax100
Жыл бұрын
Excellent tutorial, thank you!
@franciscosaimone2730
5 жыл бұрын
what if add more money every month?
@jeenajanardhanan4150
3 ай бұрын
👌🏻👌🏻
@danmurphythelongislandreal2206
4 жыл бұрын
The tutorial was excellent.
@GamingWithAro
Жыл бұрын
legit saved my life
@london4me2011
9 жыл бұрын
Thank you very much. This is an excellent lesson.
@laurasimms7031
Жыл бұрын
This is excellent.
@HauptFeldtmann
8 жыл бұрын
Thank brother Monk, you helped me out a lot today!!! I learned a good strategy, keep up the good work.
@chenoweezi
3 жыл бұрын
Legend!!!!! Thanks bro!!
@lillymcdaniel9375
3 жыл бұрын
very helpful!
@artyommkrtumyan6893
4 жыл бұрын
Thank you so much!
@Pibox
8 жыл бұрын
Thank you very much dude!!!! helped me a lot
@OmarCapellan
8 жыл бұрын
This was a great video. Thanks for the help
@EmpireTextbooks
6 жыл бұрын
This doesn’t show it compounded monthly or daily
@hotdog1214
5 жыл бұрын
You can change the formula in the last cell to divide the interest by 12 to make it monthly for example =C7+(D7/12)
@halzein4743
5 жыл бұрын
Great tutorial. thank you !!!
@lakerboy16
8 жыл бұрын
Thanks for your help!
@haridarshan7034
8 жыл бұрын
thank u dear u made my day
@swiftsifu
7 жыл бұрын
thank you, really helped.
@CJAM16
7 жыл бұрын
Awesome tutorial brother
@LL-kn1de
6 жыл бұрын
Thank you very much!!!
@ririsinofficial7382
6 жыл бұрын
Thank you !! You saved me!! hahah
@TheGodisdj
9 жыл бұрын
thanks a lot....
@pchat138
9 жыл бұрын
You're a lifesaver
@shadhiniqbal7453
7 жыл бұрын
thank you so much....
@djcb9032
6 жыл бұрын
good video
@jackc.3285
7 жыл бұрын
Thank you so much!
@mariomaciel4745
7 жыл бұрын
Thank you for your HELP, and for explaining it so simply. Thanks again.
Пікірлер: 89