Loose-leaf for Fundamentals of Financial Accounting with Connect
5th Edition
ISBN: 9781259619007
Author: Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 13.1PB
1.
To determine
To complete: The two final columns of horizontal analysis shown beside each item in the comparative financial statement of Company T
2.
To determine
The account increased by larger amount and largest percentage
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
=
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.…
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
Income statement data for Winthrop Company for two recent years ended December 31 are as follows:
Please see the attachment for details:
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place.b. What conclusions can be drawn from the horizontal analysis?
Chapter 13 Solutions
Loose-leaf for Fundamentals of Financial Accounting with Connect
Ch. 13 - What is the general goal of trend analysis?Ch. 13 - Prob. 2QCh. 13 - What is ratio analysis? Why is it useful?Ch. 13 - What benchmarks are commonly used for interpreting...Ch. 13 - Prob. 5QCh. 13 - Prob. 6QCh. 13 - Slow Cellars current ratio increased from 1.2 to...Ch. 13 - From last year to this year, Colossal Companys...Ch. 13 - From last year to this year, Berry Bam reported...Ch. 13 - Explain whether the following situations, taken...
Ch. 13 - What are the two essential characteristics of...Ch. 13 - Prob. 12QCh. 13 - Prob. 13QCh. 13 - Prob. 14QCh. 13 - Prob. 15QCh. 13 - Prob. 16QCh. 13 - 1. Which of the following ratios is not used to...Ch. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Analysts use ratios to a. Compare different...Ch. 13 - Which of the following ratios incorporates stock...Ch. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - A bank is least likely to use which of the...Ch. 13 - Prob. 9MCCh. 13 - (Supplement 13A) Which of the following items is...Ch. 13 - Calculations for Horizontal Analyses Using the...Ch. 13 - Calculations for Vertical Analyses Refer to M13-1....Ch. 13 - Interpreting Horizontal Analyses Refer to the...Ch. 13 - Interpreting Vertical Analyses Refer to the...Ch. 13 - Prob. 13.5MECh. 13 - Prob. 13.6MECh. 13 - Prob. 13.7MECh. 13 - Analyzing the Inventory Turnover Ratio A...Ch. 13 - Inferring Financial Information Using the Current...Ch. 13 - Prob. 13.10MECh. 13 - Identifying Relevant Ratios Identify the ratio...Ch. 13 - Prob. 13.12MECh. 13 - Analyzing the Impact of Accounting Alternatives...Ch. 13 - Describing the Effect of Accounting Decisions on...Ch. 13 - Prob. 13.1ECh. 13 - Prob. 13.2ECh. 13 - Prob. 13.3ECh. 13 - Computing Profitability Ratios Use the information...Ch. 13 - Prob. 13.5ECh. 13 - Matching Each Ratio with Its Computational Formula...Ch. 13 - Computing and Interpreting Selected Liquidity...Ch. 13 - Prob. 13.8ECh. 13 - Prob. 13.9ECh. 13 - Prob. 13.10ECh. 13 - Prob. 13.11ECh. 13 - Prob. 13.12ECh. 13 - Prob. 13.13ECh. 13 - Prob. 13.14ECh. 13 - Analyzing the Impact of Alternative Inventory...Ch. 13 - Prob. 13.1CPCh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3CPCh. 13 - Prob. 13.4CPCh. 13 - Prob. 13.5CPCh. 13 - Prob. 13.6CPCh. 13 - Prob. 13.7CPCh. 13 - Prob. 13.1PACh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3PACh. 13 - Prob. 13.4PACh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PACh. 13 - Prob. 13.1PBCh. 13 - Prob. 13.2PBCh. 13 - Prob. 13.3PBCh. 13 - Prob. 13.4PBCh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PBCh. 13 - Prob. 13.1SDCCh. 13 - Prob. 13.2SDCCh. 13 - Prob. 13.5SDCCh. 13 - Prob. 13.6SDCCh. 13 - Prob. 13.7SDCCh. 13 - Prob. 13.1CC
Knowledge Booster
Similar questions
- 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.arrow_forwardCompute the following ratios for the most recent two years, show all values in the computations: 1.Current ratio 2.Accounts receivable turnover 3.Debt ratio(TotalLiabilities/Total Assets, as a percentage) 4.Debt-to-equity ratio Based on the results above, what conclusions can you make about the liquidity and solvency of the company?arrow_forwardPlease Complete the Following: 1. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement", use total assets on the balance sheet and net sales on the income statement for your vertical analysis. 2. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios" 3. Answer the final OBSERVATION QUESTION (listed under Ratios calculations) Consolidated Balance Sheets (USD $) 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at…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_forward1. Complete the two final columns shown beside each item in Tiger Audio’s comparative financial statements. 2-a. Which account increased by the largest dollar amount? 2-b. Which account increased by the largest percentage?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 Analysis Bal Sheet Inc Stmt Prepare a horizontal analysis of the balance sheet. (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).) Assets Current assets Cash Marketable securities Accounts receivable (net) Inventories ALLENDALE COMPANY Horizontal Analysis of Balance Sheets Year 4 Prepaid items Total current assets Investments Plant (net) Land Total assets Liabilities and Stockholders' Equity Liabilities Current liabilities Notes payable Accounts payable Salaries payable Total current liabilities Noncurrent liabilities Bonds payable Other Total noncurrent liabilities Total liabilities Stockholders' equity Preferred stock (par value $10, 4% cumulative, nonparticipating; 8,000 shares authorized and issued) Common stock (no par; 50,000 shares authorized;…arrow_forward
- Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your percentage answers to 2 decimal places. (i.e., 0.2345 should be entered as 23.45).) Assets Current assets Cash Marketable securities Accounts receivable (net) Inventories Prepaid items Total current assets Investments Plant (net) Land Total long-term assets Total assets Liabilities and stockholders' equity Lishilitinn WALTON COMPANY Vertical Analysis of Balance Sheets Year 4 $ Amount 17,800 21,300 55,100 136,900 25,700 256,800 27,600 270,600 30,300 328,500 585,300 Percentage of Total % $ $ Amount Year 3 13,700 6,800 47,500 144,700 10,500 223,200 21,100 256,000 24,900 302,000 525,200 Percentage of Total %arrow_forwardThe following financial statements apply to Jordan Company: Year 2 Year 1 Revenues $ 220,000 $ 180,300 Expenses Cost of goods sold 125,200 102,300 Selling expenses 21,000 19,000 General and administrative expenses 10,500 9,500 Interest expense 1,100 1,100 Income tax expense 19, 200 17, 200 Total expenses 177,000 149, 100 Net income $ 43,000 $ 31, 200 Assets Current assets Cash $ $ 7,500 5,800 1,700 1,700 Marketable securities Accounts receivable Inventories 35,300 30,800 101,500 94,000 Prepaid expenses 4,700 3,700 Total current assets 149,000 137,700 Plant and equipment (net) 105,400 105,400 Intangibles 22,000 0 Total assets $ 276,400 $ 243,100 Liabilities and Stockholders' Equity Liabilities Current liabilities Accounts payable $ 39,000 $ 34,000 Other 15,800 16,100 Total current liabilities 54,800 50, 100 Bonds payable 65,700 66,700 Total liabilities 120,500 116,800 Stockholders' equity 114,100 114, 100 Common stock (49,000 shares) Retained earnings 41,800 12,200 Total stockholders'…arrow_forwardRequirements: a. Prepare horizontal analysis based on the above statements presented (for percent: round of your answers to 2 decimal places) Music Lover, Inc.xlsx b. Evaluate the company's financial position and results of operation using the comparative statement analysis i. Short-term solvency analysis ii. Long-term financial position analysis iii. Operating efficiency and profitability analysisarrow_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 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…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_forwardRequired 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. 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