8/19/2019 Fepi Excel Final Cambiadoo
1/23
INVERSION PARA EL PROYECTO
CAPITAL FIJO S/. 73,610Horno Industrial S/. 53,000
Batidora Industrial S/. 15,900Computadora S/. 1,200
Impresora S/. 300
Escritorio S/. 200
Estante administrativo S/. 250
esas industriales para cocina S/. 1,!00
"tensilios de cocina S/. 1,3#0
Constitucion ! !"#$!s% S/. $,000
INVERSI&N S/. '6,7(3
PRESTA)O PARA EL PROYECTO
B%&C' BC( ) C*E+I' (-E
PRESTA)O S/. 50,000.00ASA *E INTERES AN+AL 16.1' 0.1#19
A-OS !
Cuot% S/. 1$,93#.5$
A-O SAL*O C+OTA1 S/. 50,000.00 S/. 1$,93#.5$
2 S/. !0,15.!3 S/. 1$,93#.5$3 S/. 2,$23.51 S/. 1$,93#.5$
! S/. 15,!3$.2 S/. 1$,93#.5$
5 S/. 0.00
ALFAJORES EN PAC *E 6 +NI*A*ES
C'S' I' S/. 0,0!0
C'S' %*I%BE "&I%*I' S/. 2.5(*ECI' +E E&% S/. #.0
8/19/2019 Fepi Excel Final Cambiadoo
2/23
E&%S %&"%ES1
0000 000
I("ES' 30
*E&%. +E % I&E*SI'& 15
*EC"(. +E % I&E*SI'&
%'* +E +ESECH' 30000
FL+JO *E CAJA
FL+JO CAJA 0 1In4resos ventas S/. 2!0,000.00
Costo varia6le total S/. 100,000.00Costo 78o S/. 0,0!0.00
+epreciacin S/. $,!50.00
alor de +esec:o
Inter;s del prestamo S/. ,095.00
"%II S/. !!,!15.00
Impuesto a la *enta S/. 13,32!.50
" despu;s de Impuestos S/. 31,090.50
+epreciacin S/. $,!50.00
alor de +esec:o"tilidad &eta S/. 3,5!0.50
Inversion Inicial S/. 9#,$53
(restamo S/. 50,000.00
%morti
8/19/2019 Fepi Excel Final Cambiadoo
3/23
VARIA2LE 1 C%"4i%"os 5% c%nti% #$o
CANTI*A* VAN350000.00 S/. 5!,105.0
!00000.00 S/. 93,03!.$
!50000.00 S/. 131,9#!.!
500000.00 S/. 1$0,9!.1
550000.00 S/. 209,23.
#00000.00 S/. 2!,$53.5
8/19/2019 Fepi Excel Final Cambiadoo
4/23
c%#it%5 ! t$%4%o S/. 16,13sueldos ##$0
servicios !!0al=uiler del local $00
insumos > materiales 333
%stos ! s!$8icios 0a4ua 0
lu< 150
limpie
8/19/2019 Fepi Excel Final Cambiadoo
5/23
3 (100 630( 60
1.15
ROYECTA*O A ( A-OS
3 S/. 252,000.00 S/. 2#!,#00.00 S/. 2$$,30.00
S/. 105,000.00 S/. 110,250.00 S/. 115,$#2.50S/. 0,0!0.00 S/. 0,0!0.00 S/. 0,0!0.00
S/. $,!50.00 S/. $,!50.00 S/. $,!50.00
S/. #,501.#5 S/. !,#50.3! S/. 2,!99.29
S/. 53,00.35 S/. #2,209.## S/. $2,0$.21
S/. 15,902.51 S/. 1,##2.90 S/. 21,#23.!#
S/. 3$,105.5 S/. !3,5!#.$# S/. 50,!5!.$!
S/. $,!50.00 S/. $,!50.00 S/. $,!50.00
S/. !!,555.5 S/. 50,99#.$# S/. 5$,90!.$!
S/. 9,!1.5$ S/. 13,2#.23 S/. 15,!3$.2
S/. 3!,$1!.2$ S/. 3$,$10.53 S/. !2,!#$.!$
2225.20 215#1.12 21113.!
I* A $0.!
1 3 S/. 5,300.00 S/. 5,300.00 S/. 5,300.00
S/. 1,590.00 S/. 1,590.00 S/. 1,590.00
S/. 300.00 S/. 300.00 S/. 300.00
S/. $5.00 S/. $5.00 S/. $5.00
S/. 20.00 S/. 20.00 S/. 20.00
S/. 25.00 S/. 25.00 S/. 25.00
S/. 1!0.00 S/. 1!0.00 S/. 1!0.00
S/. 7,(0.00 S/. 7,(0.00 S/. 7,(0.00
8/19/2019 Fepi Excel Final Cambiadoo
6/23
ci%
TIR PERIO*O *E REC+PERACION#$.!$ 5
105.!$ !
1!3.1 3
12.!1 2
221.22 2
2#0.1 2
8/19/2019 Fepi Excel Final Cambiadoo
7/23
r a credito a 30 d@as.
8/19/2019 Fepi Excel Final Cambiadoo
8/23
( 6 S/. 291,$21.50
S/. 121,550.#3S/. 0,0!0.00
S/. $,0$5.00
S/. 35,3$5.00
S/. !$,#0.
S/. 1!,30!.2#
S/. 33,3$#.#1
S/. $,0$5.00
S/. 35,3$5.00S/. $5,2#.#1
S/. $5,2#.#1
0.15
32$1.9!
( S/. 5,300.00 S/. 5,300.00
S/. 1,590.00 S/. 1,590.00
S/. 300.00 S/. )
S/. $5.00 S/. )
S/. 20.00 S/. 20.00
S/. 25.00 S/. 25.00
S/. 1!0.00 S/. 1!0.00
S/. 7,(0.00 S/. 7,07(.00
8/19/2019 Fepi Excel Final Cambiadoo
9/23
8/19/2019 Fepi Excel Final Cambiadoo
10/23
8/19/2019 Fepi Excel Final Cambiadoo
11/23
S/. 9#,3.20
*EPRE AC+)+LA*A VALOR *E *ESEC:O S/. 6,(00.00 S/. 6,(00.00S/. 7,'(0.00 S/. 7,'(0.00S/. 1,00.00 S/. ;S/. 300.00 S/. ;S/. 100.00 S/. 100.00S/. 1(.00 S/. 1(.00S/. 700.00 S/. 700.00S/. 36,7(.00 S/. 3(,37(.00
8/19/2019 Fepi Excel Final Cambiadoo
12/23
8/19/2019 Fepi Excel Final Cambiadoo
13/23
8/19/2019 Fepi Excel Final Cambiadoo
14/23
2#500
5300
8/19/2019 Fepi Excel Final Cambiadoo
15/23
8/19/2019 Fepi Excel Final Cambiadoo
16/23
INSTITUCION
SUNARP
INDECOPI
SUNAT
MUNICIPIO DE MIRAFLORES
DEFENSA CIVIL
8/19/2019 Fepi Excel Final Cambiadoo
17/23
CONCEPTO TOTAL A PAGAR
BUSQUEDA DE INDICES S/. 4
RESERVA DE NOMBRE S/. 16
DERECHOS NOTARIALES S/. 350
DERECHO DE CALIFICACION S/. 38
DERECHO DE INSCRIPCION S/. 120
NOMBRAMIENTO DE ADMINISTRADORES S/. 20
TOTAL S/. 548
BUSQUEDA DE ANTECEDENTES S/. 56
PAGO POR TAA DE REGISTRO S/. 535
TOTAL S/. 535
TODOS LOS TRAMITES SON GRATUITOS S/. 0
CERTIFICADO DE ONIFICACION ! USOS S/. 140
LICENCIA PROVISIONAL DE FUNCION. S/. 216
ANUNCIOS PUBLICITARIOS S/. 406
TOTAL S/. 762
INSPECCION TECNICA S/. 144
TOTAL S/. 144
TOTAL S/. 1,988
8/19/2019 Fepi Excel Final Cambiadoo
18/23
INVERSION PARA EL PROYECTO
CAPITAL FIJO S/. 7,(0Horno Industrial S/. 53,000
Batidora Industrial S/. 15,900Computadora S/. 1,200
Impresora S/. 300
Escritorio S/. 200
Estante administrativo S/. 250
esas industriales para cocina S/. 1,!00
INVERSI&N S/. 0,7'0
C+OTA )ENS+AL S/. ,3
ALFAJORES EN PAC *E 6 +NI*A*ES
C'S' I' S/. $$,#!0
C'S' %*I%BE "&I%*I' S/. 2.5
(*ECI' +E E&% S/. #.0
I&C*EE&' +E E&%S 2 %&"%ES
E&%S %&"%ES1
0000 000
I("ES' 30
*E&%. +E % I&E*SI'& 15
*EC"(. +E % I&E*SI'&
%'* +E +ESECH' 30000
FL+JO *E CAJA PRO
FL+JO CAJA 0 1In4resos ventas S/. 2!0,000.00
Costo varia6le total S/. 100,000.00
8/19/2019 Fepi Excel Final Cambiadoo
19/23
8/19/2019 Fepi Excel Final Cambiadoo
20/23
CAPITAL *E TRA2AJO S/. ,(0"tensilios de cocina S/. 1,3#0
"tiles de o7cina S/. 200"tiles de mantenimiento S/. 100
"tiles de empa=uetadura S/. 0
ano de o6ra S/. !,00
Constitucion de empresa S/. 2,000
3 (1616 3'7
1.15
ECTA*O A ( A-OS
3 ( S/. 2!!,00.00 S/. 2!9,#9#.00 S/. 25!,#9.92 S/. 259,$3.$2
S/. 102,000.00 S/. 10!,0!0.00 S/. 10#,120.0 S/. 10,2!3.22
8/19/2019 Fepi Excel Final Cambiadoo
21/23
S/. $$,#!0.00 S/. $$,#!0.00 S/. $$,#!0.00 S/. $$,#!0.00
S/. $,!50.00 S/. $,!50.00 S/. $,!50.00 S/. $,0$5.00
S/. 5$,$10.00 S/. #0,5##.00 S/. #3,!$9.12 S/. ##,25.50
S/. 1$,313.00 S/. 1,1#9.0 S/. 19,0!3.$! S/. 20,0!$.#5
S/. !0,39$.00 S/. !2,39#.20 S/. !!,!35.3 S/. !#,$$$.5
S/. $,!50.00 S/. $,!50.00 S/. $,!50.00 S/. $,0$5.00
0 0 0
S/. !$,!$.00 S/. !9,!#.20 S/. 51,5.3 S/. 53,52.5
S/. 12,11.50 S/. 12,11.50 S/. 12,11.50 S/. 12,11.50
S/. 9,03.00 S/. 9,03.00 S/. 9,03.00 S/. 9,03.00
S/. 2#,#!5.50 S/. 2,#!!.$0 S/. 30,#3. S/. 32,#51.35
S/. 20,1! S/. 1,3! S/. 1$,5!! S/. 1#,233
1 3 S/. 5,300.00 S/. 5,300.00 S/. 5,300.00 S/. 5,300.00
S/. 1,590.00 S/. 1,590.00 S/. 1,590.00 S/. 1,590.00
S/. 300.00 S/. 300.00 S/. 300.00 S/. 300.00
S/. $5.00 S/. $5.00 S/. $5.00 S/. $5.00
S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00
S/. 25.00 S/. 25.00 S/. 25.00 S/. 25.00
S/. 1!0.00 S/. 1!0.00 S/. 1!0.00 S/. 1!0.00
S/. 7,(0.00 S/. 7,(0.00 S/. 7,(0.00 S/. 7,(0.00
8/19/2019 Fepi Excel Final Cambiadoo
22/23
8/19/2019 Fepi Excel Final Cambiadoo
23/23
( *EPRE AC+)+LA*A VALOR *E *ESEC:O S/. 5,300.00 S/. 6,(00.00 S/. 6,(00.00S/. 1,590.00 S/. 7,'(0.00 S/. 7,'(0.00S/. ) S/. 1,00.00 S/. ;S/. ) S/. 300.00 S/. ;S/. 20.00 S/. 100.00 S/. 100.00S/. 25.00 S/. 1(.00 S/. 1(.00S/. 1!0.00 S/. 700.00 S/. 700.00
S/. 7,07(.00 S/. 36,7(.00 S/. 3(,37(.00