Underwriting Spreadsheet Terms & Definitions Flashcards
Acquisition Details: Purchase Price
The total amount paid to acquire a property, reflecting its initial investment cost.
Acquisition Details: CapEx (Leveraged)
Capital expenditures financed through debt, covering property improvements or upgrades. Keeps cash reserves intact while enhancing property value.
Acquisition Details: DD, Legal & Civil Costs
Expenses for due diligence, legal, and civil requirements involved in the acquisition, including inspections, legal fees, and compliance checks.
Acquisition Details: Syndication Fee
A one-time fee paid to the General Partner(s) for sourcing, organizing, and structuring the investment, typically a percentage of the capital raised.
Acquisition Details: Closing Costs
All transactional expenses incurred to complete the property purchase, including legal fees, taxes, and lender fees.
Acquisition Details: Interest Reserve
Funds set aside to cover interest payments during periods of low or negative cash flow, typically during initial stabilization or renovation phases.
Acquisition Details: Down Payment/Cash to Close
Initial cash investment required to secure financing and close on the property, covering the loan down payment and associated closing costs.
Equation: Purchase Price - Loan Amount
Acquisition Details: Closing Credit
Seller-provided funds applied toward the buyer’s closing costs, effectively reducing the cash needed to close.
Purchase/Construction Loan: LTV
Loan-to-Value (LTV) ratio for financing, comparing loan amount to property value. Higher LTV means more leverage.
Equation: Loan Amount / Purchase Price
Purchase / Construction Loan: Start Quarter
The quarter when loan payments and interest accrual begin, marking the start of the financing term.
Purchase/Construction Loan: Term (Years):
Length of the loan period in years, affecting the loan’s interest schedule and amortization.
Purchase/Construction Loan: Interest Rate
The percentage charged by the lender on the loan principal, typically expressed as an annual rate.
Purchase/Construction Loan: Loan-to-Value (LTV)
The ratio of the loan amount to the property’s appraised value, determining leverage level and risk.
Equation: LTV = Loan Amount / Purchase Price
Purchase / Construction Loan: Construction Loan Type
Specifies if the loan is solely for property acquisition, construction, or both.
Purchase / Construction Loan: Loan Amount
Total capital borrowed to finance the acquisition or construction, based on LTV and property value.
Purchase / Construction Loan: Max Quarterly Debt Service (DS)
Maximum allowable loan payment per quarter, ensuring quarterly cash flow covers debt.
Equation: Max Quarterly DS = Annual Debt Service / 4
Purchase / Construction Loan: Max Annual Debt Service (DS)
Maximum allowable loan payment per year, ensuring annual cash flow can cover loan payments.
Equation: Max Annual DS = Principal + Interest
Purchase / Construction Loan: Debt Service Coverage Ratio (DSCR)
Measures property’s ability to cover debt obligations with NOI; a DSCR above 1.0 means income exceeds debt costs.
Equation: DSCR = NOI / Debt Service
Additional Loan (Interest Only - IO): Rate
The interest rate specifically for the interest-only loan, generally lower than an amortizing loan rate.
Additional Loan (Interest Only - IO): Amount
Total loan capital borrowed for the interest-only term.
Additional Loan (Interest Only - IO): Qts
Number of quarters during which only interest is paid, reducing initial debt service payments.
Refinance Assumptions: End of Quarter (Qt)
The quarter in which the refinance occurs, often planned based on stabilization or market conditions.
Refinance Assumptions: Interest Rate
The new rate applied to the refinanced loan, which may be lower than the original loan rate.
Refinance Assumptions: Cap Rate
The capitalization rate expected at refinance, based on current market conditions and property performance.
Equation: Cap Rate = NOI / Property Value
Refinance Assumptions: LTV (Refinanced)
Loan-to-value ratio for the refinanced amount, calculated based on updated property valuation.
Equation: Refinanced LTV = Refinanced Loan Amount / New Property Value
Refinance Assumptions: Years
Duration of the refinanced loan in years.
Refinance Assumptions: Type
Loan type designation as fixed-rate or adjustable-rate, affecting the predictability of future payments.
Refinance Assumptions: Annual NOI (next quarter)
Projected annual NOI post-refinance, based on stabilized income and expenses.
Refinance Assumptions: Implied Value
The estimated market value of the property at refinance, based on NOI and cap rate.
Equation: Implied Value = NOI / Cap Rate
Refinance Assumptions: Loan
The total amount refinanced, determined by updated property value and LTV.
Refinance Assumptions: Quarterly Debt Service
Quarterly payment required to service the refinanced loan.
Refinance Assumptions: Quarterly Debt Service
Annual payment required to service the refinanced loan.
Refinance Assumptions: DSCR (Refinanced)
Debt service coverage ratio post-refinance, evaluating the ability to cover new debt obligations with NOI.
Equation: Refinanced DSCR = NOI / Debt Service
Refinance Assumptions: Debt Yield
Measures the strength of refinance, calculated as NOI divided by loan amount.
Equation: Debt Yield = NOI / Loan Amount
Refinance Assumptions: Old Loan Amount
Remaining balance on the original loan before refinancing, impacting total refinance proceeds.
Refinance Assumptions: Refi Excess Cash
The cash remaining after refinancing the property, calculated by subtracting the original loan balance and refinancing costs from the refinanced loan amount. It provides liquidity for investors or reinvestment into the property.
Equation: Refi Excess Cash = Refinanced Loan Amount - (Old Loan Balance + Closing Costs)
Refinance Assumptions: Post Refi Basis ($)
The total property value or loan basis after refinancing, expressed in dollars. This reflects the updated financial structure after refinancing.
Refinance Assumptions: Post Refi Basis (%)
Property basis after refinancing, represented as a percentage. It indicates the new debt-to-equity balance in relation to the updated property valuation.
Operating Deficit
The shortfall between operating income and expenses when property cash flow is negative, often requiring cash reserves or additional capital to maintain operations.
Equation: Operating Deficit = Total Operating Costs - Operating Income
Raise B
A second capital raise structured to meet future funding needs, such as for additional improvements, operations, or debt service during stabilization.
Raise B: Amount
Total funds raised during the second capital raise, supplementing initial equity to meet ongoing or anticipated financial requirements.
Raise B: Raise Quarter (Qt)
The specific quarter in which the second raise takes place, coordinating with the project’s financial and operational milestones.
Sale Assumptions: End of Quarter (Qt)
The quarter in which the property is expected to be sold, marking the projected exit point for investors.
Sale Assumptions: Cap Rate at Sale
The capitalization rate anticipated at the time of sale, used to estimate the property’s market value.
Equation: Sale Cap Rate = Sale NOI / Expected Sale Price
Sale Assumptions: NOI at Sale
Net Operating Income expected at the time of sale, a key input for determining the property’s sale price using the cap rate.
Sale Assumptions: Implied Value
The estimated market value of the property at sale based on NOI and cap rate, used to calculate potential sale proceeds.
Equation: Implied Value = Sale NOI / Cap Rate
Sale Assumptions: Closing Costs
Expenses deducted from the sale proceeds to cover legal fees, broker commissions, and taxes at sale.
Sale Assumptions: Loan Repayment
The outstanding loan balance that must be repaid upon sale, reducing the amount of net sale proceeds.
Sale Assumptions: Net Sale Proceeds
Funds remaining after loan repayment and closing costs, distributed to investors as part of the exit strategy.
Equation: Net Sale Proceeds = Sale Price - (Loan Repayment + Closing Costs)
Limited Partner (LP) Returns: Total Distributions
The total cash flows and sale proceeds paid to Limited Partners over the life of the investment, including pref returns and profit splits.
Limited Partner (LP) Returns: Total Profit
Net profit earned by LPs after return of capital, including their share of property appreciation and operations.
Equation: Total Profit = Total Distributions - Initial Capital Invested
Limited Partner (LP) Returns: Average Equity Out
The average amount of LP equity invested in the property over time, useful for calculating return metrics like cash-on-cash.
Limited Partner (LP) Returns: Cash on Cash Return
Measures annual cash flow relative to equity invested, showing the cash income generated by the investment.
Equation: Cash on Cash = Annual Cash Flow / Total Equity Invested
Limited Partner (LP) Returns: XIRR (Extended Internal Rate of Return)
The annualized rate of return for LPs based on the exact timing of cash flows, accounting for both distributions and sale proceeds.
Deal Returns: Deal XIRR
The project’s total internal rate of return, annualized and calculated based on all cash inflows and outflows for both LPs and GPs.
Minimum Balance for Distribution
The minimum cash reserve required before distributions can be made to investors, ensuring the property retains enough liquidity to cover operations.