← All projects

Data analysis · SQL

How much did renewals add?

Translate a small business cohort into contracted sales, teaching commitments and renewal metrics.

R$30,000first-package value
R$14,000–16,000modeled renewal value
46.7%–53.3%modeled renewal rate

Cohort and assumptions

EWF supplied 15 learners, 48 lessons per package, R$2,000 per learner and approximately half purchasing a second package. This case treats R$2,000 as the price of each package, including the second one. Seven and eight renewals bracket half of 15.

One operating year · 15 unique learners · one extra package per renewal
Renewed learnersRenewal ratePackagesContracted lessonsRenewal valueTotal value
746.7%221,056R$14,000R$44,000
853.3%231,104R$16,000R$46,000

What renewals contribute

At the modeled package price, renewals contribute 31.8%–34.8% of total contracted value and add 336–384 lessons to the initial 720. That places modeled annual contract value per learner at R$2,933–3,067, and the package price at R$41.67 per contracted lesson.

Use the same renewal denominator each year and distinguish learners from package purchases. For operational reporting, compare planned capacity with lessons delivered once attendance and scheduling data are available.