please help me A comparative balance sheet for Shabbona Corporation is presented below.AssetsCashAccounts receivableInventoryLandEquipmentAccumulated Depreciation-EquipmentTotalLiabilities and Stockholders' EquityAccounts payableBonds payableCommon stock ($1 par)Retained earnings:TotalDecember 312014$ 72,34984,589182,58973,589257,411(71,589)$598,938$36,589150,000214,000198,349$598,938.2013$ 22,00069,240192,240113,240196,760(45,240)$548,240$ 50,240200,000164,000134,000$548,240Additional information:1. Net income for 2014 was $130,178.2. Cash dividends of $65,829 were declared and paid.3. Bonds payable amounting to $50,000 were retired through issuance of common stock.4. Scrapped fully depreciated equipment that originally cost $5,000 for $250 cash.Required (use EXCEL for each step below):1. Input the comparative balance sheet into an EXCEL spreadsheet.2. Add a column that calculates the change in each account from 2013 to 2014.3. Prepare a statement of cash flows using the indirect method. Show how you reconcile each change inthe balance sheet accounts to amounts appearing in the statement of cash flows.

Cash flow statement shows the cash inflow and cash outflow of the company. It involves the cash flow…

Answered: A comparative balance sheet for…

Business

Accounting

A comparative balance sheet for Shabbona Corporation is presented below.

Century 21 Accounting General Journal

11th Edition

ISBN:9781337680059

Author:Gilbertson

Publisher:Gilbertson

Chapter17: Financial Statement Analysis

Section17.4: Analyzing Financial Statements Using Financial Ratios

Problem 1WT

See similar textbooks

Similar questions

Which of the following measures the portion of a corporations profit allocated to each outstanding share of common stock? A. retained earnings B. EPS C. EBITDA D. NOPAT
The income statement, statement of retained earnings, and balance sheet for Somerville Company are as follows: Includes both state and federal taxes. Refer to the information for Somerville Company on the previous pages. Required: Note: Round answers to two decimal places. 1. Compute the number of common shares. 2. Compute earnings per share.
The income statement, statement of retained earnings, and balance sheet for Santiago Systems are as follows: Includes both state and federal taxes. Refer to the information for Santiago Systems above. Required: Note: Round answers to four decimal places. 1. Calculate the average common stockholders equity. 2. Calculate the return on stockholders equity.
Define each of the following terms: Annual report; balance sheet; income statement Common stockholders’ equity, or net worth; retained earnings Statement of stockholders’ equity; statement of cash flows Depreciation; amortization; EBITDA Operating current assets; operating current liabilities; net operating working capital; total net operating capital Accounting profit; net cash flow; NOPAT; free cash flow; return on invested capital Market Value Added; Economic Value Added Progressive tax; taxable income; marginal and average tax rates Capital gain or loss; tax loss carryforward Improper accumulation; S corporation
Stockholder Profitability Ratios The following information pertains to Montague Corporation Required: Calculate the return on common equity and the earnings per share. (Note: Round answers to two decimal places.)
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) (a)Current ratioenter the ratio rounded to 2 decimal places (b)Acid-test ratioenter the ratio rounded to 2 decimal places…
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83)
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) (a)Current ratioenter the ratio rounded to 2 decimal places
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) Inventory turnoverenter the number rounded to 2 decimal places Days in inventoryenter the number of days rounded to 0 decimal…
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) Asset turnoverenter the number rounded to 2 decimal places (g)Return on assetsenter percentages rounded to 0 decimal places…
A comparative balance sheet for Halpern Corporation is presented below: Assets Accumulated depreciation Total assets Liabilities and Stockholder's Equity Accounts payable Bonds payable Common stock Retained earnings (20,000 $199,000 $11,000 27,000 140,000 21,000 ) HALPERN CORPORATION Comparative Balance Sheet 2020 2019 $31,000 60,000 17,000 40,000 60,000 (13,000 ) $195,000 $6,000 19,000 115,000 55,000 Cash $36,000 Accounts receivable (net) 70,000 Prepaid insurance 25,000 Land 18,000 Equipment 70,000 Total liabilities and stockholders' equity $199,000 $195,000 Additional information: Net loss for 2020 is $20,000. Cash dividends of $14,000 were declared and paid in 2020. Land was sold for cash at a loss of $4,000. This was the only land transaction during the year. Equipment with a cost of $15,000 and accumulated depreciation of $10,000 was sold for $5,000 cash. $22,000 of bonds were retired during the year at carrying (book) value. Equipment was…
The statement of financial position of Trend, Inc. is presented below. These are the only accounts in Trend's statement of financial position. Amounts indicated by question mark (?) can be calculated from the additional information given Cash Accounts rereivahle(net) Inventory Property. Dant and equipment (net ota LIabilitieS and Stockholders Equity Accounts Davable trade Income taxes Davable (current) Long-term debt Common stock Retained earnings Total Additional Information Gurrent ratio (at vear end) Total liabilities divided by total stockholders' equity 25,000 294,000 432,000 25.000 300.000 slavento turnover based on sales and ending inventor Inventor turnover based on cost of goods sold and ending inventory Gross margin for the year 1,5 to 1 0.8 15 times 10.5 times P315,000 What was rend' balance in trade accounts payable at year-end? What was Trend's balance in retained earnings at year-end? Was rends Dalance in the inventory account at year-end? The balance of Accounts…