Project Analysis with Bearing & Beacon

Everyone can relate to a project taking longer than expected and unfortunately it appears to be the norm nowadays. Whether you're a for-profit company or a nonprofit organization, a detailed and digestible project analysis is vital. Not only for your own planning, but for grant applications, lenders, board approval, and anyone else being asked to put money behind the idea.

Funders need to see that you understand what the project actually costs — not just to start, but to sustain. They need to see where the revenue comes from, what happens if it arrives slower than expected, and whether the organization can carry the project through a hard year. Delays and unforeseen expenses can be costly. A program launched without a firm grasp on revenue and expenses can be deeply detrimental to sustainability, and the damage usually extends well beyond the project itself.

The Problem With Optimistic Math

Most projects that fail financially were not built on bad intentions. They were built on incomplete numbers.

The pattern is familiar. An opportunity appears. Someone runs rough figures on a legal pad or a single spreadsheet tab. The numbers work — barely — and the enthusiasm in the room carries the decision. What gets left out are the costs nobody thought to ask about, the revenue timing that doesn't match the expense timing, and the assumption that year one will look like a stabilized yea.

Then reality arrives. Revenue ramps slower than projected. A cost that was estimated at $2,000 comes in at $9,000. Cash gets tight. And because the project is already underway, the organization ends up pulling from operating reserves or unrestricted funds to keep it alive — which means the new program is now quietly threatening the programs that were already working.

A Ready Example: Buying a Residence

Consider an organization that wants to purchase a home to house an underprivileged group — transitional housing for families leaving shelter, a recovery residence, housing for young adults aging out of foster care. It's a common and worthy project, and it's a good illustration because the gap between the obvious costs and the real costs is so wide.

The obvious analysis looks like this. A six-bedroom house is listed at $285,000. The organization has $60,000 for a down payment. Financing the remaining $225,000 over twenty years produces a mortgage payment somewhere around $1,700 per month. Six residents paying $400 monthly in program fees brings in $2,400. The project appears to clear roughly $700 a month.

Now the analysis that actually reflects operating the property:

On the expense side. Commercial or nonprofit-owned property insurance is materially more expensive than a homeowner's policy, and a congregate-living use may require specialty coverage — call it $450 a month rather than the $120 someone assumed. Property tax exemption is not automatic; it depends on the state, the use, and an application that may take a year to process, so the first year may carry a full tax bill. Utilities for a fully occupied six-bedroom house with residents home during the day run higher than a family home: water, sewer, trash, electric, gas, plus internet, easily $700 to $900 monthly. Maintenance and repairs on an older property should be reserved at 1% to 2% of value annually, so $250 to $500 a month set aside before a single thing breaks. Lawn care, snow removal, and pest control. Furnishings and appliances at move-in, and replacement of both over time.

Then the costs specific to the use. Zoning review or a conditional use permit. Fire marshal requirements for congregate living — egress, alarms, extinguishers, possibly sprinklers. ADA accessibility if the program is publicly funded. Licensing, if the state requires it. Staffing, which is usually the largest line and the one most often omitted: even a part-time house manager at 20 hours a week runs $1,800 to $2,400 a month fully loaded with taxes and benefits. Background checks and training. Resident support services.

On the revenue side. Six beds is capacity, not occupancy. Between turnover, screening time, and the ramp-up period after opening, 80% to 85% is a realistic stabilized figure, and year one will be lower — possibly much lower if intake takes months to build. Collections are not the same as billings; a population with limited income will have months where fees don't come in, and most programs aren't willing to evict over it. If revenue comes through vouchers or a government contract, payment is typically in arrears, often 30 to 90 days, which means the property operates for a full quarter before the first reimbursement lands.

Run honestly, that $700 monthly surplus becomes a deficit of several thousand dollars a month — a gap that has to be covered by fundraising, grants, or the operating budget. That's not necessarily a reason to abandon the project. Plenty of housing programs are worth subsidizing, and the mission may fully justify it. The point is that the organization should know the number before closing, not eighteen months after.

And a proper analysis surfaces the fixes. Maybe the answer is a smaller property with lower fixed costs. Maybe it's securing an operating grant alongside the capital campaign, rather than raising only for acquisition. Maybe it's a capital reserve funded at purchase, or a line of credit sized to bridge the reimbursement lag, or simply a phased opening that matches staffing to actual occupancy. Every one of those options is available in the planning stage and expensive or impossible once the deed is signed.

What a Real Project Analysis Includes

Good analysis is not a longer spreadsheet. It's a clearer one, built around a few things:

A complete cost picture separating one-time costs from ongoing costs, and capital from operating. These get blended constantly, and blending them is how organizations raise enough to buy something they can't afford to run.

Multi-year projections, not a single stabilized year. Most projects lose money in year one. Funders expect that and want to see when it turns.

Cash flow modeled by month. Annual totals hide the problem. A project that nets positive for the year can still run out of cash in March, and running out of cash in March is what ends programs.

Stated assumptions. Every number in the model rests on an assumption about occupancy, pricing, collection rate, or timing. Writing them down is what allows a board or a program officer to evaluate the projection instead of simply trusting it.

Scenarios. What the project looks like at expected performance, at a conservative case, and at a genuine downside. The downside case is the one that tells you how much risk the organization is actually taking on.

A clear break-even. What occupancy, what volume, what price. If nobody in the room can answer that question, the project isn't ready for a decision yet.

Why This Matters for Funding

Sophisticated funders read a lot of proposals, and they can tell within a page or two whether the numbers behind one are real. A budget that reconciles, projections that acknowledge a ramp-up period, and assumptions stated plainly all signal an organization that will manage the award competently — which is exactly what a program officer needs to defend the grant to their own board.

The opposite is just as visible. Round numbers everywhere. Full occupancy from month one. No line for maintenance or staffing. A capital ask with no operating plan behind it. None of these get flagged in a rejection letter, but they shape the decision.

Strong analysis also protects you during the grant period. When you've modeled the project properly, you know early when something is drifting, and you can raise it with the funder while there's still time to adjust. That conversation is a partnership. The same conversation at closeout is a problem.

How Bearing & Beacon Can Help

Bearing & Beacon provides projection modeling and cash flow analysis built for the decisions you're actually facing — whether that's a property acquisition, a new program line, an expansion, or a grant application that needs financials a funder will trust.

We build reports that show the full cost picture, project performance over multiple years, map cash flow month by month, and test the scenarios that matter. The result is something you can act on internally and present externally with confidence.

Contact us today to learn more.