2 3 Assignment Real Estate Analysis Part I

Getting Through a Real Estate Analysis Assignment Without Losing Your Mind

The 2 3 Assignment Real Estate Analysis Part I is usually the gateway drug into commercial real estate finance classes. You get handed a property, a set of assumptions, and a spreadsheet template that may or may not work correctly. Your job is to figure out if the deal makes financial sense. It sounds straightforward. It isn't, not when you're actually doing the work. Most students open the template and immediately start typing numbers into the yellow cells without reading the instructions twice. I've seen this happen in every section I've taught. The assignment packet will have assumptions about rent growth, vacancy, operating expenses, exit cap rates, and financing terms. You need to understand each one before you touch a formula. If you plug in a 4% rent growth assumption when the market data suggests 2.5%, your entire output is garbage, and your professor will know it. The first thing I always tell people to do is build a separate assumptions sheet or at least a clearly labeled section. I keep a list of every input number with its source. A rent figure pulled from a CoStar report gets cited. A vacancy rate estimated from a local brokerage market report gets noted. This takes maybe ten extra minutes but saves you from having to reconstruct your logic when the assignment gets more complex in Part II.

The Core Mechanics You Actually Need to Calculate

Let's talk about what the assignment is really asking for. Most Part I assignments want you to compute a few key metrics: gross scheduled income, effective gross income, net operating income, cash flow before and after debt service, and either a cap rate or a return metric. Some assignments also want you to calculate an internal rate of return or equity multiple for a hold period. Here's the part most tutorial guides skip. You need to understand the relationship between these metrics and how a change in one assumption ripples through everything else. When I worked on actual deal analyses, I learned that the NOI is the single most sensitive number in the whole model. A one percent change in vacancy on a $2 million apartment building with $120,000 in annual income shifts your NOI by roughly $12,000. That's not rounding error. That changes whether the deal passes underwriting or gets rejected at the investment committee. The cap rate calculation itself is deceptively simple. You divide NOI by property value. But the nuance is in which NOI figure you use. Is it trailing NOI based on actual results? Is it stabilized NOI assuming the lease-up period is complete? Is it projected NOI for next year? The assignment will usually specify, but they rarely explain why the distinction matters. In practice, using stabilized NOI on a property that's still leasing up will overstate the value significantly. I once modeled a mixed-use development where the professor's answer key used stabilized NOI while the actual property was only 60% leased. The cap rate came out to 6.8% on paper and 9.2% on actuals. Those two numbers tell completely different stories about the deal.

Common Spreadsheet Mistakes That Will Cost You Points

Students lose points for reasons that have nothing to do with real estate knowledge. They reference the wrong cell. They copy a formula down without adjusting absolute and relative references. They forget that operating expense ratios typically increase as you normalize a property, not decrease. They calculate rental income using current rent instead of market rent when the assignment asks for pro forma income. One specific mistake I see constantly: calculating the debt service using the wrong loan term. The assignment might state a 30-year amortization with a 7-year balloon. Students use 30 years for everything including the hold period, which understates their annual debt service and inflates cash flow. The correct approach is to use the shorter of the amortization period or the actual hold period when computing annual payments, then account for the balloon payment at sale. This is a detail that separates students who understand the assignment from those who are just filling cells. Another issue is handling rent escalations. If the assignment specifies annual rent increases of 3% compounded, you cannot simply multiply the base rent by the number of years and add the percentage. You need to compound it year by year in the model. I built a habit of checking each year's revenue against a manual calculation. Year 1 at 3% on $100,000 is $103,000. Year 2 is $106,090. Year 3 is $109,272.70. If your spreadsheet shows $109,000 for year 3, something is wrong with your formula structure.

Operating Expense Analysis: Where the Real Work Happens

Gross income is easy. Operating expenses are where people make careless errors. You need to break down expenses into categories: property management, maintenance and repairs, insurance, property taxes, utilities, advertising and leasing commissions, and reserve for replacements. Each category has different behavior patterns. Property taxes often escalate at a fixed rate set by the jurisdiction, not at market rates. Insurance costs can jump significantly when a property is refinanced or when claims are filed. Maintenance reserves are typically calculated as a percentage of gross income, anywhere from 3% to 8% depending on the property type and age. If the assignment gives you a single line item for "operating expenses" as a percentage of gross income, you should verify that percentage against market benchmarks. A 35% operating expense ratio for a Class A multifamily property in 2024 is unusually low. Something is missing from the model. I ran into this exact problem once during a live underwriting session for a student project that mirrored real assignment work. The operating expense ratio came in at 31%, which is more typical of a Class B property, but the rent rolls indicated Class A positioning. I traced it back and found that the reserve for replacement line item had been accidentally zeroed out. Replacement reserves for a Class A multifamily property should be in the 4-6% range of gross income. Once I added that line back in at 5%, the expense ratio jumped to a much more realistic 36%. The NOI dropped by about $18,000 annually, which materially changed the cap rate conclusion. This kind of detail checking is what makes the difference between an assignment that passes review and one that falls apart under scrutiny.

Financing Assumptions and What They Do to Your Numbers

If the assignment includes a financing component, you'll need to calculate debt service. The standard formula uses the loan amount, interest rate, and amortization period to derive monthly payments, then multiplies by twelve for annual debt service. The monthly payment formula is P times the monthly rate divided by one minus one plus the monthly rate to the negative power of total payments. Most spreadsheets have a PMT function that does this for you, but you should understand the underlying math so you can catch errors. The loan-to-value ratio matters more than students realize. A higher LTV means more leverage, which amplifies returns but also increases risk. An 75% LTV on a $1 million property with a 7% interest rate and 30-year amortization produces a debt service coverage ratio of approximately 1.25 if the NOI is $80,000. Drop that LTV to 65% and the DSCR rises to about 1.43. The same property, different leverage level, dramatically different risk profile. The assignment may not ask you to analyze this, but understanding it will help you interpret your results. One counter-intuitive point about cap rates and leverage: a lower cap rate does not automatically mean a worse deal. Cap rates reflect risk and market conditions, not leverage decisions. A property in a prime market might have a 4.5% cap rate but strong cash flow after financing because the debt service is manageable. A property in a secondary market might show an 8% cap rate but negative cash flow because the financing costs are higher or the expense structure is worse. Don't use cap rate as a shortcut for deal quality. Calculate the actual metrics the assignment requires and evaluate from there.

What to Do When the Numbers Don't Make Sense

Sometimes your model will produce a result that looks wrong. The cap rate comes out to 12% on a stable multifamily property in a good market. The cash-on-cash return is negative in year one even though the NOI is positive. This usually means an assumption is incorrect, not that the method is flawed. Check your vacancy loss calculation. Verify your credit loss and collection loss figures. Confirm that you're not double-counting income or expenses. I had a case where a student's DSCR was below one, which should have been an immediate red flag. We traced it back to the leasing commission assumption. The model was amortizing the commission over the full lease term, but the expense was being recorded in the year the lease was signed. That created a single-year distortion that made the first year look terrible while the remaining years looked artificially clean. The fix was to spread the commission expense evenly across the lease term or to treat it as a one-time leasing cost in the year of turnover rather than an operating expense in the annual projection.

Structuring Your Submission for Maximum Clarity

Your final submission should include the completed spreadsheet with all formulas visible, a summary page showing your key metrics, and a brief narrative explaining your assumptions and conclusions. Professors can tell when you've just filled cells versus when you've actually thought through the analysis. The narrative section is where you demonstrate understanding. State your key findings upfront. Property X generates an NOI of $127,500 based on the assumptions provided. The going-in cap rate is 6.2%, which is slightly above the current market range for comparable properties in this submarket. The DSCR of 1.31 indicates adequate debt service coverage but limited cushion under stress scenarios. These kinds of statements show you're interpreting the numbers, not just reporting them. If you're required to make a buy-or-pass recommendation, support it with specific thresholds. I recommend purchasing this property if the acquisition price can be negotiated below $2.05 million, which would bring the cap rate above 6.5% and improve the DSCR to a more comfortable 1.40. At the asking price of $2.1 million, the risk-reward profile is marginal given current interest rate conditions and the property's occupancy trajectory.

Practical Steps for Tackling the 2 3 Assignment Real Estate Analysis Part I

Read the entire assignment packet before opening any spreadsheet. List every required output metric and verify you understand how each one is calculated. Build your assumptions section with sources documented. Enter revenue and expense line items one category at a time, checking each subtotal against market benchmarks as you go. Run sensitivity checks by changing one key assumption and watching how the outputs move. Write your narrative based on the actual numbers your model produced, not on what you hoped the numbers would be. The model will not lie to you, but it will amplify whatever assumptions you feed it. Garbage in, garbage out is the operating principle here. Spend the time getting the inputs right and the rest follows naturally.