Balance Sheet – Horizontal and Vertical Analysis

by

Business Finance

Prepare a horizontal and a vertical analysis of the balance sheet for Zoetis for the year ended December 31, 2017 in Excel. Be sure to use the correct Form 10-K for your analysis (Filing date 2018-02-15 for year end 12/31/2017). You can download the balance sheet using the “Interactive” or XBRL data file from the Edgar database.

Here is the link for the company’s balance sheet. You may have to copy and paste the link in the search box: https://www.sec.gov/cgi-bin/browse-edgar?company=Zoetis&owner=exclude&action=getcompany

Your Excel file should contain a tab for the horizontal balance sheet analysis (labeled “Horizontal BS”) and a separate tab for the vertical balance sheet analysis (labeled “Vertical BS”).

Please take note of the filling date when looking at the 10-K form.