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

[@camillerodriguez3258]

How did you get the percentage rate? Was it a formula from using the APY?

[@808orion]

Much appreciated. Thanks for the info.

[@ChrisMenardTraining]

welcome.

[@slick2000aus1]

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]

Thank you. I appreciate it.

[@shaam32]

thanks it was very helpful

[@ChrisMenardTraining]

You're welcome!

[@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?

[@roywilson9580]

Thanks for the video, Chris. Great revision of some of the accounting functuions that haven't used in a while

[@janedoe733]

thanks for the great video! what if the bank does not offer compounding at all? does the same formula apply?

[@ChrisMenardTraining]

That would be simple interest.

[@sondrasponseller3817]

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]

Both. discover told me the interest rate and the APY. I used Excel to verify the APY was correct.

[@TKae421]

Your video was very helpful, thank you, Chris!

[@ChrisMenardTraining]

You're very welcome!

[@rhondacharlett8216]

You are a very good teacher. Thank you for explaining the APY is such detail. I now have my own spreadsheet. Thank you!!!

[@bearbear5353]

where do I find the excel file mentioned at 8:42 in the video, cannot find it in blog posting

[@ChrisMenardTraining]

Here is the file drive.google.com/drive/folders/1disTVTFFzexsPCnjkP6Ynt8il-GyLhqP?usp=sharing

[@ddp2049]

This was a great video. keep up the great work

[@ChrisMenardTraining]

Thank you! Will do!

[@FamilleMokChamplan]

Amazing teacher & very clear explanation with topic explain with examples !

[@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

[@gmsmds]

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)

[@meganmorley3543]

Thank you! This was super helpful for me.

[@ChrisMenardTraining]

Glad it helped!

[@richardatkinson6031]

wow,I found a home here, great interest video.

[@twum4]

Excellent video 👍🏾

[@ChrisMenardTraining]

Much appreciated

[@DH-qz4mx]

You do a very good job Chris. Thanks a bunch