Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please give me ALL FORMULAS if not I will give you a thumbs down. Alignment Number Styles So A C D B Name: E .

please give me ALL FORMULAS if not I will give you a thumbs down. image text in transcribed
image text in transcribed
Alignment Number Styles So A C D B Name: E . BY b Your score: G 0% The comparative income statements of B Company follow. Calculate trend percents for all components of the income statements using 2021 as the base year. Each formula must include the ROUND function, rounding all percents to 2 decimal places. (XXX.XX%) 5 7 8 9 10 11 12 13 14 15 Sales Cost of goods sold Gross profit Operating expenses Net income B Company Comparative Income Statements For Years Ended December 31, 2025-2021 2025 2024 2023 $42,000 $38,000 $35,000 25,000 24,000 19,000 17,000 14,000 16,000 10,000 9,000 8,000 $7,000 $5,000 $8,000 2022 $30,000 18,000 12,000 7,000 $5,000 02 $26,000 17,000 9,000 6,000 $3,000 16 2025 2024 2023 2022 2021 17 18 19 20 21 22 23 24 25 Sales Cost of goods sold Gross profit Operating expenses Net income A D B Name E H 1 CM F Your score Average both tabs G 0% NA The comparative balance sheets of B Company follow Express the balance sheets in common-size percents. Each formula must include the ROUND function rounding all percents to 2 decimal places (XXX.XX%). 0 B Company Comparative Balance Sheets For Years Ended December 31, 2025 2021 2025 2024 2023 $6,000 $7,000 $8,000 13,000 15,000 18,000 39,000 45,000 54,000 49.000 56,000 68,000 $107.000 $123,000 $148,000 2022 $7,000 15,000 45,000 56,000 $123,000 2021 $6,000 13,000 39,000 49,000 $107.000 12 13 14 15 16 17 18 19 20 21 Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Current habilities Long-term liabilities Common stock Retained earnings Total liabilities and equity $14,000 11,000 15,000 67000 $107.000 $17.000 14,000 20,000 72.000 $123,000 $20,000 16,000 22,000 90,000 $148,000 $17,000 14,000 20,000 72.000 $123,000 $14,000 11,000 15,000 67,000 $107.000 22 2025 2024 2023 2022 2021 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and equity 38

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Working Papers Volume 1 For Needles/Powers/Crossons Financial And Managerial Accounting 8th

Authors: Belverd E. Needles

8th Edition

0618777237, 978-0618777235

More Books

Students also viewed these Accounting questions