| Line | Amount | Use for |
|---|---|---|
| Net sales | 36,408 | context |
| Less: Cost of goods sold | 28,225 | context |
| Less: Depreciation | 1,760 | add-back in CFO |
| Earnings before interest and taxes (EBIT) | 6,423 | context |
| Less: Interest paid | 510 | context |
| Taxable income | 5,913 | context |
| Less: Taxes | 2,070 | context |
| Net income | 3,843 | starting line |
| Item | 2023 | 2024 |
|---|---|---|
| Cash | 2,060 | 1,003 |
| Accounts receivable | 3,411 | 4,218 |
| Inventory | 18,776 | 21,908 |
| Net fixed assets (NFA) | 14,160 | 14,080 |
| Accounts payable | 7,250 | 8,384 |
| Long-term debt | 9,800 | 11,500 |
| Common stock | 15,000 | 17,500 |
| Retained earnings | 6,357 | 3,825 |
| Line | Amount (highlight) | Hint |
|---|---|---|
| Cash at the beginning of the year | 2060 | 2023 cash |
| Cash from operations (CFO) | Indirect method | |
| Net income | 3843 | From income statement |
| + Depreciation | 1760 | Non-cash add-back |
| − Accounts receivable change | -807 | A/R ↑ is use |
| − Inventory change | -3132 | Inv ↑ is use |
| + Accounts payable change | 1134 | A/P ↑ is source |
| Net cash from operations | 2798 | CFO subtotal |
| Cash from investing (CFI) | Capex / fixed assets | |
| − Net capital spending | -1680 | (End NFA − Begin NFA) + Dep |
| Net cash from investing | -1680 | CFI subtotal |
| Cash from financing (CFF) | Debt, equity, dividends | |
| + Long-term debt | 1700 | 11,500 − 9,800 |
| + Common stock | 2500 | 17,500 − 15,000 |
| − Dividends | -6375 | RE_begin + NI − RE_end |
| Net cash from financing | -2175 | CFF subtotal |
| Total net change in cash | -1057 | CFO + CFI + CFF |
| Cash at the end of the year | 1003 | Matches 2024 cash |
| Line | Amount | Hint |
|---|---|---|
| Beginning Cash | 100 | Given |
| CFO | Indirect method | |
| Net income | 90 | EBIT − Int − Tax |
| + Depreciation | 5 | Add-back |
| − Increase in A/R | -20 | A/R ↑ is use |
| − (ΔInventory) | +10 | Inventory ↓ is source |
| + (ΔA/P) | -20 | A/P ↓ is use |
| Net cash from operations | 65 | CFO subtotal |
| CFI | Capex | |
| Net capital spending | -15 | Given explanation |
| CFF | Stock & dividends | |
| + Increase in common stock | 30 | Source |
| − Dividends | -10 | Use |
| Net cash from financing | 20 | CFF subtotal |
| Net change in cash | 70 | 65 − 15 + 20 |
| Ending cash | 170 | 100 + 70 |
| Line | Amount | Calc |
|---|---|---|
| Sales | 67,977 | given |
| Less: COGS | 44,693 | given |
| Gross Profit | 23,284 | 67,977 − 44,693 |
| Less: Marketing, G&A | 15,885 | given |
| Less: Depreciation | 1,616 | given |
| EBIT | 5,783 | 23,284 − 15,885 − 1,616 |
| Less: Interest expense | 530 | given |
| EBT | 5,253 | 5,783 − 530 |
| Taxes (36.70%) | 1,928 | 0.367 × 5,253 |
| Net Income | 3,325 | 5,253 − 1,928 |
| Shares outstanding (millions) | 1,623 | given |
| EPS | 2.05 | 3,325 ÷ 1,623 |
| Dividends paid | 1,569 | given |
| DPS | 0.97 | 1,569 ÷ 1,623 |
| Addition to Retained Earnings | 1,756 | NI − Div |
| Section | Amount | Calc |
|---|---|---|
| ASSETS | ||
| Cash | 545 | given |
| Accounts receivable | 1,085 | given |
| Inventories | 10,625 | given |
| Other current assets | 1,224 | given |
| Total Current Assets | 13,479 | sum |
| Gross fixed assets | 38,471 | given |
| Less: Accumulated depreciation | 13,411 | given |
| Net fixed assets (PPE) | 25,060 | 38,471 − 13,411 |
| Other fixed assets | 1,586 | given |
| TOTAL ASSETS | 40,125 | 13,479 + 25,060 + 1,586 |
| LIABILITIES | ||
| Accounts payable | 9,080 | given |
| Short-term notes payable | 1,042 | given |
| Total Current Liabilities | 10,122 | 9,080 + 1,042 |
| Long-term debt | 11,114 | given |
| TOTAL LIABILITIES | 21,236 | 10,122 + 11,114 |
| EQUITY | ||
| Common stock | 3,894 | given |
| Retained earnings | 14,995 | given |
| TOTAL EQUITY | 18,889 | 3,894 + 14,995 |
| TOTAL LIABILITIES + EQUITY | 40,125 | 21,236 + 18,889 |
| Resource | Link | Purpose |
|---|---|---|
| Nike financials | Nasdaq | Real statements |
| Balance Sheet template | jufinance | BS builder |
| Income Statement template | jufinance | IS builder |
| Cash Flow template | jufinance | CF builder |
| Ratio analysis | jufinance | Ratios |