HAV Financing Modelling

Based on the most helpful WSO content, here’s how you can approach building a model from a NAV (Net Asset Value) lender perspective:

1. Building the Model

• Understand the Borrower’s Portfolio: Start by analyzing the underlying assets in the borrower’s portfolio. This includes asset types, valuations, cash flow generation, and any existing leverage.
• NAV Calculation: Calculate the NAV by subtracting liabilities from the total asset value. This will serve as the foundation for determining the loan amount.
• Loan-to-NAV Ratio: Determine the appropriate Loan-to-NAV ratio based on the risk profile of the assets. This ratio will dictate the maximum loan amount.
• Cash Flow Projections: Build cash flow projections to assess the borrower’s ability to service the debt. Include interest payments, principal repayments, and any potential cash flow disruptions.
• Interest Rate and Fees: Model the interest rate (e.g., LIBOR + spread) and any associated fees (e.g., origination fees, exit fees).

2. Pricing Risk

• Asset Quality: Assess the quality and stability of the underlying assets. Higher-quality assets with stable cash flows will warrant lower risk premiums.
• Leverage Levels: Evaluate the borrower’s existing leverage. Higher leverage increases risk and may require higher pricing.
• Market Conditions: Consider current market conditions, including interest rate trends and sector-specific risks.
• Stress Testing: Perform stress tests to evaluate how the portfolio performs under adverse scenarios (e.g., declining asset values, reduced cash flows).

3. Determining Terms

• Loan Tenor: Align the loan tenor with the expected liquidity events or cash flow stability of the portfolio.
• Covenants: Include covenants to protect the lender, such as minimum NAV thresholds, maximum leverage ratios, and restrictions on asset sales.
• Repayment Structure: Decide on the repayment structure (e.g., interest-only, amortizing, or bullet repayment) based on the borrower’s cash flow profile.
• Security Package: Ensure the loan is secured by the portfolio assets, with appropriate lien structures (e.g., first lien, second lien).

Additional Tips:

• Comparable Analysis: Use public comparable companies or similar deals to benchmark terms and pricing.
• Scenario Analysis: Incorporate multiple scenarios to understand the impact of different market conditions on the loan’s performance.
• Underwriting Discipline: Be prepared to defend your assumptions during credit committee discussions, as underwriting quality is critical.

If you’re looking for more detailed templates or examples, WSO offers financial modeling templates that could be helpful in building out your NAV lending model.

Sources: Tutorial: How to Model a Real Estate Development Construction Loan, Private Credit Resources and Prep, Leveraged Finance – 2017 Update, Secondary PE Modeling, Valuing Loans