Apr 10 2020 07:48 PM
Apr 10 2020 07:48 PM
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!
Apr 10 2020 09:31 PM
@swilkenburn That would be like in the attached workbook.
Apr 11 2020 11:50 AM
@Riny_van_Eekelen Yes- that is exactly what I was looking for. I can't thank you enough!
Sep 27 2022 08:46 PM
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|
Sep 27 2022 08:57 PM
@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?
Sep 27 2022 09:29 PM - edited Sep 27 2022 09:30 PM
Just started one here: https://techcommunity.microsoft.com/t5/excel/dynamic-formula-that-splits-distributes-revenue-a-value...
Im using Office 365. sorry the columns would be A: CA.
Have been playing around with this formula but the days in each month are variable so 30 doesn't necessarily work, with the total falling slightly short.
Trying to do something similar to this: