SaaS Products - Calculating Deferred Revenue when Deal is Paid Up Front

[CEvans97]

I’d be interested to see if anyone has an answer to this, we have a similar problem and a huge spreadsheet that’s calculating this currently. There must be a way to show this?