FINANCE homework help

CopyofFIN320ModuleThreeExcelAssignment.xlsx

2014 Balance Sheet

The Walt Disney Company
Balance Sheet
Period Ending		September 27, 2014
Assets
Current Assets
	Cash And Cash Equivalents	3,421,000
	Short Term Investments	-
	Net Receivables	8,319,000
	Inventory	1,574,000
	Other Current Assets	1,862,000
Total Current Assets		15,176,000
Long Term Investments		2,696,000
Property Plant and Equipment		23,332,000
Goodwill		27,881,000
Intangible Assets		7,434,000
Accumulated Amortization		-
Other Assets		7,667,000
Deferred Long Term Asset Charges		-
Total Assets		84,186,000
Liabilities
Current Liabilities
	Accounts Payable	7,595,000
	Short/Current Long Term Debt	2,164,000
	Other Current Liabilities	3,533,000
Total Current Liabilities		13,292,000
Long Term Debt		12,676,000
Other Liabilities		5,942,000
Deferred Long Term Liability Charges		4,098,000
Minority Interest		3,220,000
Negative Goodwill		-
Total Liabilities		39,228,000
Stockholders' Equity
Misc Stocks Options Warrants		-
Redeemable Preferred Stock		-
Preferred Stock		-
Common Stock		34,301,000
Retained Earnings		53,734,000
Treasury Stock		(41,109,000.00)
Capital Surplus		-
Other Stockholder Equity		(1,968,000.00)
Total Stockholder Equity		44,958,000
Net Tangible Assets		9,643,000
Reference:

The Walt Disney Company
Income Statement
Period Ending		September 27, 2014
Total Revenue		48,813,000
Cost of Revenue		26,420,000
Gross Profit		22,393,000
	Operating Expenses
	Research Development	-
	Selling General and Administrative	8,565,000
	Non Recurring	140,000
	Others	2,288,000
	Total Operating Expenses	-
Operating Income or Loss		11,400,000
	Income from Continuing Operations
	Total Other Income/Expenses Net	(31,000.00)
	Earnings Before Interest And Taxes	12,246,000
	Interest Expense	-
	Income Before Tax	12,246,000
	Income Tax Expense	4,242,000
	Minority Interest	(503,000.00)
	Net Income From Continuing Ops	8,355,000
	Non-recurring Events
	Discontinued Operations	-
	Extraordinary Items	-
	Effect Of Accounting Changes	-
	Other Items	-
Net Income		7,501,000
Preferred Stock And Other Adjustments		-
Net Income Applicable To Common Shares		7,501,000
Reference:

The Walt Disney Company
Cash Flow
Period Ending		September 27, 2014
Net Income		7,501,000
Operating Activities, Cash Flows Provided By or Used In
Depreciation		2,288,000
Adjustments To Net Income		(240,000.00)
Changes In Accounts Receivables		(480,000.00)
Changes In Liabilities		440,000
Changes In Inventories		(81,000.00)
Changes In Other Operating Activities		(151,000.00)
Total Cash Flow From Operating Activities		9,780,000
Investing Activities, Cash Flows Provided By or Used In
Capital Expenditures		(3,311,000.00)
Investments		395,000
Other Cash flows from Investing Activities		(429,000.00)
Total Cash Flows From Investing Activities		(3,345,000.00)
Financing Activities, Cash Flows Provided By or Used In
Dividends Paid		(1,508,000.00)
Sale Purchase of Stock		(6,123,000.00)
Net Borrowings		633,000
Other Cash Flows from Financing Activities		288,000
Total Cash Flows From Financing Activities		(6,710,000.00)
Effect Of Exchange Rate Changes		(235,000.00)
Change In Cash and Cash Equivalents		(510,000.00)
Reference: