Chapter 14 Financial Statement Analysis Retained earnings, urrent year, 36.8% EX 14-4 Vertical analysis of balance sheet Balance sheet data for Alvarez Company on December 31, the end of two recent follow: Obj. 2 fiscal years, Current Year Previous Year $2,500,000 $1,840,000 Current assets 5,600,000 6,072,000 Property, plant, and equipment Intangible assets EXCEL TEMPLATE 1,900,000 1,288,000 Current liabilities 2,000,000 1,380,000 Long-term liabilities 3,400,000 3,680,000 Common stock 920,000 920,000 Retained earnings 3,680,000 3,220,000 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. (Round percentages to one decimal place.)

Chapter 14 Financial Statement Analysis Retained earnings, urrent year, 36.8% EX 14-4 Vertical analysis of balance sheet Balance sheet data for Alvarez Company on December 31, the end of two recent follow: Obj. 2 fiscal years, Current Year Previous Year $2,500,000 $1,840,000 Current assets 5,600,000 6,072,000 Property, plant, and equipment Intangible assets EXCEL TEMPLATE 1,900,000 1,288,000 Current liabilities 2,000,000 1,380,000 Long-term liabilities 3,400,000 3,680,000 Common stock 920,000 920,000 Retained earnings 3,680,000 3,220,000 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. (Round percentages to one decimal place.)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Cash Accounts receivable Inventory Land Building Accumulated depreciation Total Accounts payable Common stock ($5 par) Retained earnings Total (a) (b) (c) (d) (e) FLOUNDER CORPORATION Balance Sheets December 31 (f) (h) (i) (1) Current ratio Inventory turnover Days in inventory Profit margin Average collection period Asset turnover Return on assets 2022 $12,000 Flounder's 2022 income statement included net sales of $117,000, cost of goods sold of $77,000, and net income of $28,500. 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 O decimal places, eg 18 or 25% and all other answers to 2 decimal places, e.g. 1.83. Use 365 days for calculation.) Earnings per share Accounts receivables turnover Payout ratio 17,900 12,700 33,700 75,700 (16,700) Debt to total assets ratio 135,300 19.000 73,500 42,800 135,300 Return on common stockholders' equity 2021 $5,600 26,100 9,700 29,700 75,700 (13,700) 133,100…
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $299,520 $182,520 Property, plant, and equipment 542,880 484,380 Intangible assets 93,600 35,100 Current liabilities 215,280 112,320 Long-term liabilities 365,040 287,820 Common stock 93,600 98,280 Retained earnings 262,080 203,580 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. If required, round percentages to one decimal place. Alvaraz Company Comparative Balance Sheet For the Years Ended December 31 Current Current Previous Previous уear year year year Amount Percent Amount Percent Current assets $299,520 % $182,520 % Property, plant, and equipment 542,880 % 484,380 Intangible assets 93,600 % 35,100 % Total assets $936,000 % $702,000 % Current…
Balance Sheet December 31 Assets Cash Inventory Equipment Accounts receivable Less: Accumulated depreciation $ 21,000 520,000 142,500 $ 624,000 78,000 546,000 Total assets $ 1,229,500 Liabilities and Equity Liabilities Accounts payable Loan payable Taxes payable (due March 15) $ 355,000 11,000 88,000 454,000 Equity Common stock Retained earnings $ 474,500 301,000 775,500 Total liabilities and equity $ 1,229,500 To prepare a master budget for January, February, and March, use the following information. a. The company's single product is purchased for $30 per unit and resold for $58 per unit. The inventory level of 4,750 units on December 31 is more than management's desired level, which is 20% of the next month's budgeted sales units. Budgeted sales are January, 6,500 units; February, 9,000 units; March, 11,000 units; and April, 10,000 units. All sales are on credit. b. Cash receipts from sales are budgeted as follows: January, $233,100; February, $722,857; March, $519,245. c. Cash…
Vertical Analysis Two income statements for Upward Company follow: Upward Company Income Statements For the Years Ended December 31 20Y5 20Y4 Fees earned $924,000 $784,000 Operating expenses 545,160 478,240 Income from operations $378,840 $305,760 a. Prepare a vertical analysis of Upward Company's income statements. Enter percents as whole numbers. Upward Company Income Statements For the Years Ended December 31 20Y5 Amount 20Y5 Percent 20Y4 Amount 20Y4 Percent Fees earned $924,000 100 % $784,000 100 % 545,160 0X % 478,240 X % Operating expenses X % $305,760 X % Income from operations $378,840
f
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $289,000 $172,260 Property, plant, and equipment 467,500 427,460 Intangible assets 93,500 38,280 Current liabilities 204,000 114,840 Long-term liabilities 306,000 229,680 Common stock 76,500 82,940 Retained earnings 263,500 210,540 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. If required, round percentages to one decimal place. Alvaraz Company Comparative Balance Sheet For the Years Ended December 31 CurrentyearAmount CurrentyearPercent PreviousyearAmount PreviousyearPercent Current assets $289,000 fill in the blank 1% $172,260 fill in the blank 2% Property, plant, and equipment…
Financial statement data for years ending December 31 for Xiong Company follow: Year 2 Year 1 Sales $1,560,000 $1,026,000 Fixed assets: Beginning of year 580,000 500,000 End of year 620,000 580,000 a. Determine the fixed asset turnover ratio for Year 1 and Year 2. Round your answers to one decimal place. Fixed asset turnover Year 1 Year 2 b. Does the change in the fixed asset turnover ratio from Year 1 to Year 2 indicate a favorable or an unfavorable change? Favorable Feedback
Vertical Analysis of Balance Sheet Balance sheet data for Kwan Company on December 31, the end of two recent fiscal years, follow: Current Year Previous Year Current assets $278,110 $150,990 Property, plant, and equipment 575,400 517,680 Intangible assets 105,490 50,330 Current liabilities 182,210 100,660 Long-term liabilities 412,370 309,170 Common stock 95,900 93,470 Retained earnings 268,520 215,700 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. If required, round percentages to one decimal place. Kwan CompanyComparative Balance Sheet For the Years Ended December 31 Current assets $278,110 fill in the blank 1% $150,990 fill in the blank 2% Property, plant, and equipment 575,400 fill in the blank 3% 517,680 fill in the blank 4% Intangible assets 105,490…
Question Content Area What type of analysis is indicated by the following? Increase (Decrease) Current Year Preceding Year Amount Percent Current assets $430,000 $500,000 $(70,000) (14%) Fixed assets 1,740,000 1,500,000 240,000 16 a.vertical analysis b.liquidity analysis c.horizontal analysis d.common-size analysis
Financial statement data for years ending December 31 for Davenport Company follow: Year 2 Year 1 Sales $1,668,000 $1,125,000 Fixed assets: Beginning of year End of year 670,000 580,000 720,000 670,000 a. Determine the fixed asset turnover ratio for Year 1 and Year 2. b. Does the change in the fixed asset turnover ratio from Year 1 to Year 2 indicate a favorable or an unfavorable change?
10 - T&T Company's selected financial statements items are given as following. Total net sales equals to 100.000 TL, COGS equals to 50.000 TL, operating expenses equals to 20.000 TL, interest expenses equals to 10.000 TL, tax expenses 5.000 TL, total depreciation & amortization expenses equals to 15.000 TL. Calculate the EBITDA/Interest Expense ratio of the company for the year 2020. a) 2,50 b) O 01374 3,00 c) O 4,50 d) 5,00