Hey Chandoo, nice video bro. Can you make a video showing us how to construct such dynamic chart titles like the ones you did here (while also preserving currency formats and such)? It's amazing and I'd like to learn how to do it.
Hey Chandoo can you help in creating a solution at my workplace How can I upload any PDF/Word file in a dedicated Excel cell and share the sheet with a team, so they can access the file I uploaded?
Can you help me in one formula in excel. Wherein I need 4 input boxes, two for From Date and To Date, Interest Rate per Month, And Principal Amount. Now I need a formula to calculate Compund interest on the principal amount wherein interest gets compounded every 11 months. A month always has 30 days. Even few days extra needs to be considered as a Full Month. I mean from 20-Mar-2022 to 25 - Mar-2024. It will be 24 months and 5 days, but it should calculate it as 25 months. Interest Needs to be calculated for first 11 months when duration is more than 11 months and then for the rest of the duration interest needs to be calculated on principal+11 months interest.
It's worth pointing out that spilled ranges often don't need locked cell references. For example, in the "Effect of Interest Rate on Compounding" section, you use the formula =FV(C122#,$D$118,,-$D$117), however the formula =FV(C122#,D118,,-D117) gives the same exact answer, and makes the formula more flexible and less error prone. Likewise, the formula =$D$93*(1+$D$94/D$98:I$98)^($C99:$C102*D$98:I$98) in the "Effect of Compounding Frequency" section can be simplified to =D93*(1+D94/D98:I98)^(C99:C102*D98:I98). And so on. Spilled Range is a beautiful thing!
In this case, you create a schedule by month, calculate opening balance and closing balance of both interest and principal and then reduce the amounts. You can use ipmt and ppmt functions for some of the numbers.
Thanks Chandoo, a fantastic video. Can I please ask how would you modify the FV formula to include a starting amount? e.g. if you have $20,000 to invest, and want to add $5,000 per annum at 8% interest rate, how would you modify the formula to include this initial lump sum? Thanks
You are welcome. You can use this variation. =FV(8%,10,5000,20000) calculates future value of initial investment of $20k + 5k per annum for 10 years at 8%
Went thru so many examples in the net, and finally chanced upon yours. Clear and straightforward for very layman like me to understand. Thanks man :D
Absolutely pedagogical. Very instructive. Thank you!!!
Great, informative, educational, entertaining videos... Big fan.
I am your big fan Boss
first comment 😀
Hey Chandoo, nice video bro. Can you make a video showing us how to construct such dynamic chart titles like the ones you did here (while also preserving currency formats and such)? It's amazing and I'd like to learn how to do it.
Hey Chandoo can you help in creating a solution at my workplace
How can I upload any PDF/Word file in a dedicated Excel cell and share the sheet with a team, so they can access the file I uploaded?
Sir pls make video on salary bonus sheet all employees
hi bro, can you post this chart in excel format of the comment section ?
Chandoo, that was an excellent video. Can you please create a video demonstrating how to prepare an employee monthly performance sheet?
That should be $10,998,806.28 for 100 years If I'm correct
Hi Chandoo, How to contact you, we need advanced excel training.
Please get in touch via chandoo.org/wp/power-bi-remote-training/
5k @ 8% in 100 years = 1,09,98,806.28
How please?
can someone tell me, how to download sample data set?🥲
for 100 Years $10,993,806.28
2nd Time
Sir please make a video on advance ecommerce metrics e.g: CLV, CAC, COG, AOV, customer retention rate and more. Please.....
Can you help me in one formula in excel. Wherein I need 4 input boxes, two for From Date and To Date, Interest Rate per Month, And Principal Amount. Now I need a formula to calculate Compund interest on the principal amount wherein interest gets compounded every 11 months. A month always has 30 days. Even few days extra needs to be considered as a Full Month. I mean from 20-Mar-2022 to 25 - Mar-2024. It will be 24 months and 5 days, but it should calculate it as 25 months. Interest Needs to be calculated for first 11 months when duration is more than 11 months and then for the rest of the duration interest needs to be calculated on principal+11 months interest.
Suggest me course for banking and finances
Can u make videos on power query and Power pivot
can I have the template
It's worth pointing out that spilled ranges often don't need locked cell references. For example, in the "Effect of Interest Rate on Compounding" section, you use the formula =FV(C122#,$D$118,,-$D$117), however the formula =FV(C122#,D118,,-D117) gives the same exact answer, and makes the formula more flexible and less error prone.
Likewise, the formula =$D$93*(1+$D$94/D$98:I$98)^($C99:$C102*D$98:I$98) in the "Effect of Compounding Frequency" section can be simplified to =D93*(1+D94/D98:I98)^(C99:C102*D98:I98).
And so on. Spilled Range is a beautiful thing!
They are indeed very powerful and flexible.
Excellent Chandoo!
What happen when interest compounded quarterly with mothly installment payments declining method
In this case, you create a schedule by month, calculate opening balance and closing balance of both interest and principal and then reduce the amounts. You can use ipmt and ppmt functions for some of the numbers.
meeru Thopu sir
Great work
Thanks Chandoo, a fantastic video. Can I please ask how would you modify the FV formula to include a starting amount? e.g. if you have $20,000 to invest, and want to add $5,000 per annum at 8% interest rate, how would you modify the formula to include this initial lump sum? Thanks
You are welcome. You can use this variation.
=FV(8%,10,5000,20000)
calculates future value of initial investment of $20k + 5k per annum for 10 years at 8%
@@chandoo_ fantastic thank you :)
Thanks you made it so easy to understand even children can understand by seeing this video