Online when calculator
•Download as XLSX, PDF•
0 likes•284 views
The document analyzes when a firm called OurCo will become an "online firm", defined as when over 50% of its revenues come from online. It is summarized that in 2010, OurCo had total revenues of €500k, with 20% (€100k) from online growing at 25% annually, while total revenues grow at 5% annually. At this rate, the date OurCo will become an online firm is projected to be January 2nd, 2016, when online revenues will surpass 50% of total revenues, masking a decline in non-online sales.
Online when calculator
- 1. When Does A Firm Become An "Online Firm" (When the majority of its revenues come from online) Total Revenue: 500 Annual Growth Rate of Total Revenue: 5.00% Share of Revenues Today From Online: 20.00% Revenues from Online: 100 Growth Rate of Online Revenues: 25.00% The Firm Becomes An Online Firm On: #################
- 2. When Will OurCo Become An Online Business? Narrative and Assumptions: We assume OurCo closes its FY10 today with Revenues for the year of €500k. 20% of these (€100k) are from online business. OurCo is growing Year-on-Year at 5% but its online business is growing at 25% Year-on-Year. At this rate, at some date in the future, more than half the revenues will come from online. It looks like that date is 2 Jan 2016. It also looks as though online revenue growth masks a real decline in non-online sales. Key Starting Data For Year-Ending (Assuming FY2010 Ends Today) Revenues: Total, Online and Non- 2010 2011 2012 2013 2014 2015 2016 2017 Total Revenues Online Non Online Revenue Online Revenues Company Name: OurCo 800 Total Revenue: 500 Total Revenue: 500 525 551 579 608 638 670 704 700 Currency (optional): € Online Revenue: 100 125 156 195 244 305 381 477 600 Units (optional): k Non-Online Revenue: 400 400 395 384 364 333 289 227 500 500 525 551 579 608 638 670 704 400 Annual Growth Rate of Total Revenue: 5.00% 300 Online Share of Total Revenue: 20% 24% 28% 34% 40% 48% 57% 68% 200 100 Share of Revenues Today From Online: 20.00% 0 2010 2011 2012 2013 2014 2015 2016 2017 Growth Rate of Online Revenues: 25.00% 80% Online Revenues As Share Of Total 70% 60% Some Key Derived Facts Online Revenues Today: 100 50% "Non Online" Revenue Today: 400 OurCo will be an online business on: 40% Non-Line Revenues Are In Decline: YES 30% ############### 20% 10% With 6 yrs to go, organisational change needs to be underway by 2 Jan 2013 0% 2010 2011 2012 2013 2014 2015 2016 2017