Calculate the cash available to retire debt for each of the six months. There is cash available to retire debt if there is a cas

Question

2 years ago

8

Calculate the cash available to retire debt for each of the six months. There is cash available to retire debt if there is a cas

h 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

Computers and Technology

1 answer:

Nana76 [90] · Answer 1 · 2022-04-19T20:35:13+03:00

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.