?? Work at Pickup Points � Flexible schedule

Making a Compounding Interest Calculator in Excel

David McLachlan 69 views

Download Video

Comments

Dramatick😂😊
Comment from : @SajiSNairNair-tu9dk

If this is right, I’m going to have 32 million in my account when I retire… brbrThat’s if I maintain my 9k annual investment and I went conservative on interest and dropped it to 95
Comment from : @justjuan589

This is nice, but so simplistic It assumes you will be adding $6,000 each year for 30 to 40 years, what happens with inflation, and also when you need to start making withdrawals at some point What is the impact on balance? and spendable balance taking inflation into consideration?
Comment from : @Pavlov60

I am trying to create a compounding wage calculator with different raise percentages over each year for 4 years in which co workers can put their hourly rate in the first cell and get their new rates for each year Any ideas
Comment from : @Watchingyou-daily

What if I want to do an increase in investment of 5 a year? What changes do I need to make for that? And I also want to consider inflation too! So would get a better idea of nominal returns and real returns!
Comment from : @vktultrainstinct

Unfortunately this is useless Compounding interest monthly and depositing monthly would be far more useful Why would someone save up $500 a month and not put it into this account immediately to start making gains?
Comment from : @jasonb2553

would this be the same formula for a monthly dividend reinvestment?
Comment from : @theoriginalDirtybill

Thank you so much ❤❤❤❤for your help
Comment from : @cc-finance07

Stuck at the offset formula It keeps giving me the full range and unable to adjust Great tutorial other than that, I'll just go without the chart
Comment from : @financialcheatcodes

mines worked but when i use it - it doesnt compound the way it does on the online compounding interest calculators
Comment from : @lovinarobinson7284

This was the best worst instructional video I've ever watched The speed at which he moves through some sections with hotkeys and shortcuts he doesn't explain requires you to watch it in 25 speed and still miss stuff It's like he's trying to teach without actually letting you know 100 of what he's doing like he's protecting trade secrets or something
Comment from : @geraldrekau-zo6ke

I just found your channel Great explanation on how to create a compound interest chart Question: How would you modify it to add additional streams of contribution at specific years vs just the one annual field? Example: I retired 4 years ago At a specific age I will start collecting Social Security (I live in the United States) Additionally, I invest in commercial real estate crowdfunding with specific year payouts How would add those amounts in specific years, as well?
Comment from : @craiglibby1224

thanks
Comment from : @AbdulGaffar-xv7bz

Great video and tutorial brThank you so much; I follow it until the end, and I learn a lot! 😀
Comment from : @inversionero

Hi David, brExcellent video brI have a question on how to make a table/graph that would represent your earnings from compound staking brIn other words brbrIf I invest $10,000 at 12 APY for period of 120 days my earnings would be aprox $395brBut I have the option to compound my earnings at any point brSo my question is, if I wanted to put back my monthly earnings (aprox $98) back into my initail investment for the remaining days (90), how much would I be earning?brrespectively for 60 days, and 30 days left brbrI would greatly appreciate your help on how to write up a table for this
Comment from : @SaitaAlpha

DavidbrbrThe direction of value investing is actually aiming for "compounding interest"brbrCompounding interest is actually talking about compounding dividend brbrA growth stock which consistently pay dividends, consists of “Intrinsic Value Compounding” and “Dividend Compounding”brbrRather than saying “Intrinsic Value Compounding” is being invented, i would say that “Intrinsic Value Compounding” is rather a discovery of a buried compounding inherited in a consistently growing stockbrbrNobody knows there is so called “intrinsic value compouding” except Buffett, Munger and Li Lu I am very sure about this argumentbrbrIf you want to have a breakthrough in the new value investing, i suggest you start to do research on “Intrinsic Value Compounding"brbrLogic and reasoning are utmost importantbrbrHope you found the way to reveal the right formula of “Intrinsic Value Compounding”brbrThe impact power magnitude of “Intrinsic Value Compouding” is very much stronger than the widely spoken “Compounding Interest” aka “Dividend Compounding”brbrCheers
Comment from : @vidya014

If I may ask, for the offset formula - how come your excel sheet only shows one value when the width is actually 15 cells? I have followed your instructions step by steps but when I enter the offset formula my offset output creates an array of 1x15 years which is different from your output result Is there a setting there I may have missed out ?
Comment from : @QuantumVarranis

Total amount calculation seems wrong, pls recheck
Comment from : @SHS-8

Great video and nice and quick Question though, for you or anyone - how do you add in fees? For example I am trying to show the impact of MER's on growth I can do it by building out a large worksheet but can not figure out how to have work dynamically as you have done here Thank you in advance
Comment from : @shawnpeters3389