Solving for Principal Balance (X). when we know the principal and interest payment, term and rate

Hi Matt_6360 

By using the CUMPRINC() function, you can calculate the Unpaid Principal Balance after an installment is paid. A sample file is also attached for more clarity and understanding. Simple input the number of installments paid in cell C8.

Please let me know if it works for you.

Thanks

Tauqeer