Use the data provided and the budgets prepared from JKL Corporation in Assignments 6.1 and 6.2 to help develop the following projected financial statements:

1- Pro forma statement of condition as of June 30, 20xx. (10 points)

2- Proforma income and expense statement for the quarter ended June 30, 20xx.

3- Pro-forma statement of cash flows for the quarter ended June 30, 20xx.

Then, complete the following table of financial analysis rates. It shows the calculation to obtain each rate.

Formula Cash Budget April May June Quarter July A Beginning Cash Balance $ 20,000.00 $ 10,075.80 $ 8,220.70 $ 20,000.00 B Add Cash receipts $ 80,680.00 $80,620.00 $72,180.00 $2,33,480.00 Taken from Sales collection schedule given in problem C=A+B Total Cash on Hand $1,00,680.00 $90,695.80 $80,400.70 $2,53,480.00 D Less Disbursements E Purchases $ 42,232.20 $46,315.10 $46,524.80 $1,35,072.10 Taken from Schedule of Purchase Disbursements Given in Problem F Selling & distributions G Selling & Administration expenses $ 23,172.00 $ 22,060.00 $23,132.00 $ 68,364.00 Taken from Selling & Admnistration Schedule given from problem H Purchase of Equipment $ 25,200.00 $ 19,100.00 $ $ 44,300.00 Given in problem Dividends $ 5,200.00 $ 5,200.00 Given in problem J=Sum(D:1) Total Disbursements $ 90,604.20 $87,475.10 $74,856.80 $2,52,936.10 K=C-J Excess (Deficiency) $ 10,075.80 $ 3,220.70 $ 5,543.90 $ 543.90 Fianancing Loan $ $ 5,000.00 $ 3,000.00 $ 8,000.00 Working Note 1 M Loan Repayments S + N Interest $ -50.00 -50.00 Working Note 1 in to O=L+M+N Total Financing $ 5,000.00 $ 2,950.00 $ 7,950.00 P=K+0 Cash Closing Balance $ 10,075.80 $ 8,220.70 $ 8,493.90 $ 8,493.90 Working Note:1 for Computation of Loan Amount Desired Ending Cash $ 8,000.00 $ 8,000.00 Add Deficit or less excess cash $ -3,220.70 $-5,543.90 Less Interest to be paid $ -50.00 (5000*1%) Total Loan Amount to be borrowed $ 4,779.30 $ 2,406.10 Loan Amount in 1000's $ 5,000.00 $ 3,000.00 Sheet4 4 Sheet1 Sheet2 Sheet3 + eady Accessibility: InvestigateSchedule of Purchase disbursements April May June Total Budgeted purchases $47,080.50 $45.167.00 $48,561.50 $140,809.00 Cash Purchase (40%) (1) $18,832.20 $18,066.80 $19.424.60 $56.323.60 Accounts Payable Paid (1i) $23,400.00 $28,248.30 $27,100.20 $78,748.50 Total Disbursent (i)+(ii) $42,232.20 $46,315.10 $46,524.80 $135,072.10 Selling and administrative expense disbursements for the quarter April May June Total Salaries $10,200 $10,200 $10.200 $30,600 Advertising $6.300 $6.300 $6.300 $18.900 Other Expenses $6.672 $5.560 $6.632 $18.864 Total Selling and administrative Paid $23,172 $22,060 $23,132 $68,364Ratios June 20xx Calculation 1. current ratio 2. Acid-test ratio 3. accounts receivable turn-over 4. average collection period 5. inventory turn-over 6. average sales period) 7. debt/assets B. debt-equity ratio 9. times interest earned ratio 10. gross margin percentage 11. Net margin 12. (ROI: return on investment)Schedule of Sales Collection April May June Total Sales $83.400 $69,500 $82,900 $235,800 Cash Sales (1) $16,680 $13.900 $16,580 $47,160 Credit Sales $66,720 $55,600 $66,320 $188,640 Collection from Accounts Receivable (li) $64.000 $66,720 $55.600 $186.320 Total Collection from Sales (i)+(ii) $80,680 $80,620 $72,180 $233,480 Purchase Budget April May June Total Sales $83,400.00 $69,500.00 $82,900.00 $235,800.00 Cost of Sales (Salesx62%) $51,708.00 $43,090.00 $51,398.00 $146, 196.00 Add:Ending Inventory $10,772.50 $12,849.50 $10,013.00 $10,013.00 Total Needed $62,480.50 $55,939.50 $61,411.00 $156,209.00 Less:Beginning Inventory $15,400.00 $10,772.50 $12,849.50 $15,400.00 Budgeted purchases $47,080.50 $45,167.00 $48,561.50 $140,809.00