Real estate investment metrics course

Identify the main types of real estate investments (residential, commercial, industrial, land).

Distinguish between property investment strategies (buy-and-hold, fix-and-flip, wholesale, BRRRR).

Calculate gross rental income from property rent specifications.

Itemize and calculate operating expenses for a rental property (maintenance, insurance, property tax, utilities).

Calculate net operating income (NOI) from gross rental income and operating expenses.

Calculate operating expense ratio (OER) to assess property efficiency.

Define and estimate capital expenditures (CapEx) and distinguish them from operating expenses.

Write Python code to model basic rental property income and expenses to calculate NOI.

Calculate monthly mortgage payments (debt service) using loan amount, interest rate, and term specific to Spanish market conditions.

Calculate loan-to-value (LTV) ratio and its implications for financing.

Calculate cash flow after financing but before taxes (Pre-Tax Cash Flow).

Calculate cash-on-cash return for a rental property investment.

Calculate equity buildup through mortgage principal paydown.

Analyze the impact of different down payment amounts and interest rates on cash flow and returns.

Write Python code to create a mortgage amortization schedule and model pre-tax cash flow.

Compute capitalization rate (cap rate) and interpret its meaning for property valuation.

Apply the income approach to value properties using cap rate.

Calculate gross rent multiplier (GRM) and use it for quick property evaluation.

Calculate return on investment (ROI) for a property sale transaction.

Compute total return including cash flow, appreciation, and equity buildup for a single period.

Calculate value per square meter and value per unit metrics for comparison.

Write Python code to compare multiple properties using cap rate, CoC return, and GRM.

Analyze key market demographic and economic indicators (population growth, job growth, median income).

Calculate and interpret supply/demand indicators like absorption rate, months of supply, and price-to-rent ratio.

Assess qualitative neighborhood factors like school ratings, crime statistics, and walkability scores.

Interpret a property inspection report to identify defects and estimate CapEx budgets.

Analyze key lease terms including duration, renewal options, and rent escalation clauses.

Evaluate tenant quality and property management efficiency.

Create a scoring model to quantify qualitative property and market factors.

Write a Python script to fetch and analyze demographic and market data for a specific area using a public API.

Calculate present value (PV) and future value (FV) of real estate cash flows.

Define and estimate a property-specific discount rate.

Project multi-year rental income and operating expenses with growth assumptions.

Model a multi-year pro forma cash flow statement, including projected NOI.

Calculate reversion value (projected sale price) at the end of a holding period.

Compute net present value (NPV) for a real estate investment opportunity.

Calculate internal rate of return (IRR) for multi-year investment cash flows.

Write Python code to build a multi-year pro forma and calculate NPV and IRR.

Describe the methodology of the sales comparison approach for property valuation.

Select appropriate comparable properties and apply adjustments to determine a property's value.

Explain the cost approach and when it is applicable for valuation.

Assemble a complete multi-year cash flow statement for a discounted cash flow (DCF) analysis.

Calculate a property's value using the DCF method by discounting projected cash flows and reversion value.

Reconcile valuation figures from the income, sales comparison, and DCF approaches to determine a final market value estimate.

Write Python code to perform a DCF valuation for an income-producing property.

Calculate equity multiple to evaluate total cash return to the investor.

Compute modified internal rate of return (MIRR) with explicit reinvestment assumptions.

Calculate profitability index for comparing investment opportunities of different scales.

Calculate the standard deviation of projected returns to quantify investment volatility.

Calculate the Sharpe ratio to assess risk-adjusted returns.

Calculate the Sortino ratio to assess risk-adjusted returns focusing on downside risk.

Calculate maximum drawdown from a time series of investment values.

Write Python code to calculate MIRR, Sharpe Ratio, and Maximum Drawdown for an investment.

Calculate debt service coverage ratio (DSCR) and interpret lender requirements.

Compute break-even occupancy rate for rental properties.

Calculate debt yield as a measure of leverage risk.

Perform sensitivity analysis on key variables (rent, vacancy, exit cap rate) to measure their impact on NPV and IRR.

Build tornado diagrams to visualize variable impact on returns.

Create scenario models (best case, base case, worst case) for investment outcomes.

Perform a Monte Carlo simulation to generate a probabilistic distribution of investment returns.

Write Python code to perform sensitivity and scenario analysis on a property's returns.

Distinguish between IVA and ITP taxes on property purchases in Spain and calculate their amounts.

Identify deductible expenses for rental properties under Spanish IRPF regulations.

Explain depreciation (amortización) under Spanish tax law and calculate annual deductions.

Calculate net rental income after deductions for Spanish tax purposes.

Calculate IRPF tax on rental income for Spanish residents, considering applicable reductions.

Compute after-tax cash flows for Spanish rental properties.

Write Python code to model after-tax cash flow for a Spanish rental property.

Calculate the adjusted acquisition cost (valor de adquisición) for a property under Spanish tax law.

Compute the gain subject to IRPF capital gains tax from a Spanish property sale.

Calculate the IRPF capital gains tax liability for property sales in Spain.

Calculate plusvalía municipal (local capital gains tax) for a property sale.

Analyze the impact of holding period on capital gains taxation in Spain.

Calculate after-tax IRR for Spanish property investments, incorporating all taxes.

Write Python code to model the total tax liability (IRPF and plusvalía) from a property sale.

Calculate wealth tax (Impuesto sobre el Patrimonio) liability for real estate holdings in Spain.

Model the combined annual tax impact of IRPF and wealth tax on investment returns.

Analyze the tax implications of investing through a Spanish holding company (Sociedad Limitada) vs. personal ownership.

Compare the tax treatment of rental income and capital gains for a Sociedad Limitada vs. an individual.

Calculate the tax impact of non-resident property ownership in Spain.

Evaluate tax-efficient exit strategies for Spanish real estate investments.

Write Python code to model and compare the after-tax returns of owning property personally versus through a Sociedad Limitada.

Describe the role of diversification and correlation in managing real estate portfolio risk.

Analyze portfolio concentration by property type and geographic market.

Calculate the correlation of returns between different real estate assets in a portfolio.

Calculate total portfolio risk-adjusted returns (e.g., Portfolio Sharpe Ratio).

Define a framework for building a diversified real estate portfolio in Spain.

Develop a comprehensive Python model integrating financial projections, multi-faceted tax calculations, and risk metrics for a single asset.

Write Python code to implement a basic portfolio allocation optimization for multiple Spanish properties based on after-tax risk and return metrics.