Explore BrainMass
Share

Explore BrainMass

    Completing a Horizontal and Vertical Analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    (Please see the attached files for the full problem information).
    Prepare vertical and horizontal common-size balance sheet and income statement for Valero. Note: Compute for the most recent THREE years. For the Horizontal the base year is 2010.

    © BrainMass Inc. brainmass.com October 10, 2019, 7:21 am ad1c9bdddf
    https://brainmass.com/business/discounted-cash-flows-model/completing-horizontal-vertical-analysis-578466

    Attachments

    Solution Preview

    Hi,
    (Please see the attached file for the complete solution in Excel).

    VALERO ENERGY CORP/TX
    10-K
    02/28/2013

    Balance Sheet

    December 31,
    2012.00 2011.00 2010.00
    ASSETS
    Current assets:
    Cash and temporary cash investments 3.87% 2.39% 8.86%
    Receivables, net 18.36% 20.35% 12.18%
    Inventories 13.43% 13.14% 13.15%
    Income taxes receivable 0.38% 0.50% 0.91%
    Deferred income taxes 0.62% 0.66% 0.51%
    Prepaid expenses and other 0.35% 0.29% 0.32%
    Total current assets ...

    Solution Summary

    This answer helps to do a horizontal and vertical analysis in the form of a balance sheet and income statement.

    $2.19