How do you solve this? Selected statement of comprehensive income data from 2014 to 2016 appear below2014Estrada, Inc. is concerned about the level of its advertising and office salaries expenre20162015P37,50022,5002,2504,5009,000P60,000P140,00089,6007,00022,400SalesGross ProfitAdvertising ExpenseOffice Salaries Expense37,2003,3009,00013,800Profit30,800Required:Calculate trend percentages for sales, advertising expense and office salaries expense.Use 2014 as the base year. Round to the nearest percent.

The trend percentages are calculated with the following formula: Trend percentage = (Amount of the…

Estrada, Inc. is concerned about the level of its advertising and office salaries expenre Selected statement of comprehensive income data from 2014 to 2016 appear below 2014 2015 2016 P60,000 P37,500 P140,000 89,600 7,000 Sales Gross Profit Advertising Expense Office Salaries Expense Profit 22,500 2,250 4,500 37,200 3,300 9,000 22,400 30,800 13,800 9,000 Required: Calculate trend percentages for sales, advertising expense and office salaries expense. Use 2014 as the base year. Round to the nearest percent.

Estrada, Inc. is concerned about the level of its advertising and office salaries expenre Selected statement of comprehensive income data from 2014 to 2016 appear below 2014 2015 2016 P60,000 P37,500 P140,000 89,600 7,000 Sales Gross Profit Advertising Expense Office Salaries Expense Profit 22,500 2,250 4,500 37,200 3,300 9,000 22,400 30,800 13,800 9,000 Required: Calculate trend percentages for sales, advertising expense and office salaries expense. Use 2014 as the base year. Round to the nearest percent.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Hello, can you help me in this problem of doing the horizontal analysis. below are the data. Horizontal analysis using: 2016 2017 2018 Sales 227,279 251,589 286,378 Less: Cost of Sales 152,108 168,460 194,236 Gross Profit 75,171 83,129 92,142 Less: Selling and Administrative Expenses 38,128 40,728 46,192 Operating Income 37,043 42,401 45,950 Other income and expenses 268 118 409 Net Income Before Finance Charges and Tax 37,311 42,519 46,359 Less: Finance charges 3,212 2,658 2,998 Net Income Before Tax 34,099 39,861 43,361 Less: Income Tax Expense 10,097 11,635 12,828 Net Income After Tax 24,002 28,226 30,533 using the index numbers: Horizontal Anaysis using index numbers 2016 2017 2018 Sales Less: Cost of Sales Gross Profit Less: Selling and Administrative Expenses Operating Income and the increase/decrease method: horizontal using Increase/decrease method 2016 2017 2018 Operating Income…
In the income statement below, ABC Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) Year End 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales (679.10) (659.00) (681.30) (667.00) Gross Operating Income Selling & Administration (339.70) (348.60) (351.20) (373.30) Depreciation (47.50) (52.00) (55.90) (75.20) Other Income/Expenses 11.80 7.60 7.00 8.20 Earnings Before Interest and Taxes Interest Income 1.30 1.40 1.70 2.00 Interest Expense (16.20) (15.10) (20.50) (23.70) Pre Tax Income Income Taxes (56.80) (64.20) (67.50) (72.60) Net Income Dividends (38.30) (38.70) (39.80) (40.10) Addition to Retained Earnings Group of answer choices 121.8 108.7 132.7 132.8 No choice given
The comparative statements of Osborne Company are presented here: [{HtmlTableOSBORNE COMPANYIncome StatementsFor the Years Ended December 312014 2013Net sales $1,895,999 $1,755,959Cost of goods sold 1,063,999 1,011,459Gross profit 832,000 744,500Selling and administrative expenses 505,459 484,459Income from operations 326,541 260,041Other expenses and losses Interest expense 23,583 21,583Income before income taxes 302,958 238,458Income tax expense 93,583 74,583Net income $209,375 $163,875\\OSBORNE COMPANYBalance SheetsDecember 31Assets 2014 2013Current assets Cash $60,100 $64,200Debt investments (short-term) 74,000 50,000Accounts receivable 123,259 108,259Inventory 127,583 117,083Total current assets 384,942 339,542Plant assets (net) 663,905 535,205Total assets $1,048,847 $874,747Liabilities and Stockholders' Equity Current liabilities Accounts payable $165,459 $150,859Income taxes payable 45,083 43,583Total current liabilities 210,542 194,442Bonds payable 234,905 214,905Total…
1. Data for Abakada Trading Company are given below: 2014 2015 Revenue 1,939,500 1,674,675 Cost of Goods Sold 900,000 843,975 Gross Profit 1,039,500 830,700 Selling and General Expenses 445,500 409,725 Other Expenses 37,575 30,825 Net Income 556,425 390,150 Requirements: a. Prepare a Vertical Analysis Statement A of Comprehensive Income for 2014 and 2015 for Abakada Trading Company. b. Prepare a horizontal analysis for Abakada Trading Company.
How do I calculate the NOPBT for 2016 and 2015 Consolidated Statements of Income Fiscal year ended (in thousands) Dec. 29, 2016 Dec. 30, 2015 Revenues Circulation $880,543 $851,790 Advertising 580,732 638,709 Other 94,067 88,716 Total revenues 1,555,342 1,579,215 Production costs Wages and benefits 363,051 354,516 Raw materials 72,325 77,176 Other 192,728 186,120 Total production costs 628,104 617,812 Selling, general and administrative costs 721,083 713,837 Depreciation and amortization 61,723 61,597 Total operating costs 1,410,910 1,393,246 Restructuring charge 14,804 0 Multiemployer pension plan withdrawal expense 6,730 9,055 Pension settlement charges 21,294 40,329 Early termination charge 0 0 Operating profit 101,604 136,585 Loss from joint ventures -36,273 -783 Interest expense, net 34,805 39,050 Income from continuing operations before income taxes 30,526 96,752 Income tax expense/(benefit) 4,421 33,910 Income…
Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1 Addition to Retained Earnings
E18-2 Operating data for Navarro Corporation are presented below. 2017 2016 Net sales $750,000 465,000 105,000 60,000 36,000 84,000 $600,000 390,000 Cost of goods sold Selling expenses Administrative expenses Income tax expense 66,000 54,000 27,000 63,000 Net income Instructions Prepare a schedule showing a vertical analysis for 2017 and 2016.
Prepare the Pro-Forma Statement of Financial Position for the year ending 31 December 2023 INFORMATIONSibiya ProjectsStatement of Comprehensive Income for the year ended 31 December 2022 RSales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable, selling and administrative costs (1 500 000)Fixed selling and administrative costs (500 000)Net profit 2 250 000 Statement of Financial Position for the year ended 31 December 2022ASSETS RNon-current assets 800 000Property, plant and equipment 800 000 Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000TOTAL ASSETS 4 200 000 EQUITY AND LIABILITIESEquity 3 760 000 Current liabilities 440 000Accounts payable 440 000TOTAL ASSETS AND LIABILITIES 4 200 000 Additional informationA. The sales budget for 2023 is as follows:First Quarter Second Quarter Third Quarter Fourth QuarterR2 625 000 R2 750 000 R2 875 000 R2 750 000 B. 90% of sales is collected in the quarter of the sale and 10% in the quarter…
Use the following Income Statement and Balance Sheet Information for 2018 to answer the question below. This is a Retail Company. All numbers are in Millions. Income Statement Total Sales213.8 Cost of Sales151.3 Gross Profit213.8-151.3 Selling and Administrative Expenses22.3 Research and Development 7.7 Depreciation and Amortization4.5 Other Income2.4 EBIT213.8-151.3-22.3-7.7-4.5+2.4 Interest Expense5.8 Pretax Income213.8-151.3-22.3-7.7-4.5+2.4-5.8 Taxes( 213.8-151.3-22.3-7.7-4.5+2.4-5.8 )*0.30 Net Income( 213.8-151.3-22.3-7.7-4.5+2.4-5.8 )*0.70 Balance Sheet Assets Liabilities Cash65.8Accounts Payable43.3Accounts Receivable54.4Notes Payable/Short term debt1.6Inventories4.4 Total Current Assets65.8+54.4+4.4Total Current Liabilities43.3+1.6 Net property, plant and equipment103.4Long-term debt80.0Total long-term assets103.4Total long-term debt liabilities80.0 Total Liabilities43.3+1.6+80.0 Stockholders' Equity (Total Equity)65.8+ 54.4+4.4+103.4-43.3-1.6-80.0Total…
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 - - -…
TASK THREЕ: Income Statement for the year ended 31 December 2020 Edward Frankie Company Company $ Sales 100,000 80,000 Less: Cost of goods sold 60,000 50,000 Gross Profit 40,000 30,000 Less: Expenses 36.000 18,000 Net Profit 4.000 12,000 1. Calculate the gross profit ratio, net profit ratio and expense to sales ratio for each of the company respectively. 2. Comment the profitability of the two companies.
Assume a company's Income Statement for Year 12 is as follows: Income Statement Data Net Revenues from Footwear Sales Cost of Pairs Sold Warehouse Expenses Marketing Expenses Administrative Expenses Operating Profit (Loss) Interest Income (Expense) Pre-tax Profit (Loss) Income Taxes Net Profit (Loss) Year 12 (in 000s) 5.50. 4.50. 3.15. 2.20 53.0. $530,000 340,000 40,000 80,000 15,000 55,000 (10,000) 45,000 13,500 $31,500 Based on the above income statement data and the formula for calculating the interest coverage ratio described in the Help section for p. 5 of the Footwear Industry Report, the company's interest coverage ratio is