Review illustrative exercise I7.1 carefully. Use the data provided and the budgets you prepared for JKL Corporation in Module 6 Tasks 6.1 and 6.2 to help you develop the following projected financial statements:

I7.1

Corporacin JKL Estado de Situacin Proforma Junio 30, 2013 Activos Activos corrientes: Efectivo (ver req. #5) .................................................................................... $8,400 Cuentas por cobrar (80% $90,000*) .......................................................... 72,000 Inventario (ver req. #2) ................................................................................. 9,000 Activos corrientes totales .................................................................................. 89,400 Equipo, neto ($214,100 + $14,500** $6,000^) ............................................................... 222,600 Total activos ...................................................................................................... $312,000 Deudas y capital de los accionistas Deudas corrientes: Cuentas por pagar (50% $46,800^^) ............................... $23,400 Capital de los accionistas: Capital en acciones comunes ............................................. $190,000 Ganancias retenidas# .......................................................... 98,600 288,600 Total deudas y capital ............................................................ $312,000 # Balance inicial, ganancias retenidas ............................. $75,400 Ingreso neto##............................................................... 26,700 Total .............................................................................. 102,100 Dividendos (dado)......................................................... (3,500) Balance final, ganancias retenidas ................................ $98,600

After studying the required resources of the module and completing Task 6.1, use the data and information from JKL Corporation, and the results you obtained in task 6.1, and prepare the cash budget for the quarter ending in June. Use the following table as a model:

*** Information needed bellow

Use the following information:

Preparation of Sales receipts budget for the quarter as follows:

Schedule of Sales Receipts
	April	May	June	Total
A) Sales	$75,500	$72,000	$84,000	$231,500
B) Cash sales ( A x 20% )	$15,100	$14,400	$16,800	$46,300
C) Credit sales ( A x 80% )	$60,400	$57,600	$67,200	$185,200
D) Collection from Accounts receivable	$64,000	$60,400	$57,600	$182,000
E) Total collections from sales ( B + D )	$79,100	$74,800	$74,400	$228,300

Preparation of Purchase Budget for the Quarter:

Purchase Budget
	April	May	June	Total
A) Sales	$75,500.00	$72,000.00	$84,000.00	$231,500.00
B) Cost of sales ( A x 53% )	$40,015.00	$38,160.00	$44,520.00	$122,695.00
C) Ending Inventory	$9,540.00	$11,130.00	$8,413.75	$29,083.75
D) Total Needed ( B + C )	$49,555.00	$49,290.00	$52,933.75	$151,778.75
E) Beginning Inventory	$15,400.00	$9,540.00	$11,130.00	$36,070.00
F) Budgeted Purchases ( D + E )	$64,955	$58,830	$64,063.75	$187,848.75

Preparation of Disbursements in purchases budget for the quarter:

Schedule of Purchase Disbursement
	April	May	June	Total
A) Budgeted Purchases	$64,955.00	$58,830.00	$64,063.75	$187,848.75
B) Cash Purchase ( A x 40% )	$25,982.00	$23,532.00	$25,625.50	$75,139.50
C) Accounts Payable paid	$23,400.00	$38,973.00	$35,298.00	$97,671.00
D) Total Purchase Disbursement ( B + C )	$49,382.00	$62,505.00	$60,923.50	$172,810.50

Preparation of Disbursements of Administrative and Sales expenses budget for the quarte

6.2

Use the following information:

	abril	aayo	junio	total
Balance inicial de efectivo		3,878	-9,387	-5,509
Cobros de efectivo	79,100	74,800	74,400	228,300
Efectivo disponible	79,100	78,678	74,400	222,791
Menos desembolsos:
Compras	49,382.00	62,505.00	60,923.50	172,810..50
Gastos administrativos y de ventas	25,840.00	25,560	26,520.00	77,920
Compra de equipo
Dividendos
Total de desembolsos
Exceso (deficiencia) de efectivo	3,878.00	-9,387.00	-13,043.50	-18,552.15
Financiamiento:
Prstamo		9,387.00	13,043.50	22,430.50
Pagos de prstamo
Intereses
Financiamiento
Balance final efectivo	3,878.00	-9387	-22,430.50	-27,939.20

Part A.

1. Pro forma balance sheet as of June 30, 20xx.
2. Proforma statement of income and expenses for the quarter ended June 30, 20xx
3. Proforma statement of cash flows for the quarter ended June 30, 20xx.

Part B.Then, complete the following table of financial analysis rates. Shows the calculation to get each rate

Financial Rates ( Ratios)	Junio 20xx (1 point )	vvCaculation (points)
Razn corriente (current ratio)
Razn cida (Acid-test ratio)
Rotacin de cuentas por cobrar (accounts receivable turn-over)
Periodo promedio de cobro (average collection period)
Rotacin de inventario (inventory turn-over)
Periodo promedio de ventas (average sales period)
Deuda/Activos
Deuda/Capital de los accionistas (debt-equity ratio)
Cubierta de intereses (timesinterest earned ratio)
Margen bruto (gross margin percentage)
Margen neto
Rendimiento sobre inversin (ROI: return on investment)