Forum Discussion
Formula/function to evenly distribute revenue over a variable number of months??
Hello friends - I am looking for advice on how to program a revenue recognition schedule. The idea is pretty simple but I'm stumped on the solution. I need to be able to enter the # of months over which I want to recognize revenue and have it be even distributed horizontally over that many months. Let's say I have $12,000 to recognize. I want to be able to enter "6" as the # of months, and then have $2,000 populate over 6 months. Or if I enter "12" for the # of months, it will populate $1,000 over 12 months. I've attached simple screenshots to show what outcome I am looking for. Any/all assistance appreciated. Thank you!
Riny_van_Eekelen Yes- that is exactly what I was looking for. I can't thank you enough!
Hi, in a similar situation. Trying to figure out a single dynamic formula that will allow me to split up the values from Column A (say a revenue contract value) across columns B-Z with various start and end dates. like this
Contract Value Start Date End Date Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 $1,100,000 09/06/20 09/06/23 $50,000 09/06/20 NA $375,000 05/28/20 05/28/21 $172,475 02/03/21 02/03/22 John_Bloggs650 This is slightly different from the original post. Best to start a new thread.
Anyway, which Excel version are you on and how would you split the examples if you had to do it manually? For instance, the first one covers three years (i.e. 36 months) but you mention to want to split across columns B:Z (25 columns). And the second one. How would you threat a contract with no end date?
