Private Real Estate Spreadsheet Template for Syndications and Direct Deals

A private real estate spreadsheet template is the column list you paste into Excel or Google Sheets, not a sponsor-portal screenshot. Searchers who type those five words want property or deal, equity in, preferred return, monthly or quarterly distributions, capex calls, last cap rate, and last cash-on-cash on one row per vehicle. Raziel’s real estate investment tracker is the category query. This is the download. Direct rentals and LP syndications share that sheet only if cash dates are first-class.

This is not legal, tax, or investment advice. Raziel Holdings, Inc. does not provide it. Copy the lease, the loan, and the operating agreement you signed, not a market default.

Columns on a private real estate spreadsheet template

Raziel’s understanding private real estate investing page is the vehicle. This page is the row. One row per property LLC, deal SPV, or syndication LP. A duplex you own and an LP ticket into someone else’s multifamily are two rows, even if both say “real estate.”

Write, on day one:

• Property or deal. Legal name, address or vehicle name, and type: fee-simple rental, GP deal, or LP syndication.

• Equity in. Cash you actually wrote, with the wire date. Wall Street Prep’s cash-on-cash note treats initial equity as purchase cost minus the loan (and other non-equity financing). The composition is mostly the down payment, then closing costs, repairs, or upgrades.

• Pref. Rate, compounding, current-pay or accrued, cumulative or not, copied from the operating agreement. Blank is a fact on a straight-split deal.

• Distribution cadence. Monthly, quarterly, or “when cash allows,” plus the last settlement date and net amount.

• Capex calls. Date, amount, and what the notice said the dollars were for. A roof is cash out. Do not fold it into last month’s rent.

• Last cap rate. Stabilized NOI, the value you used, the as-of date, and the percentage those two produce.

• Last CoC. This period’s pre-tax cash flow, cumulative equity in, the as-of date, and the percentage.

• Cash table. Date, direction, type, amount. Rent, pref ACH, capex call, refinance, sale. The columns above are views of this table.

• Docs. Purchase agreement or subscription, rent roll or capital-account statement, loan, last K-1 or appraisal.

Equity in, pref, and the distribution cadence

Equity in is a running total, not a purchase-price cell. A later capex call adds to cash invested. A return-of-capital ACH reduces unreturned equity. Do not overwrite the original wire. Append.

Commercial Real Estate Law Group (Shams Merchant): a preferred return pays investors a specific return before profits go to the Manager. Store the type. Cumulative: unpaid amounts are made up at the next distribution, or deferred to sale after Class A capital is repaid and before sharing with Class B. Noncumulative: Class A members receive the cash that fulfills this period’s pref, and shortfalls do not accumulate. The 70/30 example on that page is a straight split, not a pref hurdle. Copy the rate you signed.

Cadence is a field, not a hope. A rental may post monthly. A syndication may post quarterly, or only after a refinance. Store the promised cadence and the last cash date separately so a missed quarter is visible. The net amount that landed is the row. The sponsor’s year-to-date screenshot is a view.

Capex calls, last cap rate, last CoC

Capex is not operating expense. Wall Street Prep’s NOI is rental plus ancillary income, minus direct operating expenses. Mortgage payments are not in that numerator. A capital-improvement call is a dated cash-out (and, if you funded it, more equity in). Mixing a roof into NOI will print a cap rate you cannot defend.

Last cap rate and last CoC are stored snapshots, not a ranking. Wall Street Prep: cap rate is unlevered. Cap Rate (%) = Stabilized NOI ÷ Current Market Value. Financing does not move it. Cash-on-cash (cash yield) is levered: Annual Pre-Tax Cash Flow ÷ Initial Equity Investment, where annual pre-tax cash flow is NOI minus annual debt service. Raziel’s cap rate calculator prints the same identity, Cap Rate (%) = (NOI / Property Value) × 100, and treats cash-on-cash as annual cash flow divided by actual cash invested, including the down payment. The tool’s comparison copy: cap rate assumes a 100% cash purchase and is a single-year snapshot that assumes stable operations.

Wall Street Prep’s worked example: $1.2 million NOI on a $20 million value is a 6.0% cap rate. After $800,000 of annual debt service, $400,000 of pre-tax cash flow on $5 million of equity is an 8.0% cash-on-cash return. Same property. The spread is the loan. Store NOI, value, debt service, and equity in with an as-of date. Recalculate when rent, expenses, or the mark change. Raziel’s calculator FAQ: recalculate annually, or whenever income or expenses move.

Direct rentals and LP syndications on one sheet

They share a template only if every cash movement has a date. A rent check, a pref ACH, a capex call, and an LP capital call are the same object with different labels. If the rental tab stores monthly rent as a number with no day, and the syndication tab stores a portal year-to-date, you have two books. Last cap rate on the duplex and last CoC on the LP line are then incomparable.

A workbook holds this if the links hold: one row per vehicle, equity in that appends, pref terms copied from the agreement, distributions dated, capex dated, last cap rate and last CoC computed from stored inputs. It fails when purchase price stands in for equity in, when a capex call is booked as OpEx, or when last CoC is typed by hand with no cash table behind it.

Raziel’s real estate dashboard is the book those rows already sit on: property values, rent, documents, IRR and unrealized gains. Raziel does not issue the K-1s and does not give tax advice. Paste the columns. Post the cash on the day it moved.