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

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 $300,630 $170,750 Current assets 510,160 478,100 Property, plant, and equipment 100,210 34,150 Intangible assets 191,310 116,110 Current liabilities 373,510 280,030 Long-term liabilities Common stock 81,990 75,130 Retained earnings 264,190 211,730 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 Previous year Previous year Current year Percent Current year Amount Amount Percent Current assets $300,630 $170,750 Property, plant, and equipment 510,160 478,100 100,210 34,150 Intangible assets Total assets $911,000 $683,000 Current liabilities…
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Cash $ 240,000 Accounts payable $ 600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,135,000 Other current liabilities 560,000 Total current assets $2,950,000 Total current liabilities $1,260,000 Net fixed assets 1,315,000 Long-term debt 400,000 Common equity 2,605,000 Total assets $4,265,000 Total liabilities and equity $4,265,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars) Sales $7,500,000 Cost of goods sold 6,375,000 Selling, general, and administrative expenses 943,000 Earnings before interest and taxes (EBIT) $ 182,000 Interest expense 40,000 Earnings before taxes (EBT) $ 142,000 Federal and state income taxes (25%) 35,500 Net income $ 106,500 a. Calculate the indicated ratios for Lozano. Do not round intermediate calculations. Round your answers…
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…
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
Please help solving Example P20-7 from Chapter 20 in the Financial Reporting and Analysis 8th Edition Presented next are the balance sheet accounts of Bergen Corporation as of December 31, 20X1 and 20X0. 20X1 20X0 Increase (Decrease) Assets Current assets: Cash $ 541,000 $ 308,000 $ 233,000 Accounts receivable, net 585,000 495,000 90,000 Inventories 895,000 780,000 115,000 Total current assets 2,021,000 1,583,000 438,000 Land 350,000 250,000 100,000 Plant and equipment 1,060,000 720,000 340,000 Accumulated depreciation (295,000 ) (170,000 ) (125,000 ) Leased equipment under capital lease 158,000 -0- 158,000 Marketable investment securities, at cost -0- 75,000 (75,000 ) Investment in Mason, Inc., at cost 180,000 180,000 -0- Total assets $ 3,474,000 $ 2,638,000…
Consolidated Statements of Earnings For the Years Ended December 31, (in thousands of dollars) Year 8 Sales $64,000 Cost of sales. 50,000 Gross profit 14,000 Operating expenses before interest and income taxes 8,000 Interest expense 1,780 Earnings before income taxes 4,220 Income tax expense 1,900 Net earnings $ 2,320 MORKSEN CORP. Consolidated Statements of Financial Position At December 31, (in thousands of dollars) Year 8 Year 7 Assets Current assets Cash $ 480 $ 380 740 10,880 Short-term investments Accounts receivable 740 8,400 Merchandise inventory 16,660 10,060 Total current assets 28,660 19,680 Property, plant, and equipment Land 4,000 4,000 Buildings and equipment 26,000 26,000 30,000 30,000 8,940 7,440 Less: Accumulated depreciation. Net property, plant, and equipment 21,060 22,560 Total assets $49,720 $42, 240 Liabilities and Shareholders' Equity Current Liabilities Bank loan $16,500 $11,400 Accounts payable 6,000 4,300 Other liabilities 1,640 1,600 Income tax payable 960…
Vertical analysis Two income statements for Cornea Company follow: Cornea Company Income Statements For the Years Ended December 31 20Y9 20Y8 Fees earned $1,570,000 $1,300,000 Expenses (832,100) (780,000) Net income $737,900 $520,000 Required: a. Prepare a vertical analysis of Cornea Company’s income statements. If required, round your percentage to the nearest whole number. Cornea Company Income Statements For the Years Ended December 31 20Y9 20Y8 Amount Percent Amount Percent Fees earned $1,570,000 % $1,300,000 % Expenses (832,100) % (780,000) % Operating income $737,900 % $520,000 % b. Does the vertical analysis indicate a favorable or an unfavorable trend?
Question 4: Belmont Industries Balance Sheet, As at 31-Dec-01 Assets Liabilities & Equity Cash $ 100,000 Current Liabilities Receivables Long Term Debt Inventory Total Debt Plant Common Equity $ 600,000 Total Assets Total Claims Current Ratio 2.5 Average Collection Period 54 days Total Debt to Total Assets 40% Total Asset Turnover 2 Inventory Turnover 5
Question Content Area The balance sheets at the end of each of the first two years of operations indicate the following: Kellman Company Year 2 Year 1 Total current assets $614,300 $571,500 Total investments 68,000 50,400 Total property, plant, and equipment 876,700 754,200 Total current liabilities 111,200 81,800 Total long-term liabilities 291,100 248,700 Preferred 9% stock, $100 par 87,300 87,300 Common stock, $10 par 545,500 545,500 Paid-in capital in excess of par-common stock 67,500 67,500 Retained earnings 456,400 345,300 Using the balance sheets for Kellman Company, if net income is $106,400 and interest expense is $37,200 for Year 2, what is the return on stockholders' equity for Year 2 (round percent to two decimal points)?
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?
Brief Exercise 170 Using these data from the comparative balance sheet of Banner Company, perform vertical analysis. (Round answers to 1 decimal place, e.g. 15.2.) December 31, 2020 December 31, 2019 Amount Percentage Amount Percentage Accounts Receivable $ 480,000 % $ 336,000 % Inventory 720,000 % 504,000 % Total Assets 4,000,000 % 2,800,000 %