aCCOUNTING HELP

helpmeout11

20170905103410table.doc

Home >Business & Finance homework help >Accounting homework help >aCCOUNTING HELP

Table 4-8 Financial Statements for Sam's Sandwich Delivery

Revenues

Retail Sales68,283$

Wholesale Sales104,417

Total Revenues172,700$

Cost of Sales52,067

Gross Profit120,633$

Total Operating Expenses111,117

Operating Profit9,516$

Other Income/Expenses

Interest Income41

Interest Expense(651)

Depreciation-Store Equipment(292)

Total Other Income/Expenses(902)

Net Profit8,614$

Assets

Current Assets

Change Fund569$

Cash in Bank-Checking8,612

Cash in Bank-Savings9,622

Accounts Receivable6,843

Inventories2,607

Total Current Assets28,253$

Fixed Assets

Furniture and Fixtures4,296

Less: Accum Depreciation4,110 186

Equipment68,293

Less: Accum Depreciation67,725 568

Transportation Equipment31,168

Less: Accum Depreciation11,571 19,597

Total Fixed Assets20,351$

Total Assets48,604$

Current Liabilities

Accounts Payable Trade6,208

Accrued Payroll Taxes3,464

Accrued Sales Taxes987

Total Current Liabilities10,659$

Long-Term Liabilities

Auto Loans Payable18,626

Total Long-Term Liabilities18,626$

Total Liabilities29,285$

Stockholder's Equity

Common Stock83,081

Retained Earnings(72,376)

Net Profit/Loss8,614

Total Equity19,319

Balance Sheet as of 06-30-2013

Profit Loss (Income Statement) for Six Months Ending 06-30-2013

_1566146699.xls

T4-1


Table 4-1 Sample Income Statement Data
Markadel Retail Store
Income Statement Data
From January 1 through December 31, 2005 and 2006
Account	Year 2005	Year 2006	Vertical Analysis 2005 (%)	Horizontal Analysis 2005-2006 (%)
Gross sales	$ 300,580	$ 315,487	101.73	4.96
Less returns	5,124	9,253	1.73	80.58
Net sales	295,456	306,234	100.00	3.65
Cost of goods sold	101,250	120,002	34.27	18.52
Gross profit	194,206	186,232	65.73	(4.11)
Operating expenses
Administration	74,983	76,450	25.38	1.96
Advertising	35,214	37,250	11.92	5.78
Overhead	27,120	28,300	9.18	4.35
Operating income	56,889	44,232	19.25	(22.25)
Interest	7,000	6,250	2.37	(10.71)
Earnings before taxes	49,889	37,982	16.89	(23.87)
Taxes	7,483	5,697	2.53	(23.87)
Net profit	$ 42,406	$ 32,285	14.35	(23.87)

T4-2


Table 4-2 Sample Balance Sheet Data
Markadel Retail Store
Balance Sheet Data
As of December 31, 2005 and 2006
Category	Year 2005	Year 2006	Vertical Analysis 2005 (%)	Horizontal Analysis 2005-2006 (%)
Current assets
Cash	$ 10,210	$ 8,175	4.77	(19.93)
Notes receivable	3,000	5,000	1.40	66.67
Accounts receivable	15,320	18,025	7.16	17.66
Inventory	35,020	50,515	16.37	44.25
Prepaid insurance	1,000	1,500	0.47	50.00
Prepaid legal	1,280	1,602	0.60	25.16
Total current assets	65,830	84,817	30.77	28.84
Fixed assets
Land	25,000	25,000	11.69	0.00
Buildings	135,000	135,000	63.10	0.00
Accumulated depreciation	(47,000)	(50,000)	21.97	6.38
Equipment	58,250	58,250	27.23	0.00
Accumulated depreciation	(23,150)	(28,150)	10.82	21.60
Total fixed assets	148,100	140,100	69.23	(5.40)
Total assets	$ 213,930	$ 224,917	100.00	5.14
Current liabilities
Accounts payable	34,250	40,003	16.01	16.80
Notes payable	25,000	33,035	11.69	32.14
Total current liabilities	59,250	73,038	27.70	23.27
Long-term debt
Mortgage payable	65,000	63,000	30.38	(3.08)
Bank loan payable	10,000	15,000	4.67	50.00
Total long-term debt	75,000	78,000	35.06	4.00
Total liabilities	134,250	151,038	62.75	12.51
Owner’s equity	79,680	73,879	37.25	(7.28)
Total liabilities and owner’s equity	$ 213,930	$ 224,917	100.00	5.14

T4-3


Table 4-3 Balance Sheet, Sample Company
		Vertical		Vertical
Category	2005	Analysis 2005	2006	Analysis 2006
Current assets	$ 7,000,000	46.67%	$ 9,000,000	60.00%
Total fixed assets	8,000,000	53.33%	6,000,000	40.00%
Total assets	15,000,000	100.00%	15,000,000	100.00%
Current liabilities	$ 3,000,000	20.00%	$ 1,000,000	6.67%
Long term debt	4,000,000	26.67%	4,000,000	26.67%
Owner’s equity	8,000,000	53.33%	10,000,000	66.67%
Total liabilities &
owner’s equity	$ 15,000,000	100.00%	$ 15,000,000	100.00%

T4-4


Table 4-4 Sample Balance Sheet
	2005	2006	Horizontal Analysis
Current assets	$ 7,000,000	$ 9,000,000	28.57%
Total fixed assets	8,000,000	6,000,000	-25.00%
Total assets	15,000,000	15,000,000	0.00%
Current liabilities	$ 3,000,000	$ 1,000,000	-66.67%
Long term debt	4,000,000	4,000,000	0.00%
Owner’s equity	8,000,000	10,000,000	25.00%
Total liabilities &
owner’s equity	$ 15,000,000	$ 15,000,000	0.00%

T4-5


Table 4-5 Starbucks Corporation Consolidated Balance Sheet*
CONSOLIDATED BALANCE SHEETS
In thousands, except share data
Fiscal Year Ended		Oct 2, 2005	Oct 3, 2004
ASSETS
Current assets:
	Cash and cash equivalents	$ 173,809	$ 145,053
	Short-term investments — available-for-sale securities	95,379	483,157
	Short-term investments — trading securities	37,848	24,799
	Accounts receivable, net of allowances of $3,079 and $2,231, respectively	190,762	140,226
	Inventories	546,299	422,663
	Prepaid expenses and other current assets	94,429	71,347
	Deferred income taxes, net	70,808	63,650
	Total current assets	1,209,334	1,350,895
Long-term investments — available-for-sale securities		60,475	135,179
Equity and other investments		201,461	167,740
Property, plant and equipment, net		1,842,019	1,551,416
Other assets		72,893	85,561
Other intangible assets		35,409	26,800
Goodwill		92,474	68,950
	TOTAL ASSETS	$ 3,514,065	$ 3,386,541
LIABILITIES AND SHAREHOLDERS’ EQUITY
Current liabilities:
	Accounts payable	$ 220,975	$ 199,346
	Accrued compensation and related costs	232,354	208,927
	Accrued occupancy costs	44,496	29,231
	Accrued taxes	78,293	62,959
	Short-term borrowings	277,000	—
	Other accrued expenses	198,082	123,684
	Deferred revenue	175,048	121,377
	Current portion of long-term debt	748	735
	Total current liabilities	1,226,996	746,259
Deferred income taxes, net		—	21,770
Long-term debt		2,870	3,618
Other long-term liabilities		193,565	144,683
Shareholders’ equity:
	Common stock ($0.001 par value) and additional paid-in-capital — authorized, 1,200,000,000 shares; issued and outstanding, 767,442,110 and 794,811,688 shares, respectively, (includes 3,394,200 common stock units in both periods)	90,968	956,685
	Other additional paid-in-capital	39,393	39,393
	Retained earnings	1,939,359	1,444,892
	Accumulated other comprehensive income	20,914	29,241
	Total shareholders’ equity	2,090,634	2,470,211
	TOTAL LIABILITIES AND SHAREHOLDERS’ EQUITY	$ 3,514,065	$ 3,386,541
Source: Securities and Exchange Commission, Washington DC, Edgar Online, Form 10-K, Filing Date: 12/16/2005.

T4-6


Table 4-6 Starbucks Corporation Consolidated Statement of Earnings
CONSOLIDATED STATEMENTS OF EARNINGS
In thousands, except earnings per share
Fiscal Year Ended			2-Oct-05	Oct 3, 2004	Sept 28, 2003
Net revenues:
	Company-operated retail		$ 5,391,927	$ 4,457,378	$ 3,449,624
	Specialty:
		Licensing	673,015	565,798	409,551
		Foodservice and other	304,358	271,071	216,347
	Total specialty		977,373	836,869	625,898
Total net revenues			6,369,300	5,294,247	4,075,522
Cost of sales including occupancy costs			2,605,212	2,191,440	1,681,434
Store operating expenses			2,165,911	1,790,168	1,379,574
Other operating expenses			197,024	171,648	141,346
Depreciation and amortization expenses			340,169	289,182	244,671
General and administrative expenses			357,114	304,293	244,550
	Subtotal operating expenses		5,665,430	4,746,731	3,691,575
Income from equity investees			76,745	59,071	36,903
Operating income			780,615	606,587	420,850
Interest and other income, net			15,829	14,140	11,622
Earnings before income taxes			796,444	620,727	432,472
Income taxes			301,977	231,754	167,117
		Net earnings	$ 494,467	$ 388,973	$ 265,355
Net earnings per common share — basic			$ 0.63	$ 0.49	$ 0.34
Net earnings per common share — diluted			$ 0.61	$ 0.47	$ 0.33
Weighted average shares outstanding:
		Basic	789,570	794,347	781,505
		Diluted	815,417	822,930	803,296
Source: Securities and Exchange Commission, Washington DC, Edgar Online, Form 10-K, Filing Date: 12/16/2005.

T4-7


Table 4-7 Starbucks Corporation Consolidated Statement of Cash Flows*
CONSOLIDATED STATEMENTS OF CASH FLOWS
In thousands
Fiscal Year Ended			Oct 2, 2005	Oct 3, 2004	Sept 28, 2003
OPERATING ACTIVITIES
Net earnings			$ 494,467	$ 388,973	$ 265,355
Adjustments to reconcile net earnings to net cash provided by operating activities:
	Depreciation and amortization		367,207	314,047	266,258
	Provision for impairments and asset disposals		20,157	13,568	7,784
	Deferred income taxes, net		(31,253)	(3,770)	(6,767)
	Equity in income of investees		(49,633)	(31,801)	(21,320)
	Distributions of income from equity investees		30,919	38,328	28,966
	Tax benefit from exercise of nonqualified stock options		109,978	63,405	36,590
	Net accretion of discount and amortization of premium on marketable securities		10,097	11,603	5,996
	Cash provided/(used) by changes in operating assets and liabilities:
		Accounts receivable	(49,311)	(24,977)	(8,384)
		Inventories	(121,618)	(77,662)	(64,768)
		Accounts payable	9,717	27,948	24,990
		Accrued compensation and related costs	22,711	54,929	42,132
		Deferred revenue	53,276	47,590	30,732
		Other operating assets and liabilities	56,894	36,356	8,554
Net cash provided by operating activities			923,608	858,537	616,118
INVESTING ACTIVITIES
	Purchase of available-for-sale securities		(643,488)	(887,969)	(481,050)
	Maturity of available-for-sale securities		469,554	170,789	218,787
	Sale of available-for-sale securities		626,113	452,467	141,009
	Acquisitions, net of cash acquired		(21,583)	(7,515)	(69,928)
	Net additions to equity investments, other investments and other assets		(7,915)	(64,747)	(47,259)
	Net additions to property, plant and equipment		(643,989)	(412,537)	(377,983)
Net cash used by investing activities			(221,308)	(749,512)	(616,424)
FINANCING ACTIVITIES
	Proceeds from issuance of common stock		163,555	137,590	107,183
	Borrowings under revolving credit facility		277,000	—	—
	Principal payments on long-term debt		(735)	(722)	(710)
	Repurchase of common stock		(1,113,647)	(203,413)	(75,710)
Net cash provided/(used) by financing activities			(673,827	(66,545)	30,763
Effect of exchange rate changes on cash and cash equivalents			283	3,111	3,278
Net increase in cash and cash equivalents			28,756	45,591	33,735
CASH AND CASH EQUIVALENTS
Beginning of period			145,053	99,462	65,727
End of period			$ 173,809	$ 145,053	$ 99,462
SUPPLEMENTAL DISCLOSURE OF CASH FLOW INFORMATION
Cash paid during the year for:
	Interest		$ 1,060	$ 370	$ 265
	Income taxes		$ 227,812	$ 172,759	$ 140,107
Source: Securities and Exchange Commission, Washington DC, Edgar Online, Form 10-K, Filing Date: 12/16/2005.

T4-8


Table 4-8 Financial Statements for Sam's Sandwich Delivery
Profit Loss (Income Statement) for Six Months Ending 06-30-2013
Revenues
	Retail Sales	$ 68,283
	Wholesale Sales	104,417
Total Revenues			$ 172,700
Cost of Sales		52,067
Gross Profit			$ 120,633
	Total Operating Expenses	111,117
Operating Profit			$ 9,516
Other Income/Expenses
	Interest Income	41
	Interest Expense	(651)
	Depreciation-Store Equipment	(292)
Total Other Income/Expenses			(902)
Net Profit				$ 8,614
Balance Sheet as of 06-30-2013
Assets
Current Assets
	Change Fund		$ 569
	Cash in Bank-Checking		8,612
	Cash in Bank-Savings		9,622
	Accounts Receivable		6,843
	Inventories		2,607
Total Current Assets				$ 28,253
Fixed Assets
	Furniture and Fixtures	4,296
	Less: Accum Depreciation	4,110	186
	Equipment	68,293
	Less: Accum Depreciation	67,725	568
	Transportation Equipment	31,168
	Less: Accum Depreciation	11,571	19,597
Total Fixed Assets				$ 20,351
Total Assets				$ 48,604
Current Liabilities
	Accounts Payable Trade		6,208
	Accrued Payroll Taxes		3,464
	Accrued Sales Taxes		987
Total Current Liabilities				$ 10,659
Long-Term Liabilities
	Auto Loans Payable		18,626
	Total Long-Term Liabilities			$ 18,626
	Total Liabilities			$ 29,285
Stockholder's Equity
	Common Stock	83,081
	Retained Earnings	(72,376)
	Net Profit/Loss	8,614
Total Equity				19,319
Total Liabilities and Equity				$ 48,604

Q6


Table 4-5 Starbucks Corporation Consolidated Balance Sheet*
CONSOLIDATED BALANCE SHEETS
In thousands, except share data
Fiscal Year Ended		Oct 2, 2005	Oct 3, 2004	Horizontal Analysis
ASSETS
Current assets:
	Cash and cash equivalents	$ 173,809	$ 145,053	19.82%
	Short-term investments — available-for-sale securities	95,379	483,157	-80.26%
	Short-term investments — trading securities	37,848	24,799	52.62%
	Accounts receivable, net of allowances of $3,079 and $2,231, respectively	190,762	140,226	36.04%
	Inventories	546,299	422,663	29.25%
	Prepaid expenses and other current assets	94,429	71,347	32.35%
	Deferred income taxes, net	70,808	63,650	11.25%
	Total current assets	1,209,334	1,350,895	-10.48%
Long-term investments — available-for-sale securities		60,475	135,179	-55.26%
Equity and other investments		201,461	167,740	20.10%
Property, plant and equipment, net		1,842,019	1,551,416	18.73%
Other assets		72,893	85,561	-14.81%
Other intangible assets		35,409	26,800	32.12%
Goodwill		92,474	68,950	34.12%
	TOTAL ASSETS	$ 3,514,065	$ 3,386,541	3.77%
LIABILITIES AND SHAREHOLDERS’ EQUITY
Current liabilities:
	Accounts payable	$ 220,975	$ 199,346	10.85%
	Accrued compensation and related costs	232,354	208,927	11.21%
	Accrued occupancy costs	44,496	29,231	52.22%
	Accrued taxes	78,293	62,959	24.36%
	Short-term borrowings	277,000	—
	Other accrued expenses	198,082	123,684	60.15%
	Deferred revenue	175,048	121,377	44.22%
	Current portion of long-term debt	748	735	1.77%
	Total current liabilities	1,226,996	746,259	64.42%
Deferred income taxes, net		—	21,770
Long-term debt		2,870	3,618	-20.67%
Other long-term liabilities		193,565	144,683	33.79%
Shareholders’ equity:
	Common stock ($0.001 par value) and additional paid-in-capital — authorized, 1,200,000,000 shares; issued and outstanding, 767,442,110 and 794,811,688 shares, respectively, (includes 3,394,200 common stock units in both periods)	90,968	956,685	-90.49%
	Other additional paid-in-capital	39,393	39,393	0.00%
	Retained earnings	1,939,359	1,444,892	34.22%
	Accumulated other comprehensive income	20,914	29,241	-28.48%
	Total shareholders’ equity	2,090,634	2,470,211	-15.37%
	TOTAL LIABILITIES AND SHAREHOLDERS’ EQUITY	$ 3,514,065	$ 3,386,541	3.77%
Source: Securities and Exchange Commission, Washington DC, Edgar Online, Form 10-K, Filing Date: 12/16/2005.

Q7


Table 4-5 Starbucks Corporation Consolidated Balance Sheet*
(in thousands, except share data)
		3-Oct-04	28-Sep-03	Vertical Analysis
ASSETS
Current Assets
	Cash and cash equivalents	$ 299,128	$ 200,907	8.82%
	Short-term investments-Available-for-sale securities	329,082	128,905	9.71%
	Short-term investments-Trading securities	24,799	20,199	0.73%
	Accounts receivable, net of allowances of $2,231 and $4,809, respectively	140,226	114,448	4.14%
	Inventories	422,663	342,944	12.47%
	Prepaid expenses and other current assets	71,347	55,173	2.10%
	Deferred income taxes, net	63,650	47,404	1.88%
	Total current assets	1,350,895	909,980	39.84%
Long-term investments - availabe-fro-sale securities		135,179	136,159	3.99%
	Equity and other investments	171,747	144,257	5.07%
Property, plant, and equipment, net		1,551,416	1,447,738	45.76%
Other assets		85,561	52,113	2.52%
Other intangible assets		26,800	24,942	0.79%
Goodwill, net		68,950	63,344	2.03%
	Total Assets	$ 3,390,548	$ 2,778,533	100.00%
LIABILITIES AND SHAREHOLDER'S EQUITY
Current Liabilities:
	Accounts payable	$ 199,346	$ 168,984	5.88%
	Accrued compensation and related costs	208,927	152,608	6.16%
	Accrued occupancy costs	29,231	21,741	0.86%
	Accrued taxes	62,959	54,882	1.86%
	Other accrued expenses	123,684	101,800	3.65%
	Deferred revenue	121,377	73,476	3.58%
	Current portion of long-term debt	735	722	0.02%
	Total current liabilities	746,259	574,213	22.01%
Deferred income taxes, net		21,770	12,542	0.64%
Long-term debt		3,618	4,354	0.11%
Other long-term liabilities		144,683	116,314	4.27%
Shareholders' Equity:
Common stock ($0.001 par value) and additional paid-in capital — authorized, 600,000,000 shares; issued and outstanding, 397,405,844 and 393,692,536 shares, respectively, (includes 1,697,100 common stock units in both periods)		956,685	959,103	28.22%
	Other additional paid-in-capital	39,393	39,393	1.16%
Retained Earnings		1,448,899	1,058,340	42.73%
Accumulated other comprehensive income		29,241	14,274	0.86%
	Total Shareholders' equity	2,474,218	2,071,110	72.97%
TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY		$ 3,390,548	$ 2,778,533	100.00%
* Secutities and Exchange Commission, Washington DC 20549, Form 10-K Annual Report.

Q9


Table 4-6 Starbucks Corporation Consolidated Statement of Earnings
(Income Statement)
(in thousands, except earning per share)
Fiscal year ended:		3-Oct-04		28-Sep-03	Horizontal Analysis
Net revenues
	Company-operated retail	$ 4,457,378		$ 3,449,624	29.21%
	Specialty
	Licensing	565,798		409,551	38.15%
	Food service and other	271,071		216,347	25.29%
	Total specialty	836,869		625,898	33.71%
	Total Net Revenues	$ 5,294,247	$ - 0	$ 4,075,522	29.90%
Cost of sales and related occupancy costs		2,191,440		1,681,434	30.33%
Store operating expenses		1,790,168		1,379,574	29.76%
Other operating expenses		171,648		141,346	21.44%
Depreciation and amortization		289,182		244,671	18.19%
General and administrative expenses		304,293		244,550	24.43%
	Subtotal operating expenses	4,746,731	-	3,691,575	28.58%
Income from equity investees		60,657	-	38,396	57.98%
Operating income		608,173		422,343	44.00%
Interest and other income, net		14,140		11,622	21.67%
Gain on sale of investment		-		-	-
	Earnings before income taxes	622,313	-	433,965	43.40%
Income taxes		231,754		167,117	38.68%
	Net earnings	$ 390,559	$ - 0	$ 266,848	46.36%
Net earnings per common share - basic		$ 0.98		$ 0.68	44.12%
Net earnings per common share - diluted		$ 0.95		$ 0.66	43.94%
Weighted average shares outstanding:
	Basic	397,173		390,753	1.64%
	Diluted	411,465		401,648	2.44%
*Securities and Exchange Commission, Washington DC 20549, Form 10-K, Annual Report

Q11


Table 4-8 Financial Statements for Sam's Sandwich Delivery
Profit Loss (Income Statement) for Six Months Ending 06-30-2006
			Vertical Analysis
Revenues
	Retail Sales	$ 68,283	39.54%
	Wholesale Sales	104,417	60.46%
Total Revenues		$ 172,700	100.00%
Cost of Sales		52,067	30.15%
Gross Profit		$ 120,633	69.85%
	Total Operating Expenses	111,117	64.34%
Operating Profit		$ 9,516	5.51%
Other Income/Expenses
	Interest Income	41	0.02%
	Interest Expense	(651)	-0.38%
	Depreciation-Store Equipment	(292)	-0.17%
Total Other Income/Expenses		(902)	-0.52%
Net Profit		$ 8,614	4.99%
Balance Sheet as of 06-30-2006
Assets
Current Assets
	Change Fund	$ 569	1.17%
	Cash in Bank-Checking	8,612	17.72%
	Cash in Bank-Savings	9,622	19.80%
	Accounts Receivable	6,843	14.08%
	Inventories	2,607	5.36%
Total Current Assets		$ 28,253	58.13%
Fixed Assets
	Furniture and Fixtures	4,296	8.84%
	Less: Accum Depreciation	4,110	8.46%
	Net Furniture and Fixtures	$ 186	0.38%
	Equipment	68,293	140.51%
	Less: Accum Depreciation	67,725	139.34%
	Net Equipment	$ 568	1.17%
	Transportation Equipment	31,168	64.13%
	Less: Accum Depreciation	11,571	23.81%
	Net Transportation Equipment	$ 19,597	40.32%
Total Fixed Assets		$ 20,351	41.87%
Total Assets		$ 48,604	100.00%
Current Liabilities
	Accounts Payable Trade	6,208	12.77%
	Accrued Payroll Taxes	3,464	7.13%
	Accrued Sales Taxes	987	2.03%
Total Current Liabilities		$ 10,659	21.93%
Long-Term Liabilities
	Auto Loans Payable	18,626	38.32%
	Total Long-Term Liabilities	$ 18,626	38.32%
	Total Liabilities	$ 29,285	60.25%
Stockholder's Equity
	Common Stock	83,081	170.93%
	Retained Earnings	(72,376)	-148.91%
	Net Profit/Loss	8,614	17.72%
Total Equity		$ 19,319	39.75%
Total Liabilities and Equity		$ 48,604	100.00%