Hi
I am trying to build a revenue recognition formula within Excel. It's for a services company which can only consume service revenue at $40,000 per month.
So for a deal of $100,000 the revenue would be recognized as $40k in month 1, $40k in month 2 and then $20k in month 3. So the inputs we...