Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta

10th Canadian edition

1259261018, 1259261015, 978-1259024979

More Books

Students also viewed these Accounting questions