Question

Operating data for Swifty Corporation are presented below. 2022 2021Sales revenue $830,700 $634,900 Cost of goods sold 529,000 415,000 Selling expenses 124,700 73,600 Administrative expenses 78,800 53,900 Income tax expense 33,500 23,400 Net income 64,700 69,000 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)

Answer 1

Answer and Explanation:

The preparation of the vertical analysis is presented below:

Particulars Amount % Amount %

Sales $830,700 100 $634,900 100

Less:

Cost of goods sold $529,000 63.7 $415,000 65.4

Gross Profit $301,700 36.3 $219,900 34.5

Less:

Selling Expenses $124,700 15.0 $73,600 11.6

administrative expenses $78,800 9.5 $53,900 8.5

Total Operating

expenses $203,500 24.5 $127,500 20.9

Income before

income taxes $98,200 11.8 $92,400 14.5

Less:

Income tax expenses $33,500 4.0 $23,400 3.7

Net Income $64,700 7.8 $69,000 10.8

Working note

The percentage is like

= Items value ÷ sales × 100

Like for cost of goods sold

= $529,000 ÷ $830,700 × 100

= 63.68%

It is same applicable for other items also