Skip to content
Finance Calc Kit
Business

Burndown Chart Calculator

Calculate agile sprint ideal vs actual burndown rate, remaining story points per day, projected completion day, and scope creep impact.

Sprint & velocity parameters

pts
Quick story point presets:
days
Standard sprint durations:
/ 10d
pts
pts

Projected completion day

Day 12.2

Projected to miss sprint deadline by 2.2 working days (16.0 pts remaining at Day 10).

Actual Velocity

7.2 pts/day

36 pts burned over 5 days (90% of ideal)

Required Burn Rate

10.4 pts/day

52.0 pts over 5 remaining days

Remaining Work

52.0 pts

36 completed of 88 total (8 added)

Behind ScheduleSchedule Variance: -12.0 pts behind

Current velocity (7.2 pts/day) lags required pace of 10.4 pts/day.

Team is projected to miss deadline by ~2.2 days (16 pts unburned). Swarm on blockers or re-negotiate non-critical tasks.

Sprint Burndown Trajectory

Ideal linear guideline vs actual historical and projected remaining story points.

Ideal LineActual / Projected
Sprint End52 pts88 pts44 pts0 ptsDay 0Day 5Day 10

Story point backlog allocation

Scope88 pts
  • Points Completed36.0 pts40.9%
  • Remaining Scope52.0 pts59.1%
  • Scope Creep Added+8.0 pts10.0%

Day-by-day sprint burn schedule

Daily ideal target vs actual recorded and projected remaining story points.

TimelineIdeal RemainingActual / ProjectedVarianceStatus
Start (Day 0)
80.0 pts88.0 pts-8.0 behindCompleted
Day 1
72.0 pts80.8 pts-8.8 behindCompleted
Day 2
64.0 pts73.6 pts-9.6 behindCompleted
Day 3
56.0 pts66.4 pts-10.4 behindCompleted
Day 4
48.0 pts59.2 pts-11.2 behindCompleted
Day 5Current
40.0 pts52.0 pts-12.0 behindIn Progress
Day 6
32.0 pts44.8 pts-12.8 behindProjected
Day 7
24.0 pts37.6 pts-13.6 behindProjected
Day 8
16.0 pts30.4 pts-14.4 behindProjected
Day 9
8.0 pts23.2 pts-15.2 behindProjected
Day 10
0.0 pts16.0 pts-16.0 behindProjected
Day 11Overdue
0.0 pts8.8 pts-8.8 behindExtended
Day 12Overdue
0.0 pts1.6 pts-1.6 behindExtended
Day 13Overdue
0.0 pts0.0 pts+0.0 aheadExtended
Day 14Overdue
0.0 pts0.0 pts+0.0 aheadExtended

Agile burndown formulas & mathematics

Formulas used to calculate ideal trajectory, empirical velocity, completion date, and schedule variance.

  1. Total Sprint Scope & Scope Creep

    Total Scope=Initial Points+Added Scope=80+8=88 pts\text{Total Scope} = \text{Initial Points} + \text{Added Scope} = 80 + 8 = 88 \text{ pts}

    Total sprint workload includes initial commitment plus mid-sprint backlog additions.

  2. Ideal Daily Burndown Rate

    Ideal Burn Rate=Initial ScopeSprint Days=8010=8.00 pts/day\text{Ideal Burn Rate} = \frac{\text{Initial Scope}}{\text{Sprint Days}} = \frac{80}{10} = 8.00 \text{ pts/day}

    Planned daily consumption rate to achieve a zero balance by the end of Day 10.

  3. Actual Daily Velocity (Burndown Speed)

    Actual Velocity=Completed PointsDays Elapsed=365=7.20 pts/day\text{Actual Velocity} = \frac{\text{Completed Points}}{\text{Days Elapsed}} = \frac{36}{5} = 7.20 \text{ pts/day}

    Average story points burned per day over the elapsed 5 working days.

  4. Required Daily Rate for Remaining Days

    Required Rate=Remaining PointsRemaining Days=52.05=10.40 pts/day\text{Required Rate} = \frac{\text{Remaining Points}}{\text{Remaining Days}} = \frac{52.0}{5} = 10.40 \text{ pts/day}

    Pace needed across the remaining 5 days to finish all 52.0 story points.

  5. Projected Completion Day & Variance

    Projected Finish=Elapsed+Remaining PointsActual Velocity=5+52.07.20=Day 12.2\text{Projected Finish} = \text{Elapsed} + \frac{\text{Remaining Points}}{\text{Actual Velocity}} = 5 + \frac{52.0}{7.20} = \text{Day } 12.2

    At current velocity (7.20 pts/day), total sprint completion is estimated at Day 12.2 (2.2 days overdue).

Report tool

Understanding Agile Burndown Charts, Sprint Velocity, and Project Delivery

A burndown chart is a foundational visual measurement tool used by Scrum teams, product owners, and engineering leaders to track the rate at which work is completed over the course of a timeboxed sprint or project release. By plotting remaining story points or task hours against time, teams gain immediate visibility into whether they are on track to meet their sprint commitments or need to adjust scope.

Sprint delivery speed directly influences development budgets and organizational capital allocation. To analyze your engineering team operating burn, evaluate cash consumption with our burn rate calculator, calculate team billing rates with the bill rate calculator, track engineer time utilization via the billable hours calculator, and assess architectural trade-offs with the build or buy calculator.

Key Components of an Agile Burndown Chart

An effective sprint burndown chart relies on several fundamental metrics:

1. Total Committed Scope (Story Points)

The total amount of work agreed upon during sprint planning, quantified in story points or ideal engineering hours. This establishes the vertical intercept on Day 0 of the sprint.

2. Ideal Burndown Line (The Guideline)

A straight reference line connecting the initial committed story points on Day 0 to zero points on the final working day of the sprint. It represents the hypothetical linear completion rate required to finish all work perfectly on time.

3. Actual Burndown Line (Empirical Progress)

The real-time trajectory of remaining story points recorded at the end of each working day. Fluctuation above the ideal line indicates the team is behind schedule, while points below the ideal line signify the team is ahead of schedule.

4. Scope Creep and Backlog Additions

Any new user stories, bug tickets, or technical tasks injected into the sprint after kickoff. Scope additions increase the remaining points balance, causing upward spikes on the burndown chart.

Mathematical Formulas for Sprint Burndown Analysis

Scrum teams apply core mathematical formulas to compute velocity, projected finish dates, and schedule variances:

1. Ideal Daily Burndown Rate

The target number of story points the team must complete each working day:

Ideal Daily Burn Rate=Initial Committed Story PointsTotal Working Days in Sprint\text{Ideal Daily Burn Rate} = \frac{\text{Initial Committed Story Points}}{\text{Total Working Days in Sprint}}

2. Actual Daily Velocity

The empirical burn rate achieved by the engineering team over elapsed sprint days:

Actual Daily Velocity=Story Points CompletedWorking Days Elapsed\text{Actual Daily Velocity} = \frac{\text{Story Points Completed}}{\text{Working Days Elapsed}}

3. Required Daily Burn Rate for Remaining Days

The pace needed over remaining days to finish all outstanding story points:

Required Daily Burn Rate=Total ScopeCompleted PointsTotal Sprint DaysDays Elapsed\text{Required Daily Burn Rate} = \frac{\text{Total Scope} - \text{Completed Points}}{\text{Total Sprint Days} - \text{Days Elapsed}}

4. Projected Sprint Completion Day

Estimating the actual day the backlog will reach zero based on current empirical velocity:

Projected Completion Day=Days Elapsed+Remaining Story PointsActual Daily Velocity\text{Projected Completion Day} = \text{Days Elapsed} + \frac{\text{Remaining Story Points}}{\text{Actual Daily Velocity}}

5. Schedule Variance

Measuring deviation between the planned ideal remaining balance and actual remaining points:

Schedule Variance=Ideal Remaining PointsActual Remaining Points\text{Schedule Variance} = \text{Ideal Remaining Points} - \text{Actual Remaining Points}

A positive variance indicates the team is ahead of schedule, whereas a negative variance indicates an unburned point deficit.

Common Burndown Chart Patterns and How to Interpret Them

The shape of an actual burndown line reveals important team dynamics, estimation accuracy, and process bottlenecks:

The Mid-Sprint Plateau (Flatline)

Points remain unchanged for multiple consecutive days. This occurs when user stories are too large, tasks are blocked by external dependencies, or work is held up in code review or quality assurance testing.

The Upward Spike (Scope Ingestion)

The line jumps upward mid-sprint. This signals scope creep where new requirements or emergent bugs were pulled into an active sprint without removing lower-priority items.

The End-of-Sprint Cliff (Water-Scrum-Fall)

The chart stays high until the penultimate day, then plummets to zero on Day 10. This indicates stories are only marked complete when the entire batch is deployed, rather than delivering vertical slices continuously.

The Steady Staircase (Ideal Agile Flow)

The line descends in regular small increments every 1 to 2 days, hugging the ideal guideline. This demonstrates small story slicing, fast QA verification, and consistent daily throughput.

Comprehensive Worked Example

Consider a cross-functional software development team executing a 2-week (10 working days) sprint:

  • Initial Sprint Commitment: 80 story points across 10 working days.
  • Mid-Sprint Progress (Day 5): 36 story points completed by end of Day 5.
  • Scope Injected: 8 story points added on Day 3 due to an urgent client API requirement.

Step-by-Step Sprint Delivery Calculations

1. Total Scope: 80 (Initial) + 8 (Added) = 88 total story points.

2. Remaining Points on Day 5: 88 - 36 = 52 story points remaining.

3. Ideal Daily Burn Rate: 80 / 10 = 8.0 points per day.

4. Actual Daily Velocity: 36 completed / 5 days = 7.2 points per day.

5. Required Rate for Remaining 5 Days: 52 remaining points / 5 days = 10.4 points per day.

6. Projected Total Completion Day: 5 + (52 / 7.2) = Day 12.2 (2.2 working days overdue).

7. Strategic Takeaway: At the current pace of 7.2 points/day, the team will only complete 36 more points by Day 10, leaving 16 points unburned. During the Day 5 standup, the Scrum Master and Product Owner should de-scope at least 12 to 16 points of non-critical backlog items to ensure all core sprint goals are met on time.

Best Practices for Managing Sprint Burndown in Daily Standups

To maximize sprint success, engineering teams should incorporate burndown chart insights into their daily ceremonies:

1. Update Task States Immediately

Ensure engineers transition Jira or GitHub issues to Done as soon as code passes review and automated tests merge. Outdated ticket statuses distort burndown metrics and mask delivery risks.

2. Slice Stories Vertically

Break large 8-point and 13-point epics into small 2-point or 3-point vertical slices that can be delivered within 24 to 48 hours. Smaller tickets produce a smoother burndown slope and faster feedback loops.

3. Enforce a Trade-Off Rule for Scope Changes

If stakeholders insist on adding a new 5-point feature mid-sprint, the team must remove 5 points of equal or lower priority items to maintain a sustainable burndown trajectory.

Frequently asked questions

What is the difference between a sprint burndown chart and a burnup chart?
A sprint burndown chart displays remaining work decreasing over time toward zero, making it ideal for tracking daily team progress within a single sprint. A burnup chart displays total completed work accumulating upward toward a total scope line, making it better suited for tracking long-term release milestones where total scope expands over time.
Should sprint burndown charts track story points or hours?
Most modern Agile teams track story points because points represent relative complexity and value rather than time estimations. However, teams that break user stories into granular subtasks often track remaining hours during the first few days of a sprint to monitor day-to-day tactical execution.
What should a team do if the burndown line is consistently above the ideal line?
When the actual line remains above the ideal guideline for 3 or more consecutive days, the team should swarm on in-progress blockers, limit work in progress (WIP), and consult the Product Owner to de-scope lower-priority stories before the sprint concludes.
Does a flat burndown chart mean the team is not working?
Not necessarily. A flatline usually occurs when user stories are too large and remain in progress for days without reaching the Definition of Done. It can also occur when tasks are stuck waiting for QA verification, third-party API keys, or design reviews.
How do weekends and non-working days factor into burndown calculations?
Standard sprint burndown charts only count active working days (typically Monday through Friday). Non-working weekend days and public holidays are excluded from the horizontal axis so the ideal burn rate accurately reflects working hours.

Resources and references

The formulas and methods in this calculator were checked against these independent sources.