Before You Buy the Rental - companion resources
Evan Calder and Daniel H. Mercer | Groundwell Press
Local review edition | USA | USD | US English

Start with each Example, then save and fill its separate Your-Copy. All Example properties, quotes, rates and results are hypothetical. XLSX files calculate in a compatible spreadsheet application; PDFs are static reading/printing aids. No calculations run inside Kindle.

P1 Rental Deal Analyzer: enter gold cells for property/period, values, meaningful sources and dates. Unknown does not mean zero. For longer source notes on Inputs, use Home > Format > AutoFit Row Height or drag the row divider; formulas remain protected. Annual principal and interest count only the smaller of 12 and the payment count, starting before the first scheduled payment. Other financing charges have a separately stated 12-month scope. Read the complete operating/financing/cash result and the explicitly chosen scenarios.
P2 Repair & Reserve Planner: separate immediate work, annual maintenance and dated replacements. Set a replacement floor, start and contribution. Check the earliest funding need. Operating cash is a separate account.
P3 Property Evidence & Decision Board: use one to three slots and up to 30 evidence rows per property. Copy labeled results with IDs, versions and dates; write a decision and next action. Unreconciled reserve accounts leave funding amounts, commitment and cash-on-cash pending; the human choice stays visible with a funding warning. Each evidence statement carries its property ID, calculated readiness and source date into Decision; its own PENDING warning does not invalidate unrelated snapshots. Expand Decision print areas when activating additional evidence rows.

Birch v2-D1: P1 initial reserves $17,500 = replacement $13,500 + operating $4,000. Initial commitment $83,000 is the cash-on-cash denominator. P2 uses replacement $13,500 only. Do not force these different account scopes to be equal. The book provides the dated operating bridge.

Keep your data in your own copies. No macros, external workbook links or data collection. Formula protection has no password and prevents accidental edits; unprotect only to inspect formulas. Native Excel was checked; other engines are not certified. Current property-specific quotes and qualified advice remain your responsibility.

No public access URL has been assigned. This ZIP is the supplied local companion package, not evidence of publication.
