Table 7.7 Spreadsheet Pro Forma Income Statement for Карра, 2021-2026 Year 2021 2022 2023 2024 2025 2026 Income Statement ($ 000) 1 Sales 75,000 88,358 103,234 119,777 138,149 158,526 2 Cost of Goods Sold 3 Raw Materials (16,000) (18,665) (21,593) (24,808) (28,333) (32,193)| 4 Direct Labor Costs (18,000) (21,622) (25,757) (30,471) (35,834) (41,925) 5 Gross Profit 41,000 48,071 55,883 64,498 73,982 84,407 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation (11,250) (14,579) (18,582) (23,356) (27,630) (31,705) (13,500) (13,254) (15,485) (16,769) (17,959) (20,608) 16,250 20,238 21,816 24,373 28,393 32,094 (5,500) (5,450) (5,405) (6,865) (7,678) (7,710) 10 EBIT 10,750 14,788 16,411 17,508 20,715 24,383 11 Interest Expense (net) (75) (6,800) (6,800) (6,800) (7,820) (8,160) 12 Pretax Income 10,675 7,988 9,611 (3,364) 10,708 12,895 16,223 13 Income Tax (3,736) (2,796) (3,748) (4,513) (5,678) 14 Net Income 6,939 5,193 6,247 6,960 8,382 10,545

Table 7.7 Spreadsheet Pro Forma Income Statement for Карра, 2021-2026 Year 2021 2022 2023 2024 2025 2026 Income Statement ($ 000) 1 Sales 75,000 88,358 103,234 119,777 138,149 158,526 2 Cost of Goods Sold 3 Raw Materials (16,000) (18,665) (21,593) (24,808) (28,333) (32,193)| 4 Direct Labor Costs (18,000) (21,622) (25,757) (30,471) (35,834) (41,925) 5 Gross Profit 41,000 48,071 55,883 64,498 73,982 84,407 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation (11,250) (14,579) (18,582) (23,356) (27,630) (31,705) (13,500) (13,254) (15,485) (16,769) (17,959) (20,608) 16,250 20,238 21,816 24,373 28,393 32,094 (5,500) (5,450) (5,405) (6,865) (7,678) (7,710) 10 EBIT 10,750 14,788 16,411 17,508 20,715 24,383 11 Interest Expense (net) (75) (6,800) (6,800) (6,800) (7,820) (8,160) 12 Pretax Income 10,675 7,988 9,611 (3,364) 10,708 12,895 16,223 13 Income Tax (3,736) (2,796) (3,748) (4,513) (5,678) 14 Net Income 6,939 5,193 6,247 6,960 8,382 10,545

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter4: Accounting For Retail Operations

Section: Chapter Questions

Problem 4.2MBA: Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on...

See similar textbooks

Similar questions

Data for Micatin Designs, Inc. follow: Data table Micatin Designs, Inc. Comparative Income Statement Years Ended December 31, 2024 and 2023 2024 2023 Net Sales Revenue $429,000 $374,000 Expenses: Cost of Goods Sold 201,000 187,000 Selling and Administrative Expenses 97,450 92,750 Other Expenses 8,500 3,250 Total Expenses 306,950 283,000 Net Income $122,050 $91,000 . Requirements 1. Prepare a comparative common-size income statement for Micatin Designs, Inc. using the 2024 and 2023 data. Round percentages to one-tenth percent. 2. To an investor, how does 2024 compare with 2023? Explain your reasoning.
27 A1 CORPORATION, INC. Income Statement For the Year Ended December 31, 2026 Net Sales Cost of Goods Sold Gross Profit Operating Expenses Net Income Using vertical analysis, what percentage is assigned to cost of goods sold? OA) 37.5% B) 100% OC) 62.5% $240 150 90 65 $25 D) 50%
Assume the following cost of goods sold data for a company: 2023 $1295360 2022 1209000 2021 1012000 If 2021 is the base year, what is the percentage increase in cost of goods sold from 2021 to 2023?
Problem 13-02A (Video) The comparative statements of Cullumber Company are presented here: Cullumber CompanyIncome StatementsFor the Years Ended December 31 2020 2019 Net sales $1,891,640 $1,751,600 Cost of goods sold 1,059,640 1,007,100 Gross profit 832,000 744,500 Selling and administrative expenses 501,100 480,100 Income from operations 330,900 264,400 Other expenses and losses Interest expense 23,700 21,700 Income before income taxes 307,200 242,700 Income tax expense 93,700 74,700 Net income $213,500 $168,000 Cullumber CompanyBalance SheetsDecember 31 Assets 2020 2019 Current assets Cash $60,100 $64,200 Debt investments (short-term) 74,000 50,000 Accounts receivable 118,900 103,900 Inventory 127,700 117,200 Total current assets 380,700 335,300 Plant assets (net)…
A company reported the following data for the year ending 2018: Description Amount Sales Sales discount Sales returns and allowances $400,000 $16,000 $13,000 $117,000 $153,000 |Cost of goods sold |Operating expense Income tax expense $23,750 Compute the amount of gross profit to be reported on the income statement. a. $101,000 b. $117,000 c. $254,000 d. $124,750 Answer O O O O
Use the given statement of comprehensive income below in answering the question. DEF Company, Income Statement 2021 2020 Sales P10,200.00 P9,600.00 Cost of Goods Sold P3,000.00 P2,600.00 Gross Profit P7,200.00 P7,000.00 Operating Expenses P2,400.00 P2,200.00 Operating Profit P4,800.00 P4,800.00 Interest Expense P900.00 P800.00 Earnings before tax P3,900.00 P4,000.00 Income Tax P1,560.00 P1,600.00 Net Profit P2,340.00 P2,400.00 How many percent of the sales is the operating expenses in 2021 and 2020? A 8.82% and 8.33% 70.59% and 72.92% 29.41% and 27.08% 23.53% and 22.92%
WINDSOR, INC.Income StatementFor the Year Ended December 31, 2023 Net Sales $340 Cost of Goods Sold 238 Gross Profit 102 Operating Expenses 40 Net Income $ 62 Using vertical analysis, what percentage is assigned to gross profit? 100% 70.0% 42.9% 30.0%
Use the given statement of comprehensive income below in answering the question. DEF Company, Income Statement 2021 2020 Sales P10,200.00 P9,600.00 Cost of Goods Sold P3,000.00 P2,600.00 Gross Profit P7,200.00 P7,000.00 Operating Expenses P2,400.00 P2,200.00 Operating Profit P4,800.00 P4,800.00 Interest Expense P900.00 P800.00 Earnings before tax P3,900.00 P4,000.00 Income Tax P1,560.00 P1,600.00 Net Profit P2,340.00 P2,400.00 What is the percent change of net profit? А -3.5% В 12.5% C) -12.5% -2.5%
Required information For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year $ 411, 225 209,550 12, 100 9,525 $ 673,500 642, 400 $31,100 $ 1.90 :. -. - == ....... 9 US Sa M
Vertical analysis (common-size) percentages for Cullumber Company’s sales revenue, cost of goods sold, and expenses are listed here. Vertical Analysis 2022 2021 2020 Sales revenue 100.0 % 100.0 % 100.0 % Cost of goods sold 60.0 64.2 65.6 Expenses 24.7 27.1 29.5 Calculate Cullumber’s net income as a percent of sales. (Round answers to 1 decimal place, e.g. 5.2.) 2022 2021 2020 Net income Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Did Cullumber’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Cullumber’s net income as a percent of sales Choose the correct answer increaseddecreasedremained unchanged
Operating data for Joshua Corporation are presented as follows: Net Sales Cost of Goods Sold Selling Expenses Administrative Expenses Income Tax Expense Net Income 2022 800,000 520,000 120,000 60,000 30,000 70,000 Instructions Prepare a schedule showing a vertical analysis for 2022 and 2021. Net Sales Cost of Goods Sold Gross Profit Selling Expenses Your Answers: FYI: Format the percent cols to one decimal place. Ex 99.9% 2022 Administrative Expenses Total Operating Expenses Income Before Income Taxes Income Tax Expense Net Income 2021 600,000 408,000 72,000 48,000 24,000 48,000 Amount 800,000 520,000 280,000 120,000 60,000 180,000 100,000 30,000 70,000 Percent 100.0% 2021 Amount Percent 600,000 100.0% 408,000 192,000 72,000 48,000 120,000 72,000 24,000 48,000
GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…