Enter the years 0-5 in cells A2 to A7. Start by opening a document and labeling the top cell in columns A B and C Year Value and Interest Earned respectively. LOGARITHMIC FUNCTIONS Interest Rate Word Problems 1.
This is the currently selected item.
To use the compound interest formula you will need figures for principal amount annual interest rate time factor and the number of compound periods. Apply the power rule for logarithms to the right side. After some basic algebra you have. The trick to using a spreadsheet for compound interest is using compounding periods instead of simply thinking in years.