Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
26th Edition
ISBN: 9781305392373
Author: Carl Warren, Jim Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 3.29EX
(a)
To determine
Vertical analysis:
Vertical analysis is the method of financial statement analysis, and it is useful to evaluating a company’s performance and financial condition. Vertical analysis is helpful for analyzing the changes in the financial statements over the time, and comparing the each item on a financial statement with a total amount from the same statement. In the vertical analysis, the financial statements are analyzed in the following manner:
- In vertical analysis of a
balance sheet , each asset item is stated as a percent of the total asset, and each liability and owner’s equity item is stated as a percent of total liabilities and owner’s equity. - In vertical analysis of an income statement, each item of revenue and expense is stated as a percent of total revenues of the business.
To prepare: The vertical analysis of Company D’s income statement.
(b)
To determine
To prepare: The vertical analysis of Company H’s income statement.
(c)
To determine
To compare: The vertical analysis of two companies’ income statement.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Prepare a horizontal analysis of both the balance sheet and income statement.
Complete this question by entering your answers in the tabs below.
Analysis Analysis
Bal Sheet Inc Stmt
Prepare a horizontal analysis of the income statement. (Negative answers should be
indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be
entered as 23.4).)
Revenues
RUNDLE COMPANY
Horizontal Analysis of Income Statements
Year 4
Year 3
Sales (net)
Other revenues
Total revenues
Expenses
Cost of goods sold
Selling, general, and administrative
expenses
Interest expense
Income tax expense
Total expenses
Net income (loss)
$
230,900
9,200
240,100 217,000
$
210,100
6,900
119,800 101,200
53,200
49,200
6,200
5,400
22,800
21,800
202,000
177,600
$ 38,100
$ 39,400
Show less
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 Analysis
Bal Sheet 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).)
Revenues
Sales (net)
Other revenues
Total revenues
RUNDLE COMPANY
Vertical Analysis of Income Statements
Year 4
Expenses
Cost of goods sold
Selling, general, and
administrative expense
Net income
Interest expense
Income tax expense
Total expenses
Amount
$
230,300
8,900
239,200
Percentage
of Total
119,400
54,300
6,700
22,100
202,500
$
36,700
Show less
Complete this question by entering your answers in the tabs below.
Analysis Analysis
Bal Sheet 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).)
Revenues
Sales (net)
Other revenues
Total revenues
Expenses
Cost of goods sold
FANNING COMPANY
Vertical Analysis of Income Statements
Year 4
Selling, general, and
administrative expense
Interest expense
Income tax expense
Total expenses
Net income
Amount
$
231,900
9,300
241,200
118,800
54,200
6,800
22,800
202,600
$
38,600
Percentage
of Total
Analysis Bal Sheet
%
%
Year 3
Amount
$
211,200
6,400
217,600
102,100
49,100
6,000
21,800
179,000
$
Percentage
of Total
%
%
38,600
Analysis Inc Stmt >
Show less
Chapter 3 Solutions
Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
Ch. 3 - How are revenues and expenses reported on the...Ch. 3 - Is the matching concept related to (a) the cash...Ch. 3 - Why are adjusting entries needed at the end of an...Ch. 3 - What is the difference between adjusting entries...Ch. 3 - Identify the four different categories of...Ch. 3 - If the effect of the debit portion of an adjusting...Ch. 3 - If the effect of the credit portion of an...Ch. 3 - Does every adjusting entry affect net income for...Ch. 3 - Prob. 9DQCh. 3 - (a) Explain the purpose of the two accounts:...
Ch. 3 - Accounts requiring adjustment Indicate with a Yes...Ch. 3 - Accounts requiring adjustment Indicate with a Yes...Ch. 3 - Type of adjustment Classify the following items as...Ch. 3 - Prob. 3.2BPECh. 3 - Prob. 3.3APECh. 3 - Adjustment for prepaid expense The prepaid...Ch. 3 - Prob. 3.4APECh. 3 - Prob. 3.4BPECh. 3 - Adjustment for accrued revenues At the end of the...Ch. 3 - Adjustment for unearned revenue The balance in the...Ch. 3 - Adjustment for prepaid expense The prepaid...Ch. 3 - Adjustment for prepaid expense The supplies...Ch. 3 - Adjustment for depreciation The estimated amount...Ch. 3 - Adjustment for depreciation The estimated amount...Ch. 3 - Prob. 3.8APECh. 3 - Prob. 3.8BPECh. 3 - Effect of errors on adjusted trial balance For...Ch. 3 - Effect of errors on adjusted trial balance For...Ch. 3 - Prob. 3.10APECh. 3 - Prob. 3.10BPECh. 3 - Prob. 3.1EXCh. 3 - Prob. 3.2EXCh. 3 - Prob. 3.3EXCh. 3 - Prob. 3.4EXCh. 3 - Prob. 3.5EXCh. 3 - Prob. 3.6EXCh. 3 - Adjusting entries for prepaid insurance The...Ch. 3 - Prob. 3.8EXCh. 3 - Prob. 3.9EXCh. 3 - Prob. 3.10EXCh. 3 - Adjusting entries for unearned and accrued fees...Ch. 3 - Prob. 3.12EXCh. 3 - Prob. 3.13EXCh. 3 - Prob. 3.14EXCh. 3 - Prob. 3.15EXCh. 3 - Prob. 3.16EXCh. 3 - Prob. 3.17EXCh. 3 - Prob. 3.18EXCh. 3 - Determining fixed assets book value The balance in...Ch. 3 - Prob. 3.20EXCh. 3 - Prob. 3.21EXCh. 3 - Prob. 3.22EXCh. 3 - Effects of errors on financial statements The...Ch. 3 - Effects of errors on financial statements If the...Ch. 3 - Adjusting entries for depreciation; effect of...Ch. 3 - Prob. 3.26EXCh. 3 - Adjusting entries from trial balances The...Ch. 3 - Prob. 3.28EXCh. 3 - Prob. 3.29EXCh. 3 - Prob. 3.1APRCh. 3 - Prob. 3.2APRCh. 3 - Prob. 3.3APRCh. 3 - Adjusting entries Good Note Company specializes in...Ch. 3 - Prob. 3.5APRCh. 3 - Adjusting entries and errors At the end of April,...Ch. 3 - Prob. 3.1BPRCh. 3 - Prob. 3.2BPRCh. 3 - Prob. 3.3BPRCh. 3 - Prob. 3.4BPRCh. 3 - Prob. 3.5BPRCh. 3 - Prob. 3.6BPRCh. 3 - The unadjusted trial balance that you prepared for...Ch. 3 - Ethics and professional conduct in business Daryl...Ch. 3 - Accrued revenue The following is an excerpt from a...Ch. 3 - Prob. 3.3CP
Knowledge Booster
Similar questions
- The following data (in millions) are taken from recent financial statements of Nike Inc.: a. Determine the amount of change (in millions) and percent of change in net income for Year 2. Round to one decimal place. b. Determine the percentage relationship between net income and net sales (net income divided by net sales) for Year 2 and Year 1. Round to one decimal place. c. What conclusions can you draw from your analysis?arrow_forwardThe 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.arrow_forwardThe condensed income statements through income from operations for Dell Inc. and Apple Inc. for recent fiscal years follow (numbers in millions of dollars): Prepare comparative common-sized statements, rounding percents to one decimal place. Interpret the analyses.arrow_forward
- The average liabilities, average stockholders' equity, and average total assets are as follows: 1. Determine the following ratios for both companies, rounding ratios and percentagesto one decimal place: a. Return on total assets b. Return on stockholders' equity c. Times interest earned d. Ratio of total liabilities to stockholders' equity 2. Based on the information in (1), analyze and compare the two companies'solvency and profitability. Comprehensive profitability and solvency analysis Marriott International, Inc., and Hyatt Hotels Corporation are two major owners and managers of lodging and resort properties in the United States. Abstracted income statement information for the two companies is as follows for a recent year (in millions): Balance sheet information is as follows:arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…arrow_forward
- 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 %arrow_forwardPrepare a horizontal analysis of both the balance sheet and income statement. Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet Stmt Prepare a horizontal analysis of the income statement. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) ALLENDALE COMPANY Horizontal Analysis of Income Statements Year 4 Year 3 % Change Revenues Sales (net) $ 230,000 $ 210,000 % 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 expenses 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 (loss) $ 32,000 $ 32,800 %arrow_forwardPrepare a comparative common-size income statement for Jubilee Corporation. To an investor, how does the current year compare with the prior year? Explain your reasoning. E (Click the icon to view the comparative income statement.) Data table Start by calculating the percentages. (Round the percentages to two decimal places, X.XX.) Jubilee Corporation Comparative Common-Size Income Statement A C For the Years Ended December 31 1 Jubilee Corporation Current 2 Income Statement year Prior year 3 For the Years Ended December 31 Sales revenues 100.00 % 100.00 % 4 (amounts in thousands) Less: Cost of goods sold % % Current Gross profit % % year Prior year Less: Operating expenses % 6 Sales revenues $ 494,208 $ 429,000 % Operating income % 7 Less: Cost of goods sold 172,640 160,000 Less: Interest expense 8 Gross profit 2$ 321,568 $ 269,000 0% Income before income taxes % % 9 Less: Operating expenses 143,370 135,000 Less: Income tax expense 10 Operating income 2$ 178,198 $ 134,000 % % 11 Less:…arrow_forward
- please answer completearrow_forwardPrepare common size income statements Which company earns more net income? Which companies net income has a higher percentage of its net sales revenue?arrow_forward1.) Solve the Income Statement of AAA Company using Horizontal Analysis. 2.) As a Financial Analyst how would you interpret the data?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning