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]

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.

assuming you are in the home page.

1) go to the upper right hand corner

2) click on your "profile picture"

3) go down to "edit profile"

4) it should be titled as "edit your profile", click on "profile picture"

5) choose a file

6) press "change"

you're profile picture is updated

~