Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help doing a projected income statement and balance sheet for Netflix for 5 years. I also need liquidity ratios and solvency ratio for a

Need help doing a projected income statement and balance sheet for Netflix for 5 years. I also need liquidity ratios and solvency ratio for a projected five years. When I tried to do the projected ratios, the all came out the same for every year.

image text in transcribedimage text in transcribed

2018 2017 2016 2015 2014 8,830,669 $ 6,257,462 Revenues Cost of revenues gross profit Marketing Technology and development General and administrative Total expense Operating income Other income (expense): 6,779,511 $ 4,591,476 $ 15,794,341 $ 11,692,713 $ 8,033,000 5,504,656 9,967,538 3,752,760 5,826,803 3,659,713 2,573,207 2,188,035 1,751,896 2,369,469 1,436,281 1,097,519 824,092 607,186 1,221,814 953,710 431,043 2,821,034 780,232 650,788 472,321 630,294 315,663 407,329 269,741 1,349,248 4,221,577 2,193,414 1,882,209 1,605,226 838,679 379,793 305,826 402,648 Interest expense Interest and other income (expense) Interest and other income (expense) net Income before income taxes Provision for (benefit from) income taxes Net income (420,493) (238,204) (115,154) (353,358) (150,114) (132,716) (31,225) (163,941) 141,885 19,244 (50,219) (3,060) (53,279) 41,725 30,828 (378,768) (119,286) 1,226,458 485,321 260,507 349,369 15,216 (73,608) 558,929 $ 73,829 82,570 $ 1,211,242 $ 186,678 $ 122,641 $ 266,799 2017 2016 2018 2015 2014 Assets 11,692,713 $ 8,830,669 $ 6,779,511$ 5,504,656 15,794,341 $ Current assets: Cash and cash equivalents $ 2,822,795 $ 1,467,576 $ 3,794,483 $ 1,809,330 $ 1,113,608 $ 494,888 short term investments 266,206 501,385 Current content assets, net 4,310,934 3,726,307 2,905,998 2,166,134 5,151,186 Other current assets 260,202 152,423 748,466 536,245 215,127 Total current assets 5,720,291 9.694.135 7,669,974 5,431,840 3,927,053 Non-current content assets, net 2,773,326 14,960,954 10,371,055 7,274,501 4,312,817 Property and equipment, net 418,281 319,404 250,395 173,412 149,875 Other non-current assets 341,423 901,030 652,309 284,802 192,246 Iatal assets 25.974 400 19.012.742 $ 13,586,610 $ 10,202,871 $ 7,042,500 Liabilities and Stockholders' Equity Current liabilities: $ 4,686,019 $ 4,173,04$ 3,632,711$ 2,789,023 $ Current content liabilities 2,117,241 Accounts payable 359,555 253,491 562,985 312,842 201,581 Accrued expenses 477,417 315,094 197,632 140,389 69,746 Deferred revenue 760,899 618,622 443,472 346,721 274,586 Total current liabilities 6.487,320 5,466,312 4,586,657 3,529,624 2,663,154 3,759,026 Non-current content liabilities 3,329,796 2,894,654 2,026,360 1,575,832 Long-term debt 10,360,058 6,499,432 3,364,311 2,371,362 885,849 Other non-current liabilities 135,246 59,957 129,231 61,188 52,099 15.430 786 Total liabilities 10,906,810 5,184,792 20.735.635 7,979,445 Stockholders' equity 1,599,762 1,042,870 Stock 2,315,988 1,871,396 1,324,809 Accumulated other comprehensive loss (19,582) (20,557) (48,565) (43,308) (4,446) Retained eamings 1,128,603 941,925 2,942,359 1,731,117 819,284 Total stockholders' equity Intal liahilitias and stackhaldars' aquity 5,238,765 25974 400 $ 2,679,800 2,223,426 1,857,708 3,581,956 19.012.742 13,586,610 $ 10,202,871 $ 7,042,500

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Corporate Financial Management

Authors: Glen Arnold, James Pickford

2nd Edition

0582821762, 978-0582821767

More Books

Students also viewed these Finance questions