Calculate the cash used to retire debt for each of the six months.

Since the company can't use more cash than is available to retire the debt, Cash Used to Retire Debt cannot exceed the Cash Available to Retire Debt.

Likewise, the company can't use more money to retire debt than it has debt from the prior month to retire.

Cash Used to Retire Debt will be equal to the Cash Available to Retire Debt if the cash available is less than the loan balance from the prior month.

Otherwise, the Cash Used to Retire Debt will be the loan total from the prior month.

Reuse your function to complete the Cash Used to Retire Debt for each month.Excel File Edit View Insert Format Tools Data Window Help