TROV

TROV Blueprint — About

How the tool works, what is modeled, what is verified, and what is coming next.

What is TROV Blueprint

TROV Blueprint is a two-stage residential real estate underwriting tool for 1-4 unit income-producing properties. It is browser-based, requires no account or login, and is currently free. It is built for investors who want to model deals with the same precision a lender uses — not just a back-of-napkin estimate.

It is suitable for both experienced investors who already understand terms like DSCR, NOI, and IRR, and for beginners who want to learn proper underwriting by working through real deal numbers in a structured and transparent system.

How It Works

Stage 1 — Screener

The Screener evaluates whether a deal is worth pursuing at the acquisition level. Run your numbers across three loan types — Conventional, FHA, and DSCR — and get a structured pass/fail verdict before committing to deeper analysis. The Screener is designed to be fast — enter your deal details and immediately see whether the numbers work at the acquisition level before spending time on full underwriting.

Stage 2 — Underwriting

The Underwriting engine takes your screened deal and projects it forward through a full hold period of up to 30 years. Model your proforma, refinance event, equity flow, capital recovery, and returns with the same depth a professional underwriter would apply. The Underwriting engine is deliberately detailed — every assumption is visible, every calculation is traceable, and every output is connected to real lender logic.

Module Guide

Stage 1 — Screener

Read Me — Disclaimers, tool overview, and email signup for development updates

About — What the tool does, how it works, module descriptions, verification status, and roadmap

Deal Dashboard — Summary view of all key screener outputs in one place including deal verdict

Deal Inputs — Enter your purchase price, loan type, financing terms, unit count, and property details

Loan Sizing — See how your loan is sized including DSCR three-constraint logic, FHA self-sufficiency test, and PMI and MIP calculations

Income — Enter gross scheduled rent by unit, vacancy rate, and other income sources

Expenses — Enter and categorize all operating expenses with individual line items

Cashflow — See your net operating income, debt service, and net cash flow after financing

Deal Metrics — Key acquisition metrics including cap rate, cash-on-cash return, DSCR, debt yield, breakeven occupancy and rent, OpEx ratio, and a deal verdict based on investor-set thresholds

Deal Sensitivity — Stress test your acquisition assumptions across Best, Base, Worst, and Stress scenarios with independent multipliers for rent, vacancy, interest rate, insurance, taxes, and variable expenses

Stage 2 — Underwriting

UW Dashboard — Summary view of all key underwriting outputs across the full hold period in one place

UW Inputs — Set your hold period, rent growth rate, individual expense growth rates, discount rate, and all underwriting assumptions

Refi Engine — Model a cash-out refinance event using three-constraint loan sizing with full cascade through all downstream calculations

Amortization — Full month-by-month amortization schedule for the entire hold period showing loan status as Original, Replacement, or Paid Off for each month

Debt Schedule — Annual debt service summary showing principal, interest, and mortgage insurance by year across the full hold period

Proforma — Full hold-period income and expense projection with every line item growing at its own individually set growth rate

Property Value — Track property value over the hold period using either the cap rate on NOI method or the fixed appreciation rate method with LTV tracking

Equity Flow — Operating cashflows separated by loan era showing original loan period versus post-refi period, refi cash-out as a distinct inflow, net rollable equity available to redeploy, and net sale proceeds at exit

Capital Recovery — Simple and discounted cumulative cashflows tracked from year zero through the hold period with payback milestones at 25%, 50%, 75%, and 100% of initial equity recovered and an equity multiple growth chart

Exit — Model your sale price, broker fee, sale costs, debt payoff, and net proceeds to equity at the end of the hold period

Returns — Full return metrics including leveraged IRR, IRR from operations only, NPV, equity multiple, discounted equity multiple, cash-on-cash, and average annual cashflow

What Makes TROV Different

Several features in TROV Blueprint are not immediately visible from the surface of the tool. This section documents them explicitly so investors understand what is being modeled and why it matters.

FHA Loan Type Defaults to House Hacking Mode

When the FHA loan type is selected the tool automatically assumes the owner will occupy one unit of the property. Rental income used for qualification is calculated from the non-owner units only. This reflects how FHA owner-occupied financing actually works for 2-4 unit properties and eliminates a common modeling error where investors accidentally count all unit income including the unit they plan to live in. Most tools do not model FHA financing at this level of specificity — they treat all loan types as generic financing inputs.

FHA Self-Sufficiency Test Activates Automatically

For properties with 3 or 4 units using FHA financing the self-sufficiency test activates automatically without any user input. The tool calculates whether 75% of gross market rent from all units including the owner-occupied unit covers the full PITI plus mortgage insurance payment per HUD Handbook 4000.1. The result is displayed as a clear pass or fail. This test determines whether a 3-4 unit property can actually close with FHA financing — failing it means the deal cannot proceed under FHA regardless of the borrower's income or credit. No other residential underwriting software currently models this automatically.

DSCR Loan Sizing Uses Three Constraints Simultaneously

Most tools let you input a loan amount or a target DSCR ratio. TROV instead sizes the DSCR loan the way a non-QM lender actually does — by computing the maximum loan amount under three separate constraints simultaneously: a DSCR floor, an LTV cap, and a debt yield minimum. The actual loan amount is the minimum of all three and the tool identifies which constraint is the binding factor. This tells you not just what loan you can get but exactly why that is the limit — which is what a lender will tell you when they decline your requested loan amount.

PMI and MIP Cancel Mid-Amortization

For Conventional loans PMI cancels automatically in the month when the loan balance falls to 80% of the original purchase price. This cancellation is reflected in the actual monthly cash flow projections and annual proforma rather than being estimated or ignored across the full hold period. For FHA loans MIP cancels after 132 months provided the original loan-to-value ratio was 90% or below at origination. FHA loans originated with an original LTV above 90% carry MIP for the life of the loan. Both cancellation events update the cash flow projections automatically in the month they occur. Most tools either ignore mortgage insurance entirely or apply it as a flat cost for the full hold period which overstates long-term costs and understates returns on deals held beyond the cancellation point.

Dual Property Valuation Methods

The Property Value module offers two distinct methods for tracking property value across the hold period rather than forcing a single approach. The cap rate method derives the property value each year by dividing that year's projected NOI by the exit cap rate — this ties value directly to operating performance and market yields, meaning the property is worth more when rents grow and expenses are controlled, which is how buyers and lenders actually price income-producing properties. The appreciation rate method compounds the original purchase price annually at a fixed rate — simpler but useful for stress testing value assumptions independently of operating performance. Both methods feed live into the LTV calculations on the amortization schedule, the refinance engine constraint sizing, the equity flow era separation, and the exit proceeds calculation. Choosing the wrong method or defaulting to one without understanding the difference can meaningfully change every downstream return metric — TROV surfaces both explicitly so the investor makes a conscious choice rather than accepting a hidden assumption.

Two Completely Independent Sensitivity Systems

The Screener and the Underwriting engine each have their own independent sensitivity system with Best, Base, Worst, and Stress scenarios. The Stage 1 system adjusts acquisition-level variables — rent, vacancy, interest rate, insurance, taxes, and variable expense multipliers. The Stage 2 system adjusts hold-period variables — rent growth rate, individual expense growth rates, exit cap rate, refinance rate, refinance LTV, refinance closing costs, and discount rate. These systems operate independently so you can stress test your entry assumptions separately from your long-term hold assumptions without the two interfering with each other. No other residential underwriting tool currently implements dual independent sensitivity systems at this level.

The Refinance Engine Cascades Through All Downstream Calculations

The refinance event is not a static input. When you set a refinance trigger the tool looks up the actual property value at that exact month from the live proforma, looks up the actual remaining loan balance from the amortization schedule at that month, sizes the replacement loan using the same three-constraint logic used for DSCR acquisition, computes net cash-out after paying off the old loan balance and all closing costs, and then cascades the replacement loan through the debt schedule, proforma, equity flow, capital recovery, and returns calculations. Every downstream number updates automatically to reflect the actual post-refinance reality. Changing any upstream assumption — rent growth, expense growth, property value method — automatically flows through to the refinance event and all outputs beyond it.

Dual IRR Distinction

The Returns module shows two separate IRR calculations rather than a single blended number. Leveraged IRR includes the complete equity cashflow stream — all operating cashflows, refinance proceeds, and sale proceeds. IRR from Operations Only uses just the annual operating cashflows and excludes both the refinance cash-out event and the exit sale proceeds. This distinction matters because it separates how well the property performs as an income-generating asset from how much the returns depend on financing strategy and exit timing. A deal with a strong operations IRR is fundamentally sound. A deal where the leveraged IRR is high but the operations IRR is low is depending heavily on the exit or the refinance to generate returns — a meaningful risk distinction that a single blended IRR number hides.

Verification Status

TROV Blueprint is built on a rigorously developed Excel underwriting workbook refined over months of real deal analysis. Every calculation in the web application is a direct implementation of that workbook logic, verified through an automated test suite of 589 tests across 18 test files. The table below reflects where things stand today - every module listed has cleared a first round audit against workbook ground truth and HUD 4000.1 where applicable. We surface this transparently because accuracy is the product. If you find a discrepancy, we want to know.

ModuleStatusNotes
Stage 1 Screener — ConventionalVerified — Round 178 tests passing against workbook ground truth.
Stage 1 Screener — DSCRVerified — Round 194 tests passing against workbook ground truth.
Stage 1 Screener — FHAVerified — Round 134 tests passing, verified against HUD 4000.1 November 2025.
Stage 2 Underwriting — ConventionalVerified — Round 1219 tests passing across amortization, proforma, equity flow, capital recovery, exit, and returns.
Stage 2 Underwriting — Conventional Worst ScenarioVerified — Round 119 tests passing against workbook Worst scenario ground truth.
Stage 2 Underwriting — Conventional Appreciation MethodVerified — Round 117 tests passing against workbook Appreciation method ground truth.
Stage 2 Underwriting — Conventional RefiVerified — Round 121 tests passing against workbook Refi Enabled ground truth.
Stage 2 Underwriting — DSCRVerified — Round 124 tests passing against workbook DSCR Base ground truth.
Stage 2 Underwriting — DSCR Worst ScenarioVerified — Round 131 tests passing against workbook DSCR Worst ground truth.
Stage 2 Underwriting — DSCR RefiVerified — Round 133 tests passing against workbook DSCR Refi Enabled ground truth.
FHA Refi EngineVerified — Round 1LTV-only sizing and financed UFMIP verified per HUD 4000.1.
Input Validation — All Loan TypesVerified — Round 1FHA 3.5% minimum, DSCR down payment auto-calculated, conventional warnings, FHA refi LTV and seasoning locked per HUD 4000.1.

Roadmap

Currently in active development

  • Full page-by-page audit of all modules against the underlying workbook
  • Verification of all Stage 1 and Stage 2 calculations
  • UI refinements based on early user feedback

Planned future features

  • User accounts with saved deals
  • PDF report export
  • Property data integration for automated address lookup available at all tiers
  • Portfolio tracking across multiple deals
  • AI batch processing for deal pipeline analysis and automated deal ranking

Commercial Direction

TROV is currently free with no account required and no monetization in place. The intended model is tiered — a free tier keeps the core underwriting workflow accessible to everyone, while paid tiers unlock user accounts, saved deals, batch deal processing, portfolio tracking with direct benchmarking against original acquisition assumptions, personalized market analytics aggregated and broken down by location, and property data integration including the HUD Fair Market Rents API for automated rent benchmarking.

Monetization has been deliberately deferred while the foundation is built and the market is validated through direct conversations with real estate operators, investors, and industry professionals. The priority has been getting the underwriting mechanics right before building the business around them.

The tool is actively being tested with operators running real deals through it. Feedback from those conversations is driving both product decisions and the assessment of whether and how to bring it to market.

Stay in the loop as TROV develops.

Stay in the loop

No spam. Unsubscribe anytime.

Found a bug or have a suggestion? Let us know.

Limited to 3 submissions per hour. Goes directly to the builder.

Providing your email here is only used to follow up on your feedback - it is not added to any mailing list.

By using this tool you acknowledge that you have read and understood the disclaimers.