• Link to Facebook
  • Link to Youtube
  • Link to LinkedIn
  • Link to X
  • Link to Tiktok
  • Link to Instagram
  • EN ESPAÑOL
    • Inicio
    • Glosario de Términos
    • Modelos Financieros
    • Tutoriales Cortos
  • A.CRE HELP
    • Support Section
    • Contact Us
  • LOGIN/REGISTER
  • Shopping Cart Shopping Cart
    0Shopping Cart
Adventures in CRE
  • A.CRE
    • A.CRE Home
    • A.CRE Help
    • Accelerator
      • Learn More
      • Login
    • AI.Edge
      • Learn More
      • Login
    • Artificial Intelligence
    • Careers
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • Meet the A.CRE Team
  • RE Modeling
    • 1031 Exchange
    • Audio Series
    • All-in-One (Ai1) Model
      • Download
      • Guides and Tutorials
      • Support
    • Ask Me Anything (Live)
    • Beginner’s Guide to Excel
    • Excel Models
      • Excel Add-ins
      • Library of Excel Models
      • All-in-One (Ai1) Model
      • Apartment
      • Condo
      • Debt
      • Development
      • Equity Waterfall
      • Hotel
      • Industrial
      • Office
      • Portfolio
      • Retail
      • Single Family
      • Tutorial
    • Excel Tips
    • Practice Library of Case Studies
    • Stochastic Modeling
    • Argus
    • My Downloads / My Account
  • Careers
    • About Careers in Real Estate
    • Ask Me Anything (Live)
    • Audio Series
    • Compensation in Real Estate
    • CRE Job Board
      • Find a Job
        • Browse Jobs
        • Post a Resume
        • Register
        • Login
      • Post a Job
    • CRE Event Calendar
    • CRE Interviews
    • Day in the Life Series
    • Real Estate Legal Content
    • What CRE Pros Do
  • Education
    • Accelerator
    • AI.Edge
    • A.CRE 101
    • Ask Me Anything (Live)
    • A.CRE Audio Series
    • Audio Series
    • Book Reviews
    • CRE Event Calendar
    • Deep Dive Series
    • Glossary of CRE Terms
    • Real Estate Legal Content
    • Real Estate Clubs
    • University Profiles
    • Watch Me Build
  • AI
    • AI Skills
    • AI Use Cases in CRE
    • AI for CRE Training
    • AI Tools for CRE
    • AI.Edge Membership
      • Learn More
      • Login
  • Accelerator
    • Accelerator Reviews
    • Accelerator Story
    • Enroll Now
    • Learn More
    • See What’s New
    • Enterprise Members Only
      • General Enterprise Login
      • ICSC Login
      • M&M Login
    • Members Only
      • Extend/Renew Membership
      • Login
      • Manage Membership
  • My Downloads
    • View My Downloads
    • Find an Excel Model
    • Register
    • Login
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu
You are here: Home1 / Real Estate Financial Modeling2 / Excel Models3 / LIHTC (Low Income Housing Tax Credits) Overview and Calculator
Michael Belasco
General, Real Estate Financial Modeling, Excel Models, Affordable Housing

LIHTC (Low Income Housing Tax Credits) Overview and Calculator

Below is an overview of how LIHTC (low income housing tax credits) are calculated and applied to affordable housing projects. At the bottom of the post you will find downloadable excel files that correspond with the videos.

LIHTC – An Overview

LIHTC s are federal tax incentives given to the states who then award developers these credits for projects that meet certain criteria as outlined by both the state and federal government. Developers, once awarded, will then go and market these tax credits to investors who will then purchase them in exchange for offsetting taxes otherwise owed over a ten year period. The developer can then use the funding provided from the tax credit investors as equity. However, the disbursement of the tax credit funding is subject to negotiation between developer and investor and in most cases, the bulk is only distributed upon stabilization because the credits are not officially awarded until the project is up and running and has received a Form 8609.

Calculating the Amount of Tax Credits Awarded to a Project

The below video and corresponding text will walk you through how LIHTC s are calculated plus additional information that provides you with more context and information.

Eligible Basis

The amount of tax credits that can be allocated to a development project follows a formula that first starts with the project’s development budget. Once the budget has been created, some line items and their respective costs will be excluded to create what is called the Eligible Basis. Items that don’t qualify are non-depreciable. The Eligible Basis equals the budget less costs to acquire the property, finance it, reserves, syndication expenses, and marketing costs. The eligible basis can be thought of as construction related costs.

High Cost Adjustment Boost (130%)

If the project is determined to be in a Difficult to Develop Area or a Qualified Census Tract, the project may be qualified to increase the Eligible Basis by 30%. These areas can be found on the HUD User site here: https://www.huduser.gov/portal/datasets/qct.html.

Applicable Fraction

After the Eligible Basis is determined, the developer needs to determine the Applicable Fraction, or the ratio of the building that qualifies as low-income housing. To do so, the developer needs to apply the lesser of the Unit Fraction or the Floor Space Fraction defined as follows:

  • Unit Fraction – low income units/all residential units
  • Floor Space Fraction – low income space/total residential space

Qualified Basis

Taking the Eligible Basis and multiplying it by the Applicable Fraction gives us our Qualified Basis.

Tax Credit Rate – 9% or 4%

There are two tax credit rates that projects quality for based on a percentage of the Qualified Basis, either 4% or 9%, and the requirements vary between both as do the rates.

These are the rate that we multiply the Qualified Basis with and then multiply by 10 (years) to get the total tax credits available to the project. However, the actual 4% and 9% ranges are rarely ever 4% and these rates change monthly dictated by the IRS. So the true rate that gets multiplied by the Qualified Basis can be found here. Select the latest PDF and scroll down to the bottom of the third page to see the current rates. To see a table of the historical and current rates, click here.

The rates are calculated by backing into the present value of the 10 years worth of tax credits so that the present value of the tax credits is equal to 30% of a project’s eligible basis for the 4% credits or 70% of the project’s eligible basis for the 9% credits. The video below shows you how it is done.

What’s the difference between 4% and 9%?

9% credits are competitive because there is limited availability for every state based on a state per capita formula. They also can’t be combined with tax exempt bonds. 9% bonds are available for new construction projects and existing projects with substantial rehabilitation needs.

4% credits are available without competing as long as they meet the states requirements and can be used for new construction as long as there are tax exempt bonds being utilized as well and are also available for acquisition of existing properties.

Tax Credit Factor

After the Qualified Basis is multiplied by the Tax Credit Rate and the Tax Credit Rate is multiplied by 10, we then multiply this by the Tax Credit Factor, which is the market price for every $1 of tax credits. This rate can fluctuate above or below the dollar mark depending on market factors and the total tax benefits to investors.

Tax Benefits to Investors

In addition to the tax credits awarded to the investor over the 10-year period as mentioned earlier, investors will also receive and report tax losses (depreciation, interest, etc.) because as the limited partner, they are actually the majority owner of the project with the sponsor acting as both development and in most cases property manager as well.

Download the LIHTC Calculator

To make these files accessible to everyone, they are offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content coming – similar real estate Excel modules sell for $100 – $300+). Just enter a price together with an email address to send the download link to, and then click ‘Continue’. If you have any questions about our “Pay What You’re Able” program or why we offer our models on this basis, please reach out to either Mike or Spencer.

Proceed to Download Page

Frequently Asked Questions about LIHTC (Low Income Housing Tax Credits)

What is LIHTC and how does it work?

LIHTC (Low Income Housing Tax Credits) are federal tax incentives granted to states, which then award them to developers of qualifying affordable housing projects. Developers sell the credits to investors in exchange for equity. “The credits are not officially awarded until the project is up and running and has received a Form 8609.”

How is the eligible basis for LIHTC calculated?

Eligible Basis equals the development budget minus non-depreciable items like acquisition costs, financing costs, reserves, syndication expenses, and marketing costs. It “can be thought of as construction related costs.”

What is the High Cost Adjustment Boost?

Projects in a Difficult to Develop Area or a Qualified Census Tract can increase their Eligible Basis by 30%. These areas are listed on the HUD User site.

What is the Applicable Fraction and how is it used?

The Applicable Fraction is the lesser of the Unit Fraction (low-income units/total units) or Floor Space Fraction (low-income space/total space). It’s used to determine the Qualified Basis by multiplying it with the Eligible Basis.

What is the difference between 4% and 9% tax credits?

9% credits are competitive and used for new construction or substantial rehabilitation; they cannot be combined with tax-exempt bonds.
4% credits are non-competitive, available with tax-exempt bonds, and can also be used for acquisitions.

How are the total tax credits calculated?

Total tax credits = Qualified Basis × Tax Credit Rate × 10 years. The rate (4% or 9%) is dictated monthly by the IRS, and rarely equals exactly 4% or 9%.

What is the Tax Credit Factor?

The Tax Credit Factor is the market price per $1 of tax credit sold to investors. This rate may vary above or below $1 depending on the market and perceived investor benefit.

What tax benefits do investors receive from LIHTC projects?

Investors receive:

Tax credits over 10 years

Tax losses (depreciation, interest, etc.)
Because they are usually the majority owner (LP), they benefit from the project’s passive losses as well as the credits.

When do investors typically provide their equity funding?

“Most of the funding is only distributed upon stabilization because the credits are not officially awarded until the project is up and running and has received a Form 8609.”

Where can I download the LIHTC calculator?

You can download the LIHTC calculator via the “Pay What You’re Able” model. Enter your email and any amount (including $0) to receive the download link.


About the Author: Michael has spent a decade working in various capacities on more than $7 billion of real estate transactions spanning all asset classes and geographies throughout the USA. Michael is both the founder of Firm Ridge Real Estate, which has a core focus on niche and emerging real estate strategies and A.CRE Consulting, a real estate advisory and financial modeling firm that has provided services on projects totaling more than $21 billion to date. Prior, Michael was a founding member and COO of Stablewood Properties, an institutionally backed real estate operator. And before Stablewood, Michael was at Hines in San Francisco.  Michael has both an MBA and Master in Real Estate with a concentration in Real Estate Finance from Cornell University.

Contact Michael

 

 

by Michael Belasco
Share this entry
  • Share on X
  • Share on LinkedIn
  • Share by Mail
  • Link to Instagram
  • Link to Youtube
https://www.adventuresincre.com/wp-content/uploads/2020/02/LIHTC-A.CRE_-scaled.jpg 1280 1920 Michael Belasco https://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.png Michael Belasco2020-02-20 09:55:402025-06-26 11:28:18LIHTC (Low Income Housing Tax Credits) Overview and Calculator
You might also like
Understanding Low-Income Housing Tax Credit (LIHTC) Investments

Featured Content

  • RE Financial Modeling Accelerator
  • A.CRE Job Search
  • Library of Real Estate Excel Models
  • Real Estate Financial Modeling
  • Real Estate Education
  • Real Estate Careers
  • AI in Real Estate

Recent Posts

  • Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated June 2026)
  • A.CRE Self Storage Development Model (Updated June 2026)
  • Episode 12 of Multipliers: Ask Why Until the Answer Changes
  • A.CRE Jobs of the Week (Updated 6.22.2026)
  • A.CRE Real Estate Financial Models Download Guide (Updated Jun 2026)
Accelerator - Learn More

Search Adventures in CRE

Search Search

Have a Question or Need Help?

Visit our Help Section

Contact Adventures in CRE

  • Visit A.CRE Help
  • Via Email
  • Via LinkedIn

You Might Also Like

  • Real Estate Modeling Courses
  • Real Estate Financial Modeling
  • A.CRE Job Board
  • Careers in Commercial Real Estate
  • Real Estate Education

A.CRE Library of Excel Models

  • Browse Excel Models
  • Login/Register
  • View My Downloads
  • Edit Account Details

Terms, Policies, and Disclaimer

  • Privacy Policy
  • Cookie Policy
  • AI Usage Policy
  • Terms of Use
  • Disclaimer
© 2014 - Present - Copyright - www.AdventuresinCRE.com, LLC | Adventures in CRE | A.CRE
  • Link to Facebook
  • Link to Youtube
  • Link to LinkedIn
  • Link to X
  • Link to Tiktok
  • Link to Instagram
Link to: Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020) Link to: Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020) Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020) Link to: Letter of Intent for Office Leasing Link to: Letter of Intent for Office Leasing Letter of Intent for Office Leasing
Scroll to top Scroll to top Scroll to top