What is the purpose of the formula in cell C2?
The formula in cell C2 calculates the principal amortization for the first period by subtracting the principal payment (cell C2) from the beginning of the period balance (cell B2).