Forecasting income statement and balance sheet, writing homework help

Anonymous
timer Asked: Mar 26th, 2017
account_balance_wallet $15

Question Description

Project income statements and balance sheets for 5 years into the future.

Compute FCF and Dispositions of FCF for 10 years,

Unformatted Attachment Preview

Fiscal year ends in September USD in Million except per share data 2012 2013 Disney Income Statement Revenue Cost of revenue Gross profit Sales, General and administrative expense Other operating expense Total operating expense Operating income Interest Expense Other income (expense) Income before taxes Provision for income tax Other Net income Basic EPS Diluted EPS NOPAT interest expense net of tax other expense net income 42278 33415 8863 45041 35591 9450 8863 472 -869 9260 3087 -491 5682 3,17 3,13 9450 349 -519 9620 2984 -500 6136 3,42 3,38 Reformulated income statement 5438,3981 6027,5676 289,62246 222,60541 -533,2244 -331,0378 5682 6136 Disney Balance Sheet in millions, except share and per share data 2012 2013 Assets Current assets Cash and cash equivalents Receivables Inventories Deferred income taxes Prepaid expenses Other current assets Total current assets Non-current assets Gross property, plant, equipment Accumulated depreciation Equity and other investment 3387 6313 1537 765 469 1238 13709 3931 6694 1487 485 1077 435 14109 42199 -20687 2723 44839 -22459 2849 Goodwill Intangible assets Other long-term assets Total non-current assets Total Assets Liabilities Current liabilities Short-term debt Accounts payable Accrued liabilities Deferred revenues Other current liabilities Total current liabilities Non-current liabilities Long-term debt Capital leases Deferred taxes liabilities Deferred revenues Pensions and other bennefits Minority interest Other long-term liabilities Total non-current liabilities Total Liabilities Stockholders' equity Common stock Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity Total assets subtract accounts payable aubtract accruals Net operating assets 25110 5015 6829 61189 74898 27324 7370 7209 67132 81241 3614 4619 1521 2806 253 12813 1512 3389 6803 11704 10697 284 2251 220 4828 2199 1847 22326 35139 12776 274 4050 298 2091 2721 1898 24108 35812 31731 42965 -31671 -3266 39759 74898 33440 47758 -34582 -1187 45429 81241 Reformulated balance sheet 74898 -4619 -16209 54070 81241 0 -21524 59717 financial obligations 14311 14288 common stock Additional paid-in capital Accumulated other comprehensive loss retained earnings Treasury stock 31731 33440 -3266 42965 -31671 -1187 47758 -34582 financing obligations + common equity unreconciled 54070 59717 0 0 2014 2015 2016 t 48813 26420 22393 8565 2288 10853 11540 294 -1000 12246 4242 -503 7501 4,31 4,26 52465 28364 24101 8523 2354 10877 13224 265 -909 13868 5016 -470 8382 4,95 4,9 55632 29993 25639 8754 2527 11281 14358 354 -864 14868 5078 -399 9391 5,76 5,73 nt 7068,5563 7992,758 9068,8713 180,0828 160,16945 223,59524 -612,5265 -549,4115 -545,724 7501 8382 9391 2014 2015 2016 3421 7274 1574 497 425 1985 15176 4269 7456 1571 767 469 2226 16758 4610 8458 1390 1657 851 16966 47054 -23722 2696 50023 -24844 2643 54198 -26849 4280 27881 7434 7667 69010 84186 27826 7172 8604 71424 88182 27810 6949 8679 75067 92033 2164 5371 2224 3533 4563 5504 2340 3927 13292 16334 3687 6860 1747 4025 523 16842 12676 12773 16483 4098 4051 3679 3481 3220 2461 25936 39228 3940 4130 2429 27323 43657 5184 4058 2522 31926 48768 34301 53734 -41109 -1968 44958 84186 35122 59028 -47204 -2421 44525 88182 35859 66088 -54703 -3979 43265 92033 84186 -5371 -19017 59798 88182 -5504 -20817 61861 92033 -6860 -21738 63435 14840 17336 20170 34301 35122 35859 -1968 53734 -41109 -2421 59028 -47204 -3979 66088 -54703 59798 61861 63435 0 0 0 ...
Purchase answer to see full attachment

Tutor Answer

vivianvincent1989
School: UIUC

sending you the forecasted file.

Fiscal year ends in September

USD in Million except per share data

Disney Income Statement
Revenue
Cost of revenue
Gross profit
Sales, General and administrative expense
Other operating expense
Total operating expense
Operating income
Interest Expense
Other income (expense)
Income before taxes
Provision for income tax
Other
Net income
Basic EPS
Diluted EPS

Reformulated income statement
NOPAT
interest expense net of tax
other expense
net income

Disney Balance Sheet
in millions, except share and per share data

Assets
Current assets
Cash and cash equivalents
Receivables
Inventories
Deferred income taxes
Prepaid expenses
Other current assets
Total current assets
Non-current assets
Gross property, plant, equipment
Accumulated depreciation
Equity and other investment
Goodwill
Intangible assets
Other long-term assets
Total non-current assets
Total Assets

Liabilities
Current liabilities
Short-term debt
Accounts payable
Accrued liabilities
Deferred revenues
Other current liabilities
Total current liabilities
Non-current liabilities
Long-term debt
Capital leases
Deferred taxes liabilities
Deferred revenues
Pensions and other bennefits
Minority interest
Other long-term liabilities
Total non-current liabilities
Total Liabilities
Stockholders' equity
Common stock
Retained earnings
Treasury stock
Accumulated other comprehensive income
Total stockholders' equity
Total liabilities and stockholders' equity
Reformulated balance sheet
Total assets
subtract accounts payable
aubtract accruals
Net operating assets
financial obligations
common stock
Additional paid-in capital
Accumulated other comprehensive loss
retained earnings
Treasury stock
financing obligations + common equity
unreconciled
FCF Calculation
EBIT (earnings before interest and taxes)
NOPAT (Net operating profit after tax)
Net operating working capital
Net fixed assets
Total Operating capital
Net investement operating capital
Free cash Flow (NOP...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors