Amortization is usually calculated with the formula
And if graphed in excel
So my question is how would it be to solve for the payment of the 10th payment or year if in the presented sheet, the eighth and ninth monthly payment would be skipped and the payment for the tenth year would still be able to pay off the loan.
How do you solve for the exact value of the payment in the tenth year?Will there be a change in formula?how ?
I do not quite follow your notation, but if $A$ is your calculated periodic payment amount and you miss two payments, then the catch-up payment should be not $3A$ but perhaps $$A(1+i)^2+ A(1+i)+A= (3+3i+i^2)A$$ where $i$ is the effective interest rate per period.