Question

In: Accounting

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

Solutions

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.

Related Solutions

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...
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...
Monique’s Trading Company balance sheet at December 31, 2016, reported the following: Accounts receivable...........................................$1,000,000 Allowance for...
Monique’s Trading Company balance sheet at December 31, 2016, reported the following: Accounts receivable...........................................$1,000,000 Allowance for uncollectible accounts...................$33,330 The following are the transactions to be taken into consideration for 2017: a.    Total credit sales for 2017 were $2,400,000. b.    2% of sales were estimated to be uncollectible. c.    The company received cash payments on account during 2017 for $900,000 d.   Accounts receivable identified to be uncollectible totaled $64,000. e.   December 31, 2017, aging of receivables indicates that $72,000 of the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT