Tamarack Outfitters (CAD thousands) reports total assets of 4,000 at 31 December 2025 and 3,400 at 31 December 2024; shareholders’ equity of 2,200 and 1,800; accounts receivable of 600 and 480; inventory of 720 and 560; accounts payable of 480 and 400. Compute the average balance of each, using (opening + closing) ÷ 2.
Tamarack Outfitters (CAD thousands) reports total assets of 4,000 at 31 December 2025 and 3,400 at 31 December 2024; shareholders’ equity of 2,200 and 1,800; accounts receivable of 600 and 480; inventory of 720 and 560; accounts payable of 480 and 400. Compute the average balance of each, using (opening + closing) ÷ 2.
Answer
Average total assets → 3700 · Average equity → 2000 · Average receivables → 540 · Average inventory → 640 · Average payables → 440
Cells - Average total assets · ±0 - Average equity · ±0 - Average receivables · ±0 - Average inventory · ±0 - Average payables · ±0 Each average is (opening + closing) ÷ 2: assets (3,400 + 4,000) ÷ 2 = 3,700; equity (1,800 + 2,200) ÷ 2 = 2,000; receivables (480 + 600) ÷ 2 = 540; inventory (560 + 720) ÷ 2 = 640; payables (400 + 480) ÷ 2 = 440. Excel: =AVERAGE(C5,D5) on the two year-end columns.
Bigel §6.2; Lyryx IFA Vol 2 §22.4.4; Lyryx Intro FA §12.3