subscription revenue

I'm trying to quickly calculate subscription revenue...

for example: if 1k of revenue is booked in January the yearly revenue would be
1k x 12months + 1k x 11 + 1k * 10 and so on to equal 78k

Two questions:
what is a quick one cell formula?
how would model this with two variables, recurring revenue and start month?
in this case it would be 1k, month 1. However I would also like to see 1k starting month 4


Thanks

Originally Posted by newdoverman

I think that this is what you are looking for

Formula:

Please Login or Register  to view this content.

This is the number of months divided by 2 time the number of months +1 times the amount of 1000

Another way of doing this for numbers in A1 to A5.

Formula:

Please Login or Register  to view this content.

This means take the last number and add to it the first number and divide that by 2 and multiply by the number of numbers.

If the numbers were from 85 to 89 in A1 to A5 then the formula would actually read

=(89+85)/2*5
=435

Close however it breaks down if I'm calculating a partial year... see attachment

Originally Posted by newdoverman

I looked at your chart. Why are you adding an extra 1000 in L34 as you have already added the 1000 for December in cell L33? That makes 12 incomes for 11 months. The formula works fine for 11 incomes for 11 months.

you're awesome, I figured it out now
Thanks