Great video, thank you! Would you consider doing something similar for calculating interest (and future balance) on a high interest/ high APY savings account? For example, how to determine how much interest will be earned over a certain period of time with consistent deposits each week/month. Let's say interest is compounded daily and applied monthly. I did find two videos about this, but I wasn't able to follow along as easily as I do when watching your tutorials.
Can you please help me to create a excel sheet for this case:- I have a loan of ₹6Lac and earning salary ₹15k with every year of increment ₹3k and from that my expenses are per month ₹6k and the rest is used for clearing loan payment then how many years it took to clear the loan????
When you calculate back (which is on first example) 2835,43*30*12= 1020754,8 is the future value and when you divide it with primary value 1.020.754,8/450.000= 2,268344 (this is the 30 years rate . When you divide this number by 30 The annual interest rate shows 0,0756 which is 7,56% is not the same interest rate (6,47%) . Where is the mistake ???
Hello , Could you please assist us to resolve this exempl, I need an excel formula to split an amount over several cells while respecting the limit of each cell eg: A1 : 10000 $ I want to automatically split this amount to B1 (MAX 200) B2 (MAX 200) B3 (MAX 250) B4 (MAX 250) B5 (THE REST) Thanks
I'm studying Business Admin and your channel helps me so much. You explain so well, straight to the point. You are always my go to.. Thank you!
Great video! Your approach is simple and easy to follow. Kindly create a video on payroll. Thanks in advance.
Watching from India, the way you explained is amazing
Great video it was very helpful. I will share with anyone I know in need of more details solving this type of problem 😊
Nice presentation..Thank you.
Great video, thank you! Would you consider doing something similar for calculating interest (and future balance) on a high interest/ high APY savings account? For example, how to determine how much interest will be earned over a certain period of time with consistent deposits each week/month. Let's say interest is compounded daily and applied monthly. I did find two videos about this, but I wasn't able to follow along as easily as I do when watching your tutorials.
You want to see how fast I am? Let me get a notification from this gentleman, and I'll click on the video so fast, lol.
Thank you for this tutorial. Nice 👍
Thanks alot Boss, it has been very informative
Thank You! 🤗🤩👍🏻Awesome!!
so helpful
Thank YOU SO MUCH.
Very useful 👍
Ily you’re my hero
Thank you!!!
Thank you
thx pro
Sir plz do hlookup, vlookup, xlookup newer version videos ASAP!!
I am getting the value in Minus.
Can you pls help to how to calculate weekly payment...?
=PMT($B$22/52.143,F5*52.143,-E5)
i think that one year has approximately 52.143 weeks. Therefore, we are gonna multiply the nper by 53 weeks.
Hi supposed if i want to use a bimonthly system instead of paying monthly. I would replace the 12 with a 26, is that correct?
Can you please help me to create a excel sheet for this case:-
I have a loan of ₹6Lac and earning salary ₹15k with every year of increment ₹3k and from that my expenses are per month ₹6k and the rest is used for clearing loan payment then how many years it took to clear the loan????
If you got the answer or if you any other related video please let me know
How to compute using a manual calculator?
Hello! How we can calculate loan payments with residual value at the end of perriod?
Th u
When you calculate back (which is on first example) 2835,43*30*12= 1020754,8 is the future value and when you divide it with primary value 1.020.754,8/450.000= 2,268344 (this is the 30 years rate . When you divide this number by 30 The annual interest rate shows 0,0756 which is 7,56% is not the same interest rate (6,47%) . Where is the mistake ???
Nice
Hello ,
Could you please assist us to resolve this exempl,
I need an excel formula to split an amount over several cells while respecting the limit of each cell
eg:
A1 : 10000 $
I want to automatically split this amount to
B1 (MAX 200)
B2 (MAX 200)
B3 (MAX 250)
B4 (MAX 250)
B5 (THE REST)
Thanks
where`s the downloadable file?
👏 👏 👏
First one to like and comment
⚡🏠🚦🌞
Useless formula 😢😢
Thank you