Documenting the amortization schedule behind a financing model
A practical guide for commercial real estate sponsors to prepare an amortization evidence package that supports underwriting discussions, including a concrete worksheet to document repayment capacity.
A practical guide for commercial real estate sponsors to prepare an amortization evidence package that supports underwriting discussions, including a concrete worksheet to document repayment capacity.
What the lender expects from amortization documentation
Bank supervisory guidance notes that amortization schedules are a required element of underwriting standards [1]. Lenders typically evaluate the timing of principal repayment as a critical factor in loan structuring. Your task is to prepare a clear record of how the proposed amortization period and method affect the property's ability to service debt over time. This is not about stating a preference for a 25-year versus 30-year term; it is about showing the lender how the repayment schedule interacts with the property's income stream and your business plan.
Preparing the amortization evidence sheet
Create a single-page workpaper that documents the following for the proposed financing. Label it "Amortization Evidence Sheet — [Property Name]."
-
Loan amount and proposed term: Record the total senior debt requested, the proposed loan tenor (e.g., 5 years), and the amortization period (e.g., 25 years). If the loan includes an interest-only period, note the number of interest-only months and the total amortization period that begins afterward.
-
Payment calculation: Show the monthly payment under the proposed amortization schedule. For an interest-only period, show the interest-only payment separately, then the fully amortizing payment for the remaining term. Use a simple amortization calculator or spreadsheet to generate these figures.
-
Debt service coverage ratio (DSCR): Using the property's net operating income (NOI) from the trailing twelve months (T-12), divide by the annual debt service (total monthly payments × 12). If the loan has an interest-only period, calculate DSCR for both the interest-only period and the amortizing period. Lenders typically set minimum DSCR standards in their policies [1].
-
Collateral coverage projection: Estimate the loan-to-value (LTV) ratio at origination and at maturity, assuming the amortization schedule reduces principal. Compare these figures to the lender's stated LTV limits by property type [1].
Distinguishing the rent roll from the T-12
A current rent roll is a snapshot of occupancy and contracted rent as of a single date. The trailing twelve months (T-12) is a historical record of actual income and expenses over the past year. Do not compare the two as if they measure the same thing. When preparing your amortization evidence sheet, use the T-12 to calculate NOI for debt service coverage. The rent roll is useful for verifying current occupancy, but it does not show collection history, vacancy changes, or expense variability. Reconcile any differences between rent roll totals and T-12 income by identifying timing gaps, concessions, or bad debt.
Understanding income layers in the repayment analysis
Break down the property's cash flow into distinct layers to show the lender how debt service fits into the full picture:
- Gross rent: Total contracted rent before any deductions.
- Collected income: Gross rent minus vacancy, concessions, and bad debt.
- Net operating income (NOI): Collected income minus operating expenses (property management, utilities, insurance, taxes, repairs).
- Debt service: Annual principal and interest payments under the proposed amortization schedule.
- Capital expenditure (capex) reserves: Funds set aside for future repairs or replacements, typically deducted from NOI before debt service.
- Equity cash flow: What remains after debt service and capex reserves.
Lenders typically underwrite to NOI minus a capex reserve, then apply the DSCR test. If your business plan assumes lower capex than the lender's standard, be prepared to justify the difference with a capital needs assessment or recent renovation records.
Interest-only periods and their documentation
Interest-only periods are common for construction and stabilization phases when property cash flow is temporarily insufficient to support principal payments [1]. If your request includes an interest-only period, document the following:
- The length of the interest-only period (typically three to five years maximum per supervisory guidance) [1].
- The property's projected cash flow during that period, showing that it can at least cover interest.
- The loan-to-value ratio at origination, which lenders may set more conservatively for interest-only loans [1].
- The as-if amortizing debt service coverage: calculate what the DSCR would be if the loan were amortizing from day one, even though payments are interest-only initially. Lenders often require that the property could support the amortizing payment even if it is not being made [1].
If the interest-only period is requested because the property is not yet stabilized, provide a lease-up schedule or renovation timeline that shows when full income is expected. The lender will want to see that the interest-only period ends when cash flow can support principal payments.
Matching amortization to property type
Supervisory guidance indicates that amortization periods should reflect the property's income stability and useful life [1]. While there is no regulatory maximum, prudent lenders generally consider 30 years reasonable for income-producing commercial real estate. Properties with volatile income streams or weak future value prospects typically merit shorter amortization periods [1].
For your amortization evidence sheet, note the property type and explain why the proposed amortization period is appropriate. For example, stabilized multifamily properties may support a 30-year amortization, while hotels generally do not exceed 20 years [1]. If your property is a condominium or single-family residential project converting to rentals, note that amortization periods of less than 30 years are generally considered reasonable due to accelerated depreciation relative to owned units [1].
Presenting the package to the lender
Organize your amortization evidence sheet and supporting documents into a clear package. Include:
- The amortization evidence sheet described above.
- The T-12 operating statement with NOI clearly identified.
- The current rent roll with a note explaining any differences from the T-12 income.
- A pro forma showing projected income and expenses for the loan term, with assumptions labeled.
- The sources and uses of funds statement, showing how the loan proceeds will be deployed.
How do I calculate the balloon payment at maturity?
Use an amortization calculator or spreadsheet. Input the loan amount, interest rate, amortization period, and loan tenor. The calculator will show the monthly payment and the outstanding balance after the tenor period. For interest-only periods, calculate the balance after the interest-only months as the original loan amount, then apply the amortizing payment for the remaining months.
What if my T-12 shows lower NOI than the pro forma?
Reconcile the difference in writing. Identify whether the gap is due to one-time expenses, occupancy changes, or rent growth assumptions. Lenders will underwrite to the T-12 or a stabilized pro forma, whichever is more conservative. Be transparent about the assumptions and provide supporting evidence for projected increases.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).