Question

In: Accounting

Vockery Market Co. Balance Sheet 2018 2017 Cash          20,000          24,000 ST Investments          18,000.

Vockery Market Co.
Balance Sheet
2018 2017
Cash          20,000          24,000
ST Investments          18,000          26,000
Net Accounts Receivable          50,000          78,000
Inventory          70,000          66,000
Prepaid Expenses          12,000          10,000
Total Current Assets        170,000        204,000
PP&E        105,000          85,000
Total Assets        275,000        289,000
Prepare a horizontal and vertical analysis of Total Assets

Solutions

Expert Solution

HORIZONTAL ANALYSIS
2018 2017 Net Increase/(Decrease) % Increasse/(Decrease)
Cash 20000 24000 -4000 -16.67%
ST investment 18000 26000 -8000 -30.77%
Net Accounts recivable 50000 78000 -28000 -35.90%
Inventory 70000 66000 4000 6.06%
Prepaid expense 12000 10,000 2000 20%
Total current Assets 170000 204000 -34000 -16.67%
PP &E 105000 85000 20000 23.53%
Total Assets 275000 289000 -48000 16.61%
VERTICAL ANALYSIS
2018 % OF TOTAL ASSETS 2017 % OF TOTAL ASSETS
Cash 20000 7.27% 24000 8.30%
ST investment 18000 6.55% 26000 9.00%
Net Accounts recivable 50000 18.18% 78000 26.99%
Inventory 70000 25.45% 66000 22.84%
Prepaid expense 12000 4.36% 10,000 3.46%
Total current Assets 170000 61.82% 204000 70.59%
PP &E 105000 38.18% 85000 29.41%
Total Assets 275000 100% 289000 100%

Related Solutions

Based on a number of contracts in 2017 and 2018, Brangus recognized $18,000 and $20,000 of...
Based on a number of contracts in 2017 and 2018, Brangus recognized $18,000 and $20,000 of book income in 2017 and 2018 for book purposes and $12,000 and $22.000 on those same contracts in 2017 and 2018 for tax purposes. If the net income before tax in 2018 was $50,000 and the tax rate is 36% in 2017, 34% in 2018 and 32% in 2019, prepare the journal entry for income taxes for 2018.
The Murdock Corporation reported the following balance sheet data for 2018 and 2017: 2018 2017 Cash...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017: 2018 2017 Cash $77,375 $22,955 Available-for-sale debt securities (not cash equivalents) 15,500 85,000 Accounts receivable 80,000 68,250 Inventory 165,000 145,000 Prepaid insurance 1,500 2,000 Land, buildings, and equipment 1,250,000 1,125,000 Accumulated depreciation (610,000) (572,000) Total assets $979,375 $876,205 Accounts payable $76,340 $148,670 Salaries payable 20,000 24,500 Notes payable (current) 25,000 75,000 Bonds payable 200,000 0 Common stock 300,000 300,000 Retained earnings 358,035 328,035 Total liabilities and shareholders'...
Calloway Company reported the following balance sheet data for 2018 and 2017: 2018 2017 Cash $77,375...
Calloway Company reported the following balance sheet data for 2018 and 2017: 2018 2017 Cash $77,375 $22,955 Available-for-sale debt securities (not cash equivalents) 15,500 85,000 Accounts receivable 80,000 68,250 Inventory 165,000 145,000 Prepaid insurance 1,500 2,000 Land, buildings, and equipment 1,250,000 1,125,000 Accumulated depreciation (610,000) (572,000) Total assets $979,375 $876,205 Accounts payable $76,340 $148,670 Salaries payable 20,000 24,500 Notes payable (current) 25,000 75,000 Bonds payable 200,000 0 Common stock 300,000 300,000 Retained earnings 358,035 328,035 Total liabilities and shareholders' equity...
The Centurion, Inc had the following balance sheet as of 12/31/01 Cash $20,000 A/R $21,200 Investments...
The Centurion, Inc had the following balance sheet as of 12/31/01 Cash $20,000 A/R $21,200 Investments $32,000 Plant assets (net) $81,000 Land $40,000 A/P - $30,000 Bonds Payable - $41,000 Common Stock $100,000 Retained Earnings $23,200 During the year 2002, the following occurred Centurion liquidates its available-for-sale debt investment portfolio at a loss of $5,000 A tract of land was purchase for $38,000 AN additional $30,000 in common stock was issue at par. Dividends totaling $10,000 were declared and paid...
Use the following information for the next four questions: 2017 2018 Beginning Cash Balance 20,000 50,000...
Use the following information for the next four questions: 2017 2018 Beginning Cash Balance 20,000 50,000 Net Income                 65,000.00                 75,000.00 Accounts Receivable                 10,000.00                    6,000.00 Prepaid Insurance                    5,000.00                    3,500.00 Inventory                 20,000.00                 24,000.00 Accounts Payable                    3,000.00                    2,000.00 Unearned Revenue                    5,000.00                    7,000.00 Depreciation Expense                 25,000.00                 20,000.00 Cash Paid for Dividends                 25,000.00                    5,000.00 Cash Payment to Repay Note Payable                               -                    10,000.00 Cash Payment to Purchase Land...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017:    2018 2017...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017:    2018 2017 Cash $ 96,245 $ 33,155 Available-for-sale debt securities (not cash equivalents) 24,000 102,000 Accounts receivable 97,000 83,550 Inventory 182,000 160,300 Prepaid insurance 3,030 3,700 Land, buildings, and equipment 1,284,000 1,142,000 Accumulated depreciation (627,000 ) (589,000 ) Total assets $ 1,059,275 $ 935,705 Accounts payable $ 91,640 $ 165,670 Salaries payable 26,800 33,000 Notes payable (current) 40,300 92,000 Bonds payable 217,000 0 Common stock 300,000...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017: ​ 2018 2017...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017: ​ 2018 2017 Cash $77,375 $22,955 Available-for-sale debt securities ​ ​ (not cash equivalents) 15,500 85,000 Accounts receivable 80,000 68,250 Inventory 165,000 145,000 Prepaid insurance 1,500 2,000 Land, buildings, and equipment 1,250,000 1,125,000 Accumulated depreciation (610,000) (572,000) Total assets $979,375 $876,205 Accounts payable $76,340 $148,670 Salaries payable 20,000 24,500 Notes payable (current) 25,000 75,000 Bonds payable 200,000 0 Common stock 300,000 300,000 Retained earnings 358,035 328,035 Total...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017:    2018 2017...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017:    2018 2017 Cash $ 82,925 $ 25,955 Available-for-sale debt securities (not cash equivalents) 18,000 90,000 Accounts receivable 85,000 72,750 Inventory 170,000 149,500 Prepaid insurance 1,950 2,500 Land, buildings, and equipment 1,260,000 1,130,000 Accumulated depreciation (615,000 ) (577,000 ) Total assets $ 1,002,875 $ 893,705 Accounts payable $ 80,840 $ 153,670 Salaries payable 22,000 27,000 Notes payable (current) 29,500 80,000 Bonds payable 205,000 0 Common stock 300,000...
XYZ Co.’s summary balance sheets for 2017 and 2018 are below: XYZ Co. Balance Sheets 2017...
XYZ Co.’s summary balance sheets for 2017 and 2018 are below: XYZ Co. Balance Sheets 2017 2018 Cash 400,000 300,000 Accounts receivable 800,000 _________ (b) Net fixed assets 1,600,000 2,300,000 TOTAL ASSETS _________ _________ Accounts payable 250,000 300,000 Short-term debt 350,000 400,000 Long-term debt 800,000 800,000 Shareholders’ equity _________ (a) 1,500,000 TOTAL LIABIL. & SHAREHOLDER’S EQUITY _________ _________ Calculate the following: a) Shareholders’ equity in 2017 b) Accounts receivable in 2018 c) If XYZ Co. has a company policy to...
Balance Sheet As at Dec 31 2017 and 2018 Carl’s Jr Restaurants 2017               2018 Current...
Balance Sheet As at Dec 31 2017 and 2018 Carl’s Jr Restaurants 2017               2018 Current Assets: Cash $210,000,000        $215,000,000 Accounts Receivables                     355,000,000         310,000,000 Inventory                                       507,000,000       328,000,000 Total Current Assets                      $1,072,000,000       $853,000,000 Long-Term Assets: Net Equipment, Furniture, Fixtures       $6,085,000,000     $6,527,000,000 Total Assets                                      $7,157,000,000     $7,380,000,000 Current Liabilities: Accounts Payable                           $207,000,000        $298,000,000 Notes Payable                              $1,715,000,000     $1,427,000,000 Total Current Liabilities                       $1,922,000,000      $1,725,000,000 Long-term Liabilities                           $1,987,000,000      $2,308,000,000 Owners’ Equity: Common stock plus Capital Surplus   $1,000,000,000      $1,000,000,000 Retained Earnings                                 2,248,000,000       ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT