Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Bal Sheet Analysis Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) ALLENDALE COMPANY Vertical Analysis of Income Statements Year 4 Year 3 Amount % Total Amount % Total Revenues Sales (net) $ 230,000 100.00 % $ 210,000 100.00 % Other revenues 8,000 5,000 Total revenues 238,000 215,000 Expenses Cost of goods sold 120,000 103,000 Selling, general, and administrative expense 55,000 50,000 Interest expense 8,000 7,200 Income tax expense 23.000 22,000 Total expenses 206,000 182,200 Net income $ 32,000 % $ 32,800 % < Analysis Bal Sheet Analysis Inc Stmt

Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Bal Sheet Analysis Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) ALLENDALE COMPANY Vertical Analysis of Income Statements Year 4 Year 3 Amount % Total Amount % Total Revenues Sales (net) $ 230,000 100.00 % $ 210,000 100.00 % Other revenues 8,000 5,000 Total revenues 238,000 215,000 Expenses Cost of goods sold 120,000 103,000 Selling, general, and administrative expense 55,000 50,000 Interest expense 8,000 7,200 Income tax expense 23.000 22,000 Total expenses 206,000 182,200 Net income $ 32,000 % $ 32,800 % < Analysis Bal Sheet Analysis Inc Stmt

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 89PSB

See similar textbooks

Similar questions

Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet Stmt Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) PEREZ COMPANY Vertical Analysis of Balance Sheets Year 4 Year 3 Percentage of Total Percentage of Total Amount Amount Assets Current assets Cash $ 17,400 % $ 12,600 % Marketable securities 21,000 7,600 Accounts receivable (net) 54,700 46,900 Inventories 136,200 144,400 Prepaid items 25,700 11,800 Total current assets 255,000 223,300 Investments 28,100 21,000 Plant (net) 270,500 255,100 Land 29,700 24,900 Total long-term assets 328,300 301,000 Total assets $ 583,300 $ 524,300 Liabilities and stockholders' equity Liabilities Current liabilities Notes payable $ 16,100 $ 5,000…
Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet Stmt Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) ALLENDALE COMPANY Vertical Analysis of Balance Sheets Year 4 Year 3 Amount Amount Assets Current assets Cash $ 40,000 $36,000 Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 27,000 20,000 270,000 255,000 29,000 24,000 Total long-term assets 326,000 299,000 Total assets $ 600,000 $540,000 Liabilities and stockholders' equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000 Accounts payable 113,800 100,000 Salaries payable 21,000 15,000 151,800…
Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet Stmt Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) ALLENDALE COMPANY Vertical Analysis of Balance Sheets Year 4 Year 3 Amount % Total Amount % Total Assets Current assets Cash $ 40,000 % $ 36,000 % Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 Investments 27,000 20,000 Plant (net) 270,000 255,000 Land 29,000 24,000 Total long-term assets 326,000 299,000 Total assets $ 600,000 100.00 $ 540,000 100.00 Liabilities and stockholders' equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000…
Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered as 23.4).)
Required: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leverage
Suppose that you are doing a financial statement analysis. Assume you took a financial statement and divided every entry amount in the statement by the amount of total assets. The resulting statement is commonly called a? current ratio common base year income statement common size balance sheet common size income statement common base year balance sheet .DO NOT GIVE PLAGRIZED ANSWER
Compute the component percentages for Trixy Magic’s income statement below. (Enter your answers as a percentage rounded to 2 decimal place (i.e. 0.1234 should be entered as 12.34). Enter all answers as positive values.)
Income statements for Campbell Company for Year 3 and Year 4 follow: CAMPBELL COMPANY Income Statements Year 4 Year 3 $180,800 120,400 19,900 14,500 Sales $200,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,400 21,900 12,500 3,900 $180,700 5,900 $160,700 20,100 3,700 Income before taxes 20,100 Income taxes expense 6,500 Net income $ 13,600 $ 16,400 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Complete this question by entering your answers in the tabs below. Required A Required B Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered…
Perform a vertical analysis for the balance sheet entry "Accounts Payable" given below (as a %). (Round your answer to one decimal place.)
= The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Prime Fish Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data Per share stock price at end of current year Blue Water $ 42,300 44,500 92,500 159,500 85,300 $ 424,100 $ 92,500 74,100 157,100 30,300 70,100 $ 424,100 $ 427,500 (234,500) (163,600) $ 29,400 $ 23.3 45% $ 19,700 34,900 47,800 416,600 318,000 $ 34,300 $ 837,000 $ 68,500 62,600 525,000 107,300 73,600 $ 837,000 $ 789,000 (401,300) (312,300) $ 75,400 $28 45% Average income tax rate Dividends declared and paid in current year Both companies are in the fish catching and manufacturing business.…
Complete the worsheet one section at a time, beginning with the Adjustments columns. For the Adjustments columns use the appropriate letters a. through d. as posting references. For the Income Statement and Balance Sheet columns, remember to include the net income or loss after the totals and then total the columns again. (If a box is not used in the worksheet, leave the box empty; do not enter a zero. Abbreviations used: Acc. = Acccumulated; Adj. = Adjusted; Depr. = Depreciation; Stmt. = Statement.) Mullen Co. Worksheet For Year Ended December 31, 201X Trial Balance Adjustments Account Dr. Cr. Dr. Cr. Cash 7 Accounts Receivable 3 Merchandise Inventory 9 Store Supplies 7 Store Equipment 20 Acc. Depr., Store Equipment…
Comparative Income Statement Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%. Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Operating income Other expense (interest) Income before income tax expense Income tax expense Net income Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 $ 20Y6 8,250,000 X (1,242,000) 20Y5 $7,287,000 (3,444,000) $3,843,000 $(1,457,600) (1,106,000) $(2,563,600) $1,279,400 (120,600) $1,158,800 (181,980) $976,820 $ $ $ Increase/(Decrease) Amount 823,000 X…