Req 1Req 2AIncome StatementSales RevenueCost of Goods SoldGross ProfitComplete the two final columns shown beside each item in Pinnacle Plus's comparative financial statements. (Decreases shouldbe indicated by a minus sign. Round percentage values to 1 decimal place.)Operating ExpensesInterest ExpenseIncome before Income Tax ExpenseIncome Tax Expense (30%)Net IncomeBalance SheetCashAccounts Receivable, NetInventoryProperty and Equipment, NetTotal AssetsReq 2BAccounts PayableIncome Tax PayableNotes Payable (long-term)Total LiabilitiesCommon Stock (par $10)Retained EarningsTotal Liabilities and Stockholders' Equity$$PINNACLE PLUSHorizontal Analysis$$CurrentYear130,00056,00074,00031,0003,00040,00012,00028,000$ 76,90019,00024,00094,000213,90046,0003,00030,00079,00086,00048,900$ 213,900PreviousYear$ 113,00050,00063,00029,0003,00031,0009,30021,700$ 42,60012,00036,000100,000181,00037,0001,50030,00068,50086,00026,500$ 181,000$$$$$$$Increase (Decrease)in the Current year (versusPrevious year)PercentageAmount17,0006,00011,0002,00009,0002,7006,30043,960 x7,000(12,000)(6,000)32,960 x9,0001,560 X010,560 X022,40032,960 x15.012.017.56.90.029.029.029.0%%%%%%%%132.0 × %58.3%(33.3)%(6.0)%18.2%%24.386.7 X %0.0 %15.5 X %0.0%84.518.2%

The Statement of Financial Position -The statement of financial position is the position of the…

Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Interest Expense Income before Income Tax Expense Income Tax Expense (30%) Net Income Balance Sheet Cash Accounts Receivable, Net Inventory Property and Equipment, Net Total Assets Accounts Payable Income Tax Payable Notes Payable (long-term) Total Liabilities Common Stock (par $10) Retained Earnings $ PINNACLE PLUS Horizontal Analysis $ 130,000 56,000 74,000 31,000 3,000 40,000 12,000 28,000 $ 76,900 19,000 24,000 94,000 $ 213,900 $ 46,000 3,000 30,000 79,000 86,000 48,900 Total Liabilities and Stockholders' Equity $ 213,900 Current Year Previous Year $ 113,000 50,000 63,000 29,000 3,000 31,000 9,300 $ 21,700 $ $ $ 42,600 12,000 36,000 100,000 $ 181,000 $ $ 37,000 $ 1,500 30,000 68,500 86,000 26,500 $ 181,000 $ $ Increase (Decrease) in the Current year (versus Previous year) Percentage Amount 17,000 6,000 11,000 2,000 0 9,000 2,700 6,300 43,960 X 7,000 (12,000) (6,000) 32,960 X 9,000 1,560 X 0 10,560 X 0 22,400 32,960 X 15.0 % 12.0 % 17.5 % 6.9 % 0.0 % 29.0 % 29.0 % 29.0 % 132.0 58.3 (33.3) (6.0) 18.2 % % % % % 24.3 % 86.7 X % 0.0 % 15.5 X % 0.0 % 84.5 18.2 %

Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Interest Expense Income before Income Tax Expense Income Tax Expense (30%) Net Income Balance Sheet Cash Accounts Receivable, Net Inventory Property and Equipment, Net Total Assets Accounts Payable Income Tax Payable Notes Payable (long-term) Total Liabilities Common Stock (par $10) Retained Earnings $ PINNACLE PLUS Horizontal Analysis $ 130,000 56,000 74,000 31,000 3,000 40,000 12,000 28,000 $ 76,900 19,000 24,000 94,000 $ 213,900 $ 46,000 3,000 30,000 79,000 86,000 48,900 Total Liabilities and Stockholders' Equity $ 213,900 Current Year Previous Year $ 113,000 50,000 63,000 29,000 3,000 31,000 9,300 $ 21,700 $ $ $ 42,600 12,000 36,000 100,000 $ 181,000 $ $ 37,000 $ 1,500 30,000 68,500 86,000 26,500 $ 181,000 $ $ Increase (Decrease) in the Current year (versus Previous year) Percentage Amount 17,000 6,000 11,000 2,000 0 9,000 2,700 6,300 43,960 X 7,000 (12,000) (6,000) 32,960 X 9,000 1,560 X 0 10,560 X 0 22,400 32,960 X 15.0 % 12.0 % 17.5 % 6.9 % 0.0 % 29.0 % 29.0 % 29.0 % 132.0 58.3 (33.3) (6.0) 18.2 % % % % % 24.3 % 86.7 X % 0.0 % 15.5 X % 0.0 % 84.5 18.2 %

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 48CE

See similar textbooks

Similar questions

Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
The following is select account information for August Sundries. Sales: $850,360; Sales Returns and Allowances: $148,550; COGS: $300,840; Operating Expenses: $45,770; Sales Discounts: $231,820. If August Sundries uses a multi-step income statement format, what is their gross margin?
Vanishing Games Corporation (VGC) operates a massively multiplayer online game, charging players a monthly subscription of $15. At the start of January 2021, VGC's income statement accounts had zero balances and its balance sheet account balances were as follows: Cash Accounts Receivable Supplies Equipment Buildings Land Accounts Payable Deferred Revenue Notes Payable (due 2025) Common Stock Retained Earnings $ 1,500,000 150,000 14,700 874,500 422,000 1,200,000 108,000 73,500 60,000 2,500,000 1,419,700 In addition to the above accounts, VGC's chart of accounts includes the following: Service Revenue, Salaries and Wages Expense, Advertising Expense, and Utilities Expense. The January transactions are shown below: a. Received $50,000 cash from customers on 1/1 for subscriptions that had already been earned and charged on account in 2020. b. Purchased 10 new computer servers for $33,500 on 1/2; paid $10,000 cash and signed a three-year note for the remainder owed. c. Paid $10,000 for an…
Required information [The following information applies to the questions displayed below] The following information pertains to the inventory of Parvin Company for Year 3: Jan. 1 Beginning inventory Apr, 1 Oct. 1 Purchased Purchased 400 units # $17 2,900 units # $22 1,200 units # $23 During Year 3, Parvin sold 3,825 units of inventory at $43 per unit and incurred $18,30% of operating expenses. Parvin currently uses the FIFO method but is considering a change to LIFO. All transactions are cash transactions. Assume a 30 percent income tax rate. Parvin started the period with cash of $148,700, inventory of $6,800, common stock of $131,000, and retained earnings of $24,500.
Required: 1. Complete the following columns for each item in the comparative financial statements (Negative answers shoul be indicated by a minus sign. Round percentage answers to 2 decimal places, i.e., 0.1243 should be entered as 12.43.): Increase (Decrease) Year 2 over Year 1 Amount Percentage Statement of earnings: Sales revenue Cost of sales Gross margin Operating expenses and interest expense Earnings before income taxes Income tax expense Net earnings $ 45,770 38,650 7,120 4,020 3,100 1,050 $ 2,050 Statement of financial position: Cash (4,720) Accounts receivable (net) (4,220) Inventory 6,200 Property, plant, and equipment (net) 6,380 $ 3,640 Current liabilities (3,840) Long-term debt 3,530 Common shares 0 Retained earnings 3,950 $ 3,640
Comparative income statements and balance sheets for F&N are shown below ($ millions): Year 2 Year 1 Income Statement $19,889 6,204 Net sales. $20,092 6,044 Cost of goods Gross profit. Selling, general, and administrative expense Depreciation and amortization expense Interest expense (revenue) 14,048 7,893 803 (308) 13,685 9,221 773 292 3,399 1,222 Income before tax 5,660 1,691 Income tax expense. Net income $ 3,969 $ 2,177 Outstanding shares 3,491 3,481
2. Complete the below table to calculate income statement data in common-size percents. (Round your percentage answers to 2 decimal places.) KORBIN COMPANY Common-Size Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 Sales % % % Cost of goods sold -1 -1 -1 Gross profit Selling expenses -1 -1 -1 Administrative expenses -1 -1 -1 Total expenses Income before taxes -1 -1 -1 Income tax expense -1 -1 -1 Net income % % % See picture
A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $3 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio Debt-to-capital ratio Times interest earned EBITDA coverage Inventory turnover Cash and equivalents Accounts receivables Inventories Total current assets 2x 17% 3 x 6 x 11 x Days sales outstandinga Calculation is based on a 365-day year. Balance Sheet as of December 31, 2021 (millions of dollars) $78 Accounts payable Other current liabilities 51 125 Notes payable $ 254 Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity Gross fixed assets Less depreciation Net fixed assets Total assets 15 days Fixed assets turnover Total assets turnover…
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Previous Year Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Current Year $447,000 272,670 71,520 71,520 13,410 $384,000 215,040 69,120 57,600 15,360
Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Previous Year Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income tax expense Income tax expense Net income Line Item Description Sales Cost of goods sold Gross profit Selling expenses Current Year a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round your answers to one decimal place. Winthrop Company Comparative Income Statement For the Years Ended December 31 Administrative expenses Total operating expenses Income before income tax expense Income tav evnence $2,240,000 (1,925,000) $315,000 $(152,500) (118,000) $(270,500) $44,500 (17,800) $26,700 Current Previous Increase Increase Year Year (Decrease) (Decrease) Amount Amount Amount $2,240,000 $2,000,000 (1,925,000) (1,750,000) Percent…
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Sales Cost of merchandise sold Gross profit Selling expenses Winthrop Company Comparative Income Statement For the Years Ended December 31 Administrative expenses Total operating expenses Income before income tax expense Income tax expense Net income profit to be Increase Current Previous Increase year year (Decrease) (Decrease) Amount Amount Amount Percent $611,000 $470,000 $ 520,700 410,000 $90,300 $27,600 24,320 $51,920 $38,380 15,400 $22,980 $60,000 $23.000 19,000 $42,000 $18,000 $ 7,200 $10,800 % % % % % % % % % b. The net income for Winthrop Company increased between years. This increase was the combined result of an in cost of merchandise sold. The cost of merchandise sold increased at a than the percentage increase in sales. in sales and percentage rate than the increase in…
Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your percentage answers to 2 decimal places. (i.e., 0.2345 should be entered as 23.45).) Revenues Sales (net) Other revenues Total revenues Expenses Cost of goods sold WALTON COMPANY Vertical Analysis of Income Statements Year 4 Selling, general, and administrative expense Interest expense Income tax expense Total expenses Net income Amount $ 230,600 9,000 239,600 119,200 53,500 7,100 22,700 202,500 $ 37,100