Pro Forma Analysis Excel Templates
Pro Forma Analysis Excel Templates
Real Estate Financial Modeling’s
Condominium Building Development
Pro Forma Analysis Excel Templates
Trusted for 10+ years by top developers
Overview and Summary Comparison
Overview
There’s a right tool for every job. That’s why we offer a suite of professionally developed Excel models for residential condominium development financial modeling. All of our templates are 100% unlocked Excel files without any access restrictions.
B.O.T.E. (Free Tool)
Fastest possible basic feasibility by solving for a stabilized yield on cost and residual land value
Multi-Year B.O.T.E.
Rapid feasibility that generates a before-tax IRR, net profit, multiple on equity and NPV outputs
Standard Pro Forma
Detailed analysis that generates a before-tax IRR, net profit, multiple on equity and NPV outputs
Professional Pro Forma
Detailed analysis that generates before- & after-tax IRR, net profit, equity multiple and NPV outputs
525 Water Street Condominiums in Washington, DC
Underwritten with REFM’s Professional Pro Forma
Underwritten with REFM’s Professional Pro Forma
525 Water Street Condominiums
Washington, DC
Underwritten with REFM’s
Professional Pro Forma
Washington, DC
Underwritten with REFM’s
Professional Pro Forma
B.O.T.E. (Back Of The Envelope Analysis) Free Tool
$5,599.00Add to cart
Description & Video Tour
Our B.O.T.E. free tool is suited for the fastest basic feasibility assessment by solving for a stabilized yield on cost and residual land value. By design, it does not output profit or IRR values because it is purposefully not a multi-period analysis.
What is a back of the envelope analysis?
A back of the envelope, or “BOTE” analysis, is intended to give you a broad brushstroke view of the economic feasibility of a potential transaction. BOTE-level analysis is used to quickly screen potential deals in and out of one’s deal pipeline. A high level of detail is purposefully forfeited in BOTEs for the sake of speed of execution.
For an apartment building development, BOTE feasibility analysis focuses in on the Land Purchase Price as it relates to the going-in (Year 1) yield on cost (the Year 1 stabilized cap rate). Land Purchase Price is typically solved for on a residual basis, meaning the land value is what is left over after a targeted initial level of yield has been achieved.
The development back of the envelope thought experiment
Development BOTE analysis assumes the hypothetical situation where you could purchase the land at an assumed price today and then snap your fingers and the contemplated building would instantly appear and be at stabilized occupancy. As such, today’s hard and soft development costs, cost of debt and rents and expenses are used as inputs. The logic behind doing this is that if the deal does not look good using today’s values, about which we have a very high level of certainty, it’s not worth pursuing because we have significantly less certainty about the amounts to use for these variables years into the future.
FAR-Based vs. Units-Based analysis
A development site zoned for multi-unit residential use will typically have a density constraint in terms of the total gross square footage of building allowed on the site or a ceiling on the residential unit count. Our calculator has the ability to analyze a site both on an FAR basis as well as on a Units basis, and you can toggle between the two within a single analysis file. FAR stands for “floor area ratio”, but we like to think of it as “floor area to lot size ratio”. FAR is simply the ratio of the allowable above-ground gross building area to the site area. An example of an FAR ratio of 5.00 would be a 10,000 square foot development parcel with an allowable above-ground building area of 50,000 gross square feet.
Functions & Features
- Compatible with Excel on PC, Mac, iPad and Android tablets
- Solves for a stabilized yield on cost and operating margin
- Allows for back-solving to a residual land value
- Streamlined set of assumptions inputs
- Units-based and FAR-based analysis types
- Supports a NNN retail component
Debt & Equity Capabilities
Sponsor Equity and a Senior Construction Loan are supported.
Reports
The analysis prints neatly on a single 8.5 x 11 page in portrait orientation.
Support
Support is available through our online ticket system.
Multi-Year B.O.T.E. (Back Of The Envelope Analysis) Tool
Description & Video Tour
Our Multi-Year B.O.T.E. free tool is suited for rapid feasibility and residual land valuation based on goal-seeking to any of a targeted before-tax IRR, net profit, multiple on equity or NPV metric.
While static BOTE feasibility analysis focuses in on the Land Purchase Price as it relates to the going-in (Year 1) yield on cost (the Year 1 stabilized cap rate), a multi-period BOTE allows you to see this stabilized yield on cost and also take a second, deeper cut at the land price based on important targeted key performance indicators such as IRR and net profit.
Functions & Features
- Compatible with Excel on PC, Mac, iPad and Android tablets
- Supports an 11-year timeline of development and operation
- Allows for back-solving to a residual land value based on:
- stabilized cap rate
- net profit
- IRR
- multiple on equity
- average cash on cash
- NPV
- Streamlined set of assumptions inputs
- Units-based and FAR-based analysis types
- Supports a NNN retail component, sold with the apartments at a single cap rate
- Sale valuation based off of forward or trailing 12 months values
- Charts for:
- development equity and debt capitalization
- annual development costs
- annual NOI yield on cost
- annual NOI
- annual cash on cash
- equity and debt capitalization at sale
- IRR Sensitivity Analysis data tables based on:
- base building hard cost vs. exit cap
- senior construction loan LTC vs. exit cap
- land cost vs. base building hard cost.
Debt & Equity Capabilities
- Sponsor Equity
- Senior Construction Loan
- Refinancing upon stabilization with a Permanent Loan that supports an upfront interest-only period and a cash out refi
- User warning if you forget to activate refinancing given exit timing assumption past the point of stabilization
Reports
The analysis prints neatly on a single 8.5 x 11 page in landscape orientation.
Support
Support is available through our online ticket system.
Standard Version: Mixed-Use Apartment Building Development Pro Forma
Description & Video Tour
Our Standard Pro Forma is suited for detailed analysis that generates a before-tax IRR, net profit, multiple on equity and NPV outputs, among others.
Functions
- Compatible with Excel on both PC and Mac
- Supports a 31-year timeline of development and operation
- Separate unit mixes, rents and absorption for market rate and affordable/rent-controlled units
- Dynamic hard cost allocation based off of a bell-shaped curve
- Retail tenant improvements (TIs) and leasing commissions (LCs)
- Valuation and disposition of the retail component independently of the residential component
- Any operating and financing deficits are funded by equity on a pro-rata basis
Features
- Includes instructions for use, with detailed annotations tied to select cells
- Two-page assumptions input and reporting screen optimized for dashboard-style viewing
- Persistent calculation checks and associated visual alerts, and data validation protections to prevent faulty inputs or faulty conclusions
- project budget must match allocation of budget over timeline
- senior loan must be repaid in full
- all units must be leased
- waterfall profit splits must sum to match the deal-level profit
- Hyperlink navigation enables fast, intuitive access to all tabs
- Institutional-quality print-ready reporting tabs that are brandable to your company
- S-curve distribution of soft costs by individual line item
- No circular references impacting the calculation of the construction loan size and funded interest
Debt Capabilities
- Senior construction loan
- funds on a residual basis to all equity
- interest only, with default funded interest reserve, and user ability to switch to cash interest payments at specified milestone
- repaid from net sales proceeds of apartment building and retail unit dispositions, or from refinancing proceeds from Permanent Loan
- Permanent loan
- sized by the lesser of three tests
Equity Capabilities
- Equity positions supported
- sponsor/developer
- third party investor
- Equity investment options
- pari passu (pro-rata, simultaneously)
- sponsor first, then third party investor
- Equity profit sharing
- Preferred Return (includes return of capital)
- Participation: Sponsor can be included or excluded from the Pref. If the sponsor is not included in the Pref, then sponsor’s return of capital occurs only after the third party investor receives: a) all of their capital back, and b) their Pref profit.
- Accrual options:
- only based on monthly compounding, cumulative IRR hurdle based on the performance of the third party investor’s invested dollars
- based on both third party investor IRR hurdle and third party investor equity multiple hurdle, where the larger resulting dollar amount governs which basis determines the distribution
- Residual profit split with sponsor promote share defined as share of residual profit above and beyond the sponsor deal ownership position share.
- Preferred Return (includes return of capital)
Reports
The analysis prints neatly on a single 8.5 x 11 page in portrait orientation.
Support
Support is available through our online ticket system.
Professional Version: Mixed-Use Apartment Building Development Pro Forma
Description & Video Tour
Our B.O.T.E. free tool is suited for the fastest basic feasibility assessment by solving for a stabilized yield on cost and residual land value. By design, it does not output profit or IRR values because it is purposefully not a multi-period analysis.
A back of the envelope, or “BOTE” analysis, is intended to give you a broad brushstroke view of the economic feasibility of a potential transaction. BOTE-level analysis is used to quickly screen potential deals in and out of one’s deal pipeline. A high level of detail is purposefully forfeited in BOTEs for the sake of speed of execution.
For an apartment building development, BOTE feasibility analysis focuses in on the Land Purchase Price as it relates to the going-in (Year 1) yield on cost (the Year 1 stabilized cap rate). Land Purchase Price is typically solved for on a residual basis, meaning the land value is what is left over after a targeted initial level of yield has been achieved.
The development back of the envelope thought experiment
Development BOTE analysis assumes the hypothetical situation where you could purchase the land at an assumed price today and then snap your fingers and the contemplated building would instantly appear and be at stabilized occupancy. As such, today’s hard and soft development costs, cost of debt and rents and expenses are used as inputs. The logic behind doing this is that if the deal does not look good using today’s values, about which we have a very high level of certainty, it’s not worth pursuing because we have significantly less certainty about the amounts to use for these variables years into the future.
FAR-Based vs. Units-Based analysis
A development site zoned for multi-unit residential use will typically have a density constraint in terms of the total gross square footage of building allowed on the site or a ceiling on the residential unit count. Our calculator has the ability to analyze a site both on an FAR basis as well as on a Units basis, and you can toggle between the two within a single analysis file. FAR stands for “floor area ratio”, but we like to think of it as “floor area to lot size ratio”. FAR is simply the ratio of the allowable above-ground gross building area to the site area. An example of an FAR ratio of 5.00 would be a 10,000 square foot development parcel with an allowable above-ground building area of 50,000 gross square feet.
Functions & Features
- Solves for a stabilized yield on cost and operating margin
- Allows for back-solving to a residual land value
- Streamlined set of assumptions inputs
- Units-based and FAR-based analysis types
- Supports a NNN retail component
Debt & Equity Capabilities
Sponsor Equity and a Senior Construction Loan are supported.
Reports
The analysis prints neatly on a single 8.5 x 11 page in portrait orientation.
Support
Support is available through our online ticket system.
Frequently Asked Questions
Pricing
REFAI pricing is USD $1,499 for professionals, and USD $599 for current students and academic faculty/staff and active duty and retired U.S. military.
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 to ship to Canada, and an additional $65 to ship internationally other than to Canada.
You can learn about Academic and U.S. military status verification here.
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 20% discount is available for groups of 2 or more. Please email [email protected] to inquire.
Current students, academic faculty and staff are eligible for Academic pricing. They must prove their academic status by providing a current and valid Academic ID from any high school, college or university (both US-based and international), as well as government-issued ID that verifies their identity. Academic status credentials can be uploaded here.
Yes. You can do so 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 Book and Course Materials
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 the Fifth Edition of the book, you can get a $149 discount. To be granted a coupon code for the discount, please contact us at [email protected].
Yes. The course content is tied directly to the Fifth Edition of the book, which is 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.
Course Design
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. 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. There are also optional duplicate review quizzes that are ungraded, which you can use an unlimited number of times to study for the midterm and final.
You cannot take a quiz/test more than once a graded basis. However, there are also optional duplicate review quizzes that are ungraded, which you can use an unlimited number of times to study for the midterm and final.
REFAI was designed to be demanding but fair. Not everyone who takes the course will receive the Certification, as a 70% average score is required to pass. It 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.
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 [email protected] 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.
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 protected].