Desirae Duncan
Financial Analyst
Financial analyst who uses data to evaluate performance, forecast outcomes, improve profitability, and guide strategic decisions.
| Interactive Assumption | Input | Monthly Cost |
|---|---|---|
| Employees | $24,000 | |
| Hourly Wage | Used in payroll | |
| Hours per Employee / Month | Used in payroll | |
| Rent / Office | $3,500 | |
| Utilities | $800 | |
| Insurance | $2,500 | |
| Work Vehicles | $4,000 | |
| Gas / Fuel | $1,800 | |
| Technology / Phones | $1,600 | |
| Equipment / Uniforms / Supplies | $1,900 | |
| Total Monthly Operating Budget | $42,600 |
| State | COL Index | Wage | Employees | Payroll | Events | Other | Total Cost | Membership | Break-Even Members | Target Members | Revenue | Profit | Margin | Decision |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Georgia Atlanta | 0.92 | $24.00 | 4 | $7,680 | $3,500 | $4,000 | $15,180 | $99 | 154 | 200 | $19,800 | $4,620 | 23.3% | Launch First |
| Texas Dallas | 0.96 | $25.00 | 4 | $8,000 | $3,800 | $4,500 | $16,300 | $99 | 165 | 220 | $21,780 | $5,480 | 25.2% | Launch First |
| Florida Orlando | 1.01 | $26.00 | 4 | $8,320 | $4,200 | $4,800 | $17,320 | $109 | 159 | 210 | $22,890 | $5,570 | 24.3% | Phase 2 |
| Illinois Chicago |
1.05 | $27.00 | 4 | $8,640 | $4,500 | $5,100 | $18,240 | $109 | 168 | 215 | $23,435 | $5,195 | 22.2% | Phase 2 |
| California Los Angeles | 1.28 | $32.00 | 5 | $12,800 | $6,500 | $7,000 | $26,300 | $129 | 204 | 230 | $29,670 | $3,370 | 11.4% | Validate First |
| New York New York City | 1.35 | $34.00 | 5 | $13,600 | $7,000 | $7,500 | $28,100 | $139 | 203 | 230 | $31,970 | $3,870 | 12.1% | Validate First |
| Budget / Driver | Mock Amount | Formula / Analyst Logic |
|---|---|---|
| Cost-of-Living Index | 0.92 | Location adjustment used to differentiate wages and operating assumptions |
| Employees Required | 4 | Core staffing assumption for membership operations + events |
| Hourly Wage | $24.00 | Mock local wage assumption informed by relative cost of living |
| Monthly Payroll | $7,680 | Employees × hourly wage × 80 hours/month |
| Event Staffing | 5 people/event | Event lead + check-in/member support + operations coverage |
| Monthly Event Budget | $3,500 | Venue + event labor + supplies + local promotion |
| Marketing / Tech / Admin / Travel | $4,000 | Recurring state-level support budget |
| Total Monthly State Cost | $15,180 | Payroll + Event Budget + Other Operating Costs |
| Membership Price | $99/month | Mock market-specific membership pricing |
| Break-Even Memberships | 154 | Total Monthly State Cost ÷ Membership Price |
| Target Memberships | 200 | Operating target above break-even |
| Target Membership Revenue | $19,800 | Target Members × Membership Price |
| Projected Monthly Profit | $4,620 | Target Membership Revenue − Total Monthly State Cost |
| Projected Margin | 23.3% | Projected Profit ÷ Revenue |
| Budget / Driver | Mock Amount | Formula / Analyst Logic |
|---|---|---|
| Cost-of-Living Index | 0.96 | Location adjustment used to differentiate wages and operating assumptions |
| Employees Required | 4 | Core staffing assumption for membership operations + events |
| Hourly Wage | $25.00 | Mock local wage assumption informed by relative cost of living |
| Monthly Payroll | $8,000 | Employees × hourly wage × 80 hours/month |
| Event Staffing | 5 people/event | Event lead + check-in/member support + operations coverage |
| Monthly Event Budget | $3,800 | Venue + event labor + supplies + local promotion |
| Marketing / Tech / Admin / Travel | $4,500 | Recurring state-level support budget |
| Total Monthly State Cost | $16,300 | Payroll + Event Budget + Other Operating Costs |
| Membership Price | $99/month | Mock market-specific membership pricing |
| Break-Even Memberships | 165 | Total Monthly State Cost ÷ Membership Price |
| Target Memberships | 220 | Operating target above break-even |
| Target Membership Revenue | $21,780 | Target Members × Membership Price |
| Projected Monthly Profit | $5,480 | Target Membership Revenue − Total Monthly State Cost |
| Projected Margin | 25.2% | Projected Profit ÷ Revenue |
| Budget / Driver | Mock Amount | Formula / Analyst Logic |
|---|---|---|
| Cost-of-Living Index | 1.01 | Location adjustment used to differentiate wages and operating assumptions |
| Employees Required | 4 | Core staffing assumption for membership operations + events |
| Hourly Wage | $26.00 | Mock local wage assumption informed by relative cost of living |
| Monthly Payroll | $8,320 | Employees × hourly wage × 80 hours/month |
| Event Staffing | 5 people/event | Event lead + check-in/member support + operations coverage |
| Monthly Event Budget | $4,200 | Venue + event labor + supplies + local promotion |
| Marketing / Tech / Admin / Travel | $4,800 | Recurring state-level support budget |
| Total Monthly State Cost | $17,320 | Payroll + Event Budget + Other Operating Costs |
| Membership Price | $109/month | Mock market-specific membership pricing |
| Break-Even Memberships | 159 | Total Monthly State Cost ÷ Membership Price |
| Target Memberships | 210 | Operating target above break-even |
| Target Membership Revenue | $22,890 | Target Members × Membership Price |
| Projected Monthly Profit | $5,570 | Target Membership Revenue − Total Monthly State Cost |
| Projected Margin | 24.3% | Projected Profit ÷ Revenue |
| Budget / Driver | Mock Amount | Formula / Analyst Logic |
|---|---|---|
| Cost-of-Living Index | 1.05 | Location adjustment used to differentiate wages and operating assumptions |
| Employees Required | 4 | Core staffing assumption for membership operations + events |
| Hourly Wage | $27.00 | Mock local wage assumption informed by relative cost of living |
| Monthly Payroll | $8,640 | 4 employees × $27 × 80 hours/month |
| Event Staffing | 5 people/event | Event lead + check-in/member support + operations coverage |
| Monthly Event Budget | $4,500 | Venue + event labor + supplies + local promotion |
| Marketing / Tech / Admin / Travel | $5,100 | Recurring state-level support budget |
| Total Monthly State Cost | $18,240 | $8,640 + $4,500 + $5,100 |
| Membership Price | $109/month | Mock market-specific membership pricing |
| Break-Even Memberships | 168 | $18,240 ÷ $109 = 167.34 → 168 members |
| Target Memberships | 215 | Operating target above break-even |
| Target Membership Revenue | $23,435 | 215 × $109 |
| Projected Monthly Profit | $5,195 | $23,435 − $18,240 |
| Projected Margin | 22.2% | $5,195 ÷ $23,435 |
| Budget / Driver | Mock Amount | Formula / Analyst Logic |
|---|---|---|
| Cost-of-Living Index | 1.28 | Location adjustment used to differentiate wages and operating assumptions |
| Employees Required | 5 | Core staffing assumption for membership operations + events |
| Hourly Wage | $32.00 | Mock local wage assumption informed by relative cost of living |
| Monthly Payroll | $12,800 | Employees × hourly wage × 80 hours/month |
| Event Staffing | 6 people/event | Event lead + check-in/member support + operations coverage |
| Monthly Event Budget | $6,500 | Venue + event labor + supplies + local promotion |
| Marketing / Tech / Admin / Travel | $7,000 | Recurring state-level support budget |
| Total Monthly State Cost | $26,300 | Payroll + Event Budget + Other Operating Costs |
| Membership Price | $129/month | Mock market-specific membership pricing |
| Break-Even Memberships | 204 | Total Monthly State Cost ÷ Membership Price |
| Target Memberships | 230 | Operating target above break-even |
| Target Membership Revenue | $29,670 | Target Members × Membership Price |
| Projected Monthly Profit | $3,370 | Target Membership Revenue − Total Monthly State Cost |
| Projected Margin | 11.4% | Projected Profit ÷ Revenue |
| Budget / Driver | Mock Amount | Formula / Analyst Logic |
|---|---|---|
| Cost-of-Living Index | 1.35 | Location adjustment used to differentiate wages and operating assumptions |
| Employees Required | 5 | Core staffing assumption for membership operations + events |
| Hourly Wage | $34.00 | Mock local wage assumption informed by relative cost of living |
| Monthly Payroll | $13,600 | Employees × hourly wage × 80 hours/month |
| Event Staffing | 6 people/event | Event lead + check-in/member support + operations coverage |
| Monthly Event Budget | $7,000 | Venue + event labor + supplies + local promotion |
| Marketing / Tech / Admin / Travel | $7,500 | Recurring state-level support budget |
| Total Monthly State Cost | $28,100 | Payroll + Event Budget + Other Operating Costs |
| Membership Price | $139/month | Mock market-specific membership pricing |
| Break-Even Memberships | 203 | Total Monthly State Cost ÷ Membership Price |
| Target Memberships | 230 | Operating target above break-even |
| Target Membership Revenue | $31,970 | Target Members × Membership Price |
| Projected Monthly Profit | $3,870 | Target Membership Revenue − Total Monthly State Cost |
| Projected Margin | 12.1% | Projected Profit ÷ Revenue |
| Rank | State | Profitability | Break-Even | Cost Position | Expansion Score | Recommendation |
|---|---|---|---|---|---|---|
| 1 | Texas | 25.2% | 165 members | Low–Moderate | 91/100 | Priority Launch |
| 2 | Georgia | 23.3% | 154 members | Low | 90/100 | Priority Launch |
| 3 | Florida | 24.3% | 159 members | Moderate | 85/100 | Phase 2 |
| 4 | Illinois | 22.2% | 168 members | Moderate | 80/100 | Phase 2 |
| 5 | New York | 12.1% | 203 members | High | 63/100 | Validate Demand |
| 6 | California | 11.4% | 204 members | High | 61/100 | Validate Demand |
| Input Used for Every State | How the Model Uses It |
|---|---|
| Cost of Living / Local Wage | Adjusts payroll and operating assumptions by market. |
| Employees & Event Staffing | Determines workforce requirements and labor cost per market. |
| Event Cost | Models venue, event labor, supplies, and local promotion. |
| Membership Price | Reflects the mock pricing assumption for that market. |
| Break-Even Memberships | Total Monthly State Cost ÷ Monthly Membership Price. |
| Target Memberships | Sets a demand target above break-even for profitability testing. |
| Profitability | Revenue − operating costs; then Profit ÷ Revenue for margin. |
| Phase | Markets | Financial Reason |
|---|---|---|
| Phase 1 | Georgia + Texas | Lowest modeled break-even requirements with the strongest projected margins. |
| Phase 2 | Florida + Illinois | Moderate operating costs and attractive modeled profitability after Phase 1 validates membership demand. |
| Phase 3 / Validation | California + New York | Higher wages and event/operating costs require stronger membership density before launch. |
| Driver | Mock Assumption | Financial Use |
|---|---|---|
| Active Properties / Units | 12 | Revenue-producing portfolio |
| Average Monthly Revenue / Unit | $4,500 | Rental / operating revenue driver |
| Average Occupancy | 92% | Revenue realization assumption |
| Monthly Potential Revenue | $54,000 | 12 × $4,500 |
| Effective Monthly Revenue | $49,680 | $54,000 × 92% |
| Category | Budget | % Revenue |
|---|---|---|
| Effective Revenue | $49,680 | 100.0% |
| Property Management / Labor | $6,500 | 13.1% |
| Repairs & Maintenance | $4,000 | 8.1% |
| Taxes & Insurance | $5,200 | 10.5% |
| Utilities / HOA / Services | $3,800 | 7.6% |
| Marketing / Leasing | $1,500 | 3.0% |
| Administrative / Other | $2,000 | 4.0% |
| Total Operating Expenses | $23,000 | 46.3% |
| Net Operating Income (NOI) | $26,680 | 53.7% |
| Metric | Budget | Actual | $ Variance | % Variance | Status |
|---|---|---|---|---|---|
| Revenue | $48,000 | $49,680 | +$1,680 | +3.5% | Favorable |
| Repairs & Maintenance | $3,500 | $4,000 | +$500 | +14.3% | Unfavorable |
| Total Operating Expense | $22,000 | $23,000 | +$1,000 | +4.5% | Unfavorable |
| NOI | $26,000 | $26,680 | +$680 | +2.6% | Favorable |
| Account | Ledger | Supporting Detail | Difference | Action |
|---|---|---|---|---|
| Rental Receipts | $49,680 | $49,680 | $0 | Reconciled |
| Maintenance Expense | $4,000 | $3,750 | $250 | Investigate invoice timing |
| Utilities | $3,800 | $3,800 | $0 | Reconciled |
| Net Unreconciled Difference | $250 | Follow-up required |
| Scenario | Occupancy | Revenue | NOI | Implied Value @ 7% |
|---|---|---|---|---|
| Downside | 85% | $45,900 | $22,900 | $3,925,714 |
| Base Case | 92% | $49,680 | $26,680 | $4,573,714 |
| Upside | 97% | $52,380 | $29,380 | $5,036,571 |
| Metric | Monthly | Annual | Formula |
|---|---|---|---|
| Effective Revenue | $49,680 | $596,160 | Monthly × 12 |
| Operating Expenses | $23,000 | $276,000 | Monthly × 12 |
| NOI | $26,680 | $320,160 | Revenue − Operating Expenses |
| Property | Closing Date | Revenue Made |
|---|
| Project | Completion Date | Revenue Made |
|---|
| Event | Attendees | Total Cost | Cost / Attendee | Actions |
|---|
Enter event expenses to begin the cost analysis.
| Event Expenses | $0.00 |
| Desired Profit | $0.00 |
| Revenue Goal | $0.00 |
| Break-Even Tickets | 0 |
| Tickets Needed | 0 |
| Ticket Price | Tickets Needed |
|---|