FINANCIAL ACCOUNTING W/ACCESS >CI<
2nd Edition
ISBN: 9781259999024
Author: SPICELAND
Publisher: MCG CUSTOM
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 12.3BP
1.
To determine
To Prepare: The vertical analysis of the balance sheet data for 2018 and 2017 and express each amount as a percentage of total assets.
2.
To determine
To Prepare: The horizontal analysis of the balance sheet data for 2018 and 2017, using 2017 as the base year.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The current sections of Larkspur, Inc.’s balance sheets at December 31, 2021 and 2022, are presented here. Larkspur, Inc.’s net income for 2022 was $221,850. Depreciation expense was $39,150.
2022
2021
Current assets
Cash
$152,250
$ 143,550
Accounts receivable
116,000
129,050
Inventory
243,600
249,400
Prepaid expenses
39,150
31,900
Total current assets
$551,000
$553,900
Current liabilities
Accrued expenses payable
$ 21,750
$ 7,250
Accounts payable
123,250
133,400
Total current liabilities
$145,000
$ 140,650
Prepare the net cash provided (used) by operating activities section of the company’s statement of cash flows for the year ended December 31, 2022, using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)
2018
2017
Assets
Cash
90,800
48,400
Accounts receivable
92,800
33,000
Inventories
112,500
102,850
Prepaid expenses
28,400
26,000
Supplies
138,000
114,000
Machine
270,000
242,500
Less: Accumulated depreciation
-50,000
-52,000
Total
682,500
514,750
Liabilities and Shareholder’s equities
Accounts payable
112,000
67,300
Other payable
16,500
17,000
Notes payable
110,000
150,000
Total paid-in capital
220,000
175,000
Retained earnings
224,000
105,450
Total
682,500
514,750
Income statement for the year ended 31 Dec 2018
Sales revenue
392,780
Cost of goods sold
135,460
Gross profit
257,320
Adverting expense
12,410
Depreciation expense
46,500
Income taxes expense
27,280
Interest expense
4,730
Loss on sale of machine
7,500
Net income
158,900
Please prepare cash flow statement for the year ended 31 Dec 2018, show T-Account of Retain earning at 31 Dec 2018
The balance sheets for a company, along with additional information, are provided below:
Balance SheetsDecember 31, 2021 and 2020
2021
2020
Assets
Current assets:
Cash
$
155,850
$
174,600
Accounts receivable
75,200
88,500
Inventory
88,000
73,700
Prepaid rent
2,600
1,300
Long-term assets:
Land
445,000
445,000
Equipment
738,000
635,000
Accumulated depreciation
(409,000
)
(254,000
)
Total assets
$
1,095,650
$
1,164,100
Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable
$
92,000
$
78,700
Interest payable
7,050
14,100
Income tax payable
6,600
4,300
Long-term liabilities:
Notes payable
117,500
235,000
Stockholders' equity:
Common stock
665,000
665,000
Retained earnings…
Chapter 12 Solutions
FINANCIAL ACCOUNTING W/ACCESS >CI<
Ch. 12 - Prob. 1RQCh. 12 - Prob. 2RQCh. 12 - Prob. 3RQCh. 12 - Prob. 4RQCh. 12 - 5.In performing horizontal analysis, why is it...Ch. 12 - Prob. 6RQCh. 12 - Prob. 7RQCh. 12 - Prob. 8RQCh. 12 - Prob. 9RQCh. 12 - Prob. 10RQ
Ch. 12 - Prob. 11RQCh. 12 - Prob. 12RQCh. 12 - Prob. 13RQCh. 12 - Prob. 14RQCh. 12 - Prob. 15RQCh. 12 - Prob. 16RQCh. 12 - Prob. 17RQCh. 12 - Prob. 18RQCh. 12 - Prob. 19RQCh. 12 - Prob. 20RQCh. 12 - Prob. 12.1BECh. 12 - Prob. 12.2BECh. 12 - Prob. 12.3BECh. 12 - Prob. 12.4BECh. 12 - Prob. 12.5BECh. 12 - Universal Sports Supply began the year with an...Ch. 12 - Prob. 12.7BECh. 12 - Prob. 12.8BECh. 12 - Prob. 12.9BECh. 12 - Prob. 12.10BECh. 12 - Prob. 12.11BECh. 12 - Prob. 12.12BECh. 12 - Prob. 12.13BECh. 12 - Classify each of the following accounting...Ch. 12 - Classify each of the following accepted accounting...Ch. 12 - Prob. 12.1ECh. 12 - Prob. 12.2ECh. 12 - Prob. 12.3ECh. 12 - Prob. 12.4ECh. 12 - Prob. 12.5ECh. 12 - Refer to the information for Adrian Express in...Ch. 12 - Prob. 12.7ECh. 12 - Calculate profitability ratios (LO124) Refer to...Ch. 12 - Prob. 12.9ECh. 12 - The income statement for Stretch-Tape Corporation...Ch. 12 - Prob. 12.11ECh. 12 - LeBrons Bookstores has two divisions, books and...Ch. 12 - Prob. 12.13ECh. 12 - Prob. 12.14ECh. 12 - Distinguish between conservative and aggressive...Ch. 12 - Prob. 12.1APCh. 12 - Prob. 12.2APCh. 12 - Prob. 12.3APCh. 12 - Prob. 12.4APCh. 12 - Prob. 12.5APCh. 12 - Prob. 12.6APCh. 12 - Game-On Sports operates in two distinct segments:...Ch. 12 - Prob. 12.2BPCh. 12 - Prob. 12.3BPCh. 12 - Prob. 12.4BPCh. 12 - Prob. 12.5BPCh. 12 - Prob. 12.6BPCh. 12 - Prob. 12.1APCPCh. 12 - Prob. 12.2APFACh. 12 - Prob. 12.3APFACh. 12 - Prob. 12.4APCACh. 12 - Prob. 12.5APECh. 12 - Prob. 12.7APWCCh. 12 - Prob. 12.8APEM
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. Open the file CASHFLOW from the website for this book at cengagebrain.com. First, enter the formulas. Then, complete the worksheet in the manner described next. According to the problem, cash increased from 39,600 to 67,210 during the year. This is a 27,610 increase. To record this increase on the worksheet, move to row 17. Since this is the first account you are analyzing, enter the letter a in column C. Then enter 27610 in column D (a debit since cash increased). This brings the year-end balance (column G) to 67,210, its proper balance. Now move to the bottom part of the statement where you see the categories Operating Activities, Investing Activities, and so on. The credit side of the entry has to be entered here. The proper space for this cash entry is on row 59. Enter the letter a in cell E59 and 27610 in cell F59. Notice the totals at the bottom of the page (row 60) now agree. The next account balance that changed is accounts receivable. It increased by 9,035. To enter this change on the worksheet, enter the letter b in cell C18 and 9035 in cell D18 (again, a debit since accounts receivable increased). This brings the year-end balance in column G to 121,250, its proper balance. The change in accounts receivable balance is an operating activity adjustment (as explained in your textbook). Enter the credit side of this entry in cells E34 and F34, and enter the explanation Increase in accounts receivable in cell A34. Note: Your textbook probably shows Net income as the first item under Operating Activities. We will get to that later. The sequence in which you enter items on this worksheet is not important. All other balance sheet accounts must be analyzed in the same manner, placing appropriate debit or credit entries in the top part of the worksheet to obtain the proper balances in column G, and then entering the second side of the entry in the appropriate row on the bottom part of the worksheet. You should use letter references to identify all entries. Also, you must enter a description of the entry in column A under the appropriate activity category. Although a sequence of analyzing the balance sheet from top to bottom is suggested here, this order is not necessary. As mentioned earlier, your textbook may specify a different sequence. Also, note that some accounts may have both debit and credit adjustments to them. The worksheet is not a substitute for a statement of cash flows, but it does provide you with all the numbers you need to properly prepare one. You will be done with your analysis when: a. The individual account balances at December 31, 2013, as shown on the worksheet (column G) equal those shown in the given problem data. b. The transaction column totals are equal (cells D60 and F60). c. The sum of the operating, investing, and financing activities (cell G59) equals the change in cash (cell D59 or F59). When you are finished, enter your name in cell A1. Save your completed file as CASHFLOW2. Print the worksheet when done. Also print your formulas. Check figure: Total credits at 12/31/2013 (cell G31), 860,460.arrow_forwardFountain Office Supply's March 31, 2018, balance sheet follows: Fountain Office Supply Balance Sheet March 31, 2018 Assets Current Assets: Cash $34,000 Accounts Receivable 22,000 Merchandise Inventory 21,500 Prepaid Insurance 2,500 Total Current Assets $80,000 Property, Plant, and Equipment: Equipment and Fixtures 55,000 Less: Accumulated Depreciation (30,000) 25,000 Total Assets $105,000 Liabilities Current Liabilities: Accounts Payable $15,000 Salaries and Commissions Payable 6,450 Total Liabilities $21,450 Stockholders' Equity Common Stock, no par 14,000 Retained Earnings 69,550 Total Stockholders' Equity 83,550 Total Liabilities and Stockholders' Equity $105,000 The budget committee of Fountain Office Supply has assembled the following data: a. Sales in April…arrow_forwardOne Stop, Inc. Comparative Balance Sheet December 31, 2018 and 2017 2018 2017 Assets Current Assets: Cash $26,800 $14,900 Accounts Receivable 26,700 25,500 Merchandise Inventory 79,900 91,900 Long-term Assets: Land 35,400 8,000 Plant Assets 117,550 109,150 Accumulated Depreciation—Plant Assets (19,650) (15,450) Total Assets $266,700 $234,000 Liabilities Current Liabilities: Accounts Payable $35,000 $30,700 Accrued Liabilities 28,600 30,200 Long-term Liabilities: Notes Payable 73,000 105,000 Total Liabilities 136,600 165,900 Stockholders' Equity Common Stock, no par 88,200 64,300 Retained Earnings 41,900 3,800 Total Stockholders' Equity 130,100 68,100 Total Liabilities and Stockholders' Equity $266,700 $234,000 One Stop, Inc. Income Statement Year Ended December 31,…arrow_forward
- he current sections of Skysong, Inc.’s balance sheets at December 31, 2021 and 2022, are presented here.Skysong’s net income for 2022 was $152,700. Depreciation expense was $27,600. 2022 2021 Current assets Cash $107,600 $95,900 Accounts receivable 78,400 89,400 Inventory 167,800 172,100 Prepaid expenses 26,800 22,000 Total current assets $380,600 $379,400 Current liabilities Accrued expenses payable $15,800 $8,600 Accounts payable 84,900 95,500 Total current liabilities $100,700 $104,100 Prepare the net cash provided by operating activities section of the company’s statement of cash flows for the year ended December 31, 2022, using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)arrow_forwardThe current sections of Pronghorn Corp’s balance sheets at December 31, 2021 and 2022, are presented here. Pronghorn Corp’s net income for 2022 was $183,600. Depreciation expense was $32,400. 2022 2021 Current assets Cash $126,000 $ 118,800 Accounts receivable 96,000 106,800 Inventory 201,600 206,400 Prepaid expenses 32,400 26,400 Total current assets $456,000 $458,400 Current liabilities Accrued expenses payable $ 18,000 $ 6,000 Accounts payable 102,000 110,400 Total current liabilities $120,000 $ 116,400 Prepare the net cash provided (used) by operating activities section of the company’s statement of cash flows for the year ended December 31, 2022, using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).) Pronghorn CorpPartial Statement of Cash…arrow_forwardThe comparative balance sheets for Crane Company as of December 31 are presented below. Crane CompanyComparative Balance SheetsDecember 31 Assets 2022 2021 Cash $ 54,400 $ 36,000 Accounts receivable 40,000 46,400 Inventory 121,160 113,600 Prepaid expenses 12,224 16,800 Land 116,000 104,000 Buildings 160,000 160,000 Accumulated depreciation—buildings (48,000 ) (32,000 ) Equipment 180,000 124,000 Accumulated depreciation—equipment (36,000 ) (28,000 ) Total $599,784 $540,800 Liabilities and Stockholders’ Equity Accounts payable $ 35,784 $ 28,800 Bonds payable 240,000 240,000 Common stock, $1 par 160,000 128,000 Retained earnings 164,000 144,000 Total $599,784 $540,800 Additional information:…arrow_forward
- The current sections of Bramble Inc.’s balance sheets at December 31, 2021 and 2022, are presented here. Bramble’s net income for 2022 was $151,400. Depreciation expense was $27,200. 2022 2021 Current assets Cash $103,000 $97,100 Accounts receivable 80,000 90,800 Inventory 169,000 171,500 Prepaid expenses 26,000 22,000 Total current assets $378,000 $381,400 Current liabilities Accrued expenses payable $14,500 $9,100 Accounts payable 84,500 95,600 Total current liabilities $99,000 $104,700 Prepare the operating activities section of the company’s statement of cash flows for the year ended December 31, 2022, using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).arrow_forwardThe Fancy Company's comparative balance sheets for 2019 and 2020, and additional information, are presented below. Fancy Company Comparative Balance Sheets 1 December 31, 2020 December 31, 2019 2 Assets 3 Cash $14,000.00 $9,000.00 4 Accounts receivable 52,000.00 24,000.00 5 Inventory 87,000.00 40,000.00 6 Equipment 125,000.00 100,000.00 7 Accumulated depreciation (42,000.00) (34,000.00) 8 Prepaid expenses 4,000.00 2,000.00 9 Land 0.00 7,000.00 10 Building 50,000.00 0.00 11 Total Assets $290,000.00 $148,000.00 12 Liabilities and Shareholders' Equity 13 Accounts payable $25,000.00 $14,000.00 14 Interest payable 8,000.00 6,000.00 15 Taxes payable 37,000.00 11,000.00 16 Short-term note payable 37,000.00 32,000.00 17 Bonds payable 75,000.00 50,000.00 18 Common stock, $10 par 75,000.00…arrow_forwardUse the following balance sheet for problems 19 through 21: Dec 31st 2019 Dec 31st 2018 Cash 30,000 35,000 Accounts Receivable 55,000 45,000 Inventory 65,000 45,000 Prepaid expenses 15,000 25,000 Equipment 80,000 85,000 Accumulated Depreciation (8,000) (18,000) Land 40,000 40,000 Total Assets 277,000 257,000 Accounts Payable 65,000 52,000 Income tax payable 15,000 18,000 Long-term notes payable 0 23,000 Bonds payable 30,000 0 Common stock 159,000 159,000 R/E 8,000 5,000 Total Liabilities & Equity 277,000 257,000 Additional information: Equipment costing $10,000 with accumulated depreciation of $4,000 was sold for a loss of $3,000. All equipment purchases during the year were for cash. Net income for 2019 was $20,000. Depreciation expense for 2019 was $14,000. 19) Compute net cash flow from operations (in the excel submission workbook, enter net cash PROVIDED by operating activities as a POSITIVE number, and net cash USED by operating activities as a NEGATIVE…arrow_forward
- The current sections of Crane Inc.’s balance sheets at December 31, 2021 and 2022, are presented here. Crane’s net income for 2022 was $154,700. Depreciation expense was $26,300. 2022 2021 Current assets Cash $102,700 $97,700 Accounts receivable 79,400 90,000 Inventory 168,200 173,000 Prepaid expenses 26,900 22,900 Total current assets $377,200 $383,600 Current liabilities Accrued expenses payable $15,000 $9,300 Accounts payable 84,000 95,600 Total current liabilities $99,000 $104,900 Prepare the operating activities section of the company’s statement of cash flows for the year ended December 31, 2022, using the indirect methodarrow_forwardThe current sections of Riverbed Corp’s balance sheets at December 31, 2021 and 2022, are presented here. Riverbed Corp’s net income for 2022 was $355,600. Depreciation expense was $58,800. 2022 2021 Current assets Cash $86,800 $ 124,600 Accounts receivable 119,000 96,600 Inventory 109,200 86,800 Prepaid expenses 23,800 26,600 Total current assets $338,800 $334,600 Current liabilities Accrued expenses payable $ 8,400 $ 22,400 Accounts payable 123,200 100,800 Total current liabilities $131,600 $ 123,200 Prepare the net cash provided by operating activities section of the company’s statement of cash flows for the year ended December 31, 2022, using the indirect method.arrow_forwardThe balance sheets for Cosmic Company showed the following information. Additional information concerning transactions and events during 2021 are presented below. Cosmic Company Balance Sheet December 31 2021 2020 Cash $ 67,500 $71,000 Accounts receivable (net) 20,000 28,000 Inventory…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License