Faculty - Led Course | Beginner

AH121wk: Real Estate Finance Nut and Bolts

Explore the essential components of real estate finance, including amortization, mortgage lending and bond financing. You will learn to use Microsoft Excel to calculate loan payments, interest rates and investment values. Gain practical skills to create amortization schedules, analyze homebuyer ratios and build sources and uses spreadsheets for both single-family and multifamily developments. This course is perfect for beginners looking to understand the mortgage banking system and financial documentation in real estate transactions.

What You'll Learn

  • Explore key real estate finance concepts, including amortization and property financing approaches.
  • Build confidence to interpret documents and support financial decisions in real-world housing projects.
  • Use Excel to calculate loan payments, create amortization schedules and analyze real estate investments.

Live Session Schedule

Day 1:

Monday, March 9, 2026 | 3:30p.m. ET

Day 3:

Wednesday, March 11, 2026 | 3:30p.m. ET

Come Prepared for the Course

Welcome to this one week faculty-led course which is designed for optimal interactivity and engagement. Day 1 is comprised of a total of 90 minutes of live online instruction. Days 2 through 5 are dedicated to self-paced completion of all activities and assignments. Day 3 also includes an optional virtual office hours. All required coursework is due by 11:59 p.m. PT on the designated day of class.

Pre-Work & Preparation

Pre-Work & Preparation

Complete all pre-work by provided deadlines

Active Participation

Active Participation

Attend live sessions and engage in collaborative activities

Software Requirements

Software Requirements

Microsoft Excel and Zoom proficiency required

Hardware Setup

Hardware Setup

Dual monitors, webcam and file management capabilities

Your Instructor

Protip  Biswas

Protip Biswas

Faculty Member | NeighborWorks

Protip Biswas is the Vice President of Homelessness at United Way of Greater Atlanta and the Executive Director of the Regional Commission on Homelessness. He has been active in community development, affordable housing, and economic development. Protip holds a master’s degree in architecture from the University of Cincinnati and another in construction management from SPA, Delhi, India. He also completed coursework for his doctoral studies in Urban Planning at the University of North Carolina in Chapel Hill.

What Learners Are Saying

"This course gave me exactly what I needed to get started in housing counseling. The practical tools and real-world examples made it easy to apply what I learned immediately with my clients."

Maria Rodriguez

Housing Counselor, Urban CDC

"As someone transitioning from social work into housing counseling, this course provided the perfect foundation. The content was incredibly relevant to my daily work."

David Chen

Community Development Specialist

"The instructor's expertise really shines through in every module. I appreciated the balance of theory and practical application."

Sarah Johnson

Housing Program Manager

Foundations of Affordable Housing Production Micro-Credential

Foundations of Affordable Housing Production Micro-Credential

The Foundations of Affordable Housing Micro-Credential provides a solid foundation in real estate financing, project planning and development. This program equips you with the essential knowledge and skills to navigate the complexities of real estate development. 

Courses needed to earn this credential:

  • AH101 The Fundamentals of Affordable Housing Development (in-person or faculty-led)
  • AH121 Real Estate Finance Nuts and Bolts (in-person or faculty-led)
  • AH221 Rental Housing Development Finance (in-person or faculty-led)
Learn More

Ready to Get Started?

Join hundreds of housing professionals building the skills to create lasting community impact

$295
Enroll Now