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.
 Hot
 Latest

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Chart a categorical frequency distribution in MS Excel

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Completely hide the Ribbon menu in Excel

How To: Cross tabulate categorical data with formulas in Excel

How To: Use Microsoft Publisher to add a shadow to text

How To: Extract a number from a text string by Excel formula

How To: Generate random numbers (with decimals) in Excel

How To: Enter formulas in Excel with a macro

How To: Calculate probability in an Excel pivot table

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Calculate monthly retirement income in Microsoft Excel

How To: Find critical values with T functions in MS Excel

How To: Use the IF function with letter grades in Excel

How To: Conditionally format at every change in value in Excel

How To: Create an array formula for Bayes' theorem in Excel

How To: Compare two lists and extract the new values in Excel

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Chart a categorical frequency distribution in MS Excel

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Completely hide the Ribbon menu in Excel

How To: Cross tabulate categorical data with formulas in Excel

How To: Use Microsoft Publisher to add a shadow to text

How To: Extract a number from a text string by Excel formula

How To: Generate random numbers (with decimals) in Excel

How To: Enter formulas in Excel with a macro

How To: Calculate probability in an Excel pivot table

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Calculate monthly retirement income in Microsoft Excel

How To: Find critical values with T functions in MS Excel

How To: Use the IF function with letter grades in Excel

How To: Conditionally format at every change in value in Excel

How To: Create an array formula for Bayes' theorem in Excel

How To: Compare two lists and extract the new values in Excel
Be the First to Comment
Share Your Thoughts