Seminari 5 Netflix Cash flow exercise PDF

Preview

Summary

Ejercicio con solución Cash-flow seminario 5...

Description

Consolidated+Balance+Sheets+-+USD+($)+$+in+Thousands Dec.+31,+2017 Current+assets: Cash%and%cash%equivalents $%2.822.795 Short-term%investments 0% Current%content%assets,%net 4.310.934% Other%current%assets 536.245% Total+current+assets 7.669.974+ Non-current%content%assets,%net 10.371.055% Property%and%equipment,%net 319.404% Other%non-current%assets 652.309% Total%assets 19.012.742% Current+liabilities: Current%content%liabilities 4.173.041% Accounts%payable 359.555% Accrued%expenses 315.094% Deferred%revenue 618.622% Total+current+liabilities 5.466.312+ Non-current%content%liabilities 3.329.796% Long-term%debt 6.499.432% Other%non-current%liabilities 135.246% Total+liabilities 15.430.786+ Commitments%and%contingencies % Stockholders’+equity: Preferred%stock,%$0.001%par%value;%10,000,000%shares%authorized%at%December% 0% 31,%2017%and%2016;%no%shares%issued%and%outstanding%at%December%31,%2017% and%2016 Common%stock,%$0.001%par%value;%4,990,000,000%shares%authorized%at% 1.871.396% December%31,%2017%and%December%31,%2016,%respectively;%433,392,686%and% 430,054,212%issued%and%outstanding%at%December%31,%2017%and%December%31,% 2016,%respectively Accumulated%other%comprehensive%loss -20.557% Retained%earnings 1.731.117% Total%stockholders’%equity 3.581.956% Total%liabilities%and%stockholders’%equity $%19.012.742 INFORMATION+FOR+ADJUSTMENTS Net%income Stock-Based%compensation Amortization%of%streaming%content%assets Amortization%of%DVD%content%assets Depreciation%and%amortization%of%property,%equipment%and%intangibles

$%558.929 $%182.209 $%6.197.817 $%60.657 $%71.911

Dec.+31,+2016

Difference

Adjustment

$%1.467.576 266.206% 3.726.307% 260.202% 5.720.291+ 7.274.501% 250.395% 341.423% 13.586.610%

$%1.355.219 $%(266.206) $%584.627 $%276.043 $+1.949.683 $%3.096.554 $%69.009 $%310.886 $%5.426.132

3.632.711% 312.842% 197.632% 443.472% 4.586.657+ 2.894.654% 3.364.311% 61.188% 10.906.810+

$%540.330 $%46.713 $%117.462 $%175.150 $+879.655 $%435.142 $%3.135.121 $%74.058 $+4.523.976

% 0% $%0 1.599.762%

-48.565% 1.128.603% 2.679.800% $%13.586.610

$%271.634 $%28.008 $%602.514 $%902.156 $%5.426.132

Final+difference

Consolidated+Statement+of+Cash+Flows+-+USD+($)+$+in+Thousands Net+income Amortization%of%streaming%content%assets Amortization%of%DVD%content%assets Depreciation%and%amortization%of%property,%equipment%and%intangibles Increase%in%other%current%assets Increase%in%current%content%assets%(Inventory)% Increase%in%non-current%content%assets%(LT%Inventory)% Increase%in%non-current%content%liabilities Increase%(liability)%Stock-based%compensation Increase%in%content%liabilities Increase%in%accounts%payable Increase%in%accrurred%expenses Increase%in%deferred%revenue Net+cash+used+in+operating+activities Increase%in%property Increase%in%other%non%current%assets Decrease%in%ST%investment%activities Increase%in%Other%Comprehensive%Income Net+cash+used+in+investing+activities

Dec.%31,%2017 $+558.929

$+558.929

$+0

Increase%in%LT%debt

Increase%in%other%non%current%liabilities Issue%new%shares Increase%retained%earnings Net+cash+provided+by+financing+activities Net%increase%(decrease)%in%cash%and%cash%equivalents Cash%at%the%beginning%of%the%year Cash%at%the%end%of%the%year

$+0 $%558.929 $%1.467.576 $%2.026.505

Consolidated+Balance+Sheets+-+USD+($)+$+in+Thousands Dec.+31,+2017 Current+assets: Cash%and%cash%equivalents $%2.822.795 Short-term%investments 0% Current%content%assets,%net 4.310.934% Other%current%assets 536.245% Total+current+assets 7.669.974+ Non-current%content%assets,%net 10.371.055% Property%and%equipment,%net 319.404% Other%non-current%assets 652.309% Total%assets 19.012.742% Current+liabilities: Current%content%liabilities 4.173.041% Accounts%payable 359.555% Accrued%expenses 315.094% Deferred%revenue 618.622% Total+current+liabilities 5.466.312+ Non-current%content%liabilities 3.329.796% Long-term%debt 6.499.432% Other%non-current%liabilities 135.246% Total+liabilities 15.430.786+ Commitments%and%contingencies % Stockholders’+equity: Preferred%stock,%$0.001%par%value;%10,000,000%shares%authorized%at%December% 0% 31,%2017%and%2016;%no%shares%issued%and%outstanding%at%December%31,%2017% and%2016 Common%stock,%$0.001%par%value;%4,990,000,000%shares%authorized%at% 1.871.396% December%31,%2017%and%December%31,%2016,%respectively;%433,392,686%and% 430,054,212%issued%and%outstanding%at%December%31,%2017%and%December%31,% 2016,%respectively Accumulated%other%comprehensive%loss -20.557% Retained%earnings 1.731.117% Total%stockholders’%equity 3.581.956% Total%liabilities%and%stockholders’%equity $%19.012.742 INFORMATION+FOR+ADJUSTMENTS Net%income Stock-Based%compensation Amortization%of%streaming%content%assets Amortization%of%DVD%content%assets Depreciation%and%amortization%of%property,%equipment%and%intangibles

$%558.929 $%182.209 $%6.197.817 $%60.657 $%71.911

Dec.+31,+2016

Difference

Adjustment

$%1.467.576 266.206% 3.726.307% 260.202% 5.720.291+ 7.274.501% 250.395% 341.423% 13.586.610%

$%1.355.219 $%(266.206) $%584.627 $%276.043 $+1.949.683 $%3.096.554 $%69.009 $%310.886 $%5.426.132

3.632.711% 312.842% 197.632% 443.472% 4.586.657+ 2.894.654% 3.364.311% 61.188% 10.906.810+

$%540.330 $%46.713 $%117.462 $%175.150 $+879.655 $%435.142 $%3.135.121 $%74.058 $+4.523.976

Final+difference $%1.355.219 $%(266.206) $%584.627 $%276.043

$%6.258.474 $%71.911

$%9.355.028 $%140.920 $%310.886

$%540.330 $%46.713 $%117.462 $%175.150 $%435.142 $%3.135.121 $%74.058

% 0% $%0 1.599.762%

-48.565% 1.128.603% 2.679.800% $%13.586.610

$%271.634 $%28.008 $%602.514 $%902.156 $%5.426.132

$%(182.209) $%(558.929)

$%89.425 $%28.008 $%43.585

Consolidated+Statement+of+Cash+Flows+-+USD+($)+$+in+Thousands

Dec.+31,+2017

Net+income Amortization%of%streaming%content%assets Amortization%of%DVD%content%assets Depreciation%and%amortization%of%property,%equipment%and%intangibles Increase%in%other%current%assets Increase%in%current%content%assets%(Inventory)% Increase%in%non-current%content%assets%(LT%Inventory)% Increase%in%non-current%content%liabilities Increase%(liability)%Stock-based%compensation

$+558.929 6197817 60657 71911 $%(276.043) $%(584.627) $%(9.355.028) $%435.142 $%182.209

Increase%in%content%liabilities Increase%in%accounts%payable Increase%in%accrurred%expenses Increase%in%deferred%revenue Net+cash+used+in+operating+activities

$%540.330 $%46.713 $%117.462 $%175.150 $+(1.829.378)

Increase%in%property Increase%in%other%non%current%assets Decrease%in%ST%investment%activities Increase%in%Other%Comprehensive%Income Net+cash+used+in+investing+activities

$%(140.920) $%(310.886) $%266.206 $%28.008 $+(157.592)

Increase%in%LT%debt

$%3.135.121

Increase%in%other%non%current%liabilities Issue%new%shares Increase%retained%earnings Net+cash+provided+by+financing+activities Net%increase%(decrease)%in%cash%and%cash%equivalents Cash%at%the%beginning%of%the%year Cash%at%the%end%of%the%year

$%74.058 $%89.425 $%43.585 $+3.342.189 $%1.355.219 $%1.467.576 $%2.822.795...