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%
College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)
22nd Edition
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:James A. Heintz, Robert W. Parry
Chapter15: Financial Statements And Year-end Accounting For A Merchandising Business
Section: Chapter Questions
Problem 4CE
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
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning