Question
In: Accounting
Prepare a horizontal analysis of revenues and gross profit—both in dollar amounts and in percentages—for 2019...
Prepare a horizontal analysis of revenues and gross profit—both in
dollar amounts and in percentages—for 2019 and 2018.
In millions)
2019 2018 2017
Revenue $9,575 $9,300 $8,975
Cost of Goods Sold 6,250 6,000 5,890
Begin by calculating the gross profit for each year, then prepare a horizontal analysis of revenues and gross profit—both in dollar amounts and in percentages—for 2019 and 2018. (Enter amounts in millions as provided to you in the problem statement. Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.)
Solutions
Expert Solution
(a)
Gross Profit for 2019 = $3325
Gross Profit for 2018 = $3300
Calculation of Gross Profit:
| Particulars | 2019 | 2018 | 2017 |
| Revenue (a) | 9,575 | 9,300 | 8,975 |
| Cost of Goods Sold (b) | 6,250 | 6,000 | 5,890 |
| Gross Profit (a - b) | 3,325 | 3,300 | 3,085 |
(b)
There has been decrease in Revenue during 2019 as compared to 2018. The total increase in revenue during 2019 is $275 against $325 during 2018. In percentage terms, the increase in revenue during 2019 is 3.0% against 3.6% during 2018.
Further, There has been decrease in Gross Profit during 2019 as compared to 2018. The total increase in gross profit during 2019 is $25 against $215 during 2018. In percentage terms, the increase in gross profit during 2019 is 0.8% against 7.0% during 2018.
Analysis:
| Particulars | 2019 | 2018 | ||
|
Increase / (Decrease) in Revenue (c) Formula: Revenue in Current Year - Revenue in previous year |
(9575 - 9300) | 275 | (9300 - 8975) | 325 |
| %
Increase / (Decrease) in Revenue Formula: Increase in Revenue as per (c) / Revenue during previous year |
(275 / 9300) | 3.0% | (325 / 8975) | 3.6% |
| Increase
/ (Decrease) in Gross Profit (d) Formula: Gross Profit in Current Year - Gross Profit in previous year |
(3325 - 3300) | 25 | (3300 - 3085) | 215 |
| %
Increase / (Decrease) in Gross Profit Formula: Increase in Gross Profit as per (d) / Gross Profit during previous year |
(25 / 3300) | 0.8% | (215 / 3085) | 7.0% |
ekkarill92 answered 1 year agoRelated Solutions
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and
income statement.
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).)
ADAMS COMPANY
Horizontal Analysis of Balance
Sheets
2019
2018
Percentage Change
Assets
Current assets
Cash
$16,700
$12,100
%
Marketable securities
20,200
7,400
Accounts receivable (net)
54,900
47,600
Inventories
135,200
144,500
Prepaid items
25,000
10,500
Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and
income statement.
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).)
BAIRD COMPANY
Horizontal Analysis of Balance
Sheets
2019
2018
Percentage Change
Assets
Current assets
Cash
$17,600
$12,200
%
Marketable securities
21,000
6,200
Accounts receivable (net)
54,700
46,800
Inventories
136,500
143,300
Prepaid items
26,500
11,800
Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and
income statement.
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).)
THORNTON COMPANY
Horizontal Analysis of Balance
Sheets
2019
2018
Percentage Change
Assets
Current assets
Cash
$16,700
$12,200
%
Marketable securities
21,300
7,500
Accounts receivable (net)
54,100
46,500
Inventories
136,100
144,600
Prepaid items
26,300
10,400
Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Analysis Bal Sheet...
Prepare a horizontal analysis of both the balance sheet and
income statement. Analysis Bal Sheet Analysis Inc Stmt Complete
this question by entering your answers in the tabs below. 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).) Analysis Bal Sheet
Analysis Inc Stmt $ $ $ $ $ $ $ $ STUART COMPANY Horizontal
Analysis...
Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base....
Prepare a horizontal analysis of the balance sheet data for
Nike, using 2019 as a base. (Show the amount of increase or
decrease as well.)
b. Prepare a vertical analysis of the balance
sheet data for Nike for 2020.
Prepare horizontal and vertical analyses.
E13.6 (LO 2) Here are the comparative income
statements of Delaney Corporation.
Delaney Corporation
Comparative Income Statements
For the Years Ended December 31
2020
2019
Net sales
$598,000
$500,000
Cost of goods...
1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following:...
1. Calculate Revenues, COGS, Gross Profit and Gross Margin in
year 2 based on the
following:
Yr. 1
Revenues 500
COGS 400
Gross Profit 100
Gross Margin 20%
Sales rise 5%, 3% due to increase in volume and 2% due to
increase in price. COGS is 80% variable.
2. What is the primary driver of sales growth for the following
company? Explain.
Assume COGS is 60% variable.
Yr. 1 Yr. 2
Revenues 800 850
COGS 500 519
Gross Profit...
Required Prepare a vertical analysis of both the balance sheets and income statements for 2019 and...
Required
Prepare a vertical analysis of both the balance sheets and
income statements for 2019 and 2018.
Prepare a vertical analysis of the balance sheets for 2019 and
2018. (Percentages may not add exactly due to rounding. Round your
answers to 2 decimal places. (i.e., .2345 should be entered as
23.45).)
JORDAN COMPANY
Vertical Analysis of Balance
Sheets
2019
2018
Amount
Percentage of Total
Amount
Percentage of Total
Assets
Current assets
Cash
$16,500
%
$14,000
%
Marketable securities
21,200
6,600...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal
analysis of the income statement using 2018 as a base. Neiman Corp.
Comparative Balance Sheet For the years ended December 31 2019 2018
Assets Current Assets 360 300 Plant Assets 640 500 Total Assets
1,000 800 Liabilities & Stockholders' Equity Current
liabilities 150 120 Long-term debt 240 160 Common stock 350 320
Retained earnings 260 200 Total liabilities & stockholders'
equity 1,000 800
2
VERTICAL ANALYSIS
INSTRUCTIONS: Prepare a vertical analysis of the...
When revenues, costs and gross profit are recognized at the completion of the contract rather than...
When revenues, costs and gross profit are recognized at the
completion of the contract rather than periodically throughout the
contract:
a) Costs are higher and gross profit is lower
b) Either method results in the same revenues, costs and gross
profits being recognized by the end of the project.
c) Revenues are higher and gross profit is lower
d) Revenues and gross profit are higher
What is the relationship between Construction-in-progress (CIP)
and the Billings on Construction Contract account?
a)...
Construct a profit and loss statement using the following departmental figures and show the dollar amounts...
Construct a profit and loss statement using the following
departmental figures and show the dollar amounts for net sales,
total cost of goods sold, gross margin, expenses, and profit.
Gross sales $82,000
Customer returns and allowances $4,000
Inward freight $2,000
Workroom costs $1,000
Opening inventory at cost $17,000
Closing inventory at cost $14,000
Purchases at cost $36,000
Cash discounts 8%
Advertising $5,000
Rent $12,000
Salaries $17,000
Miscellaneous expenses $2,500
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In 600 words or more, Apply the multidimensional framework of the balance scorecard on any organisation....
- This week, we cover Trade and Externalities. Choose whichever topic you found of most interest (trade...
- PLEASE CREATE A PROGRAM IN PSEUDOCODE AND C# Back in my Day! Kids who grew up in...
- how does diversity affect the organization's work/ life balance, and what ethical considerations exist that may...
- How applied mechanics terminologies such as moment, moment of inertia and frictional matters are involved to...
- What is the proper way to define an assembly code in in-line assembler x86 for this...
- Use the Voltage data to test the claim that home voltages and generator voltages are from...
ADVERTISEMENT