43
Premium Real Estate Wholesaling Deal Calculator/ Analyst
UpworkUSNot specifiedexpert
Microsoft ExcelFinancial AnalysisData EntryGoogle SheetsGoogle Sheets AutomationExcel FormulaExcel MacrosFinancial ModelingReal Estate AcquisitionReal Estate Financial Modeling
I need a professional spreadsheet developer to create a comprehensive deal analyzer for my virtual real estate wholesaling business.
REQUIREMENTS:
TAB 1 - DEAL ANALYZER:
- Property info section (address, specs, property type dropdown)
- ARV calculator with 3 comp inputs, auto-calculated $/sqft averages
- Repair estimator with dropdown levels (Light/Medium/Heavy/Gut) linked to $/sqft rates
- MAO calculator using 70% rule: (ARV × 0.70) - Repairs
- My max offer calculator: MAO - Assignment Fee
- Auto "GO/NO GO" status based on seller price vs my max offer
- All formulas protected; input cells clearly marked
TAB 2 - PROFIT BREAKDOWN:
- Gross profit (assignment fee + EMD)
- Detailed cost categories: Marketing, Data/Tools, Virtual Team, Transaction costs
- Net profit auto-calculation
- $/hour rate calculator
TAB 3 - DEAL LOG:
- Table to track multiple deals (date, address, numbers, status, profit)
- Auto-calculated columns for spread %, days to close
TAB 4 - MONTHLY TRACKER:
- Budget vs actual tracking for marketing, tools, VAs
- Deal metrics (leads → offers → contracts → closed)
- Financial summary with cost-per-deal
TAB 5 - QUICK CALC:
- Mobile-friendly simple version for phone use
DESIGN REQUIREMENTS:
- Color-coded: Green=input cells, Yellow=calculated, Red=negative alerts
- Data validation dropdowns where specified
- Conditional formatting (green=GO deals, red=NO GO)
- Professional, clean layout
- Works in both Excel and Google Sheets
DELIVERABLES:
- Working spreadsheet with all formulas
- 30-minute walkthrough video explaining how to use it
- 1 round of revisions included
IDEAL FREELANCER:
- Real estate or financial modeling experience preferred
- Strong Excel/Google Sheets skills
- Attention to UI/UX and clean design
- Responsive communicator
Please include "WHOLESALE" in your proposal so I know you read this fully.
Unlock AI intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/moClient
Spent: $6,211.39Rating: 5.0Verified