Download pdf - Flujo de ventas.xlsx

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$


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


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


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


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


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


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


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/14

RA ETAPA

Ju A%& S'( O)* N&+ D-) En' "'.


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


9/14

VENTA DE SE#UNDA ET

2,015

Ma/ A./ May Jun Ju A%& S'( O)*


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


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


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


11/14

PA

2,016

N&+ D-) En' "'. Ma/ A./ May


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


13/14

TOTAL


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