ACCOUNTING
docx
keyboard_arrow_up
School
Dedan Kimathi University of Technology *
*We aren’t endorsed by this school
Course
8110
Subject
Finance
Date
Nov 24, 2024
Type
docx
Pages
6
Uploaded by rosewachiranjeri
Annual Income Statement (values in 000's)
Get Quarterly Data
Period Ending:
Trend
1/31/2019
1/31/2018
1/31/2017
1/31/2016
Total Revenue
$514,405,000 $500,343,000 $485,873,000 $482,130,000
Cost of Revenue
$385,301,000 $373,396,000 $361,256,000 $360,984,000
Gross Profit
$129,104,000 $126,947,000 $124,617,000 $121,146,000
Operating Expenses
Research and Development
$0
$0
$0
$0
Sales, General and Admin.
$107,147,000 $106,510,000 $101,853,000 $97,041,000
Non-Recurring Items
$0
$0
$0
$0
Other Operating Items
$0
$0
$0
$0
Operating Income
$21,957,000
$20,437,000
$22,764,000
$24,105,000
Add'l income/expense items
($8,151,000) ($2,984,000) $100,000
$81,000
Earnings Before Interest and
Tax
$13,806,000
$17,453,000
$22,864,000
$24,186,000
Interest Expense
$2,346,000
$2,330,000
$2,367,000
$2,548,000
Earnings Before Tax
$11,460,000
$15,123,000
$20,497,000
$21,638,000
Income Tax
$4,281,000
$4,600,000
$6,204,000
$6,558,000
Minority Interest
($509,000)
($661,000)
($650,000)
($386,000)
Equity Earnings/Loss
Unconsolidated Subsidiary
$0
$0
$0
$0
Net Income-Cont. Operations
$6,670,000
$9,862,000
$13,643,000
$14,694,000
Net Income
$6,670,000
$9,862,000
$13,643,000
$14,694,000
Net Income Applicable to
Common Shareholders
$6,670,000
$9,862,000
$13,643,000
$14,694,000
See also:
Company Financials
data entry page
\
Statement of Financial Position, Liabilities and Stockholders’ Equity
Difficulty: Beginner
Annual Data
Quarterly Data
The statement of financial position provides creditors, investors, and analysts with information
on company’s resources (assets) and its sources of capital (its equity and liabilities). It normally
also provides information about the future earnings capacity of a company’s assets as well as an
indication of cash flows that may come from receivables and inventories.
Liabilities represents obligations of a company arising from past events, the settlement of which
is expected to result in an outflow of economic benefits from the entity.
See Also:
Amazon.com Inc. (AMZN), Liabilities and Stockholders’ Equity
Home Depot Inc. (HD), Liabilities and Stockholders’ Equity
Netflix Inc. (NFLX), Liabilities and Stockholders’ Equity
Show More
Walmart Inc., Consolidated Statement of Financial Position, Liabilities and Stockholders’
Equity
USD $ in millions
Jan 31, 2019
Jan 31, 2018
Jan 31, 2017
Jan 31, 2016
Jan 31, 2015
Jan 31, 2014
Short-term borrowings 5,225
5,257
1,099
2,708
1,592
7,670
Accounts payable 47,060 46,092 41,433 38,487 38,410 37,415
Accrued wages and benefits 6,504 6,998 6,105 5,814 4,954 4,652
Self-insurance 3,979 3,737 3,922 3,414 3,306 3,477
Accrued non-income taxes 2,979 3,073 2,816 2,544 2,592 2,554
Deferred gift card revenue 1,932 2,017 1,856 — — —
Other 6,765 6,297 5,955 7,835 8,300 8,110
Accrued liabilities 22,159
22,122
20,654
19,607
19,152
18,793
Accrued income taxes 428 645 921 521 1,021 966
Long-term debt due within one year 1,876 3,738 2,256 2,745 4,810 4,103
Capital lease and financing obligations due within one year 729 667 565 551 287 309
Current liabilities of discontinued operations — — — — — 89
Current liabilities 77,477
78,521
66,928
64,619
65,272
69,345
Long-term debt, excluding due within one year 43,520 30,045 36,015 38,214 41,086 41,771
Long-term capital lease and financing obligations,
excluding due within one year
6,683 6,780 6,003 5,816 2,606 2,788
Deferred income taxes and other 11,981 8,354 9,344 7,321 8,805 8,017
Long-term liabilities 62,184
45,179
51,362
51,351
52,497
52,576
Total liabilities
139,661
123,700
118,290
115,970
117,769
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
121,921
Redeemable noncontrolling interest — — — — — 1,491
Common stock 288 295 305 317 323 323
Capital in excess of par value 2,965 2,648 2,371 1,805 2,462 2,362
Retained earnings 80,785 85,107 89,354 90,021 85,777 76,566
Accumulated other comprehensive loss
(11,542) (10,181) (14,232) (11,597) (7,168) (2,996)
Total Walmart shareholders’ equity
72,496
77,869
77,798
80,546
81,394
76,255
Nonredeemable noncontrolling interest 7,138 2,953 2,737 3,065 4,543 5,084
Total equity
79,634
80,822
80,535
83,611
85,937
81,339
Total liabilities, redeemable noncontrolling interest, and equity
219,295
204,522
198,825
199,581
203,706
204,751
Based on:
10-K (filing date: 2019-03-28)
,
10-K (filing date: 2018-03-30)
,
10-K (filing date: 2017-03-31)
,
10-K
(filing date: 2016-03-30)
,
10-K (filing date: 2015-04-01)
,
10-K (filing date: 2014-03-21)
.
Walmart Inc., Liabilities and Stockholders’ Equity, Selected ItemsCurrent liabilitiesLong-term
liabilitiesTotal liabilities1/2Jan 31, 2014Jan 31, 2015Jan 31, 2016Jan 31, 2017Jan 31, 2018Jan 31,
2019020,00040,00060,00080,000100,000120,000140,000USD $ in millions
Date
Current
liabilities
Long-term liabilities
Total liabilities
Total Walmart shareholders’
equity
Jan 31,
2014
69,345
52,576
121,921
76,255
Jan 31,
2015
65,272
52,497
117,769
81,394
Jan 31,
2016
64,619
51,351
115,970
80,546
Jan 31,
2017
66,928
51,362
118,290
77,798
Jan 31,
2018
78,521
45,179
123,700
77,869
Jan 31,
2019
77,477
62,184
139,661
72,496
Item
Description
The company
Current liabilities
Total obligations incurred as part of
normal operations that are
expected to be paid during the
following twelve months or within
one business cycle, if longer.
Walmart Inc.’s current liabilities
increased from 2017 to 2018 but
then slightly declined from 2018 to
2019.
Long-term liabilities
Amount of obligation due after one
year or beyond the normal
operating cycle, if longer.
Walmart Inc.’s long-term liabilities
declined from 2017 to 2018 but
then increased from 2018 to 2019
exceeding 2017 level.
Total liabilities
Sum of the carrying amounts as of
the balance sheet date of all
liabilities that are recognized.
Walmart Inc.’s total liabilities
increased from 2017 to 2018 and
Date
Current
liabilities
Long-term liabilities
Total liabilities
Total Walmart shareholders’
equity
Liabilities are probable future
sacrifices of economic benefits
arising from present obligations of
an entity to transfer assets or
provide services to other entities in
the future.
from 2018 to 2019.
Total Walmart shareholders’
equity
Total of all stockholders’ equity
(deficit) items, net of receivables
from officers, directors, owners, and
affiliates of the entity which are
attributable to the parent. The
amount of the economic entity’s
stockholders’ equity attributable to
the parent excludes the amount of
stockholders’ equity which is
allocable to that ownership interest
in subsidiary equity which is not
attributable to the parent
(noncontrolling interest, minority
interest). This excludes temporary
equity and is sometimes called
permanent equity.
Walmart Inc.’s total Walmart
shareholders’ equity increased from
2017 to 2018 but then declined
significantly from 2018 to 2019.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
不
Net sales, net income, and total assets for Alex Shipping, Inc., for a five-year period follow:
(Click the icon to view the data.)
Read the requirements.
Requirement 1. Calculate trend percentages for each item for 2018 through 2021. Use 2017 as the base year and round to the nearest percent.
Alex Shipping, Inc. - Trend Percentages
Net sales
Net income
Total assets
2021
2020
2019
2018
2017
199 %
161 %
115%
99%
100%
100 %
146 %
100%
123%
34 %
94%
100%
124 %
108 %
100%
Requirement 2. Calculate the rate of return on net sales for 2019 through 2021, rounding to the nearest one-tenth percent. Explain what this means.
Begin by selecting the rate of return on net sales (return on sales) formula and enter the amounts to calculate the percentages. (Enter amounts in thousands as provided to you in the
problem statement. Complete all input fields. Enter "O" for any zero amounts and enter the return on sales amounts as percentages rounded to one-tenth percent, XX%.)
)
2019
2020
2021
(
(
Net…
arrow_forward
Computing trend analysis
Grand Oaks Realty’s net revenue and net income for the following five—year period, using 2015 as the base year, follow:
Requirements
Compute a trend analysis for net revenue and net income. Round to the nearest full percent.
Which grew faster during the period, net revenue or net income?
arrow_forward
The trend analysis report of Poplar, Inc. is given below (in millions):
2019
2018
2017
2016
2015
Net income
$700
$606
$470
$405
$402
Trend percentages
174%
151%
117%
101%
100%
Which of the following is a correct conclusion from the above analysis?
Select one:
A.
Net income for 2018 decreased by 151% from 2017.
B.
Net income for 2019 increased by 174% from 2018.
C.
Net income for 2019 is 174% of net income for 2015.
D.
Net income for 2018 is 151% of the previous year.
The financial statements for Silver Service Company include the following items:
2019
2018
Cash
$49,500
$40,000
Short-term Investments
33,000
20,500
Net Accounts Receivable
52,000
53,000
Merchandise Inventory
132,000
45,000
Total Assets
530,000
547,000
Accounts Payable
131,500
122,000
Salaries Payable
15,000
18,000
Long-term Note Payable
58,000
57,000
Compute the acid-test ratio for 2018.…
arrow_forward
Here are the abbreviated financial statements for Planner’s Peanuts:
INCOME STATEMENT, 2019
Sales
$ 8,600
Cost
7,100
Net income
$ 1,500
BALANCE SHEET, YEAR-END
2018
2019
2018
2019
Assets
$ 6,500
$ 7,000
Debt
$ 853
$ 1,000
Equity
5,647
6,000
Total
$ 6,500
$ 7,000
Total
$ 6,500
$ 7,000
Assume the payout ratio is 50%.
Calculate the internal growth rate where no external debt or equity is to be issued.
Note: Do not round intermediate calculations. Enter your answer as a whole percent.
Calculate the sustainable growth rate where the firm maintains a fixed debt ratio but issues no equity.
Note: Do not round intermediate calculations. Enter your answer as a whole percent.
arrow_forward
Sales
Cost of goods sold
Accounts receivable
2021
$ 676,574
333,971
32,679
2020
$ 439,334
216,824
25,657
2019
$ 340,569
170,229
23,363
2018
$ 237,330
117,892
13,860
2017
$ 175,800
86,142
12,060
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the
situation as revealed by the trend percents appears to be favorable or unfavorable.
2021:
2020:
2019:
2018:
2017:
Trend Percent for Net Sales:
Numerator:
Denominator:
=
Trend percent
=
%
Is the trend percent for Net Sales favorable or unfavorable?
2021:
2020:
2019:
2018:
2017:
Trend Percent for Cost of Goods Sold:
Numerator:
Denominator:
Trend percent
Is the trend percent for Cost of Goods Sold favorable or unfavorable?
%
arrow_forward
2021 2020 2019 2018 2017
Sales $ 489,967 $ 322,347 $ 256,850 $ 180,880 $ 136,000
Cost of goods sold 252,383 166,097 134,444 94,199 69,360
Accounts receivable 23,763 18,857 17,594 10,600 9,302
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
arrow_forward
The trend analysis report of Poplar, Inc. is given below (in millions):
2019 2018 2017 2016 2015
Net income
Trend percentages
$700 $606 $470 $405 $402
174% 151% 117% 101% 100%
Which of the following is a correct conclusion from the above analysis?
Net income for 2019 is 174% of net income for 2015.
Net income for 2018 is 151% of the previous year.
Net income for 2019 increased by 174% from 2018.
Net income for 2018 decreased by 151% from 2017.
arrow_forward
Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
arrow_forward
Here are the abbreviated financial statements for Planner’s Peanuts:
INCOME STATEMENT, 2019
Sales
$
3,500
Cost
2,700
Net income
$
800
BALANCE SHEET, YEAR-END
2018
2019
2018
2019
Assets
$
4,500
$
5,000
Debt
$
833
$
1,000
Equity
3,667
4,000
Total
$
4,500
$
5,000
Total
$
4,500
$
5,000
Assume the payout ratio is 50%.
a. Calculate the internal growth rate where no external debt or equity is to be issued. (Do not round intermediate calculations. Enter your answer as a whole percent.)
b. Calculate the sustainable growth rate where the firm maintains a fixed debt ratio but issues no equity. (Do not round intermediate calculations. Enter your answer as a whole percent.)
arrow_forward
Gross Profit Percentage
Calculate the company's 2020 gross profit percentage and compare the result to the industry average.
arrow_forward
Randall Corporation reported the following revenue data:Year Net revenues (in millions)$$$$6,8007,0046,7327,2762016201720182019Use 2016 as the base year. The trend percentage in 2019 is closest toa. 93%.b. 104%.c. 107%.d. 112%
arrow_forward
Zoobilee Inc. reported the following sales and net income amounts:
(in thousands)
2020
2019
2018
2017
9,180 $ 8,990 $ 8,770 $ 8,550
Net income
520
500
460
400
Show Zoobilee's trend percentages for sales and net income. Use 2017 as the base year.
Sales....
$
(Round your answers to the nearest percent.)
Sales..
Net income..
2020
%
%
2019
%
%
2018
%
%
2017
100 %
100 %
arrow_forward
HIC GROUP OF Companies
COMPARATIVE INCOME STATEMENT
For years ended 3rd December 2019 2020
Revenue and gains
Sales revenue 495,500 496,738.75
Interest revenue 278,500 279,196.25
Investment Income 71,700 71,879.25
Other revenue 101,500 101,753.75
Total revenue and gains 947,200 949,968
Expenses and losses
Cost of good sold 450,000 447,750
Selling&administrative 185,000 184,075
Computer (operating) 42,500 42,288…
arrow_forward
Global Corp. initially projected the 2019 income statement shown in the table E. Suppose that in 2019, Global launched an aggressive marketing campaign that boosted 2019 sales further by 14.1%. However, their operating margin fell from
5.56% to 4.49% Suppose that they had no other income, interest expenses were unchanged, and taxes were the same percentage of pretax income (26%) as in 2018.
a. What was Global's EBIT in 2019?
b. What was Global's income in 2019?
c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019?
a. What was Global's EBIT in 2019?
Global's EBIT was $
million. (Round to two decimal places.)
b. What was Global's income in 2019?
Net income was $
million. (Round to two decimal places.)
c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019?
Global's share price in 2019 was $. (Round to the nearest cent.)
arrow_forward
ss
arrow_forward
Z Plc reports its net profit for the current year and two previous years in its 2020 annual report. For the periods ended 2020, 2019, and 2018, profits were $8960, $8400, and $8000, respectively. Using this information determine the percentage change in profit from 2018 to 2019.
5%
6.67%
12%
6%
arrow_forward
Calculate the Sales Growth of the most recent year. Enter answer as decimal (not percent. Example: .1234 is ok, 12.34% is not ok).
arrow_forward
Calculate average receivable turnover
arrow_forward
Projecting NOPAT and NOA Using Parsimonious Forecasting Method
Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands).
Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places.
Financial information
Net sales
$2,091,242
Net operating profit after tax (NOPAT) 158,522
Net operating assets (NOA)
428,867
Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions.
Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into
the provided spaces below with two decimal places..
Note: When completing the question…
arrow_forward
2021
2020
2019
2018
2017
Sales
Cost of goods sold
Accounts receivable
$ 479,191
246,837
23,289
$ 315,257
$ 247,260 $ 167,634
$ 120,600
162,481
18,379
129,153
16,888
87,443
9,807
61,506
8,249
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three acco
situation as revealed by the trend percents appears to be favorable or unfavorable.
2021:
2020:
2019:
2018:
2017:
Trend Percent for Net Sales:
Numerator:
1
Denominator:
1
1
Is the trend percent for Net Sales favorable or unfavorable?
2021:
2020:
2019:
2018:
2017:
Trend Percent for Cost of Goods Sold:
Numerator:
Denominator:
1
1
1
Is the trend percent for Cost of Goods Sold favorable or unfavorable?
2021:
2020:
2019:
2018:
2017:
Trend Percent for Accounts Receivable:
Numerator:
Denominator:
Is the trend percent for Accounts Receivable favorable or unfavorable?
=
Trend percent
%
9900
=
%
=
%
=
%
%
Trend percent
%
%
%
%
%
11
Trend percent
=
%
%
%
=
%
%
arrow_forward
Here are the abbreviated financial statements for Planner's Peanuts:
INCOME STATEMENT, 2019
Sales
Cost
$ 9,000
7,100
Net income
$ 1,900
BALANCE SHEET, YEAR-END
2018
Assets
$ 6,500
2019
$ 9,500
Total
$ 6,500
$ 9,500
Debt
Equity
Total
2018
$ 853
2019
$1,000
5,647
$6,500 $9,500
8,500
a. If sales increase by 25% In 2020 and the company uses a strict percentage of sales planning model (meaning that all items on the
Income and balance sheet also increase by 25%), what must be the balancing item?
b. What will be the value of this balancing item?
Answer is not complete.
a.
Balancing item
Dividends
b.
Value
arrow_forward
Selected financial information for Trant Corporation is presented below.Prepare a schedule showing a horizontal analysis for 2020 using 2019 as the base year. (Round percentage answers to 0 decimal places, e.g. 15%.)
Increase or (Decrease)
Dec. 31, 2020
Dec. 31, 2019
Amount
Percentage
Current assets
$ 55,000
$ 40,000
$
%
Long-term liabilities
90,000
80,000
%
Retained earnings
125,000
100,000
%
arrow_forward
Selected information from Bigg Company's financial statements follows:
Fiscal Year Ended December 31
2019
2018(in thousands)
2017
Gross sales
$2,004,719
$1,937,021
$1,835,987
Less: Sales discounts
4,811
4,649
4,406
Less: Sales returns and allowances
2,406
2,324
2,203
Net sales
$1,997,502
$1,930,048
$1,829,378
Cost of goods sold
621,463
619,847
660,955
Gross profit
$1,376,039
$1,310,201
$1,168,423
Operating expenses
577,369
595,226
583,555
Operating income
$798,670
$714,975
$584,868
Other income (expenses)
15,973
(6,140)
(8,773)
Net income
$814,643
$708,835
$576,095
At December 31
2019
2018(in thousands)
2017
Accounts receivable
$201,290
$195,427
$182,642
Less: Allowance for doubtful accounts
2,516
2,736
2,192
Net accounts receivable
$198,774
$192,691
$180,450
Required:
1. Calculate the following ratios for 2018 and 2019. Round your answers…
arrow_forward
Operating data for Joshua Corporation are presented below.
2020
2019
Sales revenue
$ 755,000
$ 604,000
Cost of goods sold
464,325
386,560
Selling expenses
118,535
75,500
Administrative expenses
58,135
54,360
Income tax expense
37,750
24,764
Net income
76,255
62,816
Prepare a schedule showing a vertical analysis for 2020 and 2019. (Round answers to 1 decimal place, e.g. 48.5%.)
arrow_forward
What is the return on sales for fiscal year 2019 2018?
arrow_forward
2021
2020
2019
2018
2017
$ 394,032
199,466
19,071
$ 262,688
132,894
15,394
$ 205,225
$ 150,348
76,774
8,780
$ 112,200
56,100
Sales
Cost of goods sold
Accounts receivable
106,013
14,058
7,708
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the
situation as revealed by the trend percents appears to be favorable or unfavorable.
Trend Percent for Net Sales:
Numerator:
Denominator:
Trend percent
2021:
%
2020:
%
2019:
%
%3D
2018:
%
=
2017:
%
Is the trend percent for Net Sales favorable or unfavorable?
Trend Percent for Cost of Goods Sold:
Numerator:
Denominator:
Trend percent
%3D
2021:
%
2020:
%
2019:
%
%3D
2018:
%
=
2017:
%3D
Is the trend percent for Cost of Goods Sold favorable or unfavorable?
Trend Percent for Accounts Receivable:
Numerator:
Denominator:
Trend percent
%3D
2021:
%
2020:
%
%3D
2019:
%
=
2018:
%
2017:
%
%3D
Is the trend percent for Accounts Receivable favorable or unfavorable?
II
II
IL ||
II
arrow_forward
Examine the selected data over the 5-year period as shown in the table below for Dumbledore
Ltd.
Item
Sales
Cost of sales
EBIT
Interest
NPAT
Current assets
Total assets
current liabilities
Total liabilities
Equity
Gross margin
Interest coverage
Current ratio
2021
$m
286.41
180.03
51.18
37.07
35.13
43.85
226.18
55.99
98.99
127.19
0.37
1.38
0.78
Year
2020
$m
280.80
166.69
51.08
33.70
35.10
43.20
221.75
53.58
91.66
130.09
0.41
1.52
0.81
2019
$m
275.29
154.35
50.98
30.64
35.06
42.56
217.40
51.27
84.87
132.53
0.44
1.66
0.89
2018
$m
269.89
142.91
50.88
27.85
35.03
41.93
213.13
49.06
78.58
134.56
0.47
1.83
U.OJ
2017
$m
264.60
134.19
49.88
25.32
34.51
41.31
206.93
47.40
74.48
132.44
0.49
1.97
0.87
2016
$m
252.00
126.00
48.90
24.00
34.00
40.70
200.90
45.80
70.60
130.30
0.50
2.04
0.89
arrow_forward
Assume this is a partial list of financial highlights from a Best Buy annual report:
2019
2020
(dollars in millions).
$ 37,580 $ 33,075
1,283
891
2,231
1,318.
Net sales
Earnings before taxes
Net earnings
Complete a horizontal and vertical analysis from the above information. (Enter your answers in millions. Round the "percent"
answers to the nearest hundredth percent.)
Net sales
Earnings before taxes
Net earnings
2020
Horizontal analysis
2019
Increase
Percent
Vertical analysis
2020
%
%
%
2019
+
%
%
%
arrow_forward
Check
Sales
Cost of goods sold
Accounts receivable
2021
2020
$ 459,829
223,168
22,256
$ 298,590
145,023
17,497
2019
$ 244,746
120,478
16,692
2018
$ 168,210
81,991
9,840
2017
$ 124,600
59,808
8,548
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts,
the situation as revealed by the trend percents appears to be favorable or unfavorable.
2021:
2020:
2019:
2018:
2017:
Numerator:
Trend Percent for Net Sales:
Denominator:
Is the trend percent for Net Sales favorable or unfavorable?
21:
20:
19:
Trend Percent for Cost of Goods Sold:
Numerator:
Denominator:
< Prev
1 of 1
Next
Trend percent
%
11
11
%
%
=
%
%
=
Trend percent
=
%
=
%
=
%
Ո
arrow_forward
Need help provide correct answer general accounting
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- 不 Net sales, net income, and total assets for Alex Shipping, Inc., for a five-year period follow: (Click the icon to view the data.) Read the requirements. Requirement 1. Calculate trend percentages for each item for 2018 through 2021. Use 2017 as the base year and round to the nearest percent. Alex Shipping, Inc. - Trend Percentages Net sales Net income Total assets 2021 2020 2019 2018 2017 199 % 161 % 115% 99% 100% 100 % 146 % 100% 123% 34 % 94% 100% 124 % 108 % 100% Requirement 2. Calculate the rate of return on net sales for 2019 through 2021, rounding to the nearest one-tenth percent. Explain what this means. Begin by selecting the rate of return on net sales (return on sales) formula and enter the amounts to calculate the percentages. (Enter amounts in thousands as provided to you in the problem statement. Complete all input fields. Enter "O" for any zero amounts and enter the return on sales amounts as percentages rounded to one-tenth percent, XX%.) ) 2019 2020 2021 ( ( Net…arrow_forwardComputing trend analysis Grand Oaks Realty’s net revenue and net income for the following five—year period, using 2015 as the base year, follow: Requirements Compute a trend analysis for net revenue and net income. Round to the nearest full percent. Which grew faster during the period, net revenue or net income?arrow_forwardThe trend analysis report of Poplar, Inc. is given below (in millions): 2019 2018 2017 2016 2015 Net income $700 $606 $470 $405 $402 Trend percentages 174% 151% 117% 101% 100% Which of the following is a correct conclusion from the above analysis? Select one: A. Net income for 2018 decreased by 151% from 2017. B. Net income for 2019 increased by 174% from 2018. C. Net income for 2019 is 174% of net income for 2015. D. Net income for 2018 is 151% of the previous year. The financial statements for Silver Service Company include the following items: 2019 2018 Cash $49,500 $40,000 Short-term Investments 33,000 20,500 Net Accounts Receivable 52,000 53,000 Merchandise Inventory 132,000 45,000 Total Assets 530,000 547,000 Accounts Payable 131,500 122,000 Salaries Payable 15,000 18,000 Long-term Note Payable 58,000 57,000 Compute the acid-test ratio for 2018.…arrow_forward
- Here are the abbreviated financial statements for Planner’s Peanuts: INCOME STATEMENT, 2019 Sales $ 8,600 Cost 7,100 Net income $ 1,500 BALANCE SHEET, YEAR-END 2018 2019 2018 2019 Assets $ 6,500 $ 7,000 Debt $ 853 $ 1,000 Equity 5,647 6,000 Total $ 6,500 $ 7,000 Total $ 6,500 $ 7,000 Assume the payout ratio is 50%. Calculate the internal growth rate where no external debt or equity is to be issued. Note: Do not round intermediate calculations. Enter your answer as a whole percent. Calculate the sustainable growth rate where the firm maintains a fixed debt ratio but issues no equity. Note: Do not round intermediate calculations. Enter your answer as a whole percent.arrow_forwardSales Cost of goods sold Accounts receivable 2021 $ 676,574 333,971 32,679 2020 $ 439,334 216,824 25,657 2019 $ 340,569 170,229 23,363 2018 $ 237,330 117,892 13,860 2017 $ 175,800 86,142 12,060 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. 2021: 2020: 2019: 2018: 2017: Trend Percent for Net Sales: Numerator: Denominator: = Trend percent = % Is the trend percent for Net Sales favorable or unfavorable? 2021: 2020: 2019: 2018: 2017: Trend Percent for Cost of Goods Sold: Numerator: Denominator: Trend percent Is the trend percent for Cost of Goods Sold favorable or unfavorable? %arrow_forward2021 2020 2019 2018 2017 Sales $ 489,967 $ 322,347 $ 256,850 $ 180,880 $ 136,000 Cost of goods sold 252,383 166,097 134,444 94,199 69,360 Accounts receivable 23,763 18,857 17,594 10,600 9,302 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.arrow_forward
- The trend analysis report of Poplar, Inc. is given below (in millions): 2019 2018 2017 2016 2015 Net income Trend percentages $700 $606 $470 $405 $402 174% 151% 117% 101% 100% Which of the following is a correct conclusion from the above analysis? Net income for 2019 is 174% of net income for 2015. Net income for 2018 is 151% of the previous year. Net income for 2019 increased by 174% from 2018. Net income for 2018 decreased by 151% from 2017.arrow_forwardComputing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.arrow_forwardHere are the abbreviated financial statements for Planner’s Peanuts: INCOME STATEMENT, 2019 Sales $ 3,500 Cost 2,700 Net income $ 800 BALANCE SHEET, YEAR-END 2018 2019 2018 2019 Assets $ 4,500 $ 5,000 Debt $ 833 $ 1,000 Equity 3,667 4,000 Total $ 4,500 $ 5,000 Total $ 4,500 $ 5,000 Assume the payout ratio is 50%. a. Calculate the internal growth rate where no external debt or equity is to be issued. (Do not round intermediate calculations. Enter your answer as a whole percent.) b. Calculate the sustainable growth rate where the firm maintains a fixed debt ratio but issues no equity. (Do not round intermediate calculations. Enter your answer as a whole percent.)arrow_forward
- Gross Profit Percentage Calculate the company's 2020 gross profit percentage and compare the result to the industry average.arrow_forwardRandall Corporation reported the following revenue data:Year Net revenues (in millions)$$$$6,8007,0046,7327,2762016201720182019Use 2016 as the base year. The trend percentage in 2019 is closest toa. 93%.b. 104%.c. 107%.d. 112%arrow_forwardZoobilee Inc. reported the following sales and net income amounts: (in thousands) 2020 2019 2018 2017 9,180 $ 8,990 $ 8,770 $ 8,550 Net income 520 500 460 400 Show Zoobilee's trend percentages for sales and net income. Use 2017 as the base year. Sales.... $ (Round your answers to the nearest percent.) Sales.. Net income.. 2020 % % 2019 % % 2018 % % 2017 100 % 100 %arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education