Attronica Historical Financials — FY2022-2025 (version 1).xlsx

	A	B
1	Attronica Historical Financials — FY2022-2025
2	Single source of truth: audited financial statements \| Units: U.S. dollars, actual \| Date: April 20, 2026
3
4	PURPOSE
5	This workbook consolidates Attronica Computers, Inc.'s audited financial statements (FY2022-2025) into a single, formula-driven, auditable model. All hardcoded source data lives on the Inputs tab; every other tab is formula-driven and traces back to Inputs. The Audit Check tab provides automated integrity verification.
6
7	CONVENTIONS — Colors, Fonts, Number Formats
8	Navy headers (#1F3864, white bold 13pt)	Section and title rows
9	Column headers (#E8EAF6, bold 11pt, centered)	Year columns
10	Subtotal rows (#F2F2F2, bold)	Sub-section subtotals
11	Total rows (#D9E1F2, bold)	Grand totals
12	Blue font (#0070C0)	Hardcoded input values — ONLY on Inputs tab
13	Black font	Same-sheet formulas (arithmetic on cells within the same tab)
14	Green font (#548235)	Cross-sheet formula references (pulling from Inputs or another tab)
15	Red font (#C00000)	Flagged errors or failed audit checks
16	Audit PASS (green #548235 fill, white bold)	Check passed within $1 tolerance
17	Audit FAIL (red #C00000 fill, white bold)	Check failed — review required
18
19	Number formats:
20	Dollars	#,##0;(#,##0);"—"
21	Percentages	0.0%;(0.0%);"—"
22	Ratios/multiples	0.00"x"
23	Days	0" days"
24	Shares	#,##0
25
26	TAB STRUCTURE
27	1. Cover	This tab — purpose, conventions, structure, limitations
28	2. Inputs	ONLY tab with hardcoded values. Every value cited to a specific PDF page.
29	3. Income Statement	Formula-driven IS FY2022-2025. Margin rows at bottom.
30	4. Balance Sheet	Formula-driven BS at 12/31 each year. Includes balance-check row.
31	5. Cash Flow Statement	Formula-driven CFS (indirect method). Beginning cash linked to prior-year BS.
32	6. Equity Rollforward	Statement of Stockholders' Equity FY2022-2025.
33	7. Ratio Analysis	Profitability, growth, liquidity, working capital, leverage, returns, cash flow quality.
34	8. Audit Check	15 integrity checks with OVERALL STATUS cell.
35
36	DATA SOURCE
37	Audited Financial Statements PDFs (3 documents):
38	• audited-2023.pdf (23 pp) — FY2022 comparative + FY2023 audited (UNCONSOLIDATED, prior auditor for FY2022)
39	• audited-2024.pdf (21 pp) — FY2023 comparative + FY2024 audited (CONSOLIDATED — adds Attronica.AI)
40	• audited-2025.pdf (22 pp) — FY2024 comparative + FY2025 audited (CONSOLIDATED)
41	Reconciled extraction file: extraction-RECONCILED.md (180+ line items × year combinations, double-extracted, 100% agreement).
42
43	KNOWN LIMITATIONS
44	1. S-Corp — no income tax line on IS. Attronica is a federal S-Corporation; tax attributes pass through to stockholders. Net income = pre-tax income every year. For DCF/valuation, a normalized corporate tax rate (e.g., 26% blended) must be layered in manually.
45	2. Consolidation scope change. FY2022-FY2023 = unconsolidated Attronica Computers standalone. FY2024-FY2025 = consolidated (adds Attronica.AI, LLC, formed 2024; 80% owned 2024 → 100% 2025). NCI impact is immaterial.
46	3. Auditor change FY2022 → FY2023. FY2022 figures audited by prior firm (report dated March 9, 2023). Current auditor (Rockville, MD firm) audited FY2023-FY2025.
47	4. No FX line. Company holds CAD cash ($48K-$183K) in Canadian bank. Management treats exposure as immaterial; no FX translation or CTA line in any audited statement.
48	5. Immaterial disclosure gap. $2,000 NCI equity contribution (FY2024) appears on Statement of Equity but is NOT on CFS. Flagged for completeness.
49	6. $(5,978) Attronica.AI consolidation adjustment to RE (FY2024) — not explained in notes beyond the rollforward itself. Worth asking management for narrative.
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100