Exercise $20\mathrm{.}17($Algo$)$ Preparation of cash budgets $($for three periods$)$ LO P$2$

Kayak Company budgeted the following cash recelpts $($excluding cash receipts from loans recelved$)$ and cash payments $($excluding cash payments for loan principal and interest payments$)$ for the first three months of next year.

$\backslash$table$[[,$cash,Receipts cas payments$],[$January$,$$$528,000,465,700],[$February$,469,800,358,200],[$Narch$,454,000,527,000]]$

Kayak requlres a minimum cash balance of $$30,000$ at each month$-$end. Loans taken to meet this requirement charge $18,$ interest per month, paid at each month$-$end. The interest is computed based on the beginning balance of the loan for the month. Ary preliminary cash balance above $$30,000$ is used to repay loans at month$-$end. The company has a cash balance of $$30,000$ and a loan balance of $$60,000$ at January $1.$

Prepare monthly cash budgets for January. February, and March. $($Negative balances and Loan repayment amounts $($if amy$)$ should be indlcated with minus sign.$)$

$\backslash$table$[[,$KAYAK COMPANY,,$],[$Cssh Budget$],[,,$Jahtuary,February,March$],[$Beginning cash balance,,$$,30,000,,,],[,,,,,,],[$Towal cash availible$],[-,,,,,,],[$rand$],[,,,,,,],[\{$

$\backslash$table$[[$Towal cash payments$],[$Prelimirisy eash bsilance$]]\}],[],[$Lasan sctivity$],[\{\begin{array}{c}\text{:}\end{array},$E$,,,,",],[$Ending cash balance$],[$Losn balance$],[$Lasn balance $-$ Beginning of month,,$5,60,000,,5,0],[$Addilionsl lasen $($bodn repayimen$),,,,,,],[$Laan bellanse, end ol moneh,,,,,,$]]$