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.3E
1)
To determine
To Conduct: A Horizontal analysis by calculating the year-over-year changes of Incorporation CTand the effect of change in computer price comparing to the changes in Incorporation CT’s total revenue, cost of crude oil and products.
2)
To determine
vertical analysis by expressing each line as a percentage of total revenues and to find out whether Incorporation CT earned more sales in 20 l3 compared to 2012.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
7
According to the producer price index database maintained by the Bureau of Labor Statistics, the average
cost of computer equipment fell 3.8 percent between January and December 2016. Let's see whether these
changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31,
2016.
2016
2015
Sales Revenue
$113,000
66,500
46,500
$139,500
76,700
62,800
Cost of Goods Sold
Gross Profit
Вook
Selling, General, and Administrative
Expenses
Interest Expense
Income before Income Tax Expense
Income Tax Expense
37,300
39,600
630
540
Hint
8,570
2,000
$ 6,570
22,660
6,300
$ 16,360
Print
Net Income
erences
Required:
1. Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the
beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each
dollar of sales in 2017?
2. Compute the net profit margin for each year. Given your calculations here and in requirement 1, explain
whether Computer…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment
fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of
Wizard Computers for the year ended December 31, 2018.
Sales Revenue
Cost of Goods Sold
Gross Profit
Selling, General, and Administrative Expenses
Interest Expense
Income before Income Tax Expense
Income Tax Expense
Net Income
Required:
2018
$ 114,000
67,000
2017
$ 141,000
77,100
47,000
63,900
37,400
39,800
640
545
8,960
2,000
23,555
6,400
$ 6,960
$ 17,155
1. Compute the times interest earned ratios for 2018 and 2017.
2. Does Wizard generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing?
Complete this question by entering your answers in the tabs below.
Required 1 Required 2
Compute the times interest earned ratios for 2018 and 2017. (Round your answers to 1 decimal place.)
Times…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment
fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of
Gonzalez Industries for the year ended December 31, 2018.
Sales Revenue
Cost of Goods Sold
Gross Profit
Selling, General, and Administrative Expenses
Interest Expense
Income before Income Tax Expense
Income Tax Expense
Net Income
Required 1
Required 2 Required 3
2018
$ 105,000
62,500
Required:
1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend,
is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019?
2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018
relative to 2017?
3. Gonzalez reported average net fixed assets of $54,700 in 2018 and $45,600 in…
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Wizard Computers for the year ended December 31, 2018. 2018 2017 Sales Revenue $ 118,000 $ 147,000 Cost of Goods Sold 69,000 78,700 Gross Profit 49,000 68,300 Selling, General, and Administrative Expenses 37,800 40,600 Interest Expense 680 565 Income before Income Tax Expense 10,520 27,135 Income Tax Expense 2,500 6,800 Net Income $ 8,020 $ 20,335 Required: Compute the times interest earned ratios for 2018 and 2017. Does Wizard generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing? yes or noarrow_forwardAccording to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required 2 2018 $ 117,000 68,500 48,500 37,700 Year 670 10, 130 2,500 $ 7,630 2017 2018 2017 $ 145,500 Required: 1. Compute the times interest earned ratios for 2018 and 2017. 2. Does Gonzalez generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing? 78,300 67,200 40,400 Complete this question by entering your answers in the tabs below. 560 26,240 6,700 $ 19,540 Compute the times interest earned ratios for 2018 and 2017. (Round your answers to 1…arrow_forwardAccording to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required 2 Required 3 2018 $ 105,000 62,500 42,500 36,500 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018 relative to 2017? 550 5,450 1,500 $ 3,950 3. Gonzalez reported average net fixed assets…arrow_forward
- According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018 relative to 2017? Required 2 2018 $ 105,000 62,500 42,500 36,500 3. Gonzalez reported average net fixed assets of $54,700 in 2018 and $45,600 in…arrow_forwardAccording to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Required: ts 1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax, interest, and operating expenses, did Computer Tycoon earn more profit per dollar of sales in 2016 compared to 2015? еВook Hint Print Complete this question by entering your answers in the tabs below. eferences Req 1 Reg 2A Reg 2B Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. (Decreases…arrow_forwardCalculate gross profit, cost of goods sold, and selling price MBI, Inc., had sales of $600 million for fiscal 2016. The company’s gross profit ratio for that year was 31.2%.Required:a. Calculate the gross profit and cost of goods sold for MBI, Inc., for fiscal 2016.b. Assume that a new product is developed and that it will cost $1,634 to manufacture. Calculate the selling price that must be set for this new product if its gross profit ratio is to be the same as the average achieved for all products for fiscal 2016.c. From a management viewpoint, what would you do with this information?arrow_forward
- Ramos Company Ramos Company included the following information in its annual report: 2011 2010 2009 Sales $178,400 $162,500 $155,500 Cost of goods sold 115,000 102,500 100,000 Operating expenses 50,000 50,000 45,000 Net income 13,400 10,000 10,500 Refer to the information for Ramos Company. In a common size income statement for 2011, the operating expenses are expressed as: Group of answer choices 100 % 50.6 % 30.3 % 28.0 %arrow_forwardThe following data have been taken from the records of a company: Production in units during 2011 200,000 Units sold during 2011 190,000 Selling Price per unit P 15.00 Standard Variable Costs per unit Material and Labor P 8.00 Indirect Manufacturing Costs 2.00 Selling and Administrative expenses 1.00 Fixed Costs budgeting for the year Indirect Manufacturing Costs P 400,000 Selling & Administrative Expenses P 300,000 Required: A. Determine the income (loss) before income taxes for the year 2011 under Absorption Costing?arrow_forwardAnalyzing Operational ChangesOperating results for department B of Delta Company during 2016 are as follows: Sales $538,000 Cost of goods sold 378,000 Gross profit 160,000 Direct expenses 120,000 Common expenses 66,000 Total expenses 186,000 Net loss $(26,000) Suppose that department B could increase physical volume of product sold by 10% if it spent an additional $17,000 on advertising while leaving selling prices unchanged. What effect would this have on the department's net income or net loss? (Ignore income tax in your calculations.) Use a negative sign to indicate a net loss answer; otherwise do not use negative signs with your answers. Sales Answer Cost of goods sold Answer Gross profit Answer Direct expenses Answer Common expenses Answer Total expenses Answer Net income (loss) Answerarrow_forward
- Analyzing Operational ChangesOperating results for department B of Shaw Company during 2016 are as follows: Sales $755,000 Cost of goods sold 480,000 Gross profit 275,000 Direct expenses 215,000 Common expenses 123,000 Total expenses 338,000 Net loss $(63,000) If department B could maintain the same physical volume of product sold while raising selling prices an average of 10% and making an additional advertising expenditure of $35,000, what would be the effect on the department's net income or net loss? (Ignore income tax in your calculations.) Use a negative sign with your answer to indicate if the effect increases the company's net loss. If Department B increased its selling price by 10%, the effect on net income (loss) would be $Answerarrow_forwardThe gross profit margin excludes all costs except the cost of goods sold. If Miller Company recorded Net Sales of $17,260 for the month of March 2021, and cost of goods sold of $11,042, what is the company’s gross profit margin for the month of March. 37.4% 36% 39.2% 38.6%arrow_forwardAnalyzing Operational ChangesOperating results for department B of Delta Company during 2016 are as follows: Sales $530,000 Cost of goods sold 378,000 Gross profit 152,000 Direct expenses 120,000 Common expenses 66,000 Total expenses 186,000 Net loss $(34,000) If department B could maintain the same physical volume of product sold while raising selling prices an average of 15% and making an additional advertising expenditure of $40,000, what would be the effect on the department's net income or net loss? (Ignore income tax in your calculations.) Use a negative sign with your answer to indicate if the effect increases the company's net loss. If Department B increased its selling price by 15%, the effect on net income (loss) would be $Answer.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license