Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of effect function. Notice that the effective rate is greater than the nominal because of compounding. Now from this you can compute the annual percentage rage rate from which you can calculate the maturity value. This video shows how to compute maturity values with daily interest deposits.
Home
Microsoft Office How to Use Excel for daily interest and monthly deposits
By Sean Conaty
Apr 22, 2010 07:42 AM
You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.
Sign up for Gadget Hacks Weekly and start unlocking your phone's full potential.
Comments
Be the first, drop a comment!