Best Math Formula website. Search anything about Math Formula in this website.
how to solve for compound interest rate in excel. You need the beginning value interest rate and number of periods in years. Amount 1.
Compound Interest Formula In Excel Myexcelonline Excel Tutorials Learning Microsoft Microsoft Excel Tutorial from www.pinterest.com
To get the total number of payment periods we multiply it by 12. If the interest on your investment is paid monthly while being quoted as an annual interest rate the Excel compound interest formula becomes. In our example the formula is A2 1B2 where A2 is your initial deposit and B2 is the annual interest rate.
For this go to that cell and press Ctrl1 or right click to select Format Cells.
To get the total number of payment periods we multiply it by 12. In the example shown the formula in C10 is. NPER stands for the total number of compounding periods it equals the product of total number of years and number of compounding periods per year. The formula now becomes.
