Working with The New Deal Worksheet: What Actually Happens When You Try to Use It
The New Deal Worksheet is a financial analysis tool used primarily by real estate investors, business buyers, and commercial deal analysts to evaluate the profitability and risk of a prospective acquisition. It typically asks for purchase price, closing costs, rehab expenses, projected rental income, vacancy rates, operating expenses, debt service, and exit strategy. From there it spits out cash flow, cap rate, cash-on-cash return, and sometimes a rough IRR projection. That part sounds straightforward enough on paper. The actual mechanics of using it consistently is where most people hit snags. I have spent years filling these out for multifamily properties, small commercial buildings, and occasional single-family rentals. The first thing you need to understand is that the worksheet itself is only as good as the numbers you feed into it. Garbage in, garbage out, obviously, but the specific ways people screw this up are more subtle than you might think. Here is the basic workflow. You open the template, enter the purchase price, then immediately pull the property's actual rent rolls and expense history from the seller's provided P&L. If there is no P&L, you get whatever the landlord will tell you over the phone and you discount it by 10 to 15 percent as a baseline accuracy adjustment. Then you fill in your own assumptions for vacancy, CapEx reserves, property management, insurance, and taxes. The formula fields should auto-calculate the rest. You do not need to touch those. Do not touch the formula fields. I have seen too many people overwrite a formula with a hardcoded number and then wonder why their cash flow looks impossible.
One thing beginners consistently miss is the difference between gross operating income and effective gross income. The worksheet will have both. Gross income is simply all potential rent plus any other income streams like laundry or parking. Effective gross income subtracts vacancy and credit losses. If you plug gross income into a cash flow calculation without accounting for vacancy, your numbers will be roughly 5 to 8 percent too optimistic on a typical multifamily deal. That margin is enough to turn a marginal deal into a losing one or make a solid deal look borderline when it is actually fine. Factor in vacancy from day one and keep it honest. Another common pitfall involves operating expense ratios. The worksheet has a field for total operating expenses, but people often omit one or two line items and wonder why their NOI seems inflated. The most frequently forgotten expense is property management, which runs 8 to 10 percent of gross income for self-managed owners who should be paying themselves even if they never actually write themselves a check. If you are going to self-manage, put yourself on payroll in the spreadsheet at a market rate. It changes your bottom line more than you expect.
A Specific Edge Case That Almost Cost Me a Deal
About three years ago I was analyzing a 12-unit property in Cincinnati using a standard version of The New Deal Worksheet. The numbers looked decent on the surface. Cash-on-cash around 9 percent, cap rate near 7. I was ready to make an offer when I noticed something in the lease schedule. Three of the twelve units had month-to-month leases that were about to renew. The other nine had fixed leases expiring within six months. I had originally run the pro forma assuming stable occupancy at current rents, but the reality was that nearly a third of the units could reprice upward or go vacant within a quarter. The workaround was simple but I should have caught it before the analysis stage. I created a separate sheet within the workbook that modeled a worst-case occupancy scenario at 75 percent for the first year, factoring in the lease turnover risk, and ran the full worksheet against that. The cash-on-cash dropped to 4.2 percent. That changed the entire conversation. I adjusted my offer price downward by roughly $40,000 to reflect the risk, and the seller accepted because they had already been through three other buyer offers that fell apart over the same occupancy concern. The lesson here is that lease structure matters as much as the raw numbers, and The New Deal Worksheet will not warn you about this automatically. You have to build in the scenarios yourself.
Get the Full Details
What Most People Get Wrong About the Exit Strategy Section
Most versions of The New Deal Worksheet include an exit strategy projection, usually at year three or year five. The typical assumption is that you sell the property and calculate your total return based on that sale price. The problem is that people use unrealistic appreciation rates. I see 5 to 7 percent annual appreciation assumed in worksheets where 2 to 3 percent is more realistic for most secondary markets. This skews your IRR dramatically. If you are using a five-year hold with a 6 percent annual appreciation assumption in a market that historically appreciates at 2.5 percent, your projected return could be 30 to 40 percent higher than what actually materializes. The fix is to ground your exit cap rate and appreciation assumptions in actual comparable sales data. Pull three to five recent sales of similar properties in the same submarket, calculate their cap rates, and use the average as your exit cap rate. For appreciation, check the local historical trend. If the Census Bureau or your state's revenue department publishes property value growth data for that county, use it. Do not guess. A worksheet with a properly grounded exit assumption will give you a return figure that is closer to reality, even if it is less exciting than the optimistic version.
Software Choices and the Spreadsheet Problem
There are dozens of versions of The New Deal Worksheet floating around online. Some are simple Excel files, some are Google Sheets, and some are proprietary software like DealCheck or BiggerPockets' calculator. I mostly use a custom Google Sheets workbook because it syncs across devices and I can share specific tabs with my accountant or mortgage broker without sending the whole file. The tradeoff is that Google Sheets handles financial formulas differently than Excel in a few edge cases, particularly around rounding. If you are doing quick back-of-the-envelope analysis, this does not matter. If you are building a formal investment memo for lenders, the rounding discrepancies can add up enough to cause a discrepancy of a few hundred dollars on net operating income calculations. Another limitation worth noting upfront is that these worksheets assume you are buying an existing property with existing income. They are not designed for ground-up developments or major value-add projects where expenses are front-loaded and income is zero during construction. If you are working on a development deal, you need a completely different model. The New Deal Worksheet will give you misleading results in that scenario because it cannot account for construction financing costs, delayed revenue, or phased expenditure timing.
Downsides and When This Tool Fails Completely
The honest answer is that The New Deal Worksheet is a screening tool, not a decision-making tool. It is useful for quickly eliminating deals that clearly do not work so you can focus your time on the ones that pass initial filters. It is not sufficient for making the final offer decision. The reasons are structural. The worksheet cannot account for local regulatory risk, zoning changes, environmental liabilities, or the quality of the physical building beyond what you infer from expense history. It also cannot factor in tenant quality, which is arguably the single most important variable in whether a deal performs as projected or falls apart. I have watched people close deals that looked good on paper and fail within eighteen months because they skipped the physical inspection, the title search, or a conversation with the property manager about maintenance issues. The worksheet had them feeling confident. That confidence was misplaced. Use The New Deal Worksheet to filter, not to commit. Any deal that clears the initial spreadsheet screen should then go through a full due diligence process that includes a physical inspection, rent roll verification, and a review of the property's legal and tax history. If you want a free starting point, there are several reputable templates available online from sources like BiggerPockets, the Real Estate Investing community forums, and various accounting firms that specialize in investment property analysis. Search for "The New Deal Worksheet" along with your specific asset class to find something tailored to what you are actually analyzing. A multifamily template will look very different from a single-family or commercial template, and using the wrong one will introduce errors that the formula structure cannot catch.
The core habit that separates people who use this tool well from those who do not is discipline in the assumption column. Every number you enter is an assumption. Treat each one like a hypothesis that needs evidence, not a guess. When you fill out The New Deal Worksheet with documented assumptions rather than hopeful ones, it becomes a genuinely useful part of your deal analysis process. When you fill it in with wishes, it becomes a machine for convincing yourself to make bad decisions. The tool itself does not care which version you build.
