I placed the promotional items and marketing under the line item of
cost of acquisition which is a per month per subscriber.
This is a typical for us to separate it in this way, since we have to do this at telcos when we sell you mobile data/subscriber plans. This is how we separate the revenue from promotional losses. The goal is to reduce expenses and COA over time. ie. we subsidize new handsets like iphones when you sign a contract with us. So we eat say $500 over 3 years (initial phone subsidy), but you are paying $2500 over 3 years in contract fees. Sometimes we have promotional offers on data, or internet or TV, in which you pay a reduced rate, and it would be calculated in these terms, or we would line item it into a single upfront cost.
Which I've shown, the COA will go down 5% per year, which is a typical corporate goal. As there becomes more need to reap more profits, the number of promotional units goes down. So there might be a 12 weeks a year it's $1 a month. And then the next year it's only for 10 weeks. Then 8 weeks. etc. Slowly reducing the rate at which these promotional activities hit because ideally they are invested in the service to care about their account. Not everyone is willing to game the system, its a lot of work to do repeatedly and the companies account for that.
So if game pass is $10 /mo
You give it to them for $2 per month
that's a Cost of Acquisition of $8 per month
I put in a COA of $6/mo, with a set price of $10. So the total profit already has been chopped down significantly.
The price will increase at a rate of 5% per year as well. To adjust for inflation and spend, the need for profitability.
Spreadsheet
- I made changes to move it back down to 1.25B spend for licensing. With an increase of 12% per year.
- I've reduced the yoy subscriber growth to 23%
- I cleaned it up to be a bit more clear.
- I guess I should add definitions on it.
https://1drv.ms/x/s!Arh_9w0iEIQBhIcTSA3K8Pyfw3BGiQ?e=xHbORF