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]
1 answer:
Answer:
The required cash used to retire a debt can be computed as follows:
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.
You might be interested in