Property Panther

Property Panther

PPJ Properties
Forgot your password?
or
© 2026 PPJ Properties · CR Capital Management
PPJ Properties
Metro Detroit BRRR Portfolio
Google Sheets—
JobTread—
Buildium—
GoHighLevel—
Google Ads—
Last refresh: —

PPJ Properties — Home

PPJ Real Estate — Michigan BRRR & Rental Asset Management

Good , Frank

Here's your business snapshot as of

BRRR Portfolio
Buy, Rehab, Rent, Refinance
Wholesale Pipeline
Offer Now Michigan — Acquisition Deals
Flip Portfolio
Active & Completed Flips
Property Management
Occupancy, Revenue & Maintenance

Properties by Project Status

Property Locations

Deal Stack: Purchase Price, Fees, Construction & Forced Equity

Stacked breakdown per property — showing how each deal's value is composed

Property Performance

Cashflow, DSCR, and NOI performance across the portfolio

Top 5 by Annual Cashflow

Address Type Annual CF Cap Rate

Bottom 5 by Annual Cashflow

Address Type Annual CF Cap Rate

Top 5 by DSCR Ratio

Address Type DSCR Monthly CF ARV

Flip Deals by Status

Profit per Deal

Flip Deal Stack: Purchase, Rehab, Holding Costs & Gross Profit

Stacked breakdown per flip — showing cost composition and profit

Flip Performance

ROI, profit, and Rule of 70 analysis across all flip deals

Flip Profit by Period

Period Deals Revenue Cost Profit Avg Profit Avg ROI

APR Analysis by Deal

Flip Deals Scorecard

Address ↕ City ↕ Status ↕ Close Date ↕ Purchase ↕ Rehab ↕ All-In ↕ ARV ↕ Gross Profit ↕ ROI ↕ MOIC ↕ APR ↕ Rule of 70 Hold Mo. ↕

Portfolio Balance Sheet

Purchase + Construction cost breakdown across all properties

BRRR Portfolio Statistics

Comprehensive metrics for evaluating portfolio health and returns

Capital Efficiency Analysis

How efficiently capital is recycled through the BRRR process

Risk & Coverage Metrics

Debt service coverage and portfolio risk indicators

5-Year Portfolio Cashflow Projection

Capital Deployed vs Recovered

DSCR Distribution Across Portfolio

Yield on Cost vs Cap Rate by Property

Cost Stack per Property (Purchase + Fees + Construction + Equity)

Monthly Cashflow Waterfall

BRRR Scorecard — All Properties

Key return and efficiency metrics per deal

Property Type All-In ARV Equity Cash Refi Net Cash MOIC Cap Rate DSCR YoC CoC NOI Margin 5yr CF Payback Deal Calc

Depreciation & Bonus Depreciation (Cost Segregation)

IRS residential rental: 27.5-yr straight-line on building + 100% bonus depreciation on qualified components (OBBBA 2025). Land at 15% of purchase price is non-depreciable.

Cost segregation estimates: ~25% of rehab costs reclassified as 5/7/15-yr property eligible for 100% Year 1 bonus depreciation. Building shell (75%) remains on 27.5-yr schedule.

Flip Calculator

Analyze flip deals with Rule of 70, APR, and all computed metrics. APR is used to report annualized returns to fund investors.

Deal Inputs

Computed Flip Metrics

Portfolio Flip Deals

All EXIT strategy deals from your portfolio with flip metrics

Property Purchase Rehab All-In ARV Forced Equity MOIC Rule of 70 Status
Property Name Bed/Bath SqFt Resident Insurance Lease Type Lease Start Lease End Monthly Rent Balance Security Deposit
W/O # Description Property Status Priority Vendor Amount Created Date Last Updated Comments

Property Maintenance Budget Tracker

5% of annual rent budget. Work orders over $500 require approval before proceeding.

Property Status Monthly Rent Annual Budget (5%) MTD Spent YTD Spent Budget Remaining % Used Open W/O Pending Approval

Work Orders by Month & Property

Stacked bar chart showing work order spend by property per month (YTD). Totals displayed on each bar.

All Work Orders

W/O # Description Property Status Priority Vendor Amount Approval Created Actions

Work Order Details

Occupancy Status

Monthly Rent by Property (Occupied)

Properties — Rent, Maintenance & Expense Ratio

Maintenance % = Trailing 12-Month Work Order Costs / Annual Rent

Property Bed/Bath Sqft Rental Score Resident Lease End Monthly Rent Annual Rent Maint. Cost (12M) Budget (5%) Actual vs Budget Rent Due # WOs
Address City Type Loan Type Status Rental Score Refi Strategy Purchase Rehab All-In ARV Equity Rent Monthly CF Annual CF Cap Rate DSCR MOIC YoC Deal Calc

Loading insurance data...

Data is pulled from the LLC Entity & Ins Tracker sheet.

Address City Type Rental Status Policy Type Carrier Policy # Monthly Rate Annual Rate Ins. Converted Entity Notes

Loading rental scores data...

Data is pulled from the Rental Scores sheet.

Score Distribution

Average Score by City

Category Averages (% of Max)

Lease-Up Speed Distribution

Category Heatmap — All Properties

Green = full marks, Yellow = partial, Red = zero. Identifies property weaknesses at a glance.

Rank Address City Type Score 2+Beds BedSize Neighborhood AC Open Plan Garage Basement Yard Closets Storage Lease-Up PM Verified

Utilities Tracker

Track gas, electric, and water accounts for all properties. Click any cell to edit.

# Property Area Type Vacancy Gas Provider Gas Acct # Electric Provider Electric Acct # Elec/Gas Status Service Start Water Acct Water Status Status Contact # Portal URL Portal User Portal Pass Actions

Deals Sold & Revenue — Month over Month

PeriodDeals SoldRevenueAvg Deal

🎯 Acquisition Pipeline

📝

Working Leads

🔥

Hot F.U

📄

Under Contract

Stage Distribution

Rep Workload

RepTotal DealsWorkingHot F.UUnder Contract

City Distribution

City# DealsTop Stage

Revenue by Deal Type

Deal TypeDealsTotal RevenueAvg FeeShare

Monthly Revenue Trend

Under Contract Deals

DealAssign PriceContract CostFeeClose DateDays To CloseLast ContactRisk

Assigned To Buyer

DealAssign PriceContract CostFeeDeal TypeLast ContactDirection

Refund/Junk — Rescue Candidates

Seller / AddressCategoryDays Since ReplyLast Seller MessageRep

COLD F.U. — Reactivation Candidates

Seller / AddressCategoryDays Since ReplyLast Seller MessageRep

Offer Rejected — Re-Engagement

Seller / AddressCategoryDays Since ReplyLast Seller Message

Canceled Contracts — Revival

Seller / AddressCategoryDays Since ReplyLast Seller Message

Revenue Recovery Projection

SegmentLeadsEst. Conv. RateEst. DealsEst. RevenuePriority

Revenue Pipeline Metrics

Pipeline Funnel

Lead Source Performance

SourceTotal LeadsActive LeadsUC+ DealsUC Conv. Rate %Avg Days in PipelineWeighted Pipeline Value

Lead Aging Analysis

Age Range# Deals% of TotalTop StageAvg Value

Monthly Lead Intake vs Closings

MonthNew Leads AddedLeads Reaching UC+Pipeline Value AddedConversion Rate %
Name Address City Stage Rep Source

Rep Workload Distribution

Deal Count by Stage

RepTotalWorking LeadsHot F.UCold F.U Under ContractRefund/Junk
PeriodPipelineDeals WonTotal RevenueAvg Deal SizeTop Rep

Closed Deals (by Close Date)

Close DateNameAddressCityPipelineStageFee/RevenueRep

Closed Deals — Missing Close Date

CreatedNameAddressCityPipelineStageFee/RevenueRep
PrioritySeller / AddressCurrent Stage IssueAction RequiredDaysRep
Pipeline Stage Breakdown
Weekly Activity (90 Days)
WeekNew LeadsUnder ContractHot F.UPipeline ValueCumulative $
Rep Leaderboard (90 Days)
RepTotal DealsNew LeadsUnder Contract Hot F.UClosedUC Pipeline $ Closed RevenueUC Rate
Stage Distribution by Rep
Pipeline Age Distribution
Key Insights & Recommendations

Daily Lead Volume & Cost

Leads

# Date Name Phone Email Address City Source Cost Status Quality Notes

🔗 Webhook Endpoint

https://us-central1-claude-app-ppj-crcap.cloudfunctions.net/pplWebhook

Point your LeadZolo webhook to this URL. Sends POST with JSON body. Fields: first_name, last_name, email, phone, address, city, state, zip, source, cost, etc.

Daily Overview

Day-by-day performance with trend indicators

Daily Spend & Conversions (90 Days)

Monthly Spend Trend

Weekly Performance

Campaign Performance (90 Days)

Ad Group Performance

Keyword Performance (Top 200 by Spend)

Search Term Report (30 Days, Top 200)

PPC Lead Source Performance in Pipeline

Correlates Google Ads spend with leads that entered the GHL pipeline from PPC sources.

PPC Leads in Pipeline

No JobTread data loaded.

Configure your JobTread API key in Settings and click Refresh Data.

Budget vs Actual by Property

All Jobs — Cost by Property

City Comparison Table

Property Details

PM Handoff — Property Status

Click a property to open its walk-through checklist

Address City Project Status Approved Handoff Progress Pass Caution Fail Certified Last Updated

Purchase & Construction Data

Purchase Price
Purchase Date
Construction Completion
Rehab Costs
All-In Cost —

Rental Score Info

Total Score —
Lease-Up Speed —
PM Verified —
Score Breakdown —

Construction & Rehab

Construction Crew
Total Construction Cost
Rehab Summary

Proposed Rent & Revenue

Proposed Monthly Rent
ARV / Appraisal
Strategy —
Est. Monthly Cashflow —
Complete the walk-through checklist below to determine rental readiness
0
Pass
0
Caution
0
Not Listable
0
N/A

Generated To-Dos → Route to Carson / Trades

Data Management

Bulk Import Deals

Upload Excel → Firestore

Paste deal JSON or use the pre-loaded import to write multiple FLIP deals to Firestore at once.

Sync Status by Integration

● Live
Loading sync status...

Buildium Connection Diagnostics

Test API connectivity

Run diagnostics to verify Buildium API credentials, proxy connectivity, Firestore data, and sync status.

Add New Deal

CSV Import

Drag and drop CSV file here or click to select

Supports: deals_data.csv, rent_roll.csv

■ Home Depot Purchase History

Upload your Home Depot Pro Xtra purchase history CSV. Transactions will be auto-matched to properties by Job Name and shown in the Construction tab.

Drag & drop Home Depot CSV or click to browse

Accepts: Purchase_History_*.csv from Home Depot Pro account
Remove loaded CSV and start fresh

Export Data

Download portfolio data as CSV files for external analysis.

Google Sheets Sync

Sync portfolio data with Google Sheets for team collaboration.

Recompute Deal Metrics

Run all computed metrics (Net Cash, MOIC, DSCR, Cap Rate, Deal Calculator, etc.) against every deal in the database.

Deal Notifications (Email + Slack)

Get an email with a formatted PDF and a Slack message every time a new deal is entered.

Generate at myaccount.google.com/apppasswords
Create at api.slack.com/messaging/webhooks

Loan Email Recipients

Override who receives Bridge Loan and DSCR Loan emails. Leave blank to use the general recipients above.

Deal Editor

Add, edit, and manage all deals directly. Formulas auto-compute on save.

# Address City Type Status Strategy Purchase All-In Rent Monthly CF MOIC Cap Rate Actions

New Deal

Deal Type:
Buy, Rehab, Rent, Refinance — long-term hold strategy

Property Info

Acquisition & Costs

Flip Sale

Comparable Sales *

Enter 3 comparable properties to support your ARV estimate.

Refinance & Valuation

Income & Expenses

Rental Score

Rate each category. Total auto-computes on the right panel.

Notes

Live Computed Metrics

Hover any row to see the formula

Acquisition
Bridge Interest—
Formula
Purchase Price × (Bridge Rate / 100) × (Hold Months / 12)
Title / Closing Costs—
Formula
From input field (or Purchase Price × 3%)
Total Holding Costs—
Formula
Holding Costs/mo × Hold Months
All-In Cost—
Formula
Purchase + Rehab + Bridge Fees + Bridge Interest + Title Costs + Holding Costs
Sale
Selling Costs—
Formula
Sale Price × Selling Cost %
Net Sale Proceeds—
Formula
Sale Price − Selling Costs
Returns
Gross Profit—
Formula
Net Sale Proceeds − All-In Cost
Profit Margin—
Formula
Gross Profit / Sale Price × 100
ROI (Total Return)—
Formula
Gross Profit / All-In Cost × 100
APR (Annualized)—
Formula
ROI / (Hold Months / 12) Annualizes the total return over the hold period
MOIC—
Formula
Net Sale Proceeds / All-In Cost Multiple on Invested Capital
Forced Equity—
Formula
ARV − All-In Cost
Cash on Cash—
Formula
Gross Profit / Out-of-Pocket Cash OOP = All-In − Bridge Loan Amount (If no OOP → "Cash Efficient")
IRR—
Formula
Newton-Raphson IRR on monthly cashflows: Month 0: −All-In Cost Month N (hold): +Net Sale Proceeds Annualized internal rate of return
Rule of 70
ARV − Rehab − Closing—
Formula
ARV − Rehab Costs − Closing/Title Costs The basis for the 70% rule
PP as % of Basis—
Formula
Purchase Price / (ARV − Rehab − Closing) × 100 Must be ≤ 70% to pass
70% Threshold—
Formula
(ARV − Rehab − Closing) × 70% This is your max allowable purchase price
Max Purchase Price—
Formula
(ARV − Rehab − Closing) × 70% Highest PP that satisfies the Rule of 70
Rule of 70 Status—
Formula
PASS if PP ≤ 70% of (ARV − Rehab − Closing) FAIL if PP exceeds 70% threshold
Relevant Comps
No comps entered
Fund Returns
Fund ROI—
Formula
Gross Profit / Fund Investment × 100
Fund APR—
Formula
Fund ROI / (Hold Months / 12) Annualized return to fund investors
Acquisition
Bridge Interest (90d)—
Formula
Loan Amount × Bridge Rate × (90/365)
Title Costs (3%)—
Formula
Purchase Price × 3%
All-In Cost—
Formula
Purchase Price + Rehab + Bridge Fees + Bridge Interest (90d) + Title Costs
ARV Variance—
Formula
|Forecasted ARV - Appraisal| / Appraisal × 100%
Refinance
Cashout Refi—
Formula
Refi % × Appraisal
DSCR Closing Cost—
Formula
1% of Cashout Refi + $995 processing + $450 valuation + 3% of Cashout Refi (title)
Net Cash—
Formula
Cashout Refi - DSCR Closing Cost - All-In Cost
Forced Equity—
Formula
Appraisal × (1 - Refi%) + Net Cash
MOIC—
Formula
Cash from Refi / All-In Cost
Cash Flow
Maintenance (5%)—
Formula
Rent x Maintenance Rate (5%)
⚙ Editable in Formula Settings
CapEx (5%)—
Formula
Rent x CapEx Rate (5%)
⚙ Editable in Formula Settings
Monthly CF—
Formula
Rent - P&I - Insurance - Tax - Maintenance - CapEx
Annual CF—
Formula
Monthly Cashflow x 12
Annual NOI—
Formula
(Rent - Insurance - Tax - Maintenance - CapEx) x 12
Monthly Interest—
Formula
Cash from Refi x Interest Rate / 12
Returns
Cap Rate—
Formula
Annual Cashflow / Purchase Price
Market Cap Rate—
Formula
Annual NOI / Appraisal
DSCR (rent/PI)—
Formula
Rent / P&I
DSCR (NOI/debt)—
Formula
Annual NOI / (P&I x 12)
Yield on Cost—
Formula
Annual NOI / All-In Cost
Year 1 ROE—
Formula
Annual CF / Capital at Risk
Cash on Cash—
Formula
Avg 5-Year CF / Out-of-Pocket (If Net Cash ≥ 0 → "Cash Efficient")
5-Year Projection
Year 1 Net Cash—
Formula
Net Cash from Deal + Annual CF
Year 2 CF—
Formula
Annual CF + (Rent x 12 x Rent Growth 3%)
⚙ Growth rate editable in Formula Settings
Year 3 CF—
Formula
Annual CF + (Rent x 12 x 3% x 2)
Year 4 CF—
Formula
Annual CF + (Rent x 12 x 3% x 3)
Year 5 CF—
Formula
Annual CF + (Rent x 12 x 3% x 4)
Year 5 Refi—
Formula
Appraisal x Yr5 Refi Factor (18.25%)
⚙ Editable in Formula Settings
5Y Total CF—
Formula
Yr1 Net + Yr2 CF + Yr3 CF + Yr4 CF + Yr5 CF + Yr5 Refi
5-Year IRR—
Formula
Newton-Raphson IRR on cashflows: [-OOP, Yr1 CF, Yr2 CF, Yr3 CF, Yr4 CF, Yr5 CF + Yr5 Refi] (If Net Cash ≥ 0 → "Infinite")
Payback (years)—
Formula
Cumulative CF until ≥ Out-of-Pocket Interpolated within the payback year
Rental Score
Total Score—
Formula
Beds + BedSize + Neighborhood + AC + OpenPlan + Garage + Basement + Yard + Closets + Storage Max = 100
Grade—
Lease-Up Speed—
PM Verified—

⚙ Formula Settings

Adjust rates and constants used in all deal computations

Editable Constants

Used in: Maintenance = Rent x Rate
Used in: CapEx = Rent x Rate
Used in: Year 2-5 CF projections
Used in: Year 5 Refi = Appraisal x Factor
Used in: Bridge = 1% x (LTC% x (PP + Rehab)) + $995 + $450
Used in: Bridge origination = Fee% x Loan Amount
Fixed fee added to bridge loan cost
Fixed fee added to bridge loan cost

All Formulas

Acquisition
All-In = Purchase + Rehab + Bridge + DSCR Closing
ARV Var = |Forecasted ARV - Appraisal| / Appraisal
Bridge Loan Auto-Calc
Bridge = OrigFee% x (LTC% x (PP + Rehab)) + ProcFee + ValFee
Refinance
Refi Cash = Appraisal x Refi%
Net Cash = Refi Cash - All-In
Forced Eq = Appraisal x (1 - Refi%) + Net Cash
MOIC = Refi Cash / All-In
Cash Flow
Maint = Rent x MaintRate%
CapEx = Rent x CapExRate%
Mo CF = Rent - PI - Ins - Tax - Maint - CapEx
Ann CF = Monthly CF x 12
NOI = (Rent - Ins - Tax - Maint - CapEx) x 12
Mo Int = Refi Cash x IntRate / 12
Returns
Cap Rate = Annual CF / Purchase Price
Mkt Cap = NOI / Appraisal
DSCR = Rent / PI
DSCR2 = NOI / (PI x 12)
YoC = Annual NOI / All-In Cost
CoC = Avg 5yr CF / Out-of-Pocket
5-Year Projections
Yr N = Annual CF + (Rent x 12 x Growth% x (N-1))
Yr5 Refi = Appraisal x Yr5RefiFactor%
IRR = Newton-Raphson on [-OOP, Yr1..Yr5+Refi]
Payback = Cumulative CF until ≥ OOP (interpolated)

Property Details

Deal Information

Economics

Financing

Cash Flow Analysis

Returns & Performance

5-Year Projection

API Settings & Configuration

Google Sheets API

JobTread API

Buildium API

Note: If Buildium API calls fail due to CORS restrictions, you can use a CORS proxy or export CSV files from Buildium and upload them via the Data Management tab.

GoHighLevel API (Offer Now Michigan)

Note: Get your Private Integration API key from GoHighLevel Settings → Integrations → API. The Location ID is in the URL when viewing your sub-account.

Google Ads API (PPC Leads)

Note: Google Ads API requires OAuth2 credentials from Google Cloud Console, a developer token from the Google Ads API Center, and a refresh token generated via OAuth2 flow. The Customer ID is your 10-digit Google Ads account number (no dashes).

Deal Notifications (Email + Slack)

Configure email and Slack notifications for new deals. Credentials are stored securely in Firestore.

Generate at myaccount.google.com/apppasswords
Create at api.slack.com/messaging/webhooks

Loan Email Recipients (optional overrides)