Ultimakk
-
Upload
omaar-mustaine-rattlehead -
Category
Documents
-
view
219 -
download
1
description
Transcript of Ultimakk
DatosTEXTILES GABY
DatosCapital de Trabajo$200,000.00Terreno$100,000.00Infraestructura$500,000.00Tiempo de Vida De Infraestructura30Equipo$1,000,000.00Valor De Recuperacin de Equipo$100,000.00Tiempo de Vida de Equipo5Gastos De Instalacin$500,000.00IVA16%Precio Unitario del Producto$800.00Incremento Porcentual de Costos de Produccin8%Incremento Porcentual de Gastos Administrativos8%Incremento Porcentual de Gastos de Venta5%Cantidades Vendidas del Producto20000Costo Unitario de Materias Primas A$120.00Costo Unitario de Materias Primas B$80.00Costo Unitario de Materiales$50.00Costo Unitario de Mano De Obra$50.00Costo De Mantenimiento de Equipo$150,000.00Gasto Unitario de Administracin$100.00Gasto Unitario de Venta$200.00Pronostico Porcentual de Crecimiento de Venta5%Tasa Mnima de Rentabilidad 45%Nivel De UtilidadesTasa De Impuestos09995%1000999910%100004999915%500009999920%10000049999925%50000099999930%100000035%Tiempo de Vida de Proyecto10
EfectivoTEXTILES GABYFlujo de Efectivo
12345678910INGRESOS$13,793,103.45$14,482,758.62$15,206,896.55$15,967,241.38$16,765,603.45$17,603,883.62$18,484,077.80$19,408,281.69$20,378,695.78$21,397,630.57Ventas Netas$13,793,103.45$14,482,758.62$15,206,896.55$15,967,241.38$16,765,603.45$17,603,883.62$18,484,077.80$19,408,281.69$20,378,695.78$21,397,630.57EGRESOS$13,286,850.57$14,033,326.44$14,823,972.09$15,705,214.81$16,579,925.42$17,522,116.90$18,484,377.66$19,427,504.41$20,419,339.47$21,462,442.40Costo Produccion$6,150,000.00$6,642,000.00$7,173,360.00$7,747,228.80$8,367,007.10$9,036,367.67$9,759,277.09$10,540,019.25$11,383,220.79$12,293,878.46Depreciacion Infraestructura$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67Depreciacion Maquinaria$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00Gastos Administrativos$2,000,000.00$2,160,000.00$2,332,800.00$2,519,424.00$2,720,977.92$2,938,656.15$3,173,748.65$3,427,648.54$3,701,860.42$3,998,009.25Gastos de Venta$4,000,000.00$4,200,000.00$4,410,000.00$4,630,500.00$4,862,025.00$5,105,126.25$5,360,382.56$5,628,401.69$5,909,821.78$6,205,312.86Impuestos$940,183.91$834,659.77$711,145.43$611,395.34$433,248.73$245,300.16-$5,697.30-$365,231.73-$772,230.19-$1,231,424.84FNE$506,252.87$449,432.18$382,924.46$262,026.57$185,678.03$81,766.72-$299.86-$19,222.72-$40,643.69-$64,811.83
ResultadosTEXTILES GABYESTADO DE RESULTADOS
12345678910Ventas Totales$16,000,000.00$16,800,000.00$17,640,000.00$18,522,000.00$19,448,100.00$20,420,505.00$21,441,530.25$22,513,606.76$23,639,287.10$24,821,251.46-IVA$2,206,896.55$2,317,241.38$2,433,103.45$2,554,758.62$2,682,496.55$2,816,621.38$2,957,452.45$3,105,325.07$3,260,591.32$3,423,620.89=Ventas Netas$13,793,103.45$14,482,758.62$15,206,896.55$15,967,241.38$16,765,603.45$17,603,883.62$18,484,077.80$19,408,281.69$20,378,695.78$21,397,630.57-Costo Produccion$6,150,000.00$6,642,000.00$7,173,360.00$7,747,228.80$8,367,007.10$9,036,367.67$9,759,277.09$10,540,019.25$11,383,220.79$12,293,878.46Costo De Materias Primas A$2,400,000.00$2,592,000.00$2,799,360.00$3,023,308.80$3,265,173.50$3,526,387.38$3,808,498.38$4,113,178.25$4,442,232.50$4,797,611.11Costo De Materias Primas B$1,600,000.00$1,728,000.00$1,866,240.00$2,015,539.20$2,176,782.34$2,350,924.92$2,538,998.92$2,742,118.83$2,961,488.34$3,198,407.40Costo De Materiales$1,000,000.00$1,080,000.00$1,166,400.00$1,259,712.00$1,360,488.96$1,469,328.08$1,586,874.32$1,713,824.27$1,850,930.21$1,999,004.63Costo de Mano de Obra$1,000,000.00$1,080,000.00$1,166,400.00$1,259,712.00$1,360,488.96$1,469,328.08$1,586,874.32$1,713,824.27$1,850,930.21$1,999,004.63Costo de Mantenimiento de Equipo$150,000.00$162,000.00$174,960.00$188,956.80$204,073.34$220,399.21$238,031.15$257,073.64$277,639.53$299,850.69-Depreciacion Infraestructura$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67$16,666.67-Depreciacion Maquinaria$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00$180,000.00=Utilidad Bruta$7,446,436.78$7,644,091.95$7,836,869.89$8,023,345.91$8,201,929.68$8,370,849.28$8,528,134.05$8,671,595.77$8,798,808.32$8,907,085.44-Gastos Administrativos$2,000,000.00$2,160,000.00$2,332,800.00$2,519,424.00$2,720,977.92$2,938,656.15$3,173,748.65$3,427,648.54$3,701,860.42$3,998,009.25-Gastos de Venta$4,000,000.00$4,200,000.00$4,410,000.00$4,630,500.00$4,862,025.00$5,105,126.25$5,360,382.56$5,628,401.69$5,909,821.78$6,205,312.86=Utilidad Antes de Impuestos$1,446,436.78$1,284,091.95$1,094,069.89$873,421.91$618,926.76$327,066.88-$5,997.16-$384,454.46-$812,873.88-$1,296,236.68-Impuestos$940,183.91$834,659.77$711,145.43$611,395.34$433,248.73$245,300.16-$5,697.30-$365,231.73-$772,230.19-$1,231,424.84=Utilidad Del Ejercicio$506,252.87$449,432.18$382,924.46$262,026.57$185,678.03$81,766.72-$299.86-$19,222.72-$40,643.69-$64,811.83
VPNTEXTILES GABYValor Presente Neto
FNEVPK0-$1,800,000.00-$1,800,000.00-1.55%1$506,252.87$349,139.91-1.50%2$449,432.18$213,760.85-1.45%3$382,924.46$125,605.63-0.50%4$262,026.57$59,275.240.00%5$185,678.03$28,968.130.50%6$81,766.72$8,797.691.00%7-$299.86-$22.251.50%8-$19,222.72-$983.722.00%9-$40,643.69-$1,434.442.50%10-$64,811.83-$1,577.523.00%
Valor Presente Neto-$1,018,470.47-$1,018,470.47
TIRTEXTILES GABYTasa Interna De Retorno
FNEVPK0-$1,800,000.00-$1,800,000.00-1.55%1$506,252.87$513,697.61-1.50%2$449,432.18$462,747.69-1.45%3$382,924.46$400,067.47-0.50%4$262,026.57$277,782.900.00%5$185,678.03$199,738.020.50%6$81,766.72$89,251.771.00%7-$299.86-$332.121.50%Valor Presente Neto0.008-$19,222.72-$21,604.052.00%9-$40,643.69-$46,350.412.50%10-$64,811.83-$74,998.883.00%TIR-1.45%
RAPTEXTILES GABYRendimiento Anual Promedio
FNE1$506,252.872$449,432.183$382,924.464$262,026.575$185,678.036$81,766.727-$299.868-$19,222.729-$40,643.6910-$64,811.83RAP0.10
1800000
IRTEXTILES GABYIndice de Rentabilidad
FNE1$506,252.872$449,432.183$382,924.464$262,026.575$185,678.036$81,766.727-$299.868-$19,222.729-$40,643.6910-$64,811.83IR0.43
1800000
PRTEXTILES GABYPeriodo De Recuperacin de Inversiones
FNEFNE ACUMULADO1$506,252.87$506,252.872$449,432.18$955,685.063$382,924.46$1,338,609.524$262,026.57$1,600,636.095$185,678.03$1,786,314.126$81,766.72$1,868,080.847-$299.86$1,867,780.988-$19,222.72$1,848,558.269-$40,643.69$1,807,914.5610-$64,811.83$1,743,102.73PRI511AosMeses
1800000
PRDESCONTTEXTILES GABYPeriodo De Recuperacin de Inversiones Descontado
FNEFNE ACUMULADOVP1$506,252.87$349,139.91$349,139.912$449,432.18$562,900.76$213,760.853$382,924.46$688,506.39$125,605.634$262,026.57$747,781.63$59,275.245$185,678.03$776,749.76$28,968.136$81,766.72$785,547.45$8,797.697-$299.86$785,525.20-$22.258-$19,222.72$784,541.48-$983.729-$40,643.69$783,107.05-$1,434.4410-$64,811.83$781,529.53-$1,577.52PRIDFALSE0AosMeses
1800000