How it works
Each year's deposit is added to the running balance, and interest is credited on the whole balance at the close of the year. Because the deposit is assumed to arrive at the start of the year, it earns for all twelve months — which is exactly what published PPF maturity tables assume, and why the figures here agree with them.
The schedule shows every year separately, so you can see the point at which annual interest exceeds the annual deposit. At the maximum deposit and the current rate that happens around year eleven, and from then on the account grows more from interest than from you.
More detail
The rate is an input rather than a constant. The government resets it every quarter and it has moved considerably over any fifteen-year stretch, so a projection that treats today's rate as permanent is the optimistic case rather than the expected one.
Nothing about tax is modelled, because there is nothing to model: deposits qualify for deduction, interest accrues untaxed and the maturity amount is exempt.
For a girl child, the same structure at a higher rate is the Sukanya Samriddhi calculator.
To compare against a taxable deposit, use the fixed deposit calculator.
For the market-linked alternative, see the SIP calculator.