I need to do a recurring charges calculation based on an investment data.
Say I have data that shows the breakdown of my investment between month 1 and month 180 (15 years). I need to calculate as below:
First i'll set up a parameter to show how much I will invest per month, then I need to show,
1. The charges I incur if every 12 months i am charged 1.5% off my total investment.
2. Another recurring charge that deducts 2.5% off my accumulated investment every 5 years. Which means that between month 1 and 60, I am charged 2.5% from the accumulated investment, then it is reset. i am then charged again 2.5% on the accumulated amount between month 61 to month 120.
Anybody can guide me on this?
A little correction, on #2, I am charged the 2.5% at month 60, month 120 and onward every 5 years, but the percentage is calculated against the accumulated amount within the 5 years, then it is reset for the next.