New Issue Loan Funding or Purchase Total Return Excel Model

All Industries, Financial Model, General Excel Financial Models

10-year Financial Projections, 5-year Financial Projections, Amortization, Bad Debt, Break-Even, Budgeting, Capitalized Earnings, Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash Multiple, Cost Projections, Dashboard, Debt Amortization, Debt Schedule, Debt Service Coverage, Excel, Financial Analysis, Financial Debt, Financial Due Diligence, Financial Feasibility, Financial Model, Financial Modeling, Financial Projections, Financial Ratios, Financing, Forecast, Forecasting, Interest Accrual, IRR (Internal Rate of Return), Levered Yield, LLCR (Loan Life Coverage Ratio), Loans, Mergers and Acquisitions Model, Mortgage, NPV (Net Present Value), Pro-Forma, Return on Invested Capital (ROIC), Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Uses and Sources of Funds, WACC (Weighted Average Cost of Capital)

New Issue Loan Funding or Purchase Total Return Excel Model

What is this model template used for?

This Excel financial model is designed to provide comprehensive analysis for professionals evaluating loan investments, whether originating new loans or purchasing existing loans in the secondary market. The model calculates expected financial returns, assesses the impact of leverage on performance, and provides detailed cash flow projections throughout the entire loan lifecycle. It serves as an essential decision-making tool for lenders, investors, and financial analysts who need to determine the profitability and viability of loan investments under various scenarios.

Main Features and Highlights

Complete Return Metrics Suite: The model calculates all critical investment return metrics including IRR (Internal Rate of Return), Cash-on-Cash returns, MOIC (Multiple on Invested Capital), dollar profit, and investment duration. These metrics are presented for both the underlying note and the total investment return.
Leverage Analysis Capabilities: Users can model debt financing with adjustable Loan-to-Value (LTV) parameters, debt costs, and amortization schedules to evaluate how different leverage structures impact overall returns.
Flexible Loan Configuration: The model accommodates various loan structures with customizable parameters for interest rates, loan term, amortization period, balloon payments, and purchase prices (including discounts or premiums to par).
Detailed Cash Flow Breakdown: The model separates cash flows into distinct components (return of capital, return on capital, interest) providing transparency into the sources of investment returns.
DSCR Monitoring: The Debt Service Coverage Ratio is automatically calculated throughout the loan term, allowing users to assess risk and ensure compliance with debt covenants.
Side-by-Side Comparison: The model presents both levered and unlevered performance metrics, enabling users to clearly see the impact of using debt financing versus all-equity investments.
Monthly and Annual Views: Cash flows are projected on both monthly and annual bases, providing both detailed monthly tracking and simplified annual summaries.

How to best work with this template

The model follows a clear, user-friendly structure with:

Input sections for loan assumptions, debt parameters, and purchase/funding terms
Automated calculation of payment schedules and amortization
Comprehensive cash flow projections
Summary sections displaying key return metrics

All input cells are clearly marked, allowing users to quickly adjust parameters and immediately see the impact on returns. The model is built with full transparency – all formulas are visible and logically structured, with no hidden calculations or macros.

For best results, users should:

Begin by entering the core loan parameters (amount, rate, term) in the designated input cells
Adjust leverage and purchase price settings to model specific scenarios
Review both the summary metrics and detailed cash flows to understand the complete investment profile
Compare multiple scenarios by saving versions of the model with different input combinations

Why you need this Financial Model Template

In today’s competitive lending environment, precision in return calculations and thorough scenario analysis are essential for successful loan investments. This model provides:

Time Savings: Eliminates the need to build complex cash flow projections from scratch
Decision Support: Provides the analytical framework required for data-driven investment decisions
Risk Management: Helps identify potential issues through detailed cash flow visibility
Presentation-Ready Outputs: Offers professional-quality analysis for stakeholder presentations
Flexibility: Works across various loan types and investment strategies
Competitive Edge: Enables quick evaluation of opportunities in fast-moving markets

Whether you’re a commercial lender evaluating new loan opportunities, a debt investor analyzing secondary market purchases, or a portfolio manager optimizing a loan book, this model provides the analytical rigor needed to maximize returns and minimize risks across your loan investments.

You must log in to submit a review.