Previews data:

1. Monthly sales are 20% in cash and 80% on credit.Credit sales from the previous month are charged in full in the following month (therefore, what is in accounts receivable at the end of March is 80% of March sales).
2. The gross profit margin generated by the corporation on its sales is28%.
3. The ending inventory for each month is equal to 25% of the budgeted cost of sales for thenext month.
4. 40% of monthly merchandise purchases are paid in the month of purchase and the remainder in the month following the purchase.
5. The expected monthly expenses are salaries, $9,100;advertising, $4,350per month and remaining expenses (except depreciation) represent9% of sales.It assumes that these expenses are paid every month (nothing is owed at the end of the month).
6. The depreciation expense is $10,000 for the quarter and includes the portion that corresponds to the assets acquired during the period.
7. Cash equipment was acquired: $2,100in April and $12,700in May 20xx.
8. Management wishes to maintain a minimum cash balance at the end of each month of $ 8,000.
9. When the business is in need of money, it can borrow from a local bank in increments of $ 1,000 at the beginning of each month up to a loan ceiling of $ 20,000.The interest rate that the bank charges on these loans is 1% per month and the interest is paid next month (we assume that it is not compound interest and that each loan is made at the end of the month).The company paid dividends $ 2700 June.

Data obtained previously:

Using the data and information from the JKL Corporation, and the results you obtained + + a model: Initial cash balance Cash collections Cash available ess outlays: Shopping Administrative and sales Purchase of equipment Dividends Total disbursements Cash excess (deficiency) Financing: Loan Loan payments Interests Financing