Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Estimating cost functions is a process that is essential for finance professionals. Therefore, it is important that you understand the methods and best practices for

Estimating cost functions is a process that is essential for finance professionals. Therefore, it is important that you understand the methods and best practices for conducting this process. For this Assignment, you use your assessment of cost function estimation methods in the context of the Netflix and Amazon Data Spreadsheet in this week’s Learning Resources. Then, you use this assessment, along with the ideas generated in this week’s Discussion, to develop cost function estimates for both Netflix, Inc., and Amazon.com, Inc. Use the following methods:


Netflix Inc.201220132014
Revenues
Cost of revenues*$             3,609,282$                  4,374,562$                  5,504,656
Marketing*               2,652,058                    3,117,203                    3,752,760
Technology and development                   439,208                       469,942                       607,186
General and administrative                   329,008                       378,769                       472,321
Operating income (loss)                   139,016                       180,301                       269,741
Other income (expense):                     49,992                       228,347                       402,648
Interest expense 
Interest and other income (expense)                   (19,986)                        (29,142)                        (50,219)
Loss on extinguishment of debt                           474                          (3,002)                          (3,060)
Income (loss) before income taxes                              -                          (25,129)                                   -  
Provision (benefit) for income taxes                     30,480                       171,074                       349,369
Net income (loss)                     13,328                          58,671                          82,570
Earnings per share:$                   17,152$                     112,403$                     266,799
Basic
Diluted$                          .31$                            1.93$                            4.44
Weighted-average common shares outstanding:$                          .29$                            1.85$                            4.32
Basic
Diluted55,52158,19860,078
58,90460,76161,699


Netflix Inc.201220132014
Assets
Current assets:
Cash and cash equivalents$                     290,291$                     604,965$                 1,113,608
Short-term investments                        457,787                       595,440                       494,888
Current content library, net                    1,368,162                    1,706,421                   2,125,702
Other current assets                        124,551                       151,937                       206,271
Total current assets                    2,240,791                    3,058,763                   3,940,469
Non-current content library, net                    1,506,008                    2,091,071                   2,773,326
Property and equipment, net                        131,681                       133,605                       149,875
Other non-current assets                          89,410                       129,124                       192,981
Total assets$                  3,967,890$                 5,412,563$                 7,056,651
Liabilities and Stockholders' Equity
Current liabilities:
Current content liabilities$                  1,366,847$                 1,775,983$                 2,117,241
Accounts payable                          86,468                       108,435                       201,581
Accrued expenses                          53,139                         54,018                         69,746
Deferred revenue                        169,472                       215,767                       274,586
Total current liabilities                    1,675,926                    2,154,203                   2,663,154
Non-current content liabilities                    1,076,622                    1,345,590                   1,575,832
Long-term debt                        200,000                       500,000                       900,000
Long-term debt due to related party                        200,000                                   -                                    -  
Other non-current liabilities                          70,669                         79,209                         59,957
Total liabilities                    3,223,217                    4,079,002                   5,198,943
Stockholders' equity:
                                  56                                 60                                 60
                        301,616                       777,441                   1,042,810
                            2,919                            3,575                          (4,446)
                        440,082                       552,485                       819,284
Total stockholders' equity                        744,673                    1,333,561                   1,857,708
Total liabilities and stockholders' equity$                  3,967,890$                 5,412,563$                 7,056,651


Netflix Inc.201220132014
 Cash flows from operating activities: 
Net income (loss)$                        17,152$                     112,403$                    266,799
Adjustments to reconcile net income (loss) to net cash
provided by (used in) operating activities:
Additions to streaming content library                   (2,515,506)                  (3,049,758)                  (3,773,459)
Change in streaming content liabilities                        762,089                       673,785                       593,125
Amortization of streaming content library                    1,591,218                    2,121,981                   2,656,279
Amortization of DVD content library                          65,396                         71,325                         71,491
Depreciation and amortization of property, equipment and intangibles                          45,469                         48,374                         54,028
Stock-based compensation expense                          73,948                         73,100                       115,239
Excess tax benefits from stock-based compensation                           (4,543)                        (81,663)                       (89,341)
Other non-cash items                           (8,392)                            5,332                         15,282
Loss on extinguishment of debt                                   -                           25,129                                  -  
Deferred taxes                        (30,071)                        (22,044)                       (30,063)
Changes in operating assets and liabilities:
Other current assets                           (5,432)                         62,234                          (8,758)
Accounts payable                           (4,943)                         18,374                         83,812
Accrued expenses                            9,806                            1,941                         55,636
Deferred revenue                          20,676                         46,295                         58,819
Other non-current assets and liabilities                            4,719                          (8,977)                       (52,406)
Net cash provided by (used in) operating activities                          21,586                         97,831                         16,483
 Cash flows from investing activities: 
Acquisition of DVD content library                        (48,275)                        (65,927)                       (74,790)
Purchases of property and equipment                        (40,278)                        (54,143)                       (69,726)
Other assets                            8,816                            5,939                           1,334
Purchases of short-term investments                      (477,321)                     (550,264)                     (426,934)
Proceeds from sale of short-term investments                        282,953                       347,502                       385,300
Proceeds from maturities of short-term investments                          29,365                         60,925                       141,950
Net cash provided by (used in) investing activities                      (244,740)                     (255,968)                       (42,866)
 Cash flows from financing activities: 
Proceeds from issuance of common stock                            4,124                       124,557                         60,544
Proceeds from issuance of debt                                   -                         500,000                       400,000
Issuance costs                              (759)                          (9,414)                          (7,080)
Redemption of debt                                   -                       (219,362)                                  -  
Excess tax benefits from stock-based compensation                            4,543                         81,663                         89,341
Principal payments of lease financing obligations                           (2,319)                          (1,180)                          (1,093)
Net cash provided by (used in) financing activities                            5,589                       476,264                       541,712
 Effect of exchange rate changes on cash and cash equivalents                               (197)                          (3,453)                          (6,686)
 Net increase (decrease) in cash and cash equivalents                       (217,762)                       314,674                       508,643
 Cash and cash equivalents, beginning of period                         508,053                       290,291                       604,965
 Cash and cash equivalents, end of period$                     290,291$                     604,965$                 1,113,608
Non-GAAP free cash flow reconciliation:
Net cash provided by (used in) operating activities$                        21,586$                       97,831$                       16,483
Acquisition of DVD content library(48,275)(65,927)(74,790)
Purchases of property and equipment(40,278)(54,143)(69,726)
Other assets8,8165,9391,334
Non-GAAP free cash flow$                      (58,151)$                     (16,300)$                   (126,699)


Amazon.com Inc.201220132014
Sales/Revenues$61.09B$74.45B$88.99B
Cost of Goods Sold (COGS) incl. D&A46.8B54.63B63.88B
COGS excluding D&A44.65B51.38B59.14B
Depreciation & Amortization Expense2.16B3.25B4.75B
Depreciation1.65B2.46B3.62B
Amortization of Intangibles506M793M1.13B
Gross Income14.29B19.82B25.11B
SG&A Expense13.96B18.96B25.37B
Research & Development4.24B6.11B8.72B
Other SG&A9.72B12.85B16.65B
Other Operating Expense(506M)00
Unusual Expense-00
EBIT after Unusual Expense-00
Non Operating Income/Expense(239M)(250M)320M
Non-Operating Interest Income40M38M39M
Equity in Affiliates (Pretax)---
Interest Expense92M141M210M
Gross Interest Expense92M141M210M
Interest Capitalized---
Pretax Income544M506M(111M)
Income Tax428M161M167M
Income Tax - Current Domestic562M144M279M
Income Tax - Current Foreign131M173M204M
Income Tax - Deferred Domestic(156M)(133M)(136M)
Income Tax - Deferred Foreign(109M)(23M)(180M)
Income Tax Credits---
Equity in Affiliates(155M)(71M)37M
Other After Tax Income (Expense)000
Consolidated Net Income(39M)274M(241M)
Minority Interest Expense000
Net Income(39M)274M(241M)
Extraordinaries & Discontinued Operations000
Extra Items & Gain/Loss Sale Of Assets000
Cumulative Effect - Accounting Chg000
Discontinued Operations000
Net Income After Extraordinaries(39M)274M(241M)
Preferred Dividends000
Net Income Available to Common(39M)274M(241M)
EPS (Basic)-0.090.6-0.52
Basic Shares Outstanding453M457M462M
EPS (Diluted)-0.090.59-0.52
Diluted Shares Outstanding453M465M462M
EBITDA2.99B4.11B4.49B


Amazon.com Inc.
Assets201220132014
Cash & Short Term Investments$11.45B$12.45B$17.42B
Cash Only8.08B8.66B14.56B
Short-Term Investments3.36B3.79B2.86B
Total Accounts Receivable3.36B4.77B5.61B
Accounts Receivables, Net2.6B3B3.3B
Accounts Receivables, Gross2.72B3.15B3.49B
Bad Debt/Doubtful Accounts(116M)(153M)(190M)
Other Receivables764M1.77B2.31B
Inventories6.03B7.41B8.3B
Finished Goods000
Work in Progress000
Raw Materials000
Progress Payments & Other6.03B7.41B8.3B
Other Current Assets453M-0
Miscellaneous Current Assets453M--
Total Current Assets21.3B24.63B31.33B
201220132014
Net Property, Plant & Equipment7.06B10.95B16.97B
Property, Plant & Equipment - Gross9.58B14.81B22.73B
Buildings2.97B4.58B7.15B
Land & Improvements---
Computer Software and Equipment866M1.1B1.3B
Other Property, Plant & Equipment174M231M304M
Accumulated Depreciation2.52B3.86B5.76B
Total Investments and Advances151M520M886M
Other Long-Term Investments99M482M811M
Long-Term Note Receivable000
Intangible Assets3.28B3.3B4.08B
Net Goodwill2.55B2.66B3.32B
Net Other Intangibles725M645M764M
Other Assets648M538M971M
Tangible Other Assets648M538M971M
Total Assets32.56B41.4B56.34B
Liabilities & Shareholders' Equity
201220132014
ST Debt & Current Portion LT Debt1.14B1.74B3.6B
Short Term Debt000
Current Portion of Long Term Debt1.14B1.74B3.6B
Accounts Payable13.32B15.13B16.46B
Income Tax Payable---
Other Current Liabilities4.55B6.11B8.03B
Dividends Payable---
Accrued Payroll---
Miscellaneous Current Liabilities4.55B6.11B8.03B
Total Current Liabilities19B22.98B28.09B
Long-Term Debt3.83B5.18B12.49B
Long-Term Debt excl. Capitalized Leases3.08B3.19B8.27B
Non-Convertible Debt3.08B3.19B8.27B
Convertible Debt000
Capitalized Lease Obligations746M1.99B4.22B
Provision for Risks & Charges-457M510M
Deferred Taxes(123M)344M750M
Deferred Taxes - Credit-1.81B2.86B
Deferred Taxes - Debit123M1.47B2.11B
Other Liabilities1.53B1.22B1.66B
Other Liabilities (excl. Deferred Income)1.42B1.22B1.66B
Deferred Income108M--
Total Liabilities24.36B31.65B45.6B
Non-Equity Reserves000
Preferred Stock (Carrying Value)000
Redeemable Preferred Stock000
Non-Redeemable Preferred Stock000
Common Equity (Total)8.19B9.75B10.74B
Common Stock Par/Carry Value5M5M5M
Retained Earnings1.92B2.19B1.95B
ESOP Debt Guarantee000
Cumulative Translation Adjustment/Unrealized For. Exch. Gain(250M)(187M)(512M)
Unrealized Gain/Loss Marketable Securities11M2M1M
Revaluation Reserves000
Treasury Stock(1.84B)(1.84B)(1.84B)
Total Shareholders' Equity8.19B9.75B10.74B
Accumulated Minority Interest000
Total Equity8.19B9.75B10.74B
Liabilities & Shareholders' Equity32.56B41.4B56.34B


Amazon.com Inc.
 Cash flows from operating activities: 201220132014
Net Income before Extraordinaries(39M)274M(241M)
Depreciation, Depletion & Amortization2.16B3.25B4.75B
Depreciation and Depletion1.65B2.46B3.62B
Amortization of Intangible Assets506M793M1.13B
Deferred Taxes & Investment Tax Credit(265M)(156M)(316M)
Deferred Taxes(265M)(156M)(316M)
Investment Tax Credit---
Other Funds802M1.34B1.68B
Funds from Operations2.66B4.71B5.87B
Extraordinaries---
Changes in Working Capital1.52B767M974M
Receivables(861M)(846M)(1.04B)
Accounts Payable2.07B1.89B1.76B
Other Assets/Liabilities275M399M741M
Net Operating Cash Flow4.18B5.48B6.84B
Investing Activities
201220132014
Capital Expenditures(3.79B)(3.44B)(4.89B)
Capital Expenditures (Fixed Assets)(3.79B)(3.44B)(4.89B)
Capital Expenditures (Other Assets)000
Net Assets from Acquisitions(745M)(312M)(979M)
Sale of Fixed Assets & Businesses---
Purchase/Sale of Investments935M(520M)807M
Purchase of Investments(3.3B)(2.83B)(2.54B)
Sale/Maturity of Investments4.24B2.31B3.35B
Other Uses000
Other Sources000
Net Investing Cash Flow(3.6B)(4.28B)(5.07B)
Financing Activities
201220132014
Cash Dividends Paid - Total000
Common Dividends000
Preferred Dividends000
Change in Capital Stock(960M)00
Repurchase of Common & Preferred Stk.(960M)00
Sale of Common & Preferred Stock000
Proceeds from Stock Options000
Other Proceeds from Sale of Stock000
Issuance/Reduction of Debt, Net2.79B(617M)4.43B
Change in Current Debt000
Change in Long-Term Debt2.79B(617M)4.43B
Issuance of Long-Term Debt3.38B394M6.36B
Reduction in Long-Term Debt(588M)(1.01B)(1.93B)
Other Funds429M78M6M
Other Uses000
Other Sources429M78M6M
Net Financing Cash Flow2.26B(539M)4.43B
Exchange Rate Effect(29M)(86M)(310M)
Miscellaneous Funds000
Net Change in Cash2.82B574M5.9B
Free Cash Flow395M2.03B1.95B

Step by Step Solution

3.38 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Here are the cost function estimates for Netflix Inc and Amazoncom Inc using the following methods Method 1 Linear Regression In linear regression we ... 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

Separation process principles

Authors: J. D. Seader

2nd Edition

471464805, 978-0471464808

More Books

Students also viewed these Organizational Behavior questions

Question

How do you identify yourself culturally?

Answered: 1 week ago