Commercial and Industrial Loans
Returns the total amount of commercial and industrial (C&I) loans outstanding at U.S. commercial banks, sourced from the Federal Reserve.
Data Source
Federal Reserve Statistical Release H.8 - Assets and Liabilities of Commercial Banks.
Usage Notes
- No parameters required
- Returns value in billions of dollars
- Data updated weekly
- Key indicator of business borrowing and economic activity
Economic Interpretation
| Trend | Interpretation |
|---|---|
| Rising | Business expansion, economic growth |
| Falling | Business contraction, economic caution |
| Rapid rise | Potential credit bubble concerns |
| Rapid fall | Credit crunch, recession risk |
Syntax
=Loans()Returns
number
Commercial and industrial loans outstanding in billions of dollars
Examples
=Loans()When to Use
- Analyzing business credit conditions
- Tracking corporate borrowing trends
- Building credit cycle dashboards
- Forecasting business investment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need consumer credit | ConsumerCreditOutstanding() |
| Need mortgage rates | MortgageRate30y() |
| Need bank reserves | BankReserves() |
Common Issues & FAQ
What types of loans are included?
Commercial and industrial loans include business loans for working capital, equipment, and other commercial purposes - not mortgages or consumer loans.
What units is this in?
Loans are reported in billions of U.S. dollars.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?