Instructions:

Show the Excel formulas, not the mathematical formula

Example $1$ Example $2$ Example $3$ Example $4$

Beginning cash balance $$10,000?????$ $$30,000?????$

Collections $$20,000$ $$50,000????$ $$3,000$

Cash Available $????$ $$75,000$ $$35,000$ $$7,000$

Less Payments $$5,000$ $$12,000??????????$

Ending cash balance $????????$ $$1,000$ $$2,000$

write your Excel formula here. Do not place the formula in the text box or cell or Excel will automatically calculate the answer

Write your Excel formula here

Answer to cell F$12$

Answer to cell F$14$

Answer to cell I$10$

Answer to cell I$14$

Answer to cell L$11$

Answer to cell L$13$

Answer to cell O$10$

Answer to cell O$13$