Question: 1. North America Gross Billings Estimate by Segment for 4Q13 Please provide your North America gross billings estimate by segment (Local, Goods, and Travel) for

1. North America Gross Billings Estimate by Segment for 4Q13

Please provide your North America gross billings estimate by segment (Local, Goods, and Travel) for 4Q13. Include your raw estimates (without adjustments), Local segment billings for the outage period, and your final estimates, including any other additional adjustments.

Segment

Unadjusted Data

Local Segment Outage

Final Estimates

Local

Goods

Travel

Total

2. Local Segment Outage Methodology Explanation & Calculations

Summary and step by step explanation of how you adjusted for the Local segment outage, the rationale for those adjustments, and supporting calculations.

We want to be able to easily understand and replicate your outage methodology. Your explanation should be able to be easily understood and fairly easily replicated by someone who doesn't have a strong background in data, programming, or statistics. Please avoid using an overly complex methodology.

3. Quality Assurance (QA) Check Descriptions, Results, & Decisions

Please describe the 5 most important Quality Assurance (QA) checks you performed and any decisions or adjustments made based on those checks.

4. Gross Billings Estimate Calculations

Please explain step by step, including the calculations you performed, how you arrived at your final billings estimate in section 1.

5. Local Segment Gross Billings Explanation for 3 Key Trends

If you plot Local Segment daily billings by start date from September 1st to the end of Q4 2013, you'll see a drop off towards the end of December 2013, an uptrend at the end of September, and a regular pattern of variation. Please explain why these three trends are occurring based on what you know about the data and Groupon’s business model.

Drop Off Towards End of December

Uptrend at the end of September

Regular Up and Down Pattern Day to Day

6. How Investors Will Interpret GRPN 4Q13 Results

Based on the data we provided, do you think investors will interpret Groupon’s 4Q13 North America total gross billings and gross billings by segment results positively or negatively? Why might one segment be more important than the others for investors from a financial perspective?

7. Explanation of Confidence in Gross Billings Estimates

Please explain how you and investors can be confident in YipitData gross billings estimates based on the materials provided.

YipitData Historical EstimatesQ3 2012Q4 2012Q1 2013Q2 2013Q3 2013
Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12Jan-13Feb-13Mar-13Apr-13May-13Jun-13Jul-13Aug-13Sep-13
Gross Billings ($ million)
Local$133.4$137.3$138.2$126.8$139.9$164.4$162.7$143.0$163.4$143.8$162.2$153.2$140.0$136.7$133.8
Goods$26.7$33.0$50.8$64.3$85.1$64.3$47.3$46.0$51.0$62.8$71.7$67.1$61.3$67.0$63.2
Travel$16.8$15.4$14.3$16.6$14.6$18.5$22.6$13.6$20.3$18.9$22.9$22.8$22.4$22.7$21.7
Total$176.9$185.8$203.3$207.7$239.6$247.2$232.6$202.6$234.7$225.5$256.8$243.1$223.6$226.4$218.7
Q3 2012Q4 2012Q1 2013Q2 2013Q3 2013
Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12Jan-13Feb-13Mar-13Apr-13May-13Jun-13Jul-13Aug-13Sep-13
Units Sold
Local4,400,8004,233,7154,991,8155,177,4364,920,3795,502,1825,330,3164,823,7725,530,9834,807,6975,592,7995,755,7984,996,2434,902,3614,967,461
Goods855,1561,162,8841,629,8231,879,6972,583,1721,915,7841,596,7381,491,2861,685,0552,470,1612,726,3262,651,3382,267,9432,471,5642,346,842
Travel61,28384,98560,25374,35887,33393,70384,82155,03084,686102,091144,592142,509103,021108,412105,752
Total5,317,2405,481,5836,681,8917,131,4917,590,8837,511,6687,011,8766,370,0887,300,7247,379,9488,463,7178,549,6457,367,2077,482,3377,420,054
Q3 2012Q4 2012Q1 2013Q2 2013Q3 2013
Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12Jan-13Feb-13Mar-13Apr-13May-13Jun-13Jul-13Aug-13Sep-13
New Deals Started
Local13,54312,92612,81414,54413,91415,37412,37511,84613,04110,79014,28113,81514,17313,07510,670
Goods3344485257701,0791,3109921,1971,4991,7552,1852,6102,7962,8872,847
Travel211277217262270334243188205329471458506537571
Total14,08813,65113,55615,57615,26317,01813,61013,23114,74512,87416,93716,88317,47516,49914,088

Step by Step Solution

3.38 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

SOLUTION Im here to assist you with your questions about Groupons North America gross billings estimate for 4Q13 Please find my responses below based on the data provided 1 North America Gross Billing... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!