
On boarding. Welcome to the course. This is my official introduction of myself
Explore 15 years of affordable housing and real estate experience. Learn from leadership at the New York City Housing Development Corporation on securitization analysis and mortgage modifications.
Explore the four-section course: from basic multifamily vs single-family deals, due diligence and key players, through turnkey, moderate rehab, and new construction finance, to asset management and financial metrics.
Explore multifamily real estate, defined as four or more units, and compare it to single-family deals, then summarize turnkey, moderate rehab, and full rehab/new construction investment types.
Identify the five players in multifamily development—investors, developers, lenders, government entities, and tenants—and explain their roles, motivations, and how they create stable, affordable housing.
Define essential real estate terms, including mortgage, mortgage note, underwriting, tax exemptions and abatements. Explain how rent roll, tenant receivables, accounts payable, loan-to-value, and debt service shape multifamily financing decisions.
Calculate equity as market value minus loan balance, then use net operating income and cap rate to estimate value; assess debt service coverage ratio and bank requirements.
Learn to use Excel to calculate mortgage payments, build an amortization schedule from scratch, and determine debt affordability using the included examples.
Vet a real estate deal through qualitative and quantitative analysis to ensure thorough due diligence. Engage experts and regulators across five categories—socioeconomic, governmental and regulatory, marketability, physical, and financial.
Navigate government and regulatory requirements, including taxes, exemptions, registrations, and permits, and assess marketability with mass transit, schools, and shopping proximity, plus financial viability through site feasibility and environmental remediation.
Turnkey Spreadsheet with Development Budget, Revenue and Cost Structure, Pro Forma, Depreciation and Amortization. Please utilize for the remainder of the Turn Key Financial modeling
Analyze the pro forma cash flow from year one to year 30, detailing revenue, expenses, NOI, debt service, debt service coverage, and fair market value via cap rate.
Assess benchmark analysis and key performance ratios to gauge project profitability from the pro forma, revenue, and cost structure, and understand debt service coverage via NOI and mortgage payments.
Learn how cash on cash return measures profitability by comparing net cash flow to paid-in capital, calculating first-year and average returns across the project life.
Calculate nominal cash flow by summing cash flows through year 30. Discounted cash flow reveals the true value of future cash flows today.
Assess the present value of a 30-year cash flow by discounting at 3%. Compare this to a lump sum today and learn to compute discounted cash flow in Excel.
Learn to use Excel to calculate nominal cash flow by summing net cash flows from year one to year thirty, and compute discounted cash flow using NPV at three percent.
Financial Modeling Assignment for a Turnkey Deal
Excel Spreadsheet for Moderate Rehab Process
Outlines two periods in moderate rehab pro forma: initial acquisition with gap financing, and post-rehab with rent increases and cost reductions, boosting cash flow and debt service in year two.
This benchmark analysis uses the pro forma to show cash flow of 1.487 million, 3% discounted value of 856k, initial debt service coverage ratio of 1.23, and 12.91% average cash-on-cash.
Financial Modeling Assignment for a Moderate Rehab Deal
Compare full rehab and new construction pathways for multifamily development. Explain conversions of standing structures and the certificate of occupancy required to lease.
Assess cost, revenue, and operational benefits of new construction, including energy efficiency, metering, and tax incentives. Note how tenant mix and rent strategies affect operations, while acknowledging force majeure risk.
Explore the three phases of new multifamily construction—development, construction, and lease-up—and learn how financing, permits, and a marketing plan drive full occupancy over roughly three to four years.
Assess a new construction multifamily project with 10 units and a Dunkin Donuts under a triple net lease. Compute net operating income and debt service affordability with a 1.25 coverage.
Apply the 75 percent loan to value rule to compute market value from debt affordability and identify equity needed as the difference between total project costs and the loan.
Explore the construction budget for a multifamily project, detailing equity coverage, soft and hard costs, and a 15% contingency, plus the impact of loan fees and the permanent mortgage.
Calculate construction loan interest by finding the average outstanding balance from construction amount and contingency, then multiply by the annual rate divided by 12 and by the construction period.
Use Excel to compute construction loan interest by adding construction and contingency amounts, applying a 50% average outstanding balance, and calculating 4% interest over 18 months for a 30-year mortgage.
Build the permanent budget with a permanent mortgage that pays off construction loan, carry forward equity from construction, and fund debt service and operating reserves to cover year-one deficits.
Analyze a new construction proforma, highlighting year one deficit, year two stabilized debt service coverage, a 10-year developer note payoff, and both nominal and discounted cash flows for long-term return.
Financial Modeling for New Construction Deal
Learn how multifamily asset management translates forecasted returns into real-world performance by strategically and efficiently managing properties to meet investors' expectations amid changing market conditions.
Learn how multifamily asset managers navigate four macroeconomic environments - economic boom, stability, stagnation, and recession - and tailor strategies to maximize returns for investors.
Maximize rental income during an economic boom with above-normal rent increases on renewals and new leases; quickly evict delinquent tenants and boost ancillary income from vending, parking, and on-site laundromats.
Maximize rental income during economic stability with two percent rent increases at renewal, evict delinquent tenants quickly, grow ancillary income, and undertake only necessary capital upgrades while maintaining reserve contributions.
Navigate asset management in economic stagnation by maximizing rental income with below normal increases, enforcing repayment plans before evictions, expanding ancillary income, and adjusting reserve escrows.
Harness cloud-based property management software to streamline rent collection, tracking receivables, and reporting, while building budgets aligned to investor expectations and proforma performance.
Explore the revenue micro strategy that leverages ancillary income from tenants and non-tenant sources, using ethical tenant profiles to offer moving services, referrals, and realtor-related revenue.
Maximize non tenant based income by diversifying funds across savings, high yield CDs, and dividend stocks. Use this mix for operating, reserve, and security deposit accounts to boost interest earnings.
Evaluate revenue strategy by applying horizontal and vertical analyses to compare period performance, examine line-item contributions, and track changes in revenue sources.
Group costs into utilities, administrative, repairs and maintenance, and financial, then analyze each category before line items to improve net cash flow via sub metering, green efficiencies, and mortgage strategies.
Evaluate cost control results using horizontal and vertical analyses, comparing pre-metering and post-metering periods and assessing each cost item’s share of total costs, including base utilities and insurance.
Learn how operational strategy uses workflow processes and infrastructure to speed rent collection via electronic payments, ensure quick repairs, and enforce checks and balances with co-signers to save costs.
Assess owner’s risk appetite to guide leveraging and select investments that cash out equity from a multifamily asset, ensuring the new investment covers the equity cost and avoids high loan-to-value.
Explore two methods to cash out equity: refinancing to reach a target loan-to-value or securing a second mortgage or line of credit, guided by fair market value.
Calculate a cash-out equity loan to meet a 1.25 debt service coverage, using a moderate risk profile and preserving cushion for financial strength.
Learn to use excel to calculate leverage by preserving a 1.25 debt service coverage, determine cash-out equity, and structure a new mortgage and down payment for a seven-unit acquisition.
Allocate about $197,914.77 of equity as investor capital for a second mortgage to fund a 7-unit turnkey purchase, aiming for a $712,493.18 max price and $2,252.92 monthly payment.
Assess leverage return calculations for a seven-unit multifamily project, comparing net cash flow, debt service coverage, and cash-on-cash returns using turnkey rent and operating costs to verify moderate leverage feasibility.
We conclude the course on multifamily development finance and asset management, empowering you to engage in your multifamily real estate development transactions and outline plans to expand benchmarks.
This is a methodical, systematic introductory course to the commercial real estate development process and asset management taught by a New York City-based finance professional. Though designed for beginners, the course is possessed of a plethora of substantive content so as to demystify the complexities and intricacies of financing and developing commercial real estate. In this course, you will learn how to seek and secure financing, structure business deals, and compound your wealth as you grow a real estate portfolio. Herein you will also learn about financial modeling for turnkey, moderate rehab properties as well as new construction. Hone your asset management strategies and contemplate scaling growth while keeping overhead lean. You will learn to utilize prudent management of leverage so as to beneficially multiply your wealth. Through careful planning, debt becomes beneficial to growing your income generating properties rather than an onerous burden. In season, your debts will lighten, and your wealth will compound. Learn to contemplate macroeconomic and environmental factors when planning your real estate deals.
Cultivate expertise to develop affordable housing apartment blocs, multiply your wealth, and fulfill your dreams. As German economist Friedrich List said "The power of creating wealth is worth more than wealth itself." By studying my course, you can take a journey forward as you start your wealth-generating real estate empire.