Download Excel Files:
Start File
Finished File
Full Page With All File Links:
When your savings plans pays interest 365 days in a year and you make monthly deposits, use the NOMINAL and EFFECT functions first before using the FV function to calculate what the savings plan will be worth at maturity.
How do you calculate Future Value when you make monthly deposits but daily interest is paid? Use the NOMINAL and EFFECT functions first before using the FV function!
Nominal Rate APR Rate Annual Percentage Rate Effective Annual Rate.
In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!
The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!
Formula
thanks sir ji
i'm looking for something simmule, I already know that i have a daily of 1.6% avarage which increses based on the current Vallue. I'm looking for a Formula that makes me automaticly update the compounding intrest based on my current vallue. i'm guessing that's going to work with a listing.
Thank you so much for this tutorial! I couldn't find out how to do this anywhere else!
Doing a sheet showing daily interest for 30 years using chained together array formulas was proving impossible. This method is not an exact amount but a few cents off. Definitely the best one available for what it does in formula. Thank you!