Upload
cristhian-macias
View
3.235
Download
0
Embed Size (px)
Citation preview
MAYO 1 2 3 4 5Balance inicial $0.00 $5,000.00 $0.00 $2,250.00 $0.00
Ingreso total $16,000.00 $2,000.00 $5,000.00 $550.00 $20,000.00Gastos totales $10,000.00 $7,000.00 $2,750.00 $2,800.00 $5,000.00
Saldo (Ingreso – Gastos) $6,000.00 -$5,000.00 $2,250.00 -$2,250.00 $15,000.00Efectivo al final del día $5,000.00 $0.00 $2,250.00 $0.00 $10,000.00
INGRESOS 1 2 3 4 5Padres 6,000.00 2,000.00 550.00 20,000.00
PerfumesTrabajos Universidad
Proveniente de deudas familiares 0.00 0.00 5,000.00 0.00 0.00Proveniente de deudas personales 10,000.00 0.00 0.00 0.00 0.00
Otros ingresosTOTAL INGRESOS 16,000.00 2,000.00 5,000.00 550.00 20,000.00
GASTOS 1 2 3 4 5Alimentacion 2700 2200Transporte 2800 2750 2800 2800Universidad 1500Entretenimiento 10000CelularDiezmos-donacionesPago prestamos personalesPago prestamos familiaresCompra Perfumes
TOTAL GASTOS $ 10,000.00 $ 7,000.00 $ 2,750.00 $ 2,800.00 $ 5,000.00
AHORROS 1 2 3 4 5Alcancia Billetes 1000 5000
Alcancia MonedasTOTAL AHORROS $ 1,000.00 $ 0.00 $ 0.00 $ 0.00 $ 5,000.00
DEUDAS 1 2 3 4 5Prestamos personales $ 10,000.00Prestamos familiares $ 5,000.00Bancosdeudas mes anterior $ 60,000.00TOTAL DEUDAS $ 70,000.00 $ 70,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00
SITUACION FINANCIERA 1 2 3 4 5Ingresos totales 6,000.00 2,000.00 0.00 550.00 20,000.00Egresos totales 10,000.00 7,000.00 2,750.00 2,800.00 5,000.00Ahorros totales 1,000.00 0.00 0.00 0.00 5,000.00Deudas totales 70,000.00 70,000.00 75,000.00 75,000.00 75,000.00Saldo Efectivo -75,000.00 -75,000.00 -77,750.00 -77,250.00 -65,000.00Capital -74,000.00 -70,000.00 -75,000.00 -75,000.00 -70,000.00
6 7 8 9 10 11 12 13$10,000.00 $4,600.00 $600.00 $600.00 $4,200.00 $0.00 $18,300.00 $19,100.00$3,000.00 $2,000.00 $0.00 $120,000.00 $0.00 $44,000.00 $10,000.00 $61,000.00$8,400.00 $6,000.00 $0.00 $113,200.00 $5,600.00 $5,700.00 $9,200.00 $2,800.00-$5,400.00 -$4,000.00 $0.00 $6,800.00 -$5,600.00 $38,300.00 $800.00 $58,200.00$4,600.00 $600.00 $600.00 $4,200.00 $0.00 $18,300.00 $19,100.00 $77,300.00
6 7 8 9 10 11 12 133,000.00 2,000.00 10,000.00 10,000.00 11,000.00
30,000.00 50,000.0050,000.00
0.00 0.00 0.00 60,000.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
14,000.003,000.00 2,000.00 0.00 120,000.00 0.00 44,000.00 10,000.00 61,000.00
6 7 8 9 10 11 12 135600 3200 2600 2800 1700 50002800 2800 5600 2800 2800 4200 2800
2000 1000
200
103000$ 8,400.00 $ 6,000.00 $ 0.00 ### $ 5,600.00 $ 5,700.00 $ 9,200.00 $ 2,800.00
6 7 8 9 10 11 12 132000 200001200 -1400
$ 0.00 $ 0.00 $ 0.00 $ 3,200.00 -$ 1,400.00 $ 20,000.00 $ 0.00 $ 0.00
6 7 8 9 10 11 12 13
$ 60,000.00
$ 75,000.00 $ 75,000.00 $ 75,000.00 ### ### ### ### ###
6 7 8 9 10 11 12 133,000.00 2,000.00 0.00 60,000.00 0.00 44,000.00 10,000.00 61,000.008,400.00 6,000.00 0.00 113,200.00 5,600.00 5,700.00 9,200.00 2,800.00
0.00 0.00 0.00 3,200.00 -1,400.00 20,000.00 0.00 0.0075,000.00 75,000.00 75,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00
-80,400.00 -79,000.00 -75,000.00 -191,400.00 -139,200.00 -116,700.00 -134,200.00 -76,800.00-75,000.00 -75,000.00 -75,000.00 -131,800.00 -136,400.00 -115,000.00 -135,000.00 -135,000.00
14 15 16 17 18 19 20 21$77,300.00 $0.00 $0.00 $1,700.00 $600.00 $0.00 $0.00 -$4,800.00
$0.00 $0.00 $14,500.00 $0.00 $5,000.00 $20,000.00 $0.00 $20,000.00$72,300.00 $0.00 $12,800.00 $2,800.00 $5,600.00 $20,000.00 $4,800.00 $28,400.00-$72,300.00 $0.00 $1,700.00 -$2,800.00 -$600.00 $0.00 -$4,800.00 -$8,400.00
$0.00 $0.00 $1,700.00 $600.00 $0.00 $0.00 -$4,800.00 -$13,200.00
14 15 16 17 18 19 20 2114,500.00 5,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 20,000.00 0.00 20,000.00
0.00 0.00 14,500.00 0.00 5,000.00 20,000.00 0.00 20,000.00
14 15 16 17 18 19 20 219000 10000 10000 2000 70002800 2800 2800 5600 10000 2800 1400
50500
10000 20000
$ 72,300.00 $ 0.00 $ 12,800.00 $ 2,800.00 $ 5,600.00 $ 20,000.00 $ 4,800.00 $ 28,400.00
14 15 16 17 18 19 20 215000
-1700$ 5,000.00 $ 0.00 $ 0.00 -$ 1,700.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00
14 15 16 17 18 19 20 21$ 20,000.00 $ 20,000.00
### ### ### ### ### ### ### ###
14 15 16 17 18 19 20 210.00 0.00 14,500.00 0.00 5,000.00 0.00 0.00 0.00
72,300.00 0.00 12,800.00 2,800.00 5,600.00 20,000.00 4,800.00 28,400.005,000.00 0.00 0.00 -1,700.00 0.00 0.00 0.00 0.00
125,000.00 125,000.00 125,000.00 125,000.00 125,000.00 145,000.00 145,000.00 145,000.00-202,300.00 -125,000.00 -123,300.00 -126,100.00 -125,600.00 -165,000.00 -149,800.00 -173,400.00-120,000.00 -125,000.00 -125,000.00 -126,700.00 -125,000.00 -145,000.00 -145,000.00 -145,000.00
22 23 24 25 26 27 28 29-$13,200.00 $0.00 $8,050.00 $8,050.00 $8,050.00 $8,050.00 $8,050.00 $8,050.00$13,000.00 $10,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00$19,900.00 $56,350.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00-$6,900.00 -$46,350.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $8,050.00 $8,050.00 $8,050.00 $8,050.00 $8,050.00 $8,050.00 $8,050.00
22 23 24 25 26 27 28 2913,000.00 10,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
13,000.00 10,000.00 0.00 0.00 0.00 0.00 0.00 0.00
22 23 24 25 26 27 28 297000 15002900 2850
2000
10000 50000
$ 19,900.00 $ 56,350.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00
22 23 24 25 26 27 28 2913000
-33100 -54400-$ 20,100.00 -$ 54,400.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00
22 23 24 25 26 27 28 29
### $ 85,000.00 $ 85,000.00 $ 85,000.00 $ 85,000.00 $ 85,000.00 $ 85,000.00 $ 85,000.00
22 23 24 25 26 27 28 2913,000.00 10,000.00 0.00 0.00 0.00 0.00 0.00 0.0019,900.00 56,350.00 0.00 0.00 0.00 0.00 0.00 0.00
-20,100.00 -54,400.00 0.00 0.00 0.00 0.00 0.00 0.00135,000.00 85,000.00 85,000.00 85,000.00 85,000.00 85,000.00 85,000.00 85,000.00
-121,800.00 -76,950.00 -85,000.00 -85,000.00 -85,000.00 -85,000.00 -85,000.00 -85,000.00-155,100.00 -139,400.00 -85,000.00 -85,000.00 -85,000.00 -85,000.00 -85,000.00 -85,000.00
30 31$8,050.00 $8,050.00 Total Promedio
$0.00 $0.00 $366,050.00 $11,808.06$0.00 $0.00 $401,400.00 $14,561.29$0.00 $0.00 -$35,350.00 -$1,140.32
$8,050.00 $8,050.00 $198,700.00
30 31 Total PromedioPorcentaje107,050.00 3453.22581 30%
80,000.00 2580.64516 23%50,000.00 1612.90323 14%
0.00 0.00 65,000.00 2096.77419 18%0.00 0.00 50,000.00 1612.90323 14%
0.00 0.00 352,050.00 11356.4516 100%
30 31 Total PromedioPorcentaje72300 2332.25806 26.94%68900 25.67%57000 21.24%10000 3.73%
200 0.07%
60000 22.35%
$ 0.00 $ 0.00 ### $ 2,332.26 100.00%
30 31 Total PromedioPorcentaje46000 1483.87097 -106%
-89400 -2883.87097 206%$ 0.00 $ 0.00 -$ 43,400.00 -$ 1,400.00 100%
30 31 Total PromedioPorcentaje$ 50,000.00 $ 1,612.90 43%$ 65,000.00 $ 2,096.77 57%
0%$ 60,000.00 $ 1,935.48 52%
$ 85,000.00 $ 85,000.00 ### $ 5,645.16 100%
30 31 Total PromedioPorcentaje0.00 0.00 ### $ 8,098.39 295%0.00 0.00 ### $ 12,948.39 472%0.00 0.00 -$ 43,400.00 -$ 1,400.00 -51%
85,000.00 85,000.00 $ 85,000.00 $ 19,646.77 717%-85,000.00 -85,000.00 -85,000.00-85,000.00 -85,000.00