Calculate the cash used to retire debt for each of the six months. Since the company can't pay down more debt than there is cash available to retire the debt, the cash used to retire debt cannot exceed the cash available to retire debt. Likewise, the company won't pay more money to retire debt than it has debt from the prior month to retire. Therefore, the cash used to retire debt will be equal to the cash available to retire debt if that total 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. [3 points]

Cash used to retire debt = cash available to retire a debt, if the cash available to retire debt is less than the loan balance from previous month. Otherwise, cash used to retire debt is equal to the loan balance from previous month.

The excel formula to perform this task is provided as follows:

D33 = IF(D32<C34,D32,C34)

The same formula is used to get the values for E33 to I33.

Explanation:

See the attached picture for table.

topeadeniran2 topeadeniran2 · Answer 2 · 2022-02-01T14:36:16+01:00

Based on the information given, the total cash inflows will simply be the sum of cash sales and the customer payments for a particular month.

How to calculate the cash in Excel

From the complete information, the total cash inflows will be:

= customer payments + cash sales

The excel formula to perform this task is provided as follows:

D13 = SUM(D11:D12)

It should also be noted that the same formula is used to get the values for E13 to I13.

Learn more about cash sales on:

https://brainly.com/question/14279491