Home Help & Support Search Tips Options: Case:


Accounting | Business | Computer Science | General Studies | Math | Sciences | Civics Exam | Help/Support | Join/Cancel | Contact Us | Login/Log Out

   Need A Tutor?    |   Need Homework Help?                                                                             Help and Support     | Join or Cancel

Chapter Tests             01  02  03  04  05  06  07  08  09  10  11  12  13  14  15  16 17 18  19  20  21  22                 Unit Test 01  02  03  04  05  06        
Homework Chapter    01  02  03  04  05  06  07  08  09  10  11  12  13  14  15  16 17 18  19  20  21  22

Business Math Homework 16

Complete a horizontal analysis for Brown Company.
(Negative answers should be indicated by a minus sign. Leave no cells blank –
be certain to enter "0" wherever required. Round the "percent" answers to the nearest hundredth percent.)
 

 

 
Prepare a December 31, 2017 balance sheet for Wildland Fire Warriors from the following:
 
cash $40,700;
accounts payable $28,700;
merchandise inventory $14,700;
Jim Shanel, capital $47,400;
and equipment, $20,700.
 

 

 
Prepare an income statement for Hansen Realty for the year ended December 31, 2017.
Beginning inventory was $1,252. Ending inventory was $1,604.
(Input all amounts as positive values.)
 
 
Sales $ 35,300
Sales returns and allowances   1,096
Sales discount   1,156
Purchases   10,712
Purchase discounts   544
Depreciation expense   119
Salary expense   5,400
Insurance expense   2,800
Utilities expense   214
Plumbing expense   254
Rent expense   184

 

 
 
LOGIC COMPANY
Comparative Income Statement
For Years Ended December 31, 2016 and 2017
  2017 2016
Gross sales $ 23,000 $ 18,000
Sales returns and allowances   800   100
Net sales $ 22,200 $ 17,900
Cost of merchandise (goods) sold   11,000   7,600
Gross profit $ 11,200 $ 10,300
Operating expenses:        
Depreciation $ 1,100 $ 800
Selling and administrative   5,200   4,000
Research   950   700
Miscellaneous   760   500
Total operating expenses $ 8,010 $ 6,000
Income before interest and taxes $ 3,190 $ 4,300
Interest expense   960   700
Income before taxes $ 2,230 $ 3,600
Provision for taxes   892   1,440
Net income $ 1,338 $ 2,160

 
LOGIC COMPANY
Comparative Balance Sheet
December 31, 2016 and 2017
  2017 2016
Assets        
Current assets:        
Cash $ 11,500 $ 8,500
Accounts receivable   16,000   12,000
Merchandise inventory   8,000   13,500
Prepaid expenses   23,500   9,500
Total current assets $ 59,000 $ 43,500
Plant and equipment:        
Building (net) $ 14,000 $ 10,500
Land   13,000   8,500
Total plant and equipment $ 27,000 $ 19,000
Total assets $ 86,000 $ 62,500
Liabilities        
Current liabilities:        
Accounts payable $ 12,500 $ 6,500
Salaries payable   6,500   4,500
Total current liabilities $ 19,000 $ 11,000
Long-term liabilities:        
Mortgage note payable   21,500   20,000
Total liabilities $ 40,500 $ 31,000
Stockholders’ Equity        
Common stock $ 20,500 $ 20,500
Retained earnings   25,000   11,000
Total stockholders’ equity $ 45,500 $ 31,500
Total liabilities and stockholders’ equity $ 86,000 $ 62,500

 
Calculate net income (after tax) to net sales.
(Enter your answer as a percentage rounded to 2 decimal places.)
 

 
 
LOGIC COMPANY
Comparative Income Statement
For Years Ended December 31, 2016 and 2017
  2017 2016
Gross sales $ 19,400 $ 15,300
Sales returns and allowances   800   100
Net sales $ 18,600 $ 15,200
Cost of merchandise (goods) sold   11,900   8,900
Gross profit $ 6,700 $ 6,300
Operating expenses:        
Depreciation $ 740 $ 620
Selling and administrative   2,500   2,200
Research   590   520
Miscellaneous   400   320
Total operating expenses $ 4,230 $ 3,660
Income before interest and taxes $ 2,470 $ 2,640
Interest expense   600   520
Income before taxes $ 1,870 $ 2,120
Provision for taxes   748   848
Net income $ 1,122 $ 1,272

 
LOGIC COMPANY
Comparative Balance Sheet
December 31, 2016 and 2017
  2017 2016
Assets        
Current assets:        
Cash $ 12,100 $ 9,300
Accounts receivable   16,700   12,700
Merchandise inventory   8,700   14,200
Prepaid expenses   24,200   10,200
Total current assets $ 61,700 $ 46,400
Plant and equipment:        
Building (net) $ 14,600 $ 11,200
Land   13,700   9,200
Total plant and equipment $ 28,300 $ 20,400
Total assets $ 90,000 $ 66,800
Liabilities        
Current liabilities:        
Accounts payable $ 13,200 $ 7,200
Salaries payable   7,200   5,200
Total current liabilities $ 20,400 $ 12,400
Long-term liabilities:        
Mortgage note payable   22,400   20,700
Total liabilities $ 42,800 $ 33,100
Stockholders’ Equity        
Common stock $ 21,100 $ 21,100
Retained earnings   26,100   12,600
Total stockholders’ equity $ 47,200 $ 33,700
Total liabilities and stockholders’ equity $ 90,000 $ 66,800

 
Calculate the total debt to total assets ratio.
(Enter your response as a decimal rounded to 2 places.)
 

                                                                                                  
 
Chapter Tests             01  02  03  04  05  06  07  08  09  10  11  12  13  14  15  16 17 18  19  20  21  22                 Unit Test 01  02  03  04  05  06        
Homework Chapter    01  02  03  04  05  06  07  08  09  10  11  12  13  14  15  16 17 18  19  20  21  22                 Need A Tutor?     Need Homework Help?

 
LOGIC COMPANY
Comparative Income Statement
For Years Ended December 31, 2016 and 2017
  2017 2016
Gross sales $ 22,600 $ 17,700
Sales returns and allowances   1,000   100
Net sales $ 21,600 $ 17,600
Cost of merchandise (goods) sold   11,100   7,800
Gross profit $ 10,500 $ 9,800
Operating expenses:        
Depreciation $ 1,060 $ 780
Selling and administrative   4,900   3,800
Research   910   680
Miscellaneous   720   480
Total operating expenses $ 7,590 $ 5,740
Income before interest and taxes $ 2,910 $ 4,060
Interest expense   920   680
Income before taxes $ 1,990 $ 3,380
Provision for taxes   796   1,352
Net income $ 1,194 $ 2,028

 
LOGIC COMPANY
Comparative Balance Sheet
December 31, 2016 and 2017
  2017 2016
Assets        
Current assets:        
Cash $ 11,700 $ 8,900
Accounts receivable   16,200   12,200
Merchandise inventory   8,200   13,700
Prepaid expenses   23,700   9,700
Total current assets $ 59,800 $ 44,500
Plant and equipment:        
Building (net) $ 14,200 $ 10,700
Land   13,200   8,700
Total plant and equipment $ 27,400 $ 19,400
Total assets $ 87,200 $ 63,900
Liabilities        
Current liabilities:        
Accounts payable $ 12,700 $ 7,000
Salaries payable   6,800   4,700
Total current liabilities $ 19,500 $ 11,700
Long-term liabilities:        
Mortgage note payable   21,700   20,200
Total liabilities $ 41,200 $ 31,900
Stockholders’ Equity        
Common stock $ 20,700 $ 20,800
Retained earnings   25,300   11,200
Total stockholders’ equity $ 46,000 $ 32,000
Total liabilities and stockholders’ equity $ 87,200 $ 63,900


Calculate the acid test ratio. (Round your answers to the nearest hundredth.)
 

 
 
LOGIC COMPANY
Comparative Income Statement
For Years Ended December 31, 2016 and 2017
  2017 2016
Gross sales $ 22,000 $ 17,250
Sales returns and allowances   1,000   100
Net sales $ 21,000 $ 17,150
Cost of merchandise (goods) sold   11,250   8,250
Gross profit $ 9,750 $ 8,900
Operating expenses:        
Depreciation $ 1,000 $ 750
Selling and administrative   4,450   3,500
Research   850   650
Miscellaneous   660   450
Total operating expenses $ 6,960 $ 5,350
Income before interest and taxes $ 2,790 $ 3,550
Interest expense   860   650
Income before taxes $ 1,930 $ 2,900
Provision for taxes   772   1,160
Net income $ 1,158 $ 1,740

 
LOGIC COMPANY
Comparative Balance Sheet
December 31, 2016 and 2017
  2017 2016
Assets        
Current assets:        
Cash $ 13,500 $ 10,500
Accounts receivable   18,000   14,000
Merchandise inventory   10,000   15,500
Prepaid expenses   25,500   11,500
Total current assets $ 67,000 $ 51,500
Plant and equipment:        
Building (net) $ 15,900 $ 12,500
Land   15,000   10,500
Total plant and equipment $ 30,900 $ 23,000
Total assets $ 97,900 $ 74,500
Liabilities        
Current liabilities:        
Accounts payable $ 14,500 $ 8,500
Salaries payable   8,500   6,500
Total current liabilities $ 23,000 $ 15,000
Long-term liabilities:        
Mortgage note payable   23,600   22,000
Total liabilities $ 46,600 $ 37,000
Stockholders’ Equity        
Common stock $ 22,500 $ 22,600
Retained earnings   28,800   14,900
Total stockholders’ equity $ 51,300 $ 37,500
Total liabilities and stockholders’ equity $ 97,900 $ 74,500

 
Calculate the current ratio. (Round your answers to the nearest hundredth.)
 

 
General Motors announced a quarterly profit of $119 million for 4th quarter 2014. Below is a portion of its balance sheet.
Conduct a horizontal analysis of the following line items.
(Negative answers should be indicated by a minus sign. Round the"percent"
answers to the nearest hundredth percent.)
 
A screenshot of a computer screen

Description automatically generated with low confidence
 

 
Assume figures were presented for the past 5 years on merchandise sold at Chicago department and discount stores ($ million).
Sales in 2016 were $3,094; in 2015, $3,354; in 2014, $2,848; in 2013, $3,092; and in 2012, $3,156. Using 2012 as the base year,
complete a trend analysis. (Round your answers to the nearest whole percent.)

 
Don Williams received a memo requesting that he complete a trend analysis of the following numbers using 2013 as the base year.
 
  2016 2015 2014 2013
Sales $ 380,000   $ 440,000   $ 460,000   $ 540,000  
Gross profit   220,000     280,000     380,000     440,000  
Net income   74,000     94,000     44,000     54,000  

 

Could you help Don with the request?
(Round your answers to the nearest whole percent.)
 

 

 
Calculate the current ratio and the quick ratio for the following partial financial statement for Tootsie Roll.
(Round your answers to the nearest hundredth.)

 

Assets

Liabilities

Current assets:

 

 

 

Current liabilities:    

 

Cash and cash equivalents (Note 1)

$

4,204,190

 

Notes payable to banks $ 692,221

 

Investments (Note 1)

 

32,513,769

 

Accounts payable   7,024,075

 

Accounts receivable, less allowances of
$746,000 and $742,000

 

16,186,648

 

Dividends payable   596,607

 

Inventories (Note 1):

 

 

 

Accrued liabilities (Note 5)   9,846,534

 

Finished goods and work in progress

 

12,630,955

 

Income taxes payable   4,491,429

 

Raw materials and supplies

 

10,255,858

 

 

 

 

 

Prepaid expenses

 

2,017,710

 

 

 

 

 


 

A screenshot of a computer

Description automatically generated with medium confidence

Chapter Tests             01  02  03  04  05  06  07  08  09  10  11  12  13  14  15  16 17 18  19  20  21  22                 Unit Test 01  02  03  04  05  06        
Homework Chapter    01  02  03  04  05  06  07  08  09  10  11  12  13  14  15  16 17 18  19  20  21  22


Home
Accounting & Finance Business
Computer Science General Studies Math Sciences
Civics Exam
Everything Else
Help & Support
Join/Cancel
Contact Us
 Login / Log Out