# Loan Book Schedule

Bank loan-portfolio build with yields, growth and provisioning.

- Canonical: https://finamodel.com/schedules/loan-book
- Group: Financing & Debt
- Found in: 3 models
- Sheet-name variants: Loan_Book, Loans

## About this loan book schedule

A loan book schedule forecasts loan balances, originations, repayments, yields, charge-offs, provisions, and portfolio growth. It turns lending assumptions into interest income, credit losses, capital needs, and balance sheet exposure.

Use this free Excel loan book schedule preview to compare bank, fintech, microfinance, and credit portfolio model structures. It is useful for lender operating models, credit risk analysis, portfolio valuation, and financial models built around loan asset performance.

## Source models

- [microfinance](https://finamodel.com/templates/microfinance) - sheet: Loan_Book
- [trade-finance](https://finamodel.com/templates/trade-finance-model) - sheet: Loan_Book
- [stress-testing](https://finamodel.com/templates/stress-testing-model) - sheet: Loan_Book

## Related schedules

- [Debt Schedule](https://finamodel.com/schedules/debt-schedule) - Tranche-by-tranche debt with draws, repayments, interest and balances.
- [Covenants](https://finamodel.com/schedules/covenants) - Leverage, coverage and liquidity covenant tests against thresholds.
- [Sources & Uses](https://finamodel.com/schedules/sources-and-uses) - Transaction funding bridge balancing sources against uses of capital.
- [Funding & Cash Runway](https://finamodel.com/schedules/funding-runway) - Cash burn, funding rounds and months-of-runway tracking.