Module 5 Levered Analysis, Sensitivity Analysis, and DCF

Overview of the Program

  • Program Focus: The main objectives of the program include understanding investments, building the pro forma, and blending unlevered and levered returns.

Session Breakdown

  • Initial Sessions: Introduction to the basics of investments and building pro forma.

  • Topics Covered:

    • Unlevered Returns: Definition and understanding.

    • Debt Sizing: Analyzing how debt impacts investment returns and cash flow.

    • Levered Returns: Understanding the integration of unlevered returns, loan amounts, and debt service to determine final returns.

  • Key Concept: Financial modeling is a continuous process that evolves with ongoing due diligence.

Financial Modeling and Due Diligence

  • Modeling Process:

    • Mechanical aspect: Using standard procedures to build financial models.

    • Understanding component: Incorporating personal expertise and insights on assumptions.

    • Continuous improvement: Updating models based on new information and learning during the underwriting process.

  • Real-World Example: An example of an underwriter for an apartment building highlights how different firms may adapt and refine their models.

Key Definitions

  • Unlevered Cash Flow: Refers to cash flow derived from the operation that does not factor in debt financing. It means cash flow before any debt obligations.

  • Net Operating Income (NOI): The revenue generated from a property minus the operating expenses, used to calculate unlevered cash flow.

  • Cash Flow Before Debt: Calculated as NOI minus capital expenditures (CapEx).

Financing Deals

  • Types of Financing:

    • Focuses on Equity and Debt but excludes distinctions like preferred equity and mezzanine debt.

    • Encouragement to join a Capital Markets Course for in-depth understanding.

  • Value of Debt:

    • Enhancing Returns: Using debt can amplify returns; for example, a leveraged situation can yield 6x returns compared to 2x for unleveraged.

    • Increasing Purchasing Power: Allows investors to acquire multiple assets rather than just one, making investments more feasible.

Types of Debt

  • Permanent Debt: Fixed-rate debt that is tied to stable income-generating properties.

  • Bridge Debt: Short-term financing designed for properties undergoing renovations or lease-up periods.

  • New Construction Loans: For funding new developments.

Debt Sizing Metrics

  • Debt Service Coverage Ratio (DSCR): Measures cash available to pay current debt obligations, indicating financial health.

  • Debt Yield: A measure of the return generated on a property based on net operating income against the debt amount.

  • Loan to Value (LTV): A ratio of the loan amount to the appraised value or purchase price of the property.

  • Conservative Approach: Banks typically use the most conservative measure when determining the loan size.

Levered Cash Flow Analysis

  • Introduction to Levered Cash Flow:

    • Incorporates debt service obligations into financial calculations and determines cash flow after accounting for these obligations.

  • Components of Levered Cash Flow:

    • Cash Flow Before Debt: Total cash generated before debt obligations.

    • Debt Service: Total payments made in interest and principal to the lender.

    • Calculation: Cash flow after debt = Cash flow before debt - Debt service payments.

Debt Service Calculation

  • Using PMT Function:

    • Debt service is calculated by using the PMT function in Excel which incorporates interest rate, loan amount, and amortization schedule.

    • Factors: Monthly payment, total number of payments, and interest rate—critical for creating a loan amortization schedule.

Loan Amortization Schedule Example

  • Example Setup: 100,000 loan at a 5% interest rate for 25 years.

  • Calculating Payments: Monthly payment calculated through the PMT function in Excel gives $5.85 per month.

  • Annual Debt Service: Total payments per year = $5.85 * 12 = $7,000.

  • Amortization Effect: Differences in loan breakdown between principal and interest over time with payments outlined month to month.

Understanding Balloon Payments

  • Loan and Amortization Term Difference: The concept of balloon payments arises when the loan term is shorter than the amortization term.

  • Mastering Payment Calculations:

    • Identify outstanding balance due at the end of the loan term.

    • Define repayment obligations based on remaining balance from loan amortization schedule.

Leveraged Returns Analysis

  • Measuring Success: The Internal Rate of Return (IRR) is the most common metric for leveraging and evaluating projects.

  • Components Required to Calculate Levered IRR:

    • Purchase price, amount of loan, equity invested, cash flow after debt, sales proceeds, and loan repayment sum.

  • Example Setup for Calculation:

    • Purchase price: $1,150,000.

    • Assumed annual cash flow before debt: $50,000.

    • Estimated sales price after five years: $1,300,000.

    • Debt representing 70% of the purchase price.

Transitioning from Unlevered to Levered Cash Flows

  • Unlevered Cash Flows Setup: Total inclusion from purchase amounts, cash flows, and sales proceeds.

  • Calculation Methodology: Deduct debt service from total cash flows to yield levered cash flows.

  • Final Levered Cash Flow Calculation: Reflects after loans are taken into account, with clear rules governing repayment priorities.

Conclusion

  • Levered vs. Unlevered Cash Flow: Understanding the transitions between unlevered and levered cash flows is critical for evaluating financial scenarios.

  • Continual Learning: Importance of building foundational knowledge through practical experience in creating loan amortization schedules and understanding the implications of debt service on investments.

Quiz

Levered Cash Flow & Returns — Answer Recap

  1. What is Levered Cash Flow in real estate finance?
    Answer: B — Cash flow generated by a property after accounting for operating expenses, taxes, and debt service.

  2. How is Debt Service calculated?
    Answer: B — Interest Expense + Principal Amortization.

  3. What is the purpose of a Loan Amortization Schedule?
    Answer: C — To allocate interest payments and principal repayment across the maturity of the loan.

  4. What happens at the end of a loan term if there is a Balloon Payment?
    Answer: B — A lump sum payment is made that is significantly larger than preceding payments.

  5. What does the Cash Flow After Debt represent?
    Answer: B — The cash flow after deducting debt service from Cash Flow Before Debt.

  6. What is the difference between Levered and Unlevered IRR?
    Answer: A — Levered IRR considers debt, while Unlevered IRR does not.

  7. Why might an investor calculate both Levered and Unlevered IRR?
    Answer: B — To assess the impact of financing decisions on investment returns.

  8. Which of the following is NOT typically included in Levered Cash Flow?
    Answer: C — Sales Proceeds.

  9. How does debt affect Cash Flow After Debt?
    Answer: A — It decreases Cash Flow After Debt due to debt service payments.

  10. What is the significance of a higher Levered IRR compared to Unlevered IRR?
    Answer: B — It shows that leverage has increased the return on equity.

  11. What is the impact of interest-only loans on Cash Flow After Debt?
    Answer: A — They reduce the principal repayment, increasing Cash Flow After Debt.

  12. What is the main benefit of using leverage in real estate investments?
    Answer: B — It increases the purchasing power and potential return on equity.

  13. When would a Balloon Payment typically be required?
    Answer: C — At the end of a loan term where the amortization period is longer than the loan term.

  14. What is Cash on Cash Return?
    Answer: B — The annual pre-tax cash flow divided by the total equity invested.

  15. How is the Sales Proceeds calculated in a Levered Cash Flow analysis?
    Answer: C — Sales Price − Loan Repayment.