With the given statement of comprehensive income below, conduct a vertical analysis. YEAR 1YEAR 2Net Sales9,937,65012,937,0003,387,6506,550,000Less: Cost of Goods Sold4,925,000Gross profit8,012,000Less: ExpensesSalaries Expense3,410,0003,938,500960,000Rent ExpenseInsurance Expence1,050,000250,000310,750Utilities Expense160,000175,500Miscellaneous Expense80,00097,800Advertising Expense140,000155,000Supplies Expense180,000198,000Depreciation Expense- Office Equipment160,000185,000Interest Expense60,00068,500Net Income1,150,0001,832,950

Here in this question, we are required to prepare vertical analysis. In this analysis, all the…

YEAR 1 YEAR 2 Net Sales 9,937,650 12,937,000 Less: Cost of Goods Sold 3,387,650 4,925,000 Gross profit 6,550,000 8,012,000 Less: Expenses Salaries Expense 3,410,000 3,938,500 Rent Expense 960,000 1,050,000 Insurance Expence 250,000 310,750 Utilities Expense Miscellaneous Expense 160,000 175,500 80,000 97,800 Advertising Expense 140,000 155,000 198,000 Supplies Expense Depreciation Expense- Office Equipment 180,000 160,000 185,000 Interest Expense 60,000 68,500 Net Income 1,150,000 1,832,950

YEAR 1 YEAR 2 Net Sales 9,937,650 12,937,000 Less: Cost of Goods Sold 3,387,650 4,925,000 Gross profit 6,550,000 8,012,000 Less: Expenses Salaries Expense 3,410,000 3,938,500 Rent Expense 960,000 1,050,000 Insurance Expence 250,000 310,750 Utilities Expense Miscellaneous Expense 160,000 175,500 80,000 97,800 Advertising Expense 140,000 155,000 198,000 Supplies Expense Depreciation Expense- Office Equipment 180,000 160,000 185,000 Interest Expense 60,000 68,500 Net Income 1,150,000 1,832,950

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter4: Analysis Of Financial Statements

Section: Chapter Questions

Problem 24P: Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of...

See similar textbooks

Similar questions

Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Sales is $ 500000 Sales returns and allowance $ 25000 Cost of goods sold 250000 Deternine the Net gales and Gross profit
Gain on Sales of Investment 5,000.00 Adversiting Expense 8,000.00 Sales 100,000.00 less: Cost of Goods Sold 20,000.00 Other Interest Expense 2,000 Gross Profit ? Net Profit ? Operating Income ?
Below are the Income Statement of ABC Company for two consecutive years. ABC Company Net Sales Cost of Goods Soldxs3 Year 1 P 5,000,000 880,000 Year 2 P 6,500,000 950,000
Purchases S250,000 Cost of goods sold 250,000 Beginning balance 30,000 Ending balance ?
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
If the gross profit 196 000 ID, other revenue and gains 4 360 ID , operating expenses 143.900 ID, net purchases 1200000ID the net profit is:
How much is the gross profit for the year? a. 662,000 b. 656,000 C. 648,000 d. 626,000
Year 1 Year 2 YR 1 YR2Sales (S) $ 614,405.00 $ 600,343.00 Cost of Good Sold (COGS) $ 385,101.00 $ 473,396.00 Gross Profit (GP) $ 229,304.00 $ 226,947.00 Calculate the following: (round to nearest percent) Answer Answer(a) Mark-up percent for year 1 (b) Mark-up percent for year 2 (c) Gross Profit for year 1 (d) Gross Profit for year 2
What is the gross profit for the year if the net revenue from by-product is treated as additional sales revenue? b. P1,230,000 c. P1,218,000 d. P1,118,000 a. P1,200,000 What is the net income for the year if the net revenue from by-product is treated as deduction from the cost of goods sold? d. P118,000 b. P230,000 a. P200,000 c. P218,000
Sales COGS Gross profit G&A expenses Sales & Marketing expenses Depreciation Operating income Interest Income Before taxes Income taxes Net income $575,000 $ 1,600,000 $200,000 $ 50,000 $ 100,000 30% $ 700,000 1: Calculate Sales. 2. Calculate Income before taxes. Taxes are 30%, so you know the Net Income (Y) is a percent of "Income before taxes" (X). 3. Calculate the Income tax figure. 4. Calculate Operating Income. 5. Calculate Sales & marketing.
Presented below is a combined single-step income and retained earnings statement for Hardrock Mining Co. for 20X1. Statement of Income and Retained Earnings for the Year Ended December 31, 20X1 ($ in 000) Net sales $5,281,954 Costs and expenses Cost of products sold Marketing, administrative, and other expenses Interest expense 4,765,505 193,147 17,143 54,529 Other, net Total expenses before taxes Earnings before income taxes 5,030,324 251,630 (52,842) 198,788 3,046,660 (100,000) Provision for income taxes Net income Retained earnings at 1/1/20X1 Dividends on common stock Retained earnings at 12/31/20X1 $3,145,448 Additional facts gleaned from notes to Hardrock's financial statements follow (dollar amounts in thousands): a. Other, net for 20X1 included a corporate restructuring charge of $8,777 and a pre-tax profit of $12,000 on discontinued operations. The remainder of the category is composed of investment losses. b. Marketing, administrative, and other expenses for 20X1 included a…