E13-1 (Algo) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, 13-3, 13-5) The average pride of a gallon of gas in 2015 dropped $094 (28 percent) from $3.34 in 2014 to $2.40 in 2015) 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 Insignia Corporation for the year ended December 31, 2015 (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 Insignia earn more profit per dollar of revenue in 2015 compared to 2014? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2A Reg 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 Insignia Corporation for the year ended December 31, 2015 Camounts in billions). (Decreases should be Indicated by a minus sign. Enter your answers in billions lew 10,000,000,000 should be entered as 10). Round percentage values to I decimal place.) INSIGNIA CORPORATION Income Statements Complete this question by entering your answers in the tabs below. Reg! Req 2A Req 2B 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 Insignia Corporation for the year ended December 31, 2015 (amounts in billions). (Decreases should be indicated by a minus sign. Enter your answers in billions (i.e., 10,000,000,000 should be entered as 10). Round percentage values to 1 decimal place.) INSIGNIA CORPORATION Income Statements Camounts in billions) For the Year Ended December 31 Change in Dollars Porcentage Revenues Cost of Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense Net Income 2015 2014 $ 1353 211 68 121 61 50 6 40 0 21 19 % Complete this question by entering your answers in the tabs below. Reg 1 Reg 2A Req 2B ht Conduct a vertical analysis by expressing each line as a percentage of total revenues. (Round percentage values to 1 decimal place.) INSIGNIA CORPORATION Income Statements (amounts in billions) For the Year Ended December 31 2015 Revenues $ 135 % 5 Cost of Crude Oil and Products 68 % Other Operating costs 61 % Income before Income Tax Expense 6 % Income Tax Expense % Net Income $ 6 %$ 2014 211 121 50 % % % % 40 21 19 Draw A ch 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 Insignia Corporation for the year ended December 31, 2015 (amounts in billions) 2-0. Conduct a vertical analysis by expressing each line as a percentage of total revenues 2-b. Excluding income tax and other operating costs, did Insignia earn more profit per dollar of revenue in 2015 compared to 2014? Complete this question by entering your answers in the tabs below. Reg 1 Req 2A Reg 28 Excluding income tax and other operating costs, did Insignia earn more profit per dollar of revenue in 2015 compared to 20142 Yes ONO