Required: Common size balance sheet June 26,2020 Dec 31, 2019 Accounts Receivable, Allowance for Credit...

Required: Common size balance sheet

	June 26,2020 Dec 31, 2019
Accounts Receivable, Allowance for Credit Loss, Current	$ 549	$ 524
Property, Plant, and Equipment, Owned, Accumulated Depreciation	$ 8,539	$ 8,083
Common Stock, Par or Stated Value Per Share	$ 0.25	$ 0.25
Common Stock, Shares Authorized	11,200	11,200
Common Stock, Shares, Issued	7,040	7,040
Treasury Stock, Shares	2,745	2,760
CURRENT ASSETS
Cash and cash equivalents	$ 10,037	$ 6,480
Short-term investments	7,551	1,467
TOTAL CASH, CASH EQUIVALENTS, AND SHORT-TERM INVESTMENTS	17,588	7,947
Marketable Securities	2,228	3,228
Trade accounts receivable, fewer allowances of $549 and $524, respectively	3,849	3,971
Inventories	3,501	3,379
Prepaid expenses and other assets	2,205	1,886
TOTAL CURRENT ASSETS	29,371	20,411
EQUITY METHOD INVESTMENTS	18,189	19,025
OTHER INVESTMENTS	746	854
OTHER ASSETS	5,875	6,075
Deferred Income Tax Assets, Net	2,366	2,412
Property, plant, and equipment, less accumulated depreciation of $8,539 and $8,083, respectively	10,695	10,838
TRADEMARKS WITH INDEFINITE LIVES	10,172	9,266
BOTTLERS' FRANCHISE RIGHTS WITH INDEFINITE LIVES	103	109
GOODWILL	16,617	16,764
OTHER INTANGIBLE ASSETS	555	627
TOTAL ASSETS	94,689	86,381
CURRENT LIABILITIES
Accounts payable and accrued expenses	11,668	11,312
Notes and Loans Payable	9,423	10,994
Current maturities of long-term debt	5,181	4,253
Accrued income taxes	576	414
TOTAL CURRENT LIABILITIES	26,848	26,973
LONG-TERM DEBT	37,729	27,516
OTHER LIABILITIES	8,954	8,510
Deferred Income Tax Liabilities, Net	1,969	2,284
SHAREOWNERS' EQUITY
Common stock, $0.25 par value; authorized — 11,200 shares; issued — 7,040 shares	1,760	1,760
Capital surplus	17,367	17,154
Reinvested earnings	66,888	65,855
Accumulated other comprehensive income (loss)	(16,460)	(13,544)
Treasury stock, at cost — 2,745 and 2,760 shares, respectively	(52,071)	(52,244)
EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY	17,484	18,981
EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS	1,705	2,117
TOTAL EQUITY	19,189	21,098
TOTAL LIABILITIES AND EQUITY	$ 94,689	$ 86,381

Expert Solution

Common Size Balance Sheet
	JUNE 26TH 2019 (Amount in $)	31ST DEC 2019 (Amount in $)	% compared with Total Assets of june 26th 2019	% compared with Total Assets of Dec 31st 2019
Accounts receivable, Allowance for credit loss, current	549.00	524.00	0.58	0.61
Property, plant and equipment, owned, Accumulated depr	8,539.00	8,083.00	9.02	9.36
common stock, par or stated value per share	0.25	0.25	0.00	0.00
common stock, shares authorised	11,200.00	11,200.00	11.83	12.97
common stock, shares, issued	7,040.00	7,040.00	7.43	8.15
treasury stock, shares	2,745.00	2,760.00	2.90	3.20
			31.76	34.28
CURRENT ASSET
Cash and cash equivalents	10,037.00	6,480.00	10.60	7.50
short-term investments	7,551.00	1,467.00	7.97	1.70
TOTAL CASH, CASH EQUIVALENTS, AND SHORT-TERM INVESTMENTS	17,588.00	7,947.00
marketable securities	2,228.00	3,228.00	2.35	3.74
trade accounts receivable, fewer allowance of $549 and $524	3,849.00	3,971.00	4.06	4.60
inventories	3,501.00	3,379.00	3.70	3.91
prepaid expenses and other assets	2,205.00	1,886.00	2.33	2.18
TOTAL CURRENT ASSETS	29,371.00	20,411.00
equity method investments	18,189.00	19,025.00	19.21	22.02
other investments	746.00	854.00	0.79	0.99
other assets	5,875.00	6,075.00	6.20	7.03
deferred income tax assets, net	2,366.00	2,412.00	2.50	2.79
property, plant and equipemtn, less accumulated dep of 8539, 8083	10,695.00	10,838.00	11.29	12.55
Trade marks with indefinite lives	10,172.00	9,266.00	10.74	10.73
bottlers franchise rights with indefinite lives	103.00	109.00	0.11	0.13
goodwill	16,617.00	16,764.00	17.55	19.41
other intangible assets	555.00	627.00	0.59	0.73
TOTAL ASSETS	94,689.00	86,381.00	100.00	100.00
CURRENT LIABILITIES
accounts payable and accured expenses	11,668.00	11,312.00	12.32	13.10
notes and loans payable	9,423.00	10,994.00	9.95	12.73
current maturities of long-term debt	5,181.00	4,253.00	5.47	4.92
accrued income taxes	576.00	414.00	0.61	0.48
TOTAL CURRENT LIABILITIES	26,848.00	26,973.00
long-term debt	37,729.00	27,516.00	39.85	31.85
other liabilities	8,954.00	8,510.00	9.46	9.85
deferred income tax liabilities, net	1,969.00	2,284.00	2.08	2.64
SHAREOWNERS EQUITY
common stock, $0.25 par value, authorised-11,200 shares, issued-7040 shares	1,760.00	1,760.00	1.86	2.04
capital surplus	17,367.00	17,154.00	18.34	19.86
reinvested earnings	66,888.00	65,855.00	70.64	76.24
accumulated other comprehensive income(loss)	(16,460.00)	(13,544.00)	(17.38)	(15.68)
treasury stock, at cost-2745 and 2760 shares	(52,071.00)	(52,244.00)	(54.99)	(60.48)
equity attributable to shareowners of the coca-cola company	17,484.00	18,981.00
equity attributable to non controllable interests	1,705.00	2,117.00	1.80	2.45
TOTAL EQUITY	19,189.00	21,098.00
TOTAL LIABILITIES AND EQUITY	94,689.00	86,381.00	100.00	100.00

Common Size Balance sheet displays items as a percentage of a common base figure, in this case it is the total assets. This type of financial statement allows for easy analysis between companies or between periods for the same company. All the assets and liabilites are converted into a percentage figure to the base figure i.e. total assets.

ekkarill92 answered 2 years ago

Balance Sheet at Dec 31, 2019 &nbs

Balance Sheet at Dec 31, 2019 Assets 2019 2018 Cash $12,000 $33,750 Accounts Receivables 65,250 58,500 Inventories 30,000 24,000 Long term investments (FV-NI) 23,250 40,500 Equipment 30,000 18,750 Accumulated Depreciation- equipment (5,625) (2,250) Building 67,500 56,250 Accumulated Depreciation- building (13,500) (9,000) Land 32,500 32,500 Total Assets $241,375 $253,000 Liabilities & Shareholder’s Equities Accounts Payable 30,000 24,750 Accrued Payables 2,375 1,125 Income tax payable 1,000 1,500 Long term note payable 26,000 31,000 Common Shares, issued & outstanding 150,000 150,000 Retained Earnings...

On Dec 31, 2016, Rawda Company had accounts receivable of $750,000 and allowance for doubtful accounts...

On Dec 31, 2016, Rawda Company had accounts receivable of $750,000 and allowance for doubtful accounts that had a debit balance of $10,000. The company uses an aging schedule (aging method) to estimate its uncollectible accounts as shown in the following table: # of Days Outstanding Amounts Estimated % Uncollectible 0-30 $ 200,000 2% 31-60 200,000 4% 61-90 200,000 6% Over 90 150,000 8% Requirements: What is the required balance for the allowance of doubtful accounts on Dec 31, 2016?...

Accounts receivable has a balance of $16,000 and the allowance for uncollectible accounts has a credit...

Accounts receivable has a balance of $16,000 and the allowance for uncollectible accounts has a credit balance of $1,600. What is net accounts receivable before and after a $60 account receivable is written off?

The March 31, 2019 balance sheet of Kalakaua Corporation had Accounts Receivable of $525,000 and a...

The March 31, 2019 balance sheet of Kalakaua Corporation had Accounts Receivable of $525,000 and a credit balance in Allowance for Doubtful Accounts of $33,000. During the year ended March 31, 2020, the following transactions occurred: sales on account $1,550,000; sales returns & allowances, $120,000; collections from customers, $1,350,000; accounts written off $41,000; previously written off accounts of $5,000 were collected. REQUIRED: 1.Using the above information, what is the balance of Accounts Receivable at March 31, 2020? 2.Suppose that it...

Fuller Corp. Balance Sheet at Dec 31, 2019 &nb

Fuller Corp. Balance Sheet at Dec 31, 2019 AAssets 2019 2018 CCash $12,000 $33,750 AAccounts Receivables 65,250 58,500 IIInventories 30,000 24,000 LLong term investments (FV-NI) 23,250 40,500 EEquipment 30,000 18,750 AAccumulated Depreciation- equipment (5,625) (2,250) BBuilding 67,500 56,250 AAccumulated Depreciation- building (13,500) (9,000) LLand 32,500 32,500 TTotal Assets $241,375 $253,000 LLiabilities & Shareholder’s Equities AAccounts Payable 30,000 24,750 AAccrued Payables 2,375 1,125 IIIncome tax payable 1,000 1,500 LLong term note payable 26,000 31,000 CCommon Shares, issued & outstanding 150,000 150,000...

2019 (Adjustment a) Dec. 31 Uncollectible Accounts Expense 4,290.00 Allowance for Doubtful Accounts 4,290.00 To record...

2019 (Adjustment a) Dec. 31 Uncollectible Accounts Expense 4,290.00 Allowance for Doubtful Accounts 4,290.00 To record estimated loss from Uncollectible accounts based on 0.6% of net credit sales, $715,000 (Adjustment b) 31 Supplies Expense 3,700.00 Supplies 3,700.00 To record supplies used during the year (Adjustment c) 31 Insurance Expense 1,050.00 Prepaid Insurance 1,050.00 To record expired insurance on 1-year $4,200 policy purchased on Oct. 1 (Adjustment d) 31 Depreciation. Exp.—Store Equipment 13,300.00 Accum. Depreciation—Store Equip. 13,300.00 To record depreciation (Adjustment...

Below is the comparative balance sheet for Sheffield Corporation. Dec. 31, 2020 Dec. 31, 2019 Cash...

Below is the comparative balance sheet for Sheffield Corporation. Dec. 31, 2020 Dec. 31, 2019 Cash $16,400 $21,100 Short-term investments 25,200 19,100 Accounts receivable 42,900 44,600 Allowance for doubtful accounts (1,800 ) (2,000 ) Prepaid expenses 4,200 2,500 Inventory 81,300 65,700 Land 49,600 49,600 Buildings 126,200 72,800 Accumulated depreciation—buildings (30,200 ) (23,300 ) Equipment 53,000 45,800 Accumulated depreciation—equipment (19,100 ) (15,600 ) Delivery equipment 39,200 39,200 Accumulated depreciation—delivery equipment (22,200 ) (20,700 ) Patents 14,900 –0– $379,600 $298,800 Accounts payable...

Below is the comparative balance sheet for Pina Corporation. Dec. 31, 2020 Dec. 31, 2019 Cash...

Below is the comparative balance sheet for Pina Corporation. Dec. 31, 2020 Dec. 31, 2019 Cash $16,700 $21,000 Short-term investments 24,900 19,100 Accounts receivable 42,500 45,000 Allowance for doubtful accounts (1,800 ) (2,100 ) Prepaid expenses 4,300 2,500 Inventory 81,800 65,500 Land 50,400 50,400 Buildings 124,200 73,600 Accumulated depreciation—buildings (29,900 ) (22,900 ) Equipment 52,700 45,700 Accumulated depreciation—equipment (18,900 ) (15,600 ) Delivery equipment 38,600 38,600 Accumulated depreciation—delivery equipment (21,900 ) (20,700 ) Patents 15,000 –0– $378,600 $300,100 Accounts payable...

Below is the comparative balance sheet for Larkspur Corporation. Dec. 31, 2020 Dec. 31, 2019 Cash...

Below is the comparative balance sheet for Larkspur Corporation. Dec. 31, 2020 Dec. 31, 2019 Cash $16,400 $21,100 Short-term investments 25,200 19,100 Accounts receivable 43,400 45,100 Allowance for doubtful accounts (1,900 ) (2,000 ) Prepaid expenses 4,300 2,400 Inventory 82,200 65,200 Land 50,100 50,100 Buildings 125,100 73,600 Accumulated depreciation—buildings (29,700 ) (23,000 ) Equipment 52,600 45,900 Accumulated depreciation—equipment (19,100 ) (15,300 ) Delivery equipment 39,400 39,400 Accumulated depreciation—delivery equipment (22,200 ) (20,700 ) Patents 14,900 –0– $380,700 $300,900 Accounts payable...

Mosaic’s Company balance sheet at December 31, 2018, reported the following: Accounts receivable...........................................$2,500,000 Allowance for uncollectible...

Mosaic’s Company balance sheet at December 31, 2018, reported the following: Accounts receivable...........................................$2,500,000 Allowance for uncollectible accounts...................$66,600 The following are the transactions to be taken into consideration for 2019: a. Total credit sales for 2019 were $3,600,000. b. 2% of sales were estimated to be uncollectible. c. The company received cash payments on account during 2019 for $1,000,000 d. Accounts receivable identified to be uncollectible totaled $94,000. e. December 31, 2019, aging of receivables indicates that $75,000 of the receivables...

Question