Hello to all, Thank you very much for your assistant in advance. I want to calculate interest for customers; for example for customer A like this interest calculate in 2010 with interest rate 15% and calculated interest amount plus amount transferred to 2011 calculated with interest rate of 2011 and then calculated 2011 payments from 20% interest rate and goes on like that for the following years: 2010 interest amount+amount:30.555,94 transferred to 2011, in 2011 (30.555,94*0,2(yearly)=6.111) and plus 2011 amounts and interest amounts 2.199,01. So if there is 2012 the transferred amount would be 38.866,14. Is there any suggestion to this calculation with pivot table or formula arrangement to calculate this for each customer with automated.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
