11 May Using the case data (attached) and the CLV?formulation provided in the textbook and slide decks, estimate the lifetime value of a Netflix customer
Posted at 06:52h
in Business & Finance /Marketing
- Using the case data (attached) and the CLV formulation provided in the textbook and slide decks, estimate the lifetime value of a Netflix customer for each quarter.
- How do you expect industry changes and technology advances to affect Netflix? Are these expectations validated by the trend in Netflix’s customer acquisition, customer retention, customer revenue, and CLV?
Title Page
| This spreadsheet supports STUDENT analysis of the case “Netflix, Inc.: The Customer Strikes Back” (UVA-M-0834). | |
| This spreadsheet was prepared by Rajkumar Venkatesan, Bank of America Research Associate Professor of Business Administration. Copyright © 2015 by the University of Virginia Darden School Foundation, Charlottesville, VA. All rights reserved. For customer service inquiries, send an e-mail [email protected] No part of this publication may be reproduced, stored in a retrieval system, posted to the Internet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Darden School Foundation. | |
| Dec. 7, 2015 | |
Base Data for CLV
| NETFLIX, INC.: THE CUSTOMER STRIKES BACK | ||||||||||||||||||||||||||||||||||||||||||||
| Data for Calculating Customer Lifetime Value | ||||||||||||||||||||||||||||||||||||||||||||
| All values in thousands except margin per subscriber and subscriber acquisition cost. | ||||||||||||||||||||||||||||||||||||||||||||
| Mar-01 | Jun-01 | Sep-01 | Dec-01 | Mar-02 | Jun-02 | Sep-02 | Dec-02 | Mar-03 | Jun-03 | Sep-03 | Dec-03 | Mar-04 | Jun-04 | Sep-04 | Dec-04 | Mar-05 | Jun-05 | Sep-05 | Dec-05 | Mar-06 | Jun-06 | Sep-06 | Dec-06 | Mar-07 | Jun-07 | Sep-07 | Dec-07 | Mar-08 | Jun-08 | Sep-08 | Dec-08 | Mar-09 | Jun-09 | Sep-09 | Dec-09 | Mar-10 | Jun-10 | Sep-10 | Dec-10 | Mar-11 | Jun-11 | Sep-11 | Dec-11 | |
| Revenues | $ 17,057 | $ 18,359 | $ 18,878 | $ 21,618 | $ 30,527 | $ 36,360 | $ 40,731 | $ 45,188 | $ 55,669 | $ 63,187 | $ 72,202 | $ 81,185 | $ 100,370 | $ 120,321 | $ 141,644 | $ 138,276 | $ 152,446 | $ 164,027 | $ 172,740 | $ 193,000 | $ 224,126 | $ 239,351 | $ 255,950 | $ 277,233 | $ 305,320 | $ 303,693 | $ 293,972 | $ 302,355 | $ 326,183 | $ 337,614 | $ 341,269 | $ 359,595 | $ 394,098 | $ 408,509 | $ 423,120 | $ 444,542 | $ 493,665 | $ 519,819 | $ 553,219 | $ 595,922 | $ 706,274 | $ 769,714 | $ 799,152 Shively, Daniel: Shively, Daniel: total domestic from shareholder letter |
$ 846,587 |
| Cost of subscription | 9,476 | 10,776 | 9,667 | 14,811 | 14,872 | 17,779 | 21,147 | 23,246 | 29,928 | 35,148 | 38,326 | 44,334 | 56,444 | 69,604 | 71,130 | 76,223 | 93,986 | 99,957 | 97,878 | 101,967 | 126,220 | 128,605 | 135,210 | 142,586 | 165,189 | 166,838 | 163,707 | 168,673 | 187,156 | 193,769 | 186,573 | 193,635 | 215,299 | 224,858 | 233,091 | 231,598 | 259,560 | 265,387 | 292,406 | 336,756 | 376,992 | 428,203 | 471,823 Shively, Daniel: Shively, Daniel: total cost of revenue from financials |
512,578 |
| Fulfillment expenses | 2,886 | 3,589 | 3,283 | 3,785 | 4,155 | 4,854 | 4,908 | 5,449 | 6,383 | 7,221 | 8,322 | 9,348 | 10,790 | 14,373 | 8,322 | 23,124 | 16,694 | 17,560 | 15,013 | 21,495 | 22,045 | 21,974 | 23,583 | 26,762 | 29,783 | 29,855 | 30,746 | 31,377 | 35,649 | 36,318 | 37,923 | 39,211 | 43,969 | 44,385 | 42,183 | 43,888 | 47,602 | 49,547 | 52,063 | 54,034 | 61,159 | 61,775 | 64,794 Shively, Daniel: Shively, Daniel: total cost of revenue from financials |
62,577 |
| Technology and development | 3,857 | 4,896 | 4,463 | 4,802 | 3,181 | 3,518 | 3,966 | 3,960 | 4,183 | 4,123 | 4,738 | 4,840 | 5,039 | 5,652 | 4,738 | 7,477 | 7,155 | 7,513 | 6,325 | 9,949 | 11,206 | 12,043 | 8,955 | 16,175 | 15,715 | 18,907 | 18,216 | 18,557 | 20,516 | 22,670 | 23,368 | 24,052 | 24,200 | 27,119 | 30,014 | 33,209 | 37,399 | 37,863 | 42,108 | 45,959 | 50,905 | 57,865 | 69,480 Shively, Daniel: Shively, Daniel: total cost of revenue from financials |
80,783 |
| Paid subscribers: end of period | 708 | 1,416 | 6,676 | 6,609 | 6,845 | 7,326 | 8,102 | 8,235 | 8,490 | 9,164 | 10,116 | 10,375 | 10,835 | 11,892 | 13,622 | 14,577 | 15,863 | 18,268 | 21,405 | 23,263 | 22,843 Shively, Daniel: Shively, Daniel: from quarterly shareholder letter |
24,395 | ||||||||||||||||||||||
| Paid subscribers: end of last period | 633 | 1,242 | 6,154 | 14,577 | 15,863 | 18,268 | 21,405 | 23,263 Shively, Daniel: Shively, Daniel: from quarterly shareholder letter |
22,843 | |||||||||||||||||||||||||||||||||||
| Number of paid subscribers | 303 | 306 | 315 | 456 | 562 | 598 | 671 | 857 | 1,009 | 1,055 | 1,172 | 1,224 | 1,631 | 1,933 | 2,080 | 2,308 | 2,687 | 2,998 | 3,266 | 3,725 | 4,380 | 4,876 | 5,253 | 5,823 | 6,415 | 6,643 | 6,727 | 7,086 | 7,714 | 8,169 | 8,363 | 8,827 | 9,640 | 10,246 | 10,605 | 11,364 | 12,757 | 14,100 | 15,220 | 17,066 | 19,837 | 22,334 | 23,053 | 23,619 |
| Gross subscriber additions | 186 | 88 | 107 | 186 | 312 | 236 | 277 | 315 | 417 | 327 | 383 | 444 | 760 | 583 | 590 | 783 | 945 | 707 | 921 | 1,156 | 1,377 | 1,070 | 1,310 | 1,493 | 1,520 | 1,028 | 1,297 | 1,495 | 1,862 | 1,384 | 1,528 | 2,085 | 2,413 | 1,936 | 2,180 | 2,803 | 3,492 | 3,059 | 4,101 | 5,649 | 6,299 | 5,315 | 4,714 Shively, Daniel: Shively, Daniel: from quarterly shareholder letter |
5,216 |
| Cost of revenues | $ 12,362 | $ 14,365 | $ 12,950 | $ 18,596 | $ 19,027 | $ 22,633 | $ 26,055 | $ 28,695 | $ 36,311 | $ 42,369 | $ 46,648 | $ 53,682 | $ 67,234 | $ 83,977 | $ 79,452 | $ 99,347 | $ 110,680 | $ 117,517 | $ 112,891 | $ 123,462 | $ 148,265 | $ 150,579 | $ 158,793 | $ 169,348 | $ 194,972 | $ 196,693 | $ 194,453 | $ 200,050 | $ 222,805 | $ 230,087 | $ 224,496 | $ 232,846 | $ 259,268 | $ 269,243 | $ 275,274 | $ 275,486 | $ 307,162 | $ 314,934 | $ 344,469 | $ 390,790 | $ 438,151 | $ 489,978 | $ 536,617 | $ 575,155 |
| Subscriber acquisition cost (domestic after March 2011) | $ 25.15 | $ 46.48 | $ 32.19 | $ 33.24 | $ 25.44 | $ 34.13 | $ 33.57 | $ 33.31 | $ 31.67 | $ 30.45 | $ 31.81 | $ 32.89 | $ 35.12 | $ 35.12 | $ 38.18 | $ 49.39 | $ 37.89 | $ 37.25 | $ 35.69 | $ 49.59 | $ 38.47 | $ 43.95 | $ 45.32 | $ 61.66 | $ 47.46 | $ 44.02 | $ 37.91 | $ 34.60 | $ 29.50 | $ 28.95 | $ 32.21 | $ 26.67 | $ 25.79 | $ 23.88 | $ 26.86 | $ 25.23 | $ 21.54 | $ 24.37 | $ 19.81 | $ 11.13 | $ 14.38 | $ 15.09 | $ 15.25 Shively, Daniel: Shively, Daniel: from quarterly shareholder letter |
$ 15.62 |
| Market capitalization | $ 302,016 | $ 214,069 | $ 247,130 | $ 467,582 | $ 612,152 | $ 813,092 | $ 1,354,507 | $ 1,758,750 | $ 1,876,356 | $ 806,512 | $ 650,186 | $ 574,670 | $ 876,721 | $ 1,402,472 | $ 1,481,697 | $ 1,609,235 | $ 1,848,566 | $ 1,552,548 | $ 1,774,306 | $ 1,594,591 | $ 1,311,501 | $ 1,727,984 | $ 1,727,984 | $ 2,132,708 | $ 1,614,020 | $ 1,825,626 | $ 1,759,385 | $ 2,510,605 | $ 2,373,577 | $ 2,522,867 | $ 2,944,010 | $ 3,853,800 | $ 5,688,697 | $ 8,473,995 | $ 9,273,797 | $ 12,487,968 | $ 13,800,682 | $ 5,947,128 | $ 3,838,597 | |||||
| Share price | 13.99 | 9.70 | 11.01 | 20.35 | 25.55 | 33.56 | 54.69 | 34.12 | 36.00 | 15.42 | 12.33 | 10.85 | 16.41 | 25.99 | 27.06 | 28.99 | 27.21 | 22.78 | 25.86 | 23.19 | 19.39 | 26.62 | 26.62 | 34.65 | 26.07 | 30.88 | 29.89 | 42.92 | 41.34 | 46.17 | 55.09 | 73.74 | 108.65 | 162.16 | 175.7 | 237.78 | 262.69 | 113.27 | 69.29 | |||||
| Outstanding shares | 21,588 | 22,069 | 22,446 | 22,977 | 23,959 | 24,228 | 24,767 | 51,546 | 52,121 | 52,303 | 52,732 | 52,965 | 53,426 | 53,962 | 54,756 | 55,510 | 67,937 | 68,154 | 68,612 | 68,762 | 67,638 | 64,913 | 64,913.00 | 61550.00 | 61,911 | 59,120 | 58,862 | 58,495 | 57,416 | 54,643 | 53,440 | 52,262 | 52,358 | 52,257 | 52,782 | 52,519 | 52,536 | 52,504 | 55,399 | |||||
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.