Does it pencil?Drop 002 / Illustrative caseMultifamily

570 Units. A 7% Cap. Does It Pencil?

A 570-apartment Class B property is 75% occupied. At an assumed 7% cap rate, the math gives one figure at today’s occupancy and a higher one at 92%. Every number here is a fictional teaching assumption.

Illustrative caseAll numbers are fictional teaching assumptions. Not a real property, offering or transaction.

01

Does it pencil?

A good opportunity starts with a question. We work through the information, test the assumptions, run the calculations, and show what supports the result — and what doesn’t.

How every drop works

The math. The code. The evidence. Your decision.

  1. Start with the information.What was actually provided, and by whom.
  2. Test the assumptions.Separate what is sourced from what is assumed.
  3. Run the math.Fixed formulas. Same inputs, same result.
  4. Check the evidence.What supports the result, and what does not.
  5. Let people decide.The work informs the decision. It does not make it.

Before the recommendation, show the work.

02

The opportunity

A 570-apartment Class B property is offered for sale. A quarter of the apartments are empty. The pitch is simple: fill the building and it is worth more.

That may be true. The question is how much of it the numbers support today, and how much depends on things nobody has shown yet.

03

What we know

Six numbers were stated. None came with a document. That makes each one an assumption, not a fact.

570ApartmentsIllustrative assumption
$1,500Average monthly rentIllustrative assumption
75%Occupancy todayIllustrative assumption
92%Stabilized occupancyIllustrative assumption
45%Operating expense ratioIllustrative assumption
7.0%Cap rateIllustrative assumption
Illustrative assumptions6

Everything in the tiles above. Stated for teaching, supported by nothing.

Verified information0

None. No rent roll, operating statement or other source document exists for this example.

04

What we don’t know

This model does not establish:

  • Purchase price
  • Actual NOI
  • Renovation cost
  • Lease-up cost
  • Financing terms
  • Hold period
  • IRR
  • Equity return

It does not calculate IRR, debt coverage, debt yield or any return. Those need a price, financing terms and costs that are not in this example.

Document neededWhat it would settle
Current rent rollUnit count, rent actually collected and occupancy today
Trailing 12-month operating statementsActual income, actual expenses and actual NOI
Lease-up plan and market studyWhether 92% is reachable, how long it takes and what it costs
Property condition report and renovation budgetWhat has to be spent before the empty apartments can be leased
Comparable salesWhether a 7% cap rate fits this property in this market
Asking price and financing termsWhat the deal costs. Without them no return can be calculated

05

Run the numbers

One set of formulas, run twice: once at today’s occupancy and once at the stabilized assumption. Average rent, the expense ratio and the cap rate are held fixed in both. Change any input and the figures recalculate in your browser.

WorkbenchIllustrative arithmetic

Showing the Drop 002 teaching assumptions. All fictional.

As-is / occupancy today

75% occupancy

Potential gross rent
$10,260,000
Effective gross income
$7,695,000
Operating expenses
$3,462,750
Modeled NOI
$4,232,250
Implied value
$60,460,714
Implied value per apartment
$106,071

Stabilized / assumed

92% occupancy

Potential gross rent
$10,260,000
Effective gross income
$9,439,200
Operating expenses
$4,247,640
Modeled NOI
$5,191,560
Implied value
$74,165,143
Implied value per apartment
$130,114

Difference

Approximately $13.70 million in implied capitalized value.

That is the gap between two modeled figures at a 7% cap rate ($13,704,429). It is not profit, an equity gain, realized appreciation or an investment return. Getting from one figure to the other costs money and time this model does not include.

The formulas and what the terms mean
potential gross rent   = apartments x average monthly rent x 12
effective gross income = potential gross rent x occupancy
operating expenses     = effective gross income x expense ratio
modeled NOI            = effective gross income - operating expenses
implied value          = modeled NOI / cap rate
value per apartment    = implied value / apartments
Potential gross rent
What the property would collect in a year if every apartment were leased at the average rent.
Occupancy
The share of apartments that are leased. This model uses physical occupancy and does not adjust for unpaid rent or concessions.
Effective gross income
Potential gross rent multiplied by occupancy.
Operating expense ratio
Operating expenses as a share of effective gross income. Held fixed here, which is a simplification.
NOI
Net operating income: income left after operating expenses, before debt payments and capital spending. Here it is modeled, not actual.
Cap rate
Capitalization rate: NOI divided by value. Dividing NOI by an assumed cap rate gives an implied value.
Implied value
Modeled NOI divided by the assumed cap rate. A modeled figure, not an appraisal, a price or an offer.

Simplified, before vacancy and credit loss beyond physical occupancy, other income, capital spending, closing costs, debt and taxes. This is arithmetic on the numbers entered. It is not an appraisal, an offer or investment advice.

06

Defend the result

Every figure carries a record: where it came from, how it was calculated and how far it can be trusted. The arithmetic is recomputed a second way and must agree. That proves the sums. It does not prove the inputs.

MATHEMATICALLY VERIFIEDThe calculation was recomputed independently and agreed. 5 of 11 records.
INCONCLUSIVEAn assumption with no source document behind it. 6 of 11 records.
EVIDENCE SUPPORTEDMatched to a source document. None in this example, because no documents exist.
Analytical record for every input and calculated figure
FigureValueDesignationStatusExceptions
Units570Illustrative assumptionINCONCLUSIVENo rent roll or unit mix supplied.
Average monthly rent$1,500 a monthIllustrative assumptionINCONCLUSIVENot supported by a source rent roll.
Occupancy today75%Illustrative assumptionINCONCLUSIVENot supported by a source rent roll.
Stabilized occupancy92%Illustrative assumptionINCONCLUSIVEAn assumption about the future. No lease-up plan or market study supplied.
Operating expense ratio45%Illustrative assumptionINCONCLUSIVENot supported by trailing operating statements.
Cap rate7%Illustrative assumptionINCONCLUSIVEStated in the scenario. No comparable sales supplied.
Modeled NOI, as-is$4,232,250 a yearCalculatedMATHEMATICALLY VERIFIEDBuilt on unverified inputs.
Implied value, as-is$60,460,714CalculatedMATHEMATICALLY VERIFIEDBuilt on unverified inputs.
Modeled NOI, stabilized$5,191,560 a yearCalculatedMATHEMATICALLY VERIFIEDBuilt on unverified inputs.
Implied value, stabilized$74,165,143CalculatedMATHEMATICALLY VERIFIEDBuilt on unverified inputs.
Difference in implied value$13,704,429CalculatedMATHEMATICALLY VERIFIEDBuilt on unverified inputs.
Open the full record for each figure
Input or output
Units
Value
570
Units
units
Designation
Illustrative assumption
Source
None. No source document supplied
Verification
INCONCLUSIVE
Exceptions
No rent roll or unit mix supplied.
Result
Included for scenario analysis only.
Review
Not reviewed
Input or output
Average monthly rent
Value
$1,500 a month
Units
USD per month
Designation
Illustrative assumption
Source
None. No source document supplied
Verification
INCONCLUSIVE
Exceptions
Not supported by a source rent roll.
Result
Included for scenario analysis only.
Review
Not reviewed
Input or output
Occupancy today
Value
75%
Units
percent
Designation
Illustrative assumption
Source
None. No source document supplied
Verification
INCONCLUSIVE
Exceptions
Not supported by a source rent roll.
Result
Included for scenario analysis only.
Review
Not reviewed
Input or output
Stabilized occupancy
Value
92%
Units
percent
Designation
Illustrative assumption
Source
None. No source document supplied
Verification
INCONCLUSIVE
Exceptions
An assumption about the future. No lease-up plan or market study supplied.
Result
Included for scenario analysis only.
Review
Not reviewed
Input or output
Operating expense ratio
Value
45%
Units
percent
Designation
Illustrative assumption
Source
None. No source document supplied
Verification
INCONCLUSIVE
Exceptions
Not supported by trailing operating statements.
Result
Included for scenario analysis only.
Review
Not reviewed
Input or output
Cap rate
Value
7%
Units
percent
Designation
Illustrative assumption
Source
None. No source document supplied
Verification
INCONCLUSIVE
Exceptions
Stated in the scenario. No comparable sales supplied.
Result
Included for scenario analysis only.
Review
Not reviewed
Input or output
Modeled NOI, as-is
Value
$4,232,250 a year
Units
USD per year
Designation
Calculated
Source
Calculated from the inputs above
Formula
Units x average rent x 12 x occupancy today, less operating expenses
Verification
MATHEMATICALLY VERIFIED
Exceptions
Built on unverified inputs.
Result
For scenario analysis only. Not an actual NOI.
Review
Not reviewed
Input or output
Implied value, as-is
Value
$60,460,714
Units
USD
Designation
Calculated
Source
Calculated from the inputs above
Formula
Modeled NOI, as-is, divided by the cap rate
Verification
MATHEMATICALLY VERIFIED
Exceptions
Built on unverified inputs.
Result
For scenario analysis only. Not an appraised value, a price or an offer.
Review
Not reviewed
Input or output
Modeled NOI, stabilized
Value
$5,191,560 a year
Units
USD per year
Designation
Calculated
Source
Calculated from the inputs above
Formula
Units x average rent x 12 x stabilized occupancy, less operating expenses
Verification
MATHEMATICALLY VERIFIED
Exceptions
Built on unverified inputs.
Result
For scenario analysis only. Not a forecast.
Review
Not reviewed
Input or output
Implied value, stabilized
Value
$74,165,143
Units
USD
Designation
Calculated
Source
Calculated from the inputs above
Formula
Modeled NOI, stabilized, divided by the cap rate
Verification
MATHEMATICALLY VERIFIED
Exceptions
Built on unverified inputs.
Result
For scenario analysis only. Not an appraised value, a price or an offer.
Review
Not reviewed
Input or output
Difference in implied value
Value
$13,704,429
Units
USD
Designation
Calculated
Source
Calculated from the inputs above
Formula
Implied value, stabilized, minus implied value, as-is
Verification
MATHEMATICALLY VERIFIED
Exceptions
Built on unverified inputs.
Result
A gap between two modeled figures. Not profit, an equity gain or a return.
Review
Not reviewed

07

Capital markets context

Does It Pencil? is BullNet’s public teaching series. Hive Capital Markets is BullNet’s capital desk. They are separate, and this page is the series, not the desk.

  • On a real engagement, capital markets work would bring in a purchase price, lender terms and the cost of the lease-up.
  • Those inputs are what make coverage, break-even and return questions answerable.
  • None of that work is in this example, so none of those figures appear here.

Neither Does It Pencil? nor Hive Capital Markets is a brokerage or an investment advisory service. BullNet is not a lender. About Hive Capital Markets

08

The human decision

The arithmetic is checked. The inputs are not. That is the difference between a calculation and an underwriting conclusion.

A person decides what happens next: ask for the documents, test the assumptions against them, or walk away. The work shown here is there to inform that decision, not to make it.

The questionWhat it decides
Why is a quarter of the building empty?Whether this is a leasing problem, a condition problem or a market problem. Each one costs a different amount to fix.
What does it cost to get to 92%?How much of the gap between the two figures is left after renovation, concessions and time.
Is $1,500 the rent collected or the rent asked?Whether the income in the model exists today.
Does a 45% expense ratio hold at both occupancy levels?Whether modeled NOI is overstated. Many costs do not fall when apartments are empty.
What supports a 7% cap rate?The implied value moves with it. A higher rate gives a lower figure on the same income.
What is the price?Everything about return. Without it, this model can only compare two modeled figures.

Does it pencil?

Not yet.INCONCLUSIVE. The arithmetic is mathematically verified. Every input is an unverified assumption, and the model has no purchase price, renovation cost, lease-up cost or financing terms. It cannot show whether this pencils.

An AI answer is not an underwriting conclusion.

09

Start a Flight Sheet

Have a real decision to test? A Flight Sheet sets out the question, the information you have and what a defendable answer would need.

Illustrative underwriting on stated assumptions. Not a real transaction, a market survey or a recommendation. Not investment, tax or legal advice.