Question

E13-1 (Static) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, 13-3, 13-5) The average p
Sed Reg 1 Req ZA Req 2B Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed
Reg 1 Req 2A Req 28 Conduct a vertical analysis by expressing each line as a percentage of total revenues. (Round percentage
The average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34 in 2014 to $2.40 in 2015) Required: 1. Con
0 0
Add a comment Improve this question Transcribed image text
Answer #1
1 Horizontal Analysis
2015 2014 Difference - Amount Difference - Percent
(i) (ii) (iii) = (i) - (ii) (iii) / (ii)
Revenue $           140 $           210 $                                 -70 -33.3%
Cost of Crude oil and products $             70 $           120 $                                 -50 -41.7%
Other operating costs $             65 $             60 $                                     5 8.3%
Income before Income tax $               5 $             30 $                                 -25 -83.3%
Income tax expense $              -   $             10 $                                 -10 -100.0%
Net Income $               5 $             20 $                                 -15 -75.0%
2 Vertical Analysis
2015 2014
(i) (i) / $140 (ii) (ii) / $210
Revenue $           140 100.0% $                                210 100.0%
Cost of Crude oil and products $             70 50.0% $                                120 57.1%
Other operating costs $             65 46.4% $                                  60 28.6%
Income before Income tax $               5 3.6% $                                  30 14.3%
Income tax expense $              -   0.0% $                                  10 4.8%
Net Income $               5 3.6% $                                  20 9.5%
3 No
Add a comment
Know the answer?
Add Answer to:
E13-1 (Static) Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, 13-3, 13-5)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • E13-1 Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses (LO 13-2, LO 13-3, LO...

    E13-1 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 2015 dropped $0.94 (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...

  • E13-3 Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses (LO 13-2, LO 13-3, LO...

    E13-3 Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses (LO 13-2, LO 13-3, LO 13-5) According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. 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 Computer Tycoon Inc. for the year ended December 31,...

  • The average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34 in 2014 (to $2.40 in 2015). Required...

    The average price of a gallon of gas in 2015 dropped $0.94 (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...

  • E13-3 Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13-3, LO...

    E13-3 Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13-3, LO 13-5] According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 8.1 percent between 2012 and 2013. 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 Computer Tycoon Inc. for the year ended December 31, 2013....

  • he average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34...

    he average price of a gallon of gas in 2015 dropped $0.94 (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...

  • The average price of a gallon of gas in 2013 dropped $0.12 (3 percent) from $3.61...

    The average price of a gallon of gas in 2013 dropped $0.12 (3 percent) from $3.61 in 2012 (to $3.49 in 2013) 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 Chevron Corporation for the year ended December 31, 2013 (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)....

  • 10.00 points The average price of a gallon of gas in 2013 dropped S0.12 (3 percent)...

    10.00 points The average price of a gallon of gas in 2013 dropped S0.12 (3 percent) from 53.61 in 2012 (to $3.49 in 2013) 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 Chevron Corporation for the year ended December 31, 2013 (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...

  • The average price of a gallon of gas in 2013 dropped $0.12 (3 percent) from S3.61...

    The average price of a gallon of gas in 2013 dropped $0.12 (3 percent) from S3.61 in 2012 (to $3.49 in 2013). Required: 1. Conduct a horlzontal analyss by calculating the year-over-year changes In each line litem, expressed in dollars and In percentages for the Income statement of Chevron Corporation for the year ended December 31, 2013 (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...

  • According to the producer price Index database maintained by the Bureau of Labor Statistics, the average...

    According to the producer price Index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 38 percent between January and December 2016 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 Computer Tycoon Inc. for the year ended December 31, 2016 2-0. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b....

  • E13-2 Computing and Interpreting Profitability Ratios (LO 13-4, LO 13-5) The average price of a gallon...

    E13-2 Computing and Interpreting Profitability Ratios (LO 13-4, LO 13-5) The average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34 in 2014 (to $2.40 in 2015). Let's see whether these changes are reflected in the income statement of Insignia Corporation for the year ended December 31, 2015 (amounts in billions). 2015 2014 Revenues $215 $234 Cost of Purchased Crude Oil and Products 120 125 Other Operating costs 56 Income before Income Tax Expense Income...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT