View
225
Download
0
Category
Preview:
Citation preview
7/25/2019 Flujo de ventas.xlsx
1/14
INGRESOS
VIV. CONST
1 ETAPA 1542 ETAPA 131
285
Velocidad de Ventas 8 und/mes
Total de meses 36
Entrega de 1ra etapa Dec-14
Entrega de 2da etapa Jun-16
T/C 2.7
VIVIED! de 55 m2 85" 34#"""
1"#"$8#"""
Condiciones de Venta
Cuota inicialCrdito Hipotecario
Cuota inicial
Plan Ahorro
Cuota inicial
Crdito directo (Dic 14)
Contado
UNIDADES VENDIDAS MENSUALES
PRODUCTOS May Jun
PRECIO PROMEDIO
DE VENTA x M2 US$
PRECIO PROMEDIO
DE VENTA PORVIVIENDA US$
7/25/2019 Flujo de ventas.xlsx
2/14
1 2
Crdito Hipotecario 3 3
Plan Ahorro
Crdito Directo 1 2
Contado 1 1
TOTAL 5 6
ESTRUCTURA DE VENTAS VALORIZADO US$
PRODUCTOS May Jun
1 2
Crdito Hipotecario 102,000 102,000Plan Ahorro 0 0
Crdito Directo 34,000 6,000
Contado 34,000 34,000
TOTAL 1!0,000 204,000
"LUJO DE CAJA
May Jun
INGRESOS 1 2
IN#RESOS POR ADELANTO 6,000 1,600
Crdito Hipotecario 20,400 20,400
Plan Ahorro 0 0
Crdito Directo 13,600 2!,200
Contado 34,000 34,000
SALDO DE IN#RESOS 0 1,600
Crdito Hipotecario 0 1,600
Plan Ahorro 0 0
Crdito Directo
Contado
TOTAL IN#RESOS 6,000 163,200
7/25/2019 Flujo de ventas.xlsx
3/14
PREVENTAS UNID PREVENT
3"% 46&2"
apro'
2$( 1"#"$8#""" 1""%
1"#"$8#"""&"" 1""%
Sobe !e" de# IGV
Tota# de# o"ecto %esti&ado' Valor del
Vi. con !"onerac
2()4"%
&'
*() 1 &
T&P CA
2() 3"%
*()
+() 2"%
,()
1(() 1"%
PREVENTAS
2,013
Ju A%& S'( O)* N&+
- UNIDADES POR
VENDER
INGRESOS
TOTA! PORPRODUCTO
7/25/2019 Flujo de ventas.xlsx
4/14
3 4 5 6 7
4 4 4 3 2
1 1 2
2 2 2 2 2
1 1 1 1 1
! ! ! !
)re*enta Total+ 4!
PREVENTAS
2,013
Ju A%& S'( O)* N&+
3 4 5 6 7
136,000 136,000 136,000 102,000 6,0000 0 34,000 34,000 6,000
6,000 6,000 6,000 6,000 6,000
34,000 34,000 34,000 34,000 34,000
23,000 23,000 2!2,000 23,000 23,000
2,013
Ju A%& S'( O)* N&+
3 4 5 6 7
,400 ,400 5,200 ,400 ,400
2!,200 2!,200 2!,200 20,400 13,600
0 0 6,00 6,00 13,600
2!,200 2!,200 2!,200 2!,200 2!,200
34,000 34,000 34,000 34,000 34,000
1,600 10,00 136,000 136,000 136,000
1,600 10,00 10,00 10,00 1,600
0 0 2!,200 2!,200 54,400
1!0,000 1!,200 231,200 224,400 224,400
7/25/2019 Flujo de ventas.xlsx
5/14
erreno () del alor de enta
#n $o%re el &'V / &T , 47-2.
1*.(()
T /0(( 0ole$
*+& 2.0( 0ole$ por d#lar
VENTAS DE PRIM
2,01
D-) En' "'. Ma/ A./ May Jun
7/25/2019 Flujo de ventas.xlsx
6/14
8 9 10 11 12 13 14
2 2 3 3 3 3 3
2 2 2 2 2 2 2
2 2 2 2 2 2 2
1 1 1 1 1 1 1
! !
VENTAS DE PRIM
2,01
D-) En' "'. Ma/ A./ May Jun
8 9 10 11 12 13 14
6,000 6,000 102,000 102,000 102,000 102,000 102,0006,000 6,000 6,000 6,000 6,000 6,000 6,000
6,000 6,000 6,000 6,000 6,000 6,000 6,000
34,000 34,000 34,000 34,000 34,000 34,000 34,000
23,000 23,000 2!2,000 2!2,000 2!2,000 2!2,000 2!2,000
2,01
D-) En' "'. Ma/ A./ May Jun
8 9 10 11 12 13 14
,400 ,400 5,200 5,200 5,200 5,200 5,200
13,600 13,600 20,400 20,400 20,400 20,400 20,400
13,600 13,600 13,600 13,600 13,600 13,600 13,600
2!,200 2!,200 2!,200 2!,200 2!,200 2!,200 2!,200
34,000 34,000 34,000 34,000 34,000 34,000 34,000
10,00 10,00 10,00 136,000 136,000 136,000 136,000
54,400 54,400 54,400 1,600 1,600 1,600 1,600
54,400 54,400 54,400 54,400 54,400 54,400 54,400
1!,200 1!,200 204,000 231,200 231,200 231,200 231,200
7/25/2019 Flujo de ventas.xlsx
7/14
RA ETAPA
Ju A%& S'( O)* N&+ D-) En' "'.
7/25/2019 Flujo de ventas.xlsx
8/14
15 16 17 18 19 20 21 22
4 4 4 3 2 2 2 3
2 2 2 2 2 2 2 2
2 2 2 2 2 2 2 2
1 1 1 1 1 1 1 1
! ! !
1ra etapa 15!
RA ETAPA
Ju A%& S'( O)* N&+ D-) En' "'.
15 16 17 18 19 20 21 22
136,000 136,000 136,000 102,000 6,000 6,000 6,000 102,0006,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
34,000 34,000 34,000 34,000 34,000 34,000 34,000 34,000
306,000 306,000 306,000 2!2,000 23,000 23,000 23,000 2!2,000
Ju A%& S'( O)* N&+ D-) En' "'.
15 16 17 18 19 20 21 22
102,000 102,000 102,000 5,200 ,400 ,400 ,400 5,200
2!,200 2!,200 2!,200 20,400 13,600 13,600 13,600 20,400
13,600 13,600 13,600 13,600 13,600 13,600 13,600 13,600
2!,200 2!,200 2!,200 2!,200 2!,200 2!,200 2!,200 2!,200
34,000 34,000 34,000 34,000 34,000 34,000 34,000 34,000
136,000 163,200 163,200 163,200 136,000 45,200 10,00 10,00
1,600 10,00 10,00 10,00 1,600 54,400 54,400 54,400
54,400 54,400 54,400 54,400 54,400 54,400 54,400 54,400
36,400
23,000 265,200 265,200 25,400 224,400 1!,200 204,000
7/25/2019 Flujo de ventas.xlsx
9/14
VENTA DE SE#UNDA ET
2,015
Ma/ A./ May Jun Ju A%& S'( O)*
7/25/2019 Flujo de ventas.xlsx
10/14
23 24 25 26 27 28 29 30
3 3 3 3 4 4 4 3
2 2 2 2 2 2 2 2
2 2 2 2 2 2 2 2
1 1 1 1 1 1 1 1
VENTA DE SE#UNDA ET
2,015
Ma/ A./ May Jun Ju A%& S'( O)*
23 24 25 26 27 28 29 30
102,000 102,000 102,000 102,000 136,000 136,000 136,000 102,0006,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
34,000 34,000 34,000 34,000 34,000 34,000 34,000 34,000
2!2,000 2!2,000 2!2,000 2!2,000 306,000 306,000 306,000 2!2,000
2,015
Ma/ A./ May Jun Ju A%& S'( O)*
23 24 25 26 27 28 29 30
5,200 5,200 5,200 5,200 102,000 102,000 102,000 5,200
20,400 20,400 20,400 20,400 2!,200 2!,200 2!,200 20,400
13,600 13,600 13,600 13,600 13,600 13,600 13,600 13,600
2!,200 2!,200 2!,200 2!,200 2!,200 2!,200 2!,200 2!,200
34,000 34,000 34,000 34,000 34,000 34,000 34,000 34,000
136,000 136,000 136,000 136,000 136,000 163,200 163,200 163,200
1,600 1,600 1,600 1,600 1,600 10,00 10,00 10,00
54,400 54,400 54,400 54,400 54,400 54,400 54,400 54,400
231,200 231,200 231,200 231,200 23,000 265,200 265,200 25,400
7/25/2019 Flujo de ventas.xlsx
11/14
PA
2,016
N&+ D-) En' "'. Ma/ A./ May
7/25/2019 Flujo de ventas.xlsx
12/14
31 32 33 34 35 36 37
2 2 2 3 3 3 3
2 2 2 2 2 2 2
2 2 2 2 2 2 2
1 1 1 1 1 1 1
! ! !
PA
2,016
N&+ D-) En' "'. Ma/ A./ May
31 32 33 34 35 36 37
6,000 6,000 6,000 102,000 102,000 102,000 102,0006,000 6,000 6,000 6,000 6,000 6,000 6,000
6,000 6,000 6,000 6,000 6,000 6,000 6,000
34,000 34,000 34,000 34,000 34,000 34,000 34,000
23,000 23,000 23,000 2!2,000 2!2,000 2!2,000 2!2,000
2,016
N&+ D-) En' "'. Ma/ A./ May Jun
31 32 33 34 35 36 37 38
,400 ,400 ,400 5,200 5,200 5,200 5,200 0
13,600 13,600 13,600 20,400 20,400 20,400 20,400 0
13,600 13,600 13,600 13,600 13,600 13,600 13,600 0
2!,200 2!,200 2!,200 2!,200 2!,200 2!,200 2!,200 0
34,000 34,000 34,000 34,000 34,000 34,000 34,000 0
136,000 10,00 10,00 10,00 136,000 136,000 136,000 !34,400
1,600 54,400 54,400 54,400 1,600 1,600 1,600 1,600
54,400 54,400 54,400 54,400 54,400 54,400 54,400 0
652,00
224,400 1!,200 1!,200 204,000 231,200 231,200 231,200 !34,400
7/25/2019 Flujo de ventas.xlsx
13/14
TOTAL
7/25/2019 Flujo de ventas.xlsx
14/14
111
64
!3
3!
25
TOTAL
3,!!4,0002,1!6,000
2,42,000
1,25,000
,60,000
TOTAL
3,440,00
6,24,200
,60,000
Recommended