Question: please see attached document. It has questions 1-7 that I need help answering. thank you 1. For the just completed year, Hanna Company had net
please see attached document. It has questions 1-7 that I need help answering. thank you

1. For the just completed year, Hanna Company had net income of $42,000. Balances in the company's current asset and current liability accounts at the beginning and end of the year were as follows: December 31 Beginning of End of Year Year Current assets: Cash Accounts receivable Inventory Prepaid expenses Current liabilities: Accounts payable Accrued liabilities Income taxes payable $ 57,000 $ 158,000 $ 430,000 $ 12,500 $ 78,000 $ 194,000 $ 370,000 $ 14,500 $ 354,000 $ 8,500 $ 35,000 $ 386,000 $ 12,500 $ 28,000 The Accumulated Depreciation account had total credits of $54,000 during the year. Hanna Company did not record any gains or losses during the year. Required: Using the indirect method, determine the net cash provided by operating activities for the year. (List any deduction in cash and cash outflows as negative amounts.) 2. The following changes took place last year in Pavolik Company's balance sheet accounts: Asset and Contra-Asset Accounts Cash $ 35 D Accounts receivable $ 39 I Inventory $ 88 D Prepaid expenses $ 34 I Long-term investments $ 36 D Property, plant, and equipment $ 620 I Accumulated depreciation $ 127 I Liabilities and Equity Accounts Accounts payable $ 107 Accrued liabilities $ 39 Income taxes payable $ 44 Bonds payable $ 324 Common stock $ 156 Retained earnings $ 127 I D I I D I D = Decrease; I = Increase. Long-term investments that had cost the company $36 were sold during the year for $76, and land that had cost $75 was sold for $39. In addition, the company declared and paid $33 in cash dividends during the year. Besides the sale of land, no other sales or retirements of plant and equipment took place during the year. Pavolik did not retire any bonds during the year or issue any new common stock. The company's income statement for the year follows: Sales Cost of goods sold $ 656 Gross margin Selling and administrat ive expenses Net operating income Nonopera ting items: Loss o n sale of land Gain on sale of investment 814 570 244 $ (36) 40 4 Income before taxes Income taxes Net income 1,470 248 88 $ 160 The company's beginning cash balance was $158 and its ending balance was $123. Required: 1. Using the indirect method, determine the net cash provided by / used in operating activities for the year. (List any deduction in cash and cash outflows as negative amounts.) 2. Prepare a statement of cash flows for the year. (List any deduction in cash and cash outflows as negative amounts.) 3. Comparative financial statements for Weller Corporation, a merchandising company, for the fiscal year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 600,000 shares of common stock were outstanding. The interest rate on the bonds, which were sold at their face value, was 10%. The income tax rate was 40%, and the dividend per share of common stock was $0.75. The market value of the company's common stock at the end of the year was $27. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Assets Current assets: Cash Accou nts receivabl e, net Invent ory Prepai d expenses $ 1,170 Last Year $ 1,240 9,200 8,400 13,200 10,700 650 580 Total current assets 24,220 20,920 Property and equipmen t: Land Buildi ngs and equipmen t, net 10,400 10,400 40,854 37,242 51,254 47,642 Total property and equipmen t Total assets $ 75,474 $ 68,562 Liabiliti es and Stockhol ders' Equity Current liabilities: Accou nts payable Accru ed liabilities Notes payable, short term $ 19,000 $ 17,900 Total current liabilities Longterm liabilities: Bonds payable Total liabilities Stockhol ders' equity: Comm on stock Additi onal paidin capital Total paid-in capital Retai ned earnings Total stockhold 1,010 790 260 260 20,270 18,950 9,300 9,300 29,570 28,250 600 600 4,000 4,000 4,600 4,600 41,304 35,712 45,904 40,312 ers' equity Total liabilities and stockhold ers' equity Sales Cost of goods sold Gross margin Selling and administra tive expenses: Selling expenses Administ rative expenses Total selling and administra tive expenses Net operating income Interest expense Net income before taxes Income taxes $ 75,474 $ 68,562 Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) This Year Last Year $ 70,000 $ 65,000 41,000 40,000 29,000 25,000 10,700 10,000 7,300 6,200 18,000 16,200 11,000 8,800 930 930 10,070 7,870 4,028 3,148 Net income Dividend s to common stockholde rs Net income added to retained earnings Beginnin g retained earnings Ending retained earnings $ 6,042 4,722 450 450 5,592 4,272 35,712 31,440 41,304 $ 35,712 Required: Compute the following financial data and ratios for this year: Working capital Current ratio Acid -test ratio 4. Comparative financial statements for Weller Corporation, a merchandising company, for the fiscal year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 600,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.50. The market value of the company's common stock at the end of the year was $21. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Assets Current assets: Cash Accou nts receivabl e, net $ 1,120 9,700 Last Year $ 1,290 7,800 Invent ory Prepai d expenses 13,000 12,200 650 560 Total current assets 24,470 21,850 Property and equipmen t: Land Buildi ngs and equipmen t, net 10,100 10,100 43,148 38,760 Total property and equipmen t 53,248 48,860 Total assets $ 77,718 $ 70,710 Liabiliti es and Stockhol ders' Equity Current liabilities: Accou nts payable Accru ed liabilities Notes payable, short term $ 18,900 $ 17,900 Total current liabilities Longterm liabilities: 960 850 260 260 20,120 19,010 Bonds payable 8,000 8,000 Total liabilities 28,120 27,010 600 600 4,000 4,000 4,600 4,600 44,998 39,100 49,598 43,700 Stockhol ders' equity: Comm on stock Additi onal paidin capital Total paid-in capital Retai ned earnings Total stockhold ers' equity Total liabilities and stockhold ers' equity Sales Cost of goods sold Gross margin Selling and administra tive expenses: $ 77,718 $ 70,710 Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) This Year Last Year $ 75,250 $ 66,000 46,620 35,000 28,630 31,000 Selling expenses Administ rative expenses Total selling and administra tive expenses Net operating income Interest expense Net income before taxes Income taxes Net income Dividend s to common stockholde rs Net income added to retained earnings Beginnin g retained earnings Ending retained earnings $ 10,800 10,400 6,700 6,200 17,500 16,600 11,130 14,400 800 800 10,330 13,600 4,132 5,440 6,198 8,160 300 300 5,898 7,860 39,100 31,240 44,998 Required: Compute the following financial data for this year: $ 39,100 1. Accounts receivable turnover. (Assume that all sales are on account.) (Round your answer to 2 decimal places.) Accounts receivable turnover Average collection period Inventory turnover Average sale period Operating cycle Total Asset turnover 5. Comparative financial statements for Weller Corporation, a merchandising company, for the fiscal year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 700,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $.75. The market value of the company's common stock at the end of the year was $26. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Assets Current assets: Cash Accou nts receivabl e, net Invent ory Prepai d expenses Total current assets Property and equipmen t: Land $ 1,160 Last Year $ 1,390 9,600 8,000 13,100 12,000 640 690 24,500 22,080 10,900 10,900 Buildi ngs and equipmen t, net 42,532 39,771 Total property and equipmen t 53,432 50,671 Total assets $ 77,932 $ 72,751 Liabiliti es and Stockhol ders' Equity Current liabilities: Accou nts payable Accru ed liabilities Notes payable, short term $ 20,000 $ 19,300 970 880 0 190 20,970 20,370 8,900 8,900 Total liabilities 29,870 29,270 Stockhol ders' equity: Comm on stock Additi onal paidin capital 2,000 2,000 4,000 4,000 Total current liabilities Longterm liabilities: Bonds payable Total paid-in capital Retai ned earnings Total stockhold ers' equity Total liabilities and stockhold ers' equity Sales Cost of goods sold $ 6,000 6,000 42,062 37,481 48,062 43,481 77,932 $ 72,751 Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) This Year Last Year $ 69,000 $ 64,000 41,000 35,000 28,000 29,000 11,500 10,000 7,100 7,000 Total selling and administra tive expenses 18,600 17,000 Net operating income 9,400 12,000 Gross margin Selling and administra tive expenses: Selling expenses Administ rative expenses Interest expense Net income before taxes Income taxes Net income Dividend s to common stockholde rs Net income added to retained earnings Beginnin g retained earnings Ending retained earnings $ 890 890 8,510 11,110 3,404 4,444 5,106 6,666 525 525 4,581 6,141 37,481 31,340 42,062 $ 37,481 Required: Compute the following financial ratios for this year: Times interest ratio Debt-to-equity ratio Equity multiplier 6. Comparative financial statements for Weller Corporation, a merchandising company, for the fiscal year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 810,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.40. The market value of the company's common stock at the end of the year was $18.50. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Assets Current assets: Cash Accou nts receivabl e, net Invent ory Prepai d expenses $ Total current assets Property and equipmen t: Land Buildi ngs and equipmen t, net Total property and equipmen t Total assets Liabiliti es and Stockhol ders' Equity Current liabilities: Accou 2,546 Last Year $ 2,770 12,400 9,150 9,750 8,240 1,810 2,120 26,506 22,280 6,100 6,100 19,300 19,100 25,400 25,200 $ 51,906 $ 47,480 $ 9,600 $ 8,350 nts payable Accru ed liabilities Notes payable, short term Total current liabilities Longterm liabilities: Bonds payable Total liabilities Stockhol ders' equity: Comm on stock Additi onal paidin capital Total paid-in capital Retai ned earnings Total stockhold ers' equity Total liabilities and stockhold ers' equity $ 620 750 310 310 10,530 9,410 6,250 6,250 16,780 15,660 810 810 4,250 4,250 5,060 5,060 30,066 26,760 35,126 31,820 51,906 $ 47,480 Sales Cost of goods sold Gross margin Selling and administrati ve expenses: Selling expenses Administr ative expenses Total selling and administrati ve expenses Net operating income Interest expense Net income before taxes Income taxes Net income Dividends to common stockholder s Net income added to retained earnings Beginning Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) This Year Last Year $ 80,000 $ 75,000 52,500 48,500 27,500 26,500 8,600 8,100 12,100 11,100 20,700 19,200 6,800 7,300 750 750 6,050 6,550 2,420 2,620 3,630 3,930 324 324 3,306 3,606 26,760 23,154 retained earnings Ending retained earnings $ 30,066 $ 26,760 Required: Compute the following financial data for this year: Gross margin percentage Net profit margin percentage Return on total assets Return on equity 7. Comparative financial statements for Weller Corporation, a merchandising company, for the fiscal year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 980,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.40. The market value of the company's common stock at the end of the year was $27.00. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Assets Current assets: Cash Accou nts receivabl e, net Invent ory Prepai d expenses Total current $ 4,568 Last Year $ 5,440 16,200 9,150 10,600 8,920 1,980 2,460 33,348 25,970 assets Property and equipmen t: Land Buildi ngs and equipmen t, net Total property and equipmen t 7,800 7,800 21,000 20,800 28,800 28,600 Total assets $ 62,148 $ 54,570 Liabiliti es and Stockhol ders' Equity Current liabilities: Accou nts payable Accru ed liabilities Notes payable, short term $ 11,300 $ 9,200 Total current liabilities Longterm liabilities: Bonds payable Total liabilities Stockhol ders' 960 1,600 480 480 12,740 11,280 8,750 8,750 21,490 20,030 equity: Comm on stock Additi onal paidin capital Total paid-in capital Retai ned earnings Total stockhold ers' equity Total liabilities and stockhold ers' equity Sales Cost of goods sold Gross margin Selling and administrati ve expenses: Selling expenses Administr ative expenses $ 980 980 5,100 5,100 6,080 6,080 34,578 28,460 40,658 34,540 62,148 $ 54,570 Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) This Year Last Year $ 97,000 $ 92,000 61,000 57,000 36,000 35,000 10,300 9,800 13,800 12,800 Total selling and administrati ve expenses Net operating income Interest expense Net income before taxes Income taxes Net income Dividends to common stockholder s Net income added to retained earnings Beginning retained earnings Ending retained earnings $ 24,100 22,600 11,900 12,400 1,050 1,050 10,850 11,350 4,340 4,540 6,510 6,810 392 392 6,118 6,418 28,460 22,042 34,578 Required: Compute the following financial data for this year: Earnings per share Price-earnings ratio Dividend payout ratio $ 28,460 Dividend yield ratio Book value per share
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
