TCO comparison between CRM OnPremises and CRM Online

Question Status

Alexandru Molodoi asked a question on 13 Feb 2013 12:05 AM

We recently had a workshop with our customers to demo features of CRM Online and one very requested topic was a comparison of costs between the OnPremises and public cloud variants of Dynamics CRM.

So I prepared this Excel calculator which takes input: number of years, return rate, CRM Online monthly cost, licenses and hardware and outputs a chart with the break even point between the two editions of CRM.

The formula takes into account the Workgroup Edition of CRM 2011 and also switches from Server+CAL to SQL Core licensing after 13 users. On more thing to note is that I used the PV (present value) formula for future payments like the CRM Online monthly rate and the yearly costs for On Premises.

I've thought the community could benefit from this, so I made it freely available. Enjoy the Excel calculator here:

John Grace responded on 13 Feb 2013 1:20 AM

Thanks for sharing Alexandru, I've tweeted it...

İsmail Tutumluer responded on 13 Feb 2013 4:06 AM

Thanks .Its very useful document.

nalbi responded on 26 Feb 2015 11:44 PM

I can't change xlsx.  Could you send me password ?

s_j_b responded on 25 Jun 2015 11:43 PM

This is great, thank you! I work in Australia and wanted to change the xslx to reflect Aus $ can you send me the password please