Question

Using these data from the comparative balance sheet of Rollaird Company, perform horizontal analysis.

December 31, 2020 December 31, 2019
Accounts receivable $550,200 $420,000
Inventory 855,600 620,000
Total assets 2,909,750 2,575,000
(Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)
Increase or (Decrease)
December 31, 2020 December 31, 2019 Amount Percentage
Accounts receivable $550,200 $420,000 $ %
Inventory 855,600 620,000 $ %
Total assets 2,909,750 2,575,000 $ %

Answer 1

1) Accounts receivable amount = $550,200 - $420,000

Accounts receivable amount = $130,200

% increase = $130,200/$420,000 * 100

% increase = 0.31 * 100

% increase = 31%

2. Inventory amount = $855,600 - $620,000

Inventory amount = $235,600

% increase = $235,600/$620,000 * 100

% increase = 0.38 * 100

% increase = 38%

3. Total asset amount = $2,909,750 - $2,575,000

Total asset amount = $334,750

% increase = $334,750/$2,575,000 * 100

% increase = 0.13 * 100

% increase = 13%