1 2 INCOME STATEMENT 3 Net sales 15 BALANCE SHEET 16 ASSETS 17 Cash and marketable securities 18 Accounts receivable 19 Inventory 20 Current assets A Land, buildings, plant, and 21 equipment 22 Accumulated depreciation 23 Net fixed assets O AVERAGE(F19:G19)*B3 none of the answers is correct. =E18*B3 =E19*B24 B O AVERAGE(F19:G19)*B24 2020 $452,500 ? 2020 с $ VALUES 2019 $390,000 2019 $37,974 10,000 D E F PERCENT OF SALES 2019 2018 % AVERAGE $327 Close find bar 00.00% 2018 % AVERAGE $154,550 28.46% 6,000 2.20% 250,000 135,000 52.66% $297,974 $295,550 83.32% $250,000 $125,000 51.14% 64.10% 38.17% 50,000 25,000 10.23% 12.82% 7.63% $200,000 $100,000 40.91% 51.28% 30.53% 24 Total assets $497,974 $395,550 124.23% 127.69% 120.78% If you apply the percent of sales method to the balance sheet shown above, what is the formula in B19 to forecast the Inventory for 2020? 100.00% 2019 9.74% 2.56% 64.10% 76.40% G 2018 100.00% 2018 47.19% 1.83% 41.22% 90.24%
1 2 INCOME STATEMENT 3 Net sales 15 BALANCE SHEET 16 ASSETS 17 Cash and marketable securities 18 Accounts receivable 19 Inventory 20 Current assets A Land, buildings, plant, and 21 equipment 22 Accumulated depreciation 23 Net fixed assets O AVERAGE(F19:G19)*B3 none of the answers is correct. =E18*B3 =E19*B24 B O AVERAGE(F19:G19)*B24 2020 $452,500 ? 2020 с $ VALUES 2019 $390,000 2019 $37,974 10,000 D E F PERCENT OF SALES 2019 2018 % AVERAGE $327 Close find bar 00.00% 2018 % AVERAGE $154,550 28.46% 6,000 2.20% 250,000 135,000 52.66% $297,974 $295,550 83.32% $250,000 $125,000 51.14% 64.10% 38.17% 50,000 25,000 10.23% 12.82% 7.63% $200,000 $100,000 40.91% 51.28% 30.53% 24 Total assets $497,974 $395,550 124.23% 127.69% 120.78% If you apply the percent of sales method to the balance sheet shown above, what is the formula in B19 to forecast the Inventory for 2020? 100.00% 2019 9.74% 2.56% 64.10% 76.40% G 2018 100.00% 2018 47.19% 1.83% 41.22% 90.24%
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter9: Metric-analysis Of Financial Statements
Section: Chapter Questions
Problem 9.4.10P: Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of...
Related questions
Concept explainers
Financial Ratios
A Ratio refers to a figure calculated as a reference to the relationship of two or more numbers and can be expressed as a fraction, proportion, percentage, or the number of times. When the number is determined by taking two accounting numbers derived from the financial statements, it is termed as the accounting ratio.
Return on Equity
The Return on Equity (RoE) is a measure of the profitability of a business concerning the funds by its stockholders/shareholders. ROE is a metric used generally to determine how well the company utilizes its funds provided by the equity shareholders.
Topic Video
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning