S18-2 Trend analysisMariner Ltd reported the following revenues and profit amounts:(In millions)2016201520142013$9 9107 475$9 7007 400$9 1104 690Revenue$9 210Profit5 495Requirements1 Calculate Mariner's trend analysis for revenues and profit. Use 2013 as the base year andround to the nearest percentage.2 Which measure increased faster during 2014–16?

Trend analysis refers to horizontal analysis which includes comparison of items of financial…

S18-2 Trend analysis Mariner Ltd reported the following revenues and profit amounts: (In millions) 2016 2015 2014 2013 $9 910 7 475 $9 210 $9 700 7 400 $9 110 4 690 Revenue Profit 5 495 Requirements Calculate Mariner's trend analysis for revenues and profit. Use 2013 as the base year and round to the nearest percentage. 1 2 Which measure increased faster during 2014–16?

S18-2 Trend analysis Mariner Ltd reported the following revenues and profit amounts: (In millions) 2016 2015 2014 2013 $9 910 7 475 $9 210 $9 700 7 400 $9 110 4 690 Revenue Profit 5 495 Requirements Calculate Mariner's trend analysis for revenues and profit. Use 2013 as the base year and round to the nearest percentage. 1 2 Which measure increased faster during 2014–16?

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter5: Sales And Receivables

Section: Chapter Questions

Problem 96.6C

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?
Profitability metrics The following selected data were taken from the financial statements of The O'Malley Group Inc. for December 31, 20Y5. 20Y4. and 20Y3: No dividends on common stock were declared between 20Y3 and 20Y5. a.Determine the return on total assets, the return on stockholders' equity, and the return on common stockholders' equity Tor the years 20Y4 and 20Y5. Round to one decimal place. b. What conclusions can be drawn from these data as to the company's profitability?
Randall Corporation reported the following revenue data:Year Net revenues (in millions)$$$$6,8007,0046,7327,2762016201720182019Use 2016 as the base year. The trend percentage in 2019 is closest toa. 93%.b. 104%.c. 107%.d. 112%
The trend analysis report of Poplar, Inc. is given below (in millions): 2019 2018 2017 2016 2015 Net income $700 $606 $470 $405 $402 Trend percentages 174% 151% 117% 101% 100% Which of the following is a correct conclusion from the above analysis? Select one: A. Net income for 2018 decreased by 151% from 2017. B. Net income for 2019 increased by 174% from 2018. C. Net income for 2019 is 174% of net income for 2015. D. Net income for 2018 is 151% of the previous year. The financial statements for Silver Service Company include the following items: 2019 2018 Cash $49,500 $40,000 Short-term Investments 33,000 20,500 Net Accounts Receivable 52,000 53,000 Merchandise Inventory 132,000 45,000 Total Assets 530,000 547,000 Accounts Payable 131,500 122,000 Salaries Payable 15,000 18,000 Long-term Note Payable 58,000 57,000 Compute the acid-test ratio for 2018.…
Q1) You are required to calculate the Relative Percentage Change in the company for the blanks below and the Net Profit for the other blanks. Show all working out below including the formula used for each year and include the completed table here. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Net Profit ($ 000’) <blank> 50 200 150 225 250 <blank> 200 250 260 Relative Percentage Change N/A -50% 300% <blank> 50% 11% -30% 14% 25% <blank> Table 1: Net Profit ($) per financial year Q1 a) Using Excel, create a column chart of the Net Profit calculated in part (a) for the years 2010-2019. label the axis and provide an appropriate title. Q1 b) Using Excel, create a Sparkline of the Relative Percentage Change calculated in part (a) for the years 2011-2019. use the Sparkline options to mark if there are any negative values and include a horizontal axis to easily visualise…
What is Yahoo’s common-sized product development expense for 2017? (Rounded to two decimal places, in percentage format). $ in millions Dec 31, 2017 Dec 31, 2016 Total Assets $17,103.30 $16,805.00 Revenues 4,984.20 4,986.60 Product development exp 919.40 885.80 Operating Expense 3,102.00 3,007.80 Net Income $1,048.80 $1,093.00
REVENUE AND EXPENSE DATA FOR SOLDNER, INC ARE AS FOLLOWS; SALES 2014 1,500,000 2013 1,450,000 COGS 930,000 812,000 SELLING EXP 210,000 261,000 ADM EXP 255,000 232,000 INC TAX EXP 52,500 72,500 PREPARE AN INCOME STATEMENT IN COMPARATIVE FORM, STATING EACH ITEM FOR BOTH 2014 AND 2013 AS A PERCENT OF SALES. ROUND TO ONE DECIMAL.
ccounting Assume the following sales data for a company: 2026 $734000 2025 655500 2024 570000 If 2024 is the base year, what is the percentage increase in sales from 2024 to 2025? 129% 29% 115% 15%
XYZ Corporation had the following data in 2022 below: Total assets = P300,000Gross profit margin = 25%Quick ratio = 0.80 xBond payable = P60,000Days sales outstanding = 36 daysDebt ratio = 50%Retained earnings = P97,500Times interest earned= 6 xInventory turnover = 5 xTotal assets turnover = 1.5 xNo. of days in a year = 360 days Tax rate = 35%Compute the average merchandise inventory.
Jones Enterprises reported sales revenue totaling $672,000, $668,000, and $708,000 in the years, 2015, 2016, and 2017, respectively.Performing trend analysis, with 2015 serving as the base year, what is the percentage for 2017? Question 15 options: A) 19.08% B) 28.21% C) 105.36% D) 105.99%
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
Kincaid Company reported the following data (in millions) for the past two years:2019 2018$$$$$2801501304090$$$$$2501401103575Net revenues........................................Cost of goods sold...............................Gross profit..........................................Operating expenses..............................Operating income................................In a vertical analysis of 2019, the operating expenses percentage is closest toa. 225%.b. 69%.c. 14%.d. 32%.