E13-1 (Algo) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13-...

Transcribed Image Text:

E13-1 (Algo) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13- 3, LO 13-5] The average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018. Required: 1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in billions). 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared to 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A. Req 28 Conduct a vertical analysis by expressing each line as a percentage of total revenues. Note: Round percentage values to 1 decimal place. PRONZE, INCORPORATED Income Statements Revenues (amounts in billions) For the Year Ended December 31 Costs of Purchased Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense Net Income 2018 2017 $ 300 100.0 % $ 260 100.0 % 175 58.7 % 139 58.7 % 92 41.3 % 104 45.6 % 39 32.6 % 17 28.1% 11 0.6 % 4.7 % S 281 6.4% S 17 12.61% 6 of 15 Next > Check t es 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared t 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 28 Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in billions). Note: Decreases should be indicated by a minus sign. Enter your answers in billions (1.e., 10,000,000,000 should be entered as 10). Round percentage values to 1 decimal place. BRONZE, INCORPORATED Income Statements (amounts in billions) For the Year Ended December 31 Change In 2018 2017 Dollars Percentage Revenues $ 306 $ $ 260 19.3 % (50,000) Costs of Purchased Crude Oil and Products 175 139 10,000 (12.9) % Other Operating Costs 92 104 17,500 (26.9) % $ Income before Income Tax Expense 39 17 2,500 (6.3) % Income Tax Expense 11 (4,050) (69) % Net Income $ 28 $ 17 (59.1) % Re: 1 Req 2A > < Prev 6 of 15 Next > Show less A E13-1 (Algo) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13- 3, LO 13-5] The average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018 Required: 1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Bronz, Incorporated for the year ended December 31, 2018 (amounts in billions). 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared to 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 28 Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared to 2017? Did Fossil earn more gross profit per dollar of revenue in 2018? E13-1 (Algo) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13- 3, LO 13-5] The average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018. Required: 1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in billions). 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared to 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A. Req 28 Conduct a vertical analysis by expressing each line as a percentage of total revenues. Note: Round percentage values to 1 decimal place. PRONZE, INCORPORATED Income Statements Revenues (amounts in billions) For the Year Ended December 31 Costs of Purchased Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense Net Income 2018 2017 $ 300 100.0 % $ 260 100.0 % 175 58.7 % 139 58.7 % 92 41.3 % 104 45.6 % 39 32.6 % 17 28.1% 11 0.6 % 4.7 % S 281 6.4% S 17 12.61% 6 of 15 Next > Check t es 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared t 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 28 Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in billions). Note: Decreases should be indicated by a minus sign. Enter your answers in billions (1.e., 10,000,000,000 should be entered as 10). Round percentage values to 1 decimal place. BRONZE, INCORPORATED Income Statements (amounts in billions) For the Year Ended December 31 Change In 2018 2017 Dollars Percentage Revenues $ 306 $ $ 260 19.3 % (50,000) Costs of Purchased Crude Oil and Products 175 139 10,000 (12.9) % Other Operating Costs 92 104 17,500 (26.9) % $ Income before Income Tax Expense 39 17 2,500 (6.3) % Income Tax Expense 11 (4,050) (69) % Net Income $ 28 $ 17 (59.1) % Re: 1 Req 2A > < Prev 6 of 15 Next > Show less A E13-1 (Algo) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13- 3, LO 13-5] The average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018 Required: 1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Bronz, Incorporated for the year ended December 31, 2018 (amounts in billions). 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared to 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 28 Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared to 2017? Did Fossil earn more gross profit per dollar of revenue in 2018?