amie

Private finance tool

Enter the shared team password.

The calculator and its workbook assumptions stay encrypted until the correct password is entered.

LTV : CAC · 12-month cohort planner

Know what today’s acquisition plan earns—and when.

Edit the blue assumptions to model future cohorts, monthly contribution profit, cash requirements, and customer payback. The workbook baseline stays visible for comparison.

Scenario

Decision model, not booked revenue. “Net profit” here means gross profit less paid acquisition and the fixed monthly overhead entered below. It excludes taxes, working-capital timing, and costs not captured in gross margin.

Media buying guardrails

CPA that fully pays back by Day 30, 60, and 90

Maximum blended acquisition cost supported by cumulative contribution through each day. These targets move with every model input.

Current blended NCAC —

30-day payback CPA — Compared with current NCAC

60-day payback CPA — Compared with current NCAC

90-day payback CPA — Compared with current NCAC

12-month net profit

— Working scenario

12-month net margin

— After media + fixed costs

Contribution LTV : CAC

— 12-month contribution LTV

Customer payback

— Cumulative gross profit

Peak contribution cash need

— Maximum cumulative deficit

Model inputs

Change the blue cells

Acquisition & overhead

Monthly ad spend $ Blended NCAC $ Fixed overhead / month $

New customers / month—

First-order ROAS—

First-order refunds / month—

Customer economicsWorkbook blue cells

First buyers taking subscription %

First buyers one-time —

Subscriber first-order AOV $ Repeat-subscriber AOV $ One-time first-order AOV $ One-time repeat AOV $ First-order gross margin % First-order refund rate % Money-back guarantee refunds in M0. Revenue is reversed; product COGS remains incurred. Later refunds stay in the cohort curves. Repeat-order gross margin %

Repeat-order curvesWithin M1 through M12

These are monthly order rates against each original acquisition cohort—not a survival curve. “Within M1” occurs in the acquisition month.

Within M1 % %

M2 % %

M3 % %

M4 % %

M5 % %

M6 % %

M7 % %

M8 % %

M9 % %

M10 % %

M11 % %

M12 % %

Baseline source Daily Revenue - Amie - 2026.xlsx LTV to Cac tab · audited Aug 24, 2026 Live operating inputs updated Aug 24, 2026; repeat-order curves remain cohort assumptions.

Profit & cash path

How the next 12 months build

Monthly net profit bars with cumulative profit versus the workbook baseline.

Monthly profit Cumulative Baseline

Hover or tap any month for revenue, monthly profit, cumulative profit, and baseline values.

12-month revenue—

Paid acquisition—

First-order refunds—

Maximum CAC at 15% margin—

Customer payback

When contribution clears CAC

First-order contribution lands on day 0—including the $2 telehealth saving when monthly acquisition exceeds 7,500 customers. Repeat contribution is spread across 30-day months.

Decision checks

What the plan implies

Cash and efficiency signals from the live assumptions.

Checking

90-day contribution — Per customer after CAC through day 90

Month 1 net profit — First calendar month after media and fixed costs

CAC headroom @ 15% — Maximum CAC at a 15% net margin less current CAC

Profit vs baseline — Change in 12-month projected net profit

Monthly operating view

Revenue, media, profit, and cash

Each column includes every acquisition cohort active in that calendar month. Gross profit includes the telehealth savings shown when active.

USD · contribution basis

Month	Ad spend	New customers	Cumulative customers	Net revenue	First-order refunds	Telehealth savings	Gross profit	Fixed overhead	Net profit	Cumulative profit

Cohort calendar

Where future profit arrives

Rows are acquisition cohorts; columns are future calendar months.

Cell metric

Acquisition-month cells include initial orders net of first-order refunds, within-month repeats, that cohort’s CAC, and telehealth bulk savings when the monthly volume rule is active. Rate views show repeat-order rates—not account survival. Blank cells have not occurred within the 12-month window.