Rent Comps Tab

Multifamily Rent Comp Template

An organized Excel template to aggregate all your rent comp data for a property. One input tab, one summary tab.

$99

Toggle It: View comps individually or consolidated via a drop down menu.
Unlimited Comps: Add as many properties as you'd like.
Unit-Level Input: One row per unit type, per property.
Standardized Dropdowns: Classic, Light Reno, Renovated. Unit type dropdown. Locked lists maintain consistency.
Subject Property Anchor: Your deal's rent, SF, and PSF by unit type anchored on top.
Condition-Level Averages: Blended, Classic, Light Reno, and Renovated rents, by unit type.
Condition-Matched Variance: Compares your subject property's In-Place rent against Classic comps, and Proforma rent against Renovated comps.
Weighted Property-Level Summary: Combines unit-type variance into one blended number, weighted by your actual unit mix, in both $ and $/SF.
Ancillary Income: Concessions and RUBS tracked alongside rent.
Data Currency: Entered comps are dated to show recency of rents.

Buy Now

Delivered instantly after purchase.

Template Structure

Rent Comps Tab: The input tab, comp data entry point
Summary Tab: Consolidated and single property views by unit type
Legend Tab: Quick reference for dropdown values and abbreviations

What's Included

The blank template
A completed template with sample rent comps
Lifetime access to future template revisions

Behind The Template:

Hi, I'm Michael. I began my career as the first employee of a multifamily investment firm, where I eventually became the firm's sole acquisitions underwriter. I underwrote more than $2 billion in market-rate and LIHTC multifamily acquisition opportunities, contributing to more than $100 million in closed transactions before transitioning into industrial CRE analysis and accounting. All my models reflect how I've actually underwritten and analyzed deals in practice.

Full Bio

FAQ

Is there a limit on number of comps?

No. While the default template comes with a predefined table range, adding more properties is very simple and the template will handle it with ease.

Does this work in Google Sheets or on Mac?

This template is built and tested in Microsoft Excel. It works on both Windows and Mac versions of Excel. It is not officially supported in Google Sheets; some formulas and formatting may not convert correctly.

Does this use macros or VBA?

No. This template runs entirely on native Excel formulas, no macros, no VBA, no external code. That means it opens fast, calculates fast, and isn't at risk of getting blocked by your firm's macro security settings.

Is support included?

No individual support is included with this purchase. The Instructions tab is built to walk you through the template on its own.

What's your refund policy?

Due to the digital nature of this product, sales are final - there's no way to take back a file once it's downloaded. That said, I stand behind the template. If something doesn't work as shown, or you find an error, email me and I'll fix it.

Do I need to be good at Excel?

Helpful, but not required. This template is built in a way that following the formulas is not too complex, and encouraged.

What if I find a bug or mistake?

Reach out and let me know. Fixes are rolled into future versions, which you get access to at no additional cost.

How does licensing work?

Your purchase is licensed for your own use. Redistribution or resale of the template, in whole or in part, isn't permitted.

Can I get a student discount?

Not yet, but student discounts are planned. Join the newsletter to hear when they launch.

This template is provided as-is; you're responsible for independently verifying all calculations before relying on them for a real transaction. By purchasing, you agree to our Terms.

A clean rent comp template, built intentionally simple.

$99

Buy Now