Тёмный

Annual Percentage Yield (APY) and Future Value and Effect function in Excel by Chris Menard 

Chris Menard
Подписаться 76 тыс.
Просмотров 16 тыс.
50% 1

Опубликовано:

 

1 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@camillerodriguez3258
@camillerodriguez3258 4 года назад
How did you get the percentage rate? Was it a formula from using the APY?
@808orion
@808orion 29 дней назад
Much appreciated. Thanks for the info.
@ChrisMenardTraining
@ChrisMenardTraining 29 дней назад
welcome.
@shaam32
@shaam32 5 месяцев назад
thanks it was very helpful
@ChrisMenardTraining
@ChrisMenardTraining 5 месяцев назад
You're welcome!
@Jetlag320
@Jetlag320 Год назад
Chris - nice presentation. At the 2:17 point you say the interest rate is daily. That would be a very high annual rate. Did you mean to say that the rate was compounded daily?
@slick2000aus1
@slick2000aus1 2 года назад
Chris, Thanks for this information. I was struggling to workout my daily interest on my money but you showed me some very easy functions to use. Great stuff.
@ChrisMenardTraining
@ChrisMenardTraining 2 года назад
Thank you. I appreciate it.
@roywilson9580
@roywilson9580 4 года назад
Thanks for the video, Chris. Great revision of some of the accounting functuions that haven't used in a while
@rhondacharlett8216
@rhondacharlett8216 5 месяцев назад
You are a very good teacher. Thank you for explaining the APY is such detail. I now have my own spreadsheet. Thank you!!!
@janedoe733
@janedoe733 3 года назад
thanks for the great video! what if the bank does not offer compounding at all? does the same formula apply?
@ChrisMenardTraining
@ChrisMenardTraining 3 года назад
That would be simple interest.
@sondrasponseller3817
@sondrasponseller3817 4 года назад
Great Video but I too am not sure how you found the actual interest rate. Did you find it by calculating it or did you find it on the Discover website.
@ChrisMenardTraining
@ChrisMenardTraining 4 года назад
Both. discover told me the interest rate and the APY. I used Excel to verify the APY was correct.
@hanko498
@hanko498 Год назад
What would I change to get the daily interest when it is compounded monthly? Also, do you know a formula to find the interest rate when only the apy is given? Thx
@FamilleMokChamplan
@FamilleMokChamplan 5 месяцев назад
Amazing teacher & very clear explanation with topic explain with examples !
@TKae421
@TKae421 Год назад
Your video was very helpful, thank you, Chris!
@ChrisMenardTraining
@ChrisMenardTraining Год назад
You're very welcome!
@gmsmds
@gmsmds 3 года назад
Thanks a lot for your video. I have a question : What is the formula to have the right Ending Value of an Random day. Let's say, I want to calculate the Ending Value after 9 days ? (without doing day by day as you did)
@bearbear5353
@bearbear5353 Год назад
where do I find the excel file mentioned at 8:42 in the video, cannot find it in blog posting
@ChrisMenardTraining
@ChrisMenardTraining Год назад
Here is the file drive.google.com/drive/folders/1disTVTFFzexsPCnjkP6Ynt8il-GyLhqP?usp=sharing
@ddp2049
@ddp2049 10 месяцев назад
This was a great video. keep up the great work
@ChrisMenardTraining
@ChrisMenardTraining 10 месяцев назад
Thank you! Will do!
@meganmorley3543
@meganmorley3543 4 года назад
Thank you! This was super helpful for me.
@ChrisMenardTraining
@ChrisMenardTraining 4 года назад
Glad it helped!
@richardatkinson6031
@richardatkinson6031 Год назад
wow,I found a home here, great interest video.
@DH-qz4mx
@DH-qz4mx Год назад
You do a very good job Chris. Thanks a bunch
@twum4
@twum4 2 года назад
Excellent video 👍🏾
@ChrisMenardTraining
@ChrisMenardTraining 2 года назад
Much appreciated
Далее
APR vs Interest Rate by Chris Menard
10:16
Просмотров 5 тыс.
Обменялись песнями с POLI
00:18
Просмотров 110 тыс.
COUNTIFS function in Excel with dates by Chris Menard
15:25
Annual Percentage Rate vs Annual Percentage Yield
13:24
Master the IF Formula in Excel (Beginner to Pro)
11:16
Просмотров 473 тыс.
calculating future value on excel
6:18
Просмотров 329 тыс.