Excel Consistent Formula Needed Across 24 Months

[Ayesh856]

I have 24 months in my SaaS financial model and some costs have to charged on annual basis. I am unable to draw a formula that can be applied across all the rows consistently and only give me costs at the end of the year e.g. in months 12, 24, 36, and so on.

Similarly, I have to apply a rate at after a year when the customer has joined. For example if customer has joined in April 2015 the formula should take up the figure and give resultant figure in April 2016.

Can anyone help please?

 

[RCBricker]

I have 24 months in my SaaS financial model and some costs have to charged on annual basis. I am unable to draw a formula that can be applied across all the rows consistently and only give me costs at the end of the year e.g. in months 12, 24, 36, and so on.

Similarly, I have to apply a rate at after a year when the customer has joined. For example if customer has joined in April 2015 the formula should take up the figure and give resultant figure in April 2016.

Can anyone help please?

going to need more info

1. what column is this formula in? will it be in multiple columns to accommodate the usage at 12, 24, and 36 months?

2. where is the customer join date stored?

3. where is the rate for the customer stored?

4. How is the rate handled for existing customers?