Annual rate calculator excel
Take note that there is no interest earned at time 0, so you put 0 for the periodic rate at Year 0. The future value is also listed to Year 3, where we want to have A, B, C, D, E, F, G. 1, INTEREST CALCULATION TEMPLATE. 2. 3, Member, Period 1, Period 2, Period 3, Total, Average, Interest due. 4, $ -, $ -. 5, $ -, $ -, $ -. Excel calculates the average annual rate of return as 9.52%. Remember that when you enter formulas in Excel, you double-click on the cell and put it in formula mode by pressing the equals key (=). When Excel is in formula mode, type in the formula.