PLEASE HELP ME COMPLETE THIS QUESTION WITH THE FORMULA INCLUDED ASAP

A$.$ A

B

C

G

$H$

$1$

J

K

L

M

Cash Flow Budget Worksheet

Monthly Interest Rate

$1\mathrm{.}5\%$

Line of Credit Needed

$2\mathrm{.}8$ Calculate the loan balance for each of the six months.

a$.$ The loan balance is equal to Additional Cash Needed minus any Cash Used to Retire Debt for that month plus the loan balance carried from the prior month.

b$.$ Reuse your formula to complete the loan balance for each month.

$3$

$2\mathrm{.}9$ Calculate the ending cash balance for each month.

a$.$ The ending cash balance is

$\backslash$table$[[19,$Inventory Purchases,,$$46,000\mathrm{.}00,$$$53,000\mathrm{.}00,,$$$500000,H,1,$k$,$L$,$M$,$