Higher Office 365 Revenue Per User Leads to Bigger Profits
Every time Microsoft releases a set of quarterly results, CFO Amy Hood takes the opportunity to reinforce growing the ARPU (average revenue per user) from its cloud customers. It’s a trend that’s existed for several quarters, including Microsoft’s recent FY23 Q2 earnings.
To understand why ARPU is so important to Microsoft, I tried to figure out how much it is and how ARPU has increased over time. The mathematics involved in the calculation are not difficult if you have the numbers. Unfortunately, Microsoft loves to obfuscate the information given about cloud revenues, so some detective work is necessary.
Microsoft uses a bucket called the Microsoft Cloud to report revenues associated with cloud products. It does not break out Office 365 or Azure revenues in the form of definite numbers. Instead, Microsoft gives details like Office 365 revenues grew 11% year over year. That’s only helpful if you know the base figure.
Microsoft Cloud revenues amounted to $27.1 billion in FY23 Q2. On an annualized basis, the ARR (annual run rate) is $108.4 billion, which is a lot of money. The ARR is calculated as if the revenue achieved for the quarter flowed in for four quarters. This doesn’t happen in the real world. For instance, Microsoft Cloud earned $25 billion revenues in FY22 Q4, or an ARR of $100 billion. The actual sum for Microsoft Cloud over the four FY22 quarters is $91.2 billion.
Office 365 Revenues within the Microsoft Cloud
Microsoft hasn’t defined the exact make-up of Microsoft Cloud. We know that it covers Office 365, Azure, LinkedIn, Dynamics 365, and other cloud products, so the first thing we need to figure out is how much does Office 365 contribute to Microsoft Cloud. One way to approach the problem is to ask what the other parts contribute. For FY22, we get some insight from:
Putting a figure on Dynamics 365 revenue is difficult. I can’t find any good source. Let’s say that it’s $4 billion.
Together, this amounts to $48.25 billion, which leaves Office 365 with revenues of $42.95 billion, or around 47.09% of the total revenues for Microsoft Cloud. That’s a bit over what I estimated in July 2022, but better data is now available.
Calculating ARPU
To determine the APRU, we need to know how many Office 365 users exist. Microsoft used to give this number on a regular basis, but has become more reticent recently, possibly because the number is not increasing at the same rate as it once did. In April 2022, Microsoft said that Office 365 had reached 345 million paid seats. That’s not the same as active users, which we need for apple-to-apple comparisons with previous years.
For this comparison, I used a figure of 335 million active users. This tracks the regular monthly growth of active users of about 3-3.5 million observed over the 2015-2020 period when Microsoft did report active user numbers. Using this number, we get an ARPU of $128.21 per Office 365 user in FY22. To give some context, that’s 28.49% of what Microsoft receives annually for a user with an Office 365 E5 license.
The number seems low, but you’ve got to account for the mix of license types that exist across the Microsoft 365 spectrum. Some are expensive (like E5), some are very cheap or zero cost, like those used by frontline workers or students. In FY22 Q4, Microsoft said that E5represented 12% of their license mix.
But what we can say is that by using the information Microsoft releases and some analyst interpretations, the ARPU has increased since 2019 and is likely to increase again in the current fiscal year based on the reported revenues for the first two quarters. If anything, the FY23 numbers might be higher if the Teams Premium license (due in February 2023) is popular with customers. Table 1 summarizes the numbers. In a nutshell, Microsoft is steadily going towards extracting 30% of an annual E5 license from every user (the annual cost of an E5 license increased by $36 from March 2022).
Year
Microsoft Cloud Revenues
Office 365 Revenues
Users (end FY)
ARPU
Office 365 E5 Annual Cost
Percentage of E5 Cost
FY19
41.11
19.36
190,000,000
$101.90
$420.00
24.26%
FY20
51.80
24.39
240,000,000
$101.65
$420.00
24.20%
FY21
69.10
32.54
280,000,000
$116.22
$420.00
27.67%
FY22
91.20
42.95
335,000,000
$128.21
$450.00
28.49%
FY23 (est.)
108.24
50.97
370,000,000
$137.77
$456.00
30.21%
Table 1: Office 365 Revenues FY19-FY23
These calculations assumes that Microsoft 365 licenses that include Office 365 are in the Office 365 revenues. Again, we don’t know if this is true. However, just like using Fitbit or any other fitness tracker, trends emerge by using the same measurements over time.
Growing ARPU is Good for Microsoft
Obviously, the more money you can extract from a customer base, the more profit you can make. With the size of the Office 365 installed base, Microsoft can extract more revenue and profit through:
Continuing sales activity to convince customers to move licenses to more expensive variations.
Engineering investments to make high-end licenses more attractive by bundling most new security and compliance functionality in those products.
Some would call this the dark side of capitalism. To me, it’s just business and Microsoft is perfectly within its rights to monetize the user base it has built up. What it does mean for tenant administrators is that license management will continue to be a critical task. Office 365 and Microsoft 365 licenses can be expensive. If you buy licenses, make sure that the licenses are used efficiently.
Sure, it is straight up capitalism to charge your customer for “Teams Premium” instead of building those extra features into the already expensive enough product.
{"id":null,"mode":"button","open_style":"in_modal","currency_code":"EUR","currency_symbol":"\u20ac","currency_type":"decimal","blank_flag_url":"https:\/\/office365itpros.com\/wp-content\/plugins\/tip-jar-wp\/\/assets\/images\/flags\/blank.gif","flag_sprite_url":"https:\/\/office365itpros.com\/wp-content\/plugins\/tip-jar-wp\/\/assets\/images\/flags\/flags.png","default_amount":100,"top_media_type":"featured_image","featured_image_url":"https:\/\/office365itpros.com\/wp-content\/uploads\/2022\/11\/cover-141x200.jpg","featured_embed":"","header_media":null,"file_download_attachment_data":null,"recurring_options_enabled":true,"recurring_options":{"never":{"selected":true,"after_output":"One time only"},"weekly":{"selected":false,"after_output":"Every week"},"monthly":{"selected":false,"after_output":"Every month"},"yearly":{"selected":false,"after_output":"Every year"}},"strings":{"current_user_email":"","current_user_name":"","link_text":"Virtual Tip Jar","complete_payment_button_error_text":"Check info and try again","payment_verb":"Pay","payment_request_label":"Office 365 for IT Pros","form_has_an_error":"Please check and fix the errors above","general_server_error":"Something isn't working right at the moment. Please try again.","form_title":"Office 365 for IT Pros","form_subtitle":null,"currency_search_text":"Country or Currency here","other_payment_option":"Other payment option","manage_payments_button_text":"Manage your payments","thank_you_message":"Thank you for supporting the work of Office 365 for IT Pros!","payment_confirmation_title":"Office 365 for IT Pros","receipt_title":"Your Receipt","print_receipt":"Print Receipt","email_receipt":"Email Receipt","email_receipt_sending":"Sending receipt...","email_receipt_success":"Email receipt successfully sent","email_receipt_failed":"Email receipt failed to send. Please try again.","receipt_payee":"Paid to","receipt_statement_descriptor":"This will show up on your statement as","receipt_date":"Date","receipt_transaction_id":"Transaction ID","receipt_transaction_amount":"Amount","refund_payer":"Refund from","login":"Log in to manage your payments","manage_payments":"Manage Payments","transactions_title":"Your Transactions","transaction_title":"Transaction Receipt","transaction_period":"Plan Period","arrangements_title":"Your Plans","arrangement_title":"Manage Plan","arrangement_details":"Plan Details","arrangement_id_title":"Plan ID","arrangement_payment_method_title":"Payment Method","arrangement_amount_title":"Plan Amount","arrangement_renewal_title":"Next renewal date","arrangement_action_cancel":"Cancel Plan","arrangement_action_cant_cancel":"Cancelling is currently not available.","arrangement_action_cancel_double":"Are you sure you'd like to cancel?","arrangement_cancelling":"Cancelling Plan...","arrangement_cancelled":"Plan Cancelled","arrangement_failed_to_cancel":"Failed to cancel plan","back_to_plans":"\u2190 Back to Plans","update_payment_method_verb":"Update","sca_auth_description":"Your have a pending renewal payment which requires authorization.","sca_auth_verb":"Authorize renewal payment","sca_authing_verb":"Authorizing payment","sca_authed_verb":"Payment successfully authorized!","sca_auth_failed":"Unable to authorize! Please try again.","login_button_text":"Log in","login_form_has_an_error":"Please check and fix the errors above","uppercase_search":"Search","lowercase_search":"search","uppercase_page":"Page","lowercase_page":"page","uppercase_items":"Items","lowercase_items":"items","uppercase_per":"Per","lowercase_per":"per","uppercase_of":"Of","lowercase_of":"of","back":"Back to plans","zip_code_placeholder":"Zip\/Postal Code","download_file_button_text":"Download File","input_field_instructions":{"tip_amount":{"placeholder_text":"How much would you like to tip?","initial":{"instruction_type":"normal","instruction_message":"How much would you like to tip? Choose any currency."},"empty":{"instruction_type":"error","instruction_message":"How much would you like to tip? Choose any currency."},"invalid_curency":{"instruction_type":"error","instruction_message":"Please choose a valid currency."}},"recurring":{"placeholder_text":"Recurring","initial":{"instruction_type":"normal","instruction_message":"How often would you like to give this?"},"success":{"instruction_type":"success","instruction_message":"How often would you like to give this?"},"empty":{"instruction_type":"error","instruction_message":"How often would you like to give this?"}},"name":{"placeholder_text":"Name on Credit Card","initial":{"instruction_type":"normal","instruction_message":"Enter the name on your card."},"success":{"instruction_type":"success","instruction_message":"Enter the name on your card."},"empty":{"instruction_type":"error","instruction_message":"Please enter the name on your card."}},"privacy_policy":{"terms_title":"Terms and conditions","terms_body":null,"terms_show_text":"View Terms","terms_hide_text":"Hide Terms","initial":{"instruction_type":"normal","instruction_message":"I agree to the terms."},"unchecked":{"instruction_type":"error","instruction_message":"Please agree to the terms."},"checked":{"instruction_type":"success","instruction_message":"I agree to the terms."}},"email":{"placeholder_text":"Your email address","initial":{"instruction_type":"normal","instruction_message":"Enter your email address"},"success":{"instruction_type":"success","instruction_message":"Enter your email address"},"blank":{"instruction_type":"error","instruction_message":"Enter your email address"},"not_an_email_address":{"instruction_type":"error","instruction_message":"Make sure you have entered a valid email address"}},"note_with_tip":{"placeholder_text":"Your note here...","initial":{"instruction_type":"normal","instruction_message":"Attach a note to your tip (optional)"},"empty":{"instruction_type":"normal","instruction_message":"Attach a note to your tip (optional)"},"not_empty_initial":{"instruction_type":"normal","instruction_message":"Attach a note to your tip (optional)"},"saving":{"instruction_type":"normal","instruction_message":"Saving note..."},"success":{"instruction_type":"success","instruction_message":"Note successfully saved!"},"error":{"instruction_type":"error","instruction_message":"Unable to save note note at this time. Please try again."}},"email_for_login_code":{"placeholder_text":"Your email address","initial":{"instruction_type":"normal","instruction_message":"Enter your email to log in."},"success":{"instruction_type":"success","instruction_message":"Enter your email to log in."},"blank":{"instruction_type":"error","instruction_message":"Enter your email to log in."},"empty":{"instruction_type":"error","instruction_message":"Enter your email to log in."}},"login_code":{"initial":{"instruction_type":"normal","instruction_message":"Check your email and enter the login code."},"success":{"instruction_type":"success","instruction_message":"Check your email and enter the login code."},"blank":{"instruction_type":"error","instruction_message":"Check your email and enter the login code."},"empty":{"instruction_type":"error","instruction_message":"Check your email and enter the login code."}},"stripe_all_in_one":{"initial":{"instruction_type":"normal","instruction_message":"Enter your credit card details here."},"empty":{"instruction_type":"error","instruction_message":"Enter your credit card details here."},"success":{"instruction_type":"normal","instruction_message":"Enter your credit card details here."},"invalid_number":{"instruction_type":"error","instruction_message":"The card number is not a valid credit card number."},"invalid_expiry_month":{"instruction_type":"error","instruction_message":"The card's expiration month is invalid."},"invalid_expiry_year":{"instruction_type":"error","instruction_message":"The card's expiration year is invalid."},"invalid_cvc":{"instruction_type":"error","instruction_message":"The card's security code is invalid."},"incorrect_number":{"instruction_type":"error","instruction_message":"The card number is incorrect."},"incomplete_number":{"instruction_type":"error","instruction_message":"The card number is incomplete."},"incomplete_cvc":{"instruction_type":"error","instruction_message":"The card's security code is incomplete."},"incomplete_expiry":{"instruction_type":"error","instruction_message":"The card's expiration date is incomplete."},"incomplete_zip":{"instruction_type":"error","instruction_message":"The card's zip code is incomplete."},"expired_card":{"instruction_type":"error","instruction_message":"The card has expired."},"incorrect_cvc":{"instruction_type":"error","instruction_message":"The card's security code is incorrect."},"incorrect_zip":{"instruction_type":"error","instruction_message":"The card's zip code failed validation."},"invalid_expiry_year_past":{"instruction_type":"error","instruction_message":"The card's expiration year is in the past"},"card_declined":{"instruction_type":"error","instruction_message":"The card was declined."},"missing":{"instruction_type":"error","instruction_message":"There is no card on a customer that is being charged."},"processing_error":{"instruction_type":"error","instruction_message":"An error occurred while processing the card."},"invalid_request_error":{"instruction_type":"error","instruction_message":"Unable to process this payment, please try again or use alternative method."},"invalid_sofort_country":{"instruction_type":"error","instruction_message":"The billing country is not accepted by SOFORT. Please try another country."}}}},"fetched_oembed_html":false}
Sure, it is straight up capitalism to charge your customer for “Teams Premium” instead of building those extra features into the already expensive enough product.