1 Reply Latest reply on Dec 18, 2012 5:11 PM by Fakhzan Firdaus Bin Abdullah

# How do I show recurring charges?

Hi there,

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?

• ###### 1. Re: How do I show recurring charges?

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.