Question

Calculate the cash available to retire debt for each of the six months. There is cash available to retire debt if there is a cash surplus at the end of a month (shortfall/surplus cash > 0). Therefore cash available to retire debt is equal to any cash surplus at the end of a month. If there is not a surplus, cash available to retire debt is 0

Answer 1

Answer:

$16,240

Explanation:

The required cash available to retire a debt can be computed as follows:

Cash available to retire a debt = 0 if there is no surplus at the end of the month

Cash available to retire a debt = surplus if there is a surplus at the end of the month

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

D32 = IF(D28>0,D28,0)

The formula is used to get the values for E32 to I32.