Restructuracion ingenieria financiera
Enviado por ernesua • 1 de Septiembre de 2015 • Práctica o problema • 929 Palabras (4 Páginas) • 162 Visitas
INSTRUCCIONES:
18 | ESTADO DE RESULTADOS | ||||||
AÑO 1 | AÑO 2 | AÑO 3 | AÑO 4 | AÑO 5 | PROMEDIO | ||
Ventas Netas | 3,240,000 | 3,470,040 | 3,861,461 | 4,584,326 | 5,644,222 | 3,523,834 | |
- | Costo de Ventas | 2,160,000 | 2,312,160 | 2,571,737 | 3,051,927 | 3,756,023 | 2,347,966 |
= | Utilidad bruta | 1,080,000 | 1,157,880 | 1,289,724 | 1,532,399 | 1,888,199 | 1,175,868 |
- | Gastos Administrativos | -10,000 | -10,000 | -10,000 | -10,000 | -10,000 | -10,000 |
- | Gastos de Venta | -74,800 | -79,401 | -87,229 | -101,687 | -122,884 | -80,477 |
- | Depreciación | 0 | -170,000 | -270,000 | -370,000 | -470,000 | -146,667 |
= | Utilidad de operación | 995,200 | 898,479 | 922,495 | 1,050,713 | 1,285,315 | 938,725 |
- | Egreso anual por gastos financieros | -200,000 | -200,000 | -160,000 | -120,000 | -80,000 | -186,667 |
+ | Ingreso anual por productos financieros | 0 | 25,000 | 50,000 | 75,000 | 75,000 | 25,000 |
= | Utilidad antes de impuestos y PTU | 795,200 | 723,479 | 812,495 | 1,005,713 | 1,280,315 | 777,058 |
- | ISR 30% | -238,560 | -217,044 | -243,748 | -301,714 | -384,094 | -233,117 |
- | PTU 10% | -79,520 | -72,348 | -81,249 | -100,571 | -128,031 | -77,706 |
= | Resultado del ejercicio | 477,120 | 434,088 | 487,497 | 603,428 | 768,189 | 466,235 |
20 | BALANCE GENERAL | AÑO 1 | AÑO 2 | AÑO 3 | AÑO 4 | AÑO 5 | PROMEDIO |
ACTIVO | |||||||
AC | |||||||
= | Banco | 1,753,120 | 3,468,574 | 5,500,155 | 8,143,730 | 11,525,838 | 600,000 |
+ | Inversión en Bonos | 100,000 | 200,000 | 300,000 | 300,000 | 300,000 | 100,000 |
+ | Clientes | 810,000 | 867,510 | 965,365 | 1,146,081 | 1,411,056 | 880,958 |
+ | Almacen | 60,000 | 64,260 | 71,509 | 84,895 | 104,523 | 65,256 |
TOTAL AC | 2,723,120 | 4,600,344 | 6,837,028 | 9,674,707 | 13,341,416 | 1,646,214 | |
AF | |||||||
AF varios | 850,000 | 1,350,000 | 1,680,000 | 1,910,000 | 2,040,000 | 1,293,333 | |
Depreciación AF varios | 0 | 170,000 | 270,000 | 370,000 | 470,000 | 146,667 | |
+ | AF varios Neto | 850,000 | 1,180,000 | 1,410,000 | 1,540,000 | 1,570,000 | 880,000 |
TOTAL AF | 850,000 | 1,180,000 | 1,410,000 | 1,540,000 | 1,570,000 | 880,000 | |
= | TOTAL ACTIVO | 3,573,120 | 5,780,344 | 8,247,028 | 11,214,707 | 14,911,416 | 2,526,214 |
PASIVO | |||||||
PCP | |||||||
Proveedor | 1,776,000 | 3,629,136 | 5,692,324 | 8,144,575 | 11,165,095 | 158,537 | |
+ | Intereses por pagar | 20,000 | 40,000 | 56,000 | 68,000 | 76,000 | 38,667 |
TOTAL PCP | 1,796,000 | 3,669,136 | 5,748,324 | 8,212,575 | 11,241,095 | 197,204 | |
PLP | |||||||
+ | Préstamo bancario | 500,000 | 400,000 | 300,000 | 200,000 | 100,000 | 400,000 |
TOTAL PLP | 500,000 | 400,000 | 300,000 | 200,000 | 100,000 | 400,000 | |
= | TOTAL PASIVO | 2,296,000 | 4,069,136 | 6,048,324 | 8,412,575 | 11,341,095 | 597,204 |
CAPITAL CONTABLE | |||||||
Capital Social | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 1,000,000 | |
+ | Resultado del ejercicio: | 477,120 | 434,088 | 487,497 | 603,428 | 768,189 | 466,235 |
+ | Resultado de ejercicios anteriores: | 0 | 477,120 | 911,208 | 1,398,704 | 2,002,132 | 462,776 |
= | TOTAL CAPITAL CONTABLE | 1,277,120 | 1,711,208 | 2,198,704 | 2,802,132 | 3,570,321 | 1,929,011 |
TOTAL PASIVO + CAPITAL CONT | 3,573,120 | 5,780,344 | 8,247,028 | 11,214,707 | 14,911,416 | 2,526,214 |
CUENTA | CANTIDAD PROM | PONDERACIÓN | FÓRMULA | COSTO CAPITAL | CTO CAP POND |
|
| 365/n | |||
PROVEEDOR | 158,537 | .0627 | KprA = . F . - 1 | ||
15% / 7, neto 60 | P | 2.0625 | .1293 | ||
| n = Per crédito – Per Descto | ||||
INTERESES X PAGAR | 38,667 | .0153 | Kcxp = Directo | .08 | .0012 |
8% | |||||
|
| ||||
PRÉSTAMO BANCARIO A LP | Kpb = . IB - Re . - 1[pic 1][pic 2] | ||||
Re = 10% sobre préstamo | √ IB - GT - I - Re | .0828 | .0131 | ||
GT = 5,000 | 400,000 | .1583 | |||
i = 12% anual | I = IB * i * t | ||||
CAPITAL SOCIAL Acciones Preferentes | 1,000,000 | .3958 | Kap = . D . | .5853 | .2316 |
D = Utilidad Ejercicio (PROM) | IB - GT(1- Imps) | ||||
GT = 5,000 | |||||
Imps = 30% |
| ||||
TOT PASIVO + CAP CONTABLE | 2,526,214 | 1.0000 | COSTO DE CAPITAL PROMEDIO PONDERADO | .3752 |
...