You just closed Q3 for a mid-sized personal lines insurer and your manager asks you to explain the quarter's financial statements to a new analyst. The analyst understands individual line items but is struggling to connect net income, working capital movements, capital expenditures, and financing activity across the statements. You need to walk through the relationships using the quarter's actual numbers under U.S. GAAP and show how the ending cash balance is derived.
| Metric | Q3 Amount |
|---|---|
| Revenue | $1,200,000 |
| Operating expenses excluding depreciation | $900,000 |
| Depreciation expense | $50,000 |
| Interest expense | $20,000 |
| Tax expense | $46,000 |
| Increase in accounts receivable | $30,000 |
| Increase in accounts payable | $25,000 |
| Capital expenditures | $80,000 |
| Debt issued | $40,000 |
| Beginning cash balance | $150,000 |
How do the three core financial statements relate to each other in this quarter, and what ending cash balance would you report after walking through the links between net income, the balance sheet movements, and the cash flow statement?
Understanding of the income statement, balance sheet, and cash flow statementAbility to reconcile net income to operating cash flowAbility to explain how capex and debt issuance affect both cash and balance sheet accounts