Help Presented below is selected data from the financial statements of Vert, Inc. for the current and prior year (select all that apply):12/31/20X212/31/20X1Current assets$330,000$220,000Total assets$2,300,000$1,950,000Current liabilities$195,000$180,000Total liabilities$1,190,000$1,180,000Total stockholders' equity$1,110,000$770,000Net sales$5,200,000$3,900,000Cost of Goods Sold$3,800,000$2,690,000Wages expense$953,000$869,000Supplies expense$60,000$50,000Depreciation expense$35,000$32,000Interest expense$12,000$9,000Net income$340,000S250,000A vertical analysis of the data would show (select all that apply):O A. The net profit margin for 20X2 is 6.54%.O B. The net profit margin for 20X1 is 6.54%.O C. Net income increased 36% from 20X1 to 20X2.O D. Cost of goods sold in 20X2 is 73% of net sales.O E. Cost of goods sold increased 40.89% from 20X1 to 20X2.

Vertical analysis: It is a method of analyzing the financial statement in which each item is shown…

Answered: Presented below is selected data from…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 17E

See similar textbooks

Similar questions

Prince Corporations accounts provided the following information at December 31, 2019: What should be the current balance of retained earnings? a. 520,000 b. 580,000 c. 610,000 d. 670,000
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. You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.
Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019: Additional information: a. On January 2, 2019, Farrell sold equipment costing 45,000, with a book value of 24,000, for 19,000 cash. b. On April 2, 2019, Farrell issued 1, 000 shares of common stock for 23,000 cash. c. On May 14, 2019, Farrell sold all of its treasury stock for 25,000 cash. d. On June 1, 2019, Farrell paid 50, 000 to retire bonds with a face value (and book value) of 50, 000. e. On July 2, 2019, Farrell purchased equipment for 63, 000 cash. f. On December 31, 2019, land with a fair market value of 150,000 was purchased through the issuance of a long-term note in the amount of 150,000. The note bears interest at the rate of 15% and is due on December 31, 2021. g. Deferred taxes payable represent temporary differences relating to the use of accelerated depreciation methods for income tax reporting and the straight-line method for financial statement reporting. Required: 1. Prepare a spreadsheet to support a statement of cash flows for Farrell for the year ended December 31, 2019, based on the preceding information. 2. Prepare the statement of cash flows. (Appendix 21.1) Spreadsheet and Statement Refer to the information for Farrell Corporation in P21-13. Required: 1. Using the direct method for operating cash flows, prepare a spreadsheet to support a 2019 statement of cash flows. (Hint: Combine the income statement and December 31, 2019, balance sheet items for the adjusted trial balance. Use a retained earnings balance of 291,000 in this adjusted trial balance.) 2. Prepare the statement of cash flows. (A separate schedule reconciling net income to cash provided by operating activities is not necessary.)
Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019: Additional information: a. On January 2, 2019, Farrell sold equipment costing 45,000, with a book value of 24,000, for 19,000 cash. b. On April 2, 2019, Farrell issued 1,000 shares of common stock for 23,000 cash. c. On May 14, 2019, Farrell sold all of its treasury stock for 25,000 cash. d. On June 1, 2019, Farrell paid 50,000 to retire bonds with a face value (and book value) of 50,000. e. On July 2, 2019, Farrell purchased equipment for 63,000 cash. f. On December 31, 2019. land with a fair market value of 150,000 was purchased through the issuance of a long-term note in the amount of 150,000. The note bears interest at the rate of 15% and is due on December 31, 2021. g. Deferred taxes payable represent temporary differences relating to the use of accelerated depreciation methods for income tax reporting and the straight-line method for financial statement reporting. Required: 1. Prepare a spreadsheet to support a statement of cash flows for Farrell for the year ended December 31, 2019, based on the preceding information. 2. Prepare the statement of cash flows.
The following data (in millions) are taken from the financial statements of Target Corporation: a. For Target Corporation, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. What conclusions can you draw from your analysis of the revenue and the total operating expenses?
Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Refer to the information for Juroe Company on the previous page. Also, assume that Juroes total assets at the beginning of last year equaled 17,350,000 and that the tax rate applicable to Juroe is 40%. Required: Note: Round answers to two decimal places. 1. Calculate the average total assets. 2. Calculate the return on assets.
Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: Note: Round answers to two decimal places. 1. Calculate the times-interest-earned ratio. 2. Calculate the debt ratio. 3. Calculate the debt-to-equity ratio.
The following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.
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.
Financial statements The assets and liabilities of Global Travel Agency on December 31, 20Y5, and its revenue and expenses for the year are as follows: Common stock was 525,000 and retained earnings was 1,250,000 as of January 1, 20Y5. During the year, additional common stock of 50,000 was issued for cash, and dividends of 90,000 were paid. Instructions 1. Prepare an income statement for the year ended December 31, 20Y5. 2. Prepare a statement of stockholders equity for the year ended December 31, 20Y5. 3. Prepare a balance sheet as of December 31, 20Y5. 4. What items appears on both the statement of stockholders equity and the balance sheet?
Income Statement Ratio The income statement of Holly Enterprises shows operating revenues of $134,800, selling expenses of $38,310, general and administrative expenses of $36,990, interest expense of $580, and income tax expense of $13,920. Hollys stockholders equity was $280,000 at the beginning of the year and $320,000 at the end of the year. The company has 20,000 shares of stock outstanding at the end of the year. Required Compute Hollys profit margin. What other information would you need in order to comment on whether this ratio is favorable?
Ratio Analysis Rising Stars Academy provided the following information on its 2019 balance sheet and state mcnt of cash flows: Long-term debt S 4,400 Interest expense S 398 Total liabilities 8,972 Net income 559 Total assets 38,775 Interest payments 432 Total equity 29,803 Cash flows from operations 1.015 Operating income 1.223 Income tax expenses 266 Income taxes paid 150 Required: Calculate the following ratios for Rising Stars: (a) debt to equity, (b) debt to total assets, (c) long-term debt to equity, (d) times interest earned (accrual basis), and (e) times interest earned (cash basis). (Note: Round answers to three decimal places.) CONCEPTUAL CONNECTION Interpret these results. 3.What does it mean if a bond is callable

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781305088436

Author:

Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781305088436

Author:

Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS