
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 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.
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.
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 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.
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.
Financial Modeling Assignment for a Moderate Rehab Deal
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.
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.
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.
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.
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.
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.
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.
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.