# Student Loan Model Build a student loan financial model for lending platforms and fintech originators. Model repayment structures, grace periods, default curves, and warehouse facility drawdowns with institutional-grade precision. - Canonical: https://finamodel.com/templates/student-loan-model - Excel download: https://finamodel.com/templates/student-loan.xlsx - Category: Credit - Model type: Underwriting - Difficulty: Advanced - Audiences: Credit & risk, Investors & analysts, Credit analysts, Servicers, Bond investors, Policy analysts - Tags: ABS, repayment, forbearance, cohort, servicer ## Overview Compare student loan repayment plans - standard amortization or income-driven repayment (IDR) - to calculate the lowest total cost over a 25-year horizon. This borrower-focused model projects payments under both plan types, accounts for Discretionary Income thresholds tied to the Federal Poverty Level, and estimates the tax liability if forgiveness is triggered. Interest accrual, negative amortization, and the interaction between rising income and payment caps are all modeled explicitly. The workbook contains a 25-year repayment schedule for each plan, a Borrower_Income sheet tracking discretionary income and affordability ratios, and detailed P&L-equivalent outputs showing cumulative cost, forgiven balance, and tax-bomb implications. Grace-period interest capitalization is handled upfront; payment formulas reference a single master payment calculation to ensure consistency across all years. Standard repayment is best for borrowers with predictable incomes and no forgiveness eligibility; IDR plans suit graduates with low starting salaries or substantial forgiveness expectations. Origination balance averages $45,000 (federal data); IDR rates default to 10% of discretionary income with 25-year forgiveness. ## What's included - Multi-tranche cohort modelling by vintage and programme type - Repayment and grace period logic with graduation-based transitions - Default rate curves and recovery lag assumptions - Warehouse financing and capital stack modelling - Net interest margin and unit economics outputs - Loan origination and cohort segmentation by school type and degree level - Repayment schedule mechanics with multiple repayment plans - Forbearance and deferment period tracking - Default assumptions and loss severity by cohort - Cash flow waterfall with collections, interest, and principal - Portfolio-level analytics and delinquency aging ## How the Student Loan Model Compares Standard and Income-Driven Repayment This student loan model helps borrowers compare two federal repayment paths: standard amortisation and income-driven repayment. It projects annual payments, interest accrual, and the potential tax liability from forgiven balances over a 25-year horizon. The template provides a transparent framework for evaluating total cost and monthly affordability, using configurable assumptions for loan terms, income growth, and poverty-level thresholds. ### Operating Drivers: Loan Terms, Income, and IDR Parameters The model's behaviour is shaped by inputs on the Assumptions sheet. Loan terms include the original balance, annual interest rate, grace period, and standard repayment term. - A capitalisation flag determines whether accrued interest during grace is added to principal. The IDR side relies on the discretionary income formula, which subtracts a multiple of the Federal Poverty Level (FPL) from gross income. - The payment rate, forgiveness year, family size, and FPL inflation rate are all configurable, allowing the model to represent any IDR plan by adjusting these parameters. Income assumptions include the starting salary, annual growth rate, and the marginal tax rate applied to forgiven amounts. ### Calculation Flow: Annual Schedules and Payment Logic The model builds two parallel annual schedules: one for standard repayment and one for IDR. In the standard schedule, the annual payment is computed once at grace-end using the PMT function and remains fixed for the entire term. - Each year, interest is calculated on the opening balance, and principal is reduced by the payment amount. The IDR schedule uses a separate income projection to determine discretionary income and the uncapped IDR payment, which is then capped at the standard payment. - Interest accrues on the opening balance; payments cover interest first, and any remainder reduces principal. When payments are less than interest, negative amortisation occurs and the balance grows. No circular references exist because IDR payments depend only on income, not on the loan balance. ### Outputs: Total Cost, Forgiveness, and the Tax Bomb The Summary sheet presents a side-by-side comparison of total payments, interest paid, and final balances. For standard repayment, the loan fully amortises, and the final balance is zero. - For IDR, the model calculates the forgiven balance at the end of the forgiveness year, which is then multiplied by the assumed marginal tax rate to produce the tax bomb. The effective total cost for IDR equals all payments made plus the tax bomb. - The model also computes a differential and recommends the plan with the lower total cost. Additionally, it derives annual and monthly savings under the recommended plan, providing a clear measure of financial impact. Calculation summary: ```text The effective total cost for IDR = all payments made + the tax bomb ``` ### Practical Use: Evaluating Repayment Plans and Affordability This template is designed for individual borrowers or advisors assessing federal student loan repayment options. By adjusting assumptions such as income growth or family size, users can explore how IDR payments evolve and whether they remain affordable relative to income. - The model also highlights the importance of planning for the tax bomb, a one-time tax liability that can be substantial. The built-in checks ensure that both schedules balance and that payments never exceed the standard amount. - While the public download is a values-only preview, the underlying structure captures the key relationships needed to compare plans and supports informed decision-making. ## Built for student lending platforms Use this model when origination volumes, default curves, and warehouse facility economics drive the business case for a student lending operation. ## Handles complex repayment structures A strong student loan model captures in-school interest-only periods, post-graduation grace periods, and the transition to fully amortising payments. ## Useful for capital raising and facility negotiation Demonstrate long-term unit economics and stress-test portfolio performance under different prepayment and default scenarios. ## Built for student lending platforms Use this model when origination volumes, default curves, and warehouse facility economics drive the business case for a student lending operation. ## Handles complex repayment structures A strong student loan model captures in-school interest-only periods, post-graduation grace periods, and the transition to fully amortising payments. ## Useful for capital raising and facility negotiation Demonstrate long-term unit economics and stress-test portfolio performance under different prepayment and default scenarios. ## Features - **Cohort-driven analysis:** Segment borrowers by origination year, school type, and degree level to model repayment behavior independently for each cohort. - **Flexible repayment modeling:** Support income-based repayment (IBR), income-contingent repayment (ICR), standard amortization, and graduated plans in a single model. - **Default and deferment mechanics:** Model loss mitigation periods, forbearance costs, and default severity as functions of time in repayment and economic conditions. ## Use cases - **Student loan ABS structuring:** Price and stress-test student loan securities with transparent default and prepayment assumptions. - **Servicer cash flow forecasting:** Forecast collections, interest revenue, and servicing costs across a diversified portfolio. - **Credit policy analysis:** Model the fiscal impact of loan forgiveness programs or changes to repayment terms. ## Frequently asked questions ### What is a student loan financial model? It is a model that forecasts loan origination, repayment behaviour, default rates, and portfolio economics for student lending businesses or fintech platforms. ### Who uses student loan models? Fintech lenders, private loan originators, warehouse lenders, and investors use them for portfolio forecasting and capital planning. ### What should a student loan model include? It should include cohort-based origination, repayment schedules, default and recovery assumptions, warehouse financing, and net interest margin analysis. ### How does it handle loan defaults? The model applies monthly constant default rate curves to outstanding balances, with configurable recovery lags and net recovery percentages from collection efforts. ### Can I model both fixed and variable rate loans? Yes. The model supports SOFR-based variable rates with configurable spreads as well as fixed-rate tranches for interest rate sensitivity analysis. ## Related templates - [Auto Loan Portfolio Model](https://finamodel.com/templates/auto-loan-model) - [Mortgage Portfolio Model](https://finamodel.com/templates/mortgage-portfolio-model) - [Credit Portfolio CDO Model](https://finamodel.com/templates/credit-portfolio-cdo-model)