Part i: 4 spreadsheets (see description for templates); part ii:

Part I

As a new accountant, you have been assigned to your firm’s client, Jim’s Auto Body. Jim’s Auto Body is a relatively new company of 2 years. To help the client understand the company’s performance over the last 2 years, complete a horizontal and vertical analysis of the income statement and balance sheet using the financial statements provided below.

Horizontal Analysis of the Income Statement

Table 1 Table 2