REFAI® Certification Adopters Include
Learn how to frame risk related to investment and development opportunities and how to model and assess the potential rewards
The ultimate teaching collaboration with over 50 combined years of course design, teaching, skills training and CRE investing experience
In publication for 20 years, the co-authored course textbook has been nicknamed the “Blue Bible of real estate” by former students
Earn your first REFM Excel for Real Estate Certification in as little as a day, and graduate to earn the overarching REFAI® designation
Apply yourself and REFAI can help you upskill, get in the know, and potentially accelerate your career by up to a year
Evaluate and analyze investment opportunities with real world tools, and prepare for technical Excel testing
The backbone of REFAI is Real Estate Finance and Investments: Risks and Opportunities, nicknamed “the Blue Bible of real estate” by readers, authored by Dr. Peter Linneman and Bruce Kirsch, REFAI®.
Downloadable and online value add and ground-up development back of the envelope (BOTE) analysis tools
Library of actual equity joint venture partnership waterfall structures across strategies and geographies
3.5-hour video tutorial with Excel-based answer key for a simulated technical Excel modeling job interview test
The course is organized in an enjoyable format, being well-proportioned yet sufficiently challenging, with each module building on the previous modules. Both instructors, Peter Linneman and Bruce Kirsch, are extremely knowledgeable. I definitely would recommend this course to anyone who wants to build a career in the commercial real estate industry!
I was able to improve my modeling skills through extremely detailed tutorials, and, to my surprise, I learned even more through their textbook and online lectures. I am very satisfied with their program and would highly recommend it to anyone looking to learn the real estate business or, like me, improve their knowledge and skill set.
The textbook is well written and the interviews, lectures, and practice questions are very well thought out. The instructors are very helpful with any extra questions or clarifying misunderstandings, giving you everything you need to succeed. I have enjoyed this course immensely and cant wait to start applying what I have learned in my career moving forward.
The disciplined, logical, clear, and methodical way in which the material was presented should be the benchmark for how real estate finance and investing is taught in top-tier universities. I feel much more confident in my ability to “talk real estate finance” after reading the book and working on the exercises. I also have a better sense of my strengths and weaknesses. Likewise, I have a lifetime to improve my skills with the course materials and textbook.
I am really glad I used my free time on something as productive as REFM.
Thank you for everything.
I have taken financial modeling courses before. REFAI/REFM is unique because it’s the only one that shows how you lose money as a real estate investor through the Excel work, historic examples and scenarios.
The chapter interviews and insights are gold.
Earn shareable badges as you complete each Module on your way to achieving the full Certification.
The REFAI program curriculum is equal to that of “Real Estate Finance and Investment Analysis 101” semester-long courses delivered in the traditional classroom format in top MBA and Masters in real estate programs.
The backbone of REFAI is Real Estate Finance and Investments: Risks and Opportunities, “the Blue Bible of real estate,” authored by Dr. Peter Linneman and Bruce Kirsch. In circulation for 17 years and based on his Wharton classes, the book reflects Dr. Linneman’s frustration with texts that concentrate excessively on theoretical detail and literature, while ignoring important aspects of financial analysis and decision making. This book balances the “real world” aspects of real estate finance without compromising key theoretical underpinnings. It covers the basic mathematics of real estate finance and investments, while stressing the ambiguity of decision making.
The book, and the REFAI program by extension, is an exploration of the key concepts of real estate finance and investment strategy, not a mere formulaic analysis of numbers designed to give you “the answer” to any and all real estate investment decisions.
Holding the REFAI Certification signifies proficiency in this material and the ability to apply that knowledge by overlaying sound analytical frameworks on real world problems. Candidates must earn a minimum passing grade of 70% to complete the requirements for the Program and receive the Certification. Candidates are forewarned that this grade depends upon their performance and passing is not guaranteed.
You can even go directly to these modules if you wish and complete them first.
This self-paced program requires 120-160 hours to complete the course content, and complete the exercises, quizzes, midterm and final exams. Lifetime access is provided to all course materials.
Authored by Peter Linneman, PhD and Bruce Kirsch, REFAI ®
Edition 5.2 | First Published in 2003 | 457 pages | 26 Chapters
Select Corporate Adoptions
125+ University Adoptions
Chapter 1 in Audiobook | Hands-on Excel modeling exercises integrated throughout | ARGUS platform overview
For over 40 years, Dr. Peter Linneman’s unique blend of scholarly rigor and practical business insight has won him accolades from around the world, including PREA’s prestigious Graaskamp Award for Real Estate Research, Wharton’s Zell-Lurie Real Estate Center’s Lifetime Achievement Award, Realty Stock Magazine’s Special Achievement Award, being named “One of the 25 Most Influential People in Real Estate” by Realtor Magazine and inclusion in The New York Observer’s “100 Most Powerful People in New York Real Estate”.
After receiving both his Masters and Doctorate in Economics under the tutelage of Nobel Prize winners Milton Friedman, Gary Becker, George Stigler, Ted Schultz and Jim Heckman, Peter had a distinguished academic career at both The University of Chicago and the Wharton School of Business at the University of Pennsylvania. For 35 years, he was a leading member of Wharton’s faculty, serving as the Albert Sussman Professor of Real Estate, Finance and Public Policy as well as the Founding Chairman of the Real Estate Department and Director of the prestigious Zell-Lurie Real Estate Center.
During this time, he was co-editor of The Wharton Real Estate Review. In addition, he published over 100 scholarly articles, four editions of the acclaimed book Real Estate Finance and Investments: Risks and Opportunities, and the widely read Linneman Letter quarterly report.
Peter’s long and ongoing business career is highlighted by his roles as Founding Principal of Linneman Associates, a leading real estate advisory firm; CEO of American Land Fund; and CEO of KL Realty. For more than 35 years, he has advised leading corporations and served on over 20 public and private boards, including serving as Chairman of Rockefeller Center Properties, where he led the successful restructuring and sale of Rockefeller Center in the mid-1990s.
Although retired from Wharton’s faculty, Dr. Linneman continues his commitment to education through his Save A Mind, Give A Choice educational charity for orphans and children of extreme poverty in rural Kenya. He has been married for over 40 years and is an exercise enthusiast.
As the founder of Real Estate Financial Modeling (REFM), Bruce Kirsch has trained thousands of students and professionals around the world in Excel-based projection analysis. In addition, REFM’s self-study products, Excel-based templates and its Valuate® property valuation and investment analysis software are used by more than 250,000 professionals. Mr. Kirsch’s firm has assisted with modeling for the raising of billions of dollars of equity and debt for individual property acquisitions and developments, as well as for major mixed-use projects and private equity funds. Mr. Kirsch has also maintained a blog on real estate financial modeling, Model for Success, authoring more than 500 posts.
Mr. Kirsch began his real estate career at CB Richard Ellis, where he marketed highrise New York City office buildings for re-development in the Midtown Manhattan Investment Properties Institutional Group. After CBRE, Mr. Kirsch was recruited to lead acquisitions at Metropolis Development Company, and later joined The Clarett Group, a programmatic development partner of Prudential.
While at The Clarett Group, Mr. Kirsch was responsible for making development site recommendations for office, condominium and multi-family properties in the greater Washington, D.C. metropolitan area. In addition, Mr. Kirsch had significant day-to-day project management responsibilities for the entitlement, financing and marketing of the company’s existing D.C.-area development portfolio.
Mr. Kirsch holds an MBA in Real Estate from The Wharton School of the University of Pennsylvania, where he was awarded the Benjamin Franklin Kahn/Washington Real Estate Investment Trust Award for academic excellence. Prior to Wharton, Mr. Kirsch performed quantitative equity research on the technology sector at The Capital Group Companies. Mr. Kirsch served as an Adjunct Faculty member in real estate finance at Georgetown University School of Continuing Studies. Mr. Kirsch graduated with a BA in Communication from Stanford University.
REFAI pricing is USD $1,999 for professionals, and USD $699 for current students and academic faculty/staff and active duty and retired U.S. military. Groups of 2+ receive a 25% discount. Email firstname.lastname@example.org for details.
The cost of the hard copy textbook is included no matter where you live. The book is a required material for the course. If you already have the book, you can choose to not receive another copy, and you will be instantly credited $149 during the checkout process.
Book shipping costs are shown below:
We ship via UPS Monday through Friday, shipping same day for orders received before 2:30 PM Eastern time. International delivery generally takes 7-10 business days depending on the practices of your local Customs and UPS offices. Tracking information is sent to you by email typically the same day as the materials ship out.
You can learn about Academic and U.S. military status verification here.
If you already have Edition 5.1 or 5.2 of the book, you can get a $149 discount. To be granted a coupon code for the discount, please contact us at email@example.com.
Yes, we offer the chance to pay for the course over time through Affirm. You can apply for this option during the checkout process.
Yes, a 25% discount is available for groups of 2 or more. Please email firstname.lastname@example.org to inquire.
Current students, academic faculty and staff, and current and former U.S. military are eligible for discounted pricing. They must prove their status by providing a current and valid ID from any high school, college or university (both US-based and international), or military ID, as well as government-issued ID that verifies their identity. Credentials can be uploaded here.
No, as each individual candidate must pass quizzes and exams tied to their username, and the quizzes and exams are not accessible again once taken by a candidate.
The cost of the hard copy textbook is included no matter where you live. Shipping is free within the US, but it is an additional $35 if shipping to Canada, and an additional $65 if you shipping internationally excluding Canada.
No, the book is provided to you in hard copy only. The book is not offered in PDF.
If you already have Edition 5.1 or 5.2 of the book, you can get a $149 discount. To be granted a coupon code for the discount, please contact us at email@example.com.
Yes. The course content is tied directly to Edition 5.1/5.2 of the book, which are majorly enhanced and updated from prior editions.
No, the videos are streaming only. You must have a stable broadband Internet connection to view them without experiencing interruptions and file buffering.
No, you have lifetime access to everything.
You can start the course at any time once you have the textbook in your possession. The course is self-paced and the online platform is available 24/7/365.
It applies to both. A key chapter on projection modeling uses an apartment building as the case study.
No. The course is self-paced, and you have lifetime access to it.
In addition to reading the textbook, candidates will learn on the online course platform through various media, including recorded video and audio lectures, spreadsheet modeling exercises, multiple choice quizzes and exams.
This program requires 120-160 hours to complete the course content, and complete the exercises, quizzes, midterm and final exams. Some have finished in 5 days, some in 300, but the norm is around 90 days.
Lifetime access is provided to all course materials.
You are welcome to take the course just for your own educational enrichment and skill building if you wish.
Yes, the learning platform is optimized for phones and tablets. However, we recommend working on Excel on a desktop or laptop for the best experience.
Any computer purchased in the last 5 years, and Excel 2013 or more recent. For best results, we recommend using Google Chrome as your web browser.
The course is available on-demand, 24/7/365. All of the videos have been produced in a studio environment and edited to achieve the highest production value.
There is an online course forum, with discussion monitored and responded to by Bruce Kirsch, one of the course creators and textbook authors.
Yes, in your learner profile you have a list of all of the quizzes and links to view the quiz and answer explanations. You can also revisit your graded quizzes at any time and view the answer explanation.
You cannot take a quiz more than once, but you are given the option of one re-take for each of the three Excel for Real Estate Certification exams, as well as for the Midterm and Final.
The way it works for the Midterm and Final is as follows:
Before you submit your answers, if you are not feeling satisfied with your performance, you can elect to forfeit your test submission and forfeit your ability to view a graded version with the answer key for the initial take. This will allow you to retake the test at another time. Your last take of the Midterm/Final will be the score counted.
You can also learn from all of your graded quizzes, as well as the Midterm and Final, by revisiting them at any time.
REFAI was designed to be demanding but fair. While the pass rate is quite high, you’re not guaranteed passing and you need to get approximately 350 questions correct of the approximately 500 questions in the course. REFAI is your chance to both learn and to demonstrate you have mastered the material.
REFAI is the equivalent of a semester-long “Real Estate Finance and Investment Analysis 101” course given in a traditional university setting. REFM’s Excel for Real Estate Certifications are short-format tutorials focused solely on technical skills in Excel as they apply to real estate analyses.
You will receive them in real time as you complete them, and can list them on your resume and LinkedIn at those points in time. You can even go straight to these modules if you wish to do them before the rest of the REFAI course.
If you have already earned any of Level 1, 2 or 3 Excel for Real Estate Certification and do not wish to repeat the content and exam in the course, please email firstname.lastname@example.org to be verified and automatically passed through the relevant lesson(s) and quiz(zes).
No, it is much more. This course is the equivalent of a semester-long “Real Estate Finance and Investment Analysis 101” course given in a traditional university setting. Financial modeling is one aspect of the course, and a critical one, but one of many. The full syllabus and textbook contents can be viewed below.
To pass the course, you must achieve an average score of 70% or better across the entire set of graded quizzes, midterm and final exam. To pass With Distinction, you must achieve an average score of 85% or better and complete the course within 150 days of registration.
You can be a complete beginner and you will be fine. We start from zero and build from there.
You will receive a high-resolution PDF certificate with your name on it, and the With Distinction designation if applicable. You may print the certificate yourself or have it professionally printed and framed.
Have a question that’s not addressed above? Email email@example.com.