Ejercicio-1.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ejercicio-1.xlsx as PDF for free.
More details
- Words: 895
- Pages: 7
PERIODOS PRECIO DEMANDA
0
Valor libro construcción
75,000
Valor libro máquinaria 1 Valor libro maáquinaria 2
25,000
1 11.9 11,800
2 3 11.9 11.9 13,570 14,656 < =C3*(1+15%) < =D3*(1+8%) 73,335 71,707 70,115 < =B5-C10 22,500
20,000
17,500
1 140,420
2 161,483
3 174,402
94,400 2,144
108,560 2,144
117,245 2,144
1,665 2,500
1,628 2,500
1,592 2,500
39,711 13,105 26,606 1,665 2,500
46,651 15,395 31,256 1,628 2,500
50,921 16,804 34,117 1,592 2,500
7,080.00 23,691
4,342.40 31,042
38,209
23,691
54,733
92,942
< =$B$7-C9*($B$7/10) PERIODOS (+) INGRESOS (+) VENTA ACTIVO (-) Costos variables (-) Costos fijos (-) Depreciación Construcción (-) Depreciación maquinaria (-) Valor libro UAI (-) Impuestos 33% UDI (+) Depreciación Construcción (+) Depreciación maquinaria (-) Terrenos (-) Construcciones (-) Maquinaria (-) Capital de trabajo FLUJO DE CAJA PERIODO DE RECUPERACIÓN TIO VPN TIR RBC PERIODO DE RECUPERACIÓN
0
-
-
40,000 75,000 25,000 48,272 188,272
35% - 127,780.58 NO ES VIABLE -9% NO ES VIABLE 0.32 NO ES VIABLE 3.22 AÑOS
< =VNA(B31;C27:L27)+B27 < = TIR(B27:L27;0,95) < =VNA(B31;C27:L27) / - B27
4 12.5 15,095 < =E3*(1+3%) 68,559 15,000
5 12.5 15,548
6 12.5 16,015
7 12.5 16,495
8 12.5 16,990
9 12.5 17,500
10 12.5 18,025
67,037
65,548
64,093
62,670
61,279
59,919
12,500
10,000
7,500
5,000 25,000
22,500
20,000
8 212,373 15,000 135,919 2,144
9 218,744
10 225,307
139,996 2,144
144,196 2,144
1,391 2,500
1,360 2,500
72,713 23,995 48,718 1,391 2,500
75,106 24,785 50,321 1,360 2,500
4 188,691
5 194,352
6 200,182
7 206,188
120,762 2,144
124,385 2,144
128,117 2,144
131,960 2,144
1,557 2,500
1,522 2,500
1,488 2,500
1,455 2,500
61,728 20,370 41,358 1,557 2,500
63,801 21,054 42,746 1,522 2,500
65,933 21,758 44,175 1,488 2,500
68,128 22,482 45,646 1,455 2,500
1,423 2,500 5,000 80,387 26,528 53,860 1,423 2,500
301,938
25,000
45,414
46,768
48,164 -
252,337
32,782
52,609
54,181
138,356
185,125
233,288 -
19,048
13,734
66,343
120,524
0.25 0.75
0.25 1
0.22
-
AÑO
1.10 0.25 0.25
0.25 0.5
Dólar hoy Salario
3095.1 828116 267.5571
PERIODOS PRECIO DEMANDA VALOR CONTABLE CONSTRUCCIÓN VALOR CONTABLE MÁQUINARIA VALOR CONTABLE MÁQUINARIA 2
PERIODOS (+) INGRESOS (+) INGRESOS NO OPERACIONALES (-) COSTOS VARIABLES (-) COSTOS FIJOS (-) DEPRECIACIÓN CONSTRUCCIÓN (-) DEPRECIACIÓN MÁQUINARIA (-) VALOR EN LIBRO UAI (-) IMPUESTOS 33% UDI (+) DEPRECIACIÓN CONSTRUCCIÓN (+) DEPRECIACIÓN MÁQUINARIA (+) VALOR EN LIBRO (-) TERRENOS (-) CONSTRUCCIONES (-) MÁQUINARIA (-) CAPITAL DE TRABAJO (+) VALOR RESIDUAL FLUJO DE CAJA TIO VPN TIR
0
1 11.9 11,800
2 11.9 13,570
3 11.9 14,656
4 12.5 15,095
75,000 25,000
73,335 22,500
71,707 20,000
70,115 17,500
68,559 15,000
0
94,400 2,120 1,665 2,500
108,560 2,240 1,628 2,500
117,245 2,366 1,592 2,500
120,762 2,500 1,557 2,500
39,735 13,113 26,622 1,665 2,500
46,555 15,363 31,192 1,628 2,500
50,699 16,731 33,968 1,592 2,500
61,372 20,253 41,119 1,557 2,500
40,000 75,000 25,000 48,260
7,139.89
4,405.67
1,825.52
1,882.06
188,260
23,648
30,914
36,234
43,294
-
-
-
1 140,420
CONSTRUCCIÓN FLUJO DE CAJA 2 3 4 161,483 174,402 188,691
35% 83,997.47 NO ES VIABLE 20% NO ES VIABLE
El capital de trabajo corresponde a seis meses de operación.
5 12.5 15,548
6 12.5 16,015
7 12.5 16,495
8 12.5 16,990
9 12.5 17,500
10 12.5 18,025
67,037 12,500
65,548 10,000
64,093 7,500
62,670 5,000 25,000
61,279 2,500 22,500
59,919 20,000
5 194,352
6 200,182
7 206,188
9 218,744
10 225,307
124,385 2,641 1,522 2,500
128,117 2,791 1,488 2,500
131,960 2,948 1,455 2,500
139,996 3,291 1,391 2,500
144,196 3,477 1,360 2,500
63,303 20,890 42,413 1,522 2,500
65,287 21,545 43,742 1,488 2,500
67,324 22,217 45,107 1,455 2,500
8 212,373 15,000 135,919 3,115 1,423 2,500 5,000 79,417 26,208 53,209 1,423 2,500 5,000
71,566 23,617 47,949 1,391 2,500
73,773 24,345 49,428 1,360 2,500
1,940.39
2,000.58
2,062.69
25,000 2,126.77
44,495
45,730
47,000
35,005
FLUJO DE CAJA
2,192.91 49,648
73,836.48 119,919 247,044
PERIODOS PRECIO DEMANDA VALOR CONTABLE CONSTRUCCIÓN VALOR CONTABLE MÁQUINARIA 1 VALOR CONTABLE MÁQUINARIA 2
PERIODOS (+) INGRESOS OPERACIONALES (+) VENTA ACTIVOS (-) COSTOS VARIABLES (-) COSTOS FIJOS (-) DEPRECIACIÓN CONSTRUCCIÓN (-) DEPRECIACIÓN MAQUINARIA (-) VALOR EN LIBRO
UAI (-) IMPUESTO 33% UDI (+) DEPRECIACIÓN CONSTRUCCIÓN (+) DEPRECIACIÓN MAQUINARIA (+) VALOR EN LIBRO (-) TERRENOS (-) CONSTRUCCIONES (-) MAQUINARIA (-) CAPITAL DE TRABAJO (+) VALOR RESIDUAL
FLUJO DE CAJA
0
1 11.9 11,800
2 11.9 13,570
3 11.9 14,656
75,000 25,000
73,335 22,500
71,707 20,000
70,115 17,500
0 -
1 140,420
CONSTRUCCIÓN FLUJO DE CAJA 2 3 161,483 174,402
94,400 2,144 1,665 2,500
108,560 2,265 1,628 2,500
117,245 2,393 1,592 2,500
-
39,711
46,530
50,672
-
13,104.63
15,355
16,722
-
26,606
31,175
33,950
1,665 2,500
1,628 2,500
1,592 2,500
40,000 75,000 25,000 48,272
7,140.57
4,406.39
1,826.28
- 188,272
23,631
30,897
36,216
4 12.5 15,095
5 12.5 15,548
6 12.5 16,015
7 12.5 16,495
8 12.5 16,990
9 12.5 17,500
10 12.5 18,025
68,559 15,000
67,037 12,500
65,548 10,000
64,093 7,500
62,670 5,000 25,000
61,279
59,919
22,500
20,000
8 212,373 15,000 135,919 3,150 1,423 2,500 5,000
9 218,744
10 225,307
139,996 3,328 1,391 2,500
144,196 3,516 1,360 2,500
NSTRUCCIÓN FLUJO DE CAJA 4 5 188,691 194,352
6 200,182
7 206,188
120,762 2,528 1,557 2,500
124,385 2,671 1,522 2,500
128,117 2,822 1,488 2,500
131,960 2,982 1,455 2,500
61,344
63,273
65,255
67,291
79,381
71,529
73,734
20,243
20,880
21,534
22,206
26,196
23,604
24,332
41,100
42,393
43,721
45,085
53,186
47,924
49,402
1,557 2,500
1,522 2,500
1,488 2,500
1,455 2,500
1,423 2,500 5,000
1,391 2,500
1,360 2,500
1,882.86
1,941.24
2,001.47
2,063.63
25,000 2,127.77
2,193.96 -
43,274
44,474
45,708
46,976
34,981
49,622
73,856 119,919
247,037
0
Valor libro construcción
75,000
Valor libro máquinaria 1 Valor libro maáquinaria 2
25,000
1 11.9 11,800
2 3 11.9 11.9 13,570 14,656 < =C3*(1+15%) < =D3*(1+8%) 73,335 71,707 70,115 < =B5-C10 22,500
20,000
17,500
1 140,420
2 161,483
3 174,402
94,400 2,144
108,560 2,144
117,245 2,144
1,665 2,500
1,628 2,500
1,592 2,500
39,711 13,105 26,606 1,665 2,500
46,651 15,395 31,256 1,628 2,500
50,921 16,804 34,117 1,592 2,500
7,080.00 23,691
4,342.40 31,042
38,209
23,691
54,733
92,942
< =$B$7-C9*($B$7/10) PERIODOS (+) INGRESOS (+) VENTA ACTIVO (-) Costos variables (-) Costos fijos (-) Depreciación Construcción (-) Depreciación maquinaria (-) Valor libro UAI (-) Impuestos 33% UDI (+) Depreciación Construcción (+) Depreciación maquinaria (-) Terrenos (-) Construcciones (-) Maquinaria (-) Capital de trabajo FLUJO DE CAJA PERIODO DE RECUPERACIÓN TIO VPN TIR RBC PERIODO DE RECUPERACIÓN
0
-
-
40,000 75,000 25,000 48,272 188,272
35% - 127,780.58 NO ES VIABLE -9% NO ES VIABLE 0.32 NO ES VIABLE 3.22 AÑOS
< =VNA(B31;C27:L27)+B27 < = TIR(B27:L27;0,95) < =VNA(B31;C27:L27) / - B27
4 12.5 15,095 < =E3*(1+3%) 68,559 15,000
5 12.5 15,548
6 12.5 16,015
7 12.5 16,495
8 12.5 16,990
9 12.5 17,500
10 12.5 18,025
67,037
65,548
64,093
62,670
61,279
59,919
12,500
10,000
7,500
5,000 25,000
22,500
20,000
8 212,373 15,000 135,919 2,144
9 218,744
10 225,307
139,996 2,144
144,196 2,144
1,391 2,500
1,360 2,500
72,713 23,995 48,718 1,391 2,500
75,106 24,785 50,321 1,360 2,500
4 188,691
5 194,352
6 200,182
7 206,188
120,762 2,144
124,385 2,144
128,117 2,144
131,960 2,144
1,557 2,500
1,522 2,500
1,488 2,500
1,455 2,500
61,728 20,370 41,358 1,557 2,500
63,801 21,054 42,746 1,522 2,500
65,933 21,758 44,175 1,488 2,500
68,128 22,482 45,646 1,455 2,500
1,423 2,500 5,000 80,387 26,528 53,860 1,423 2,500
301,938
25,000
45,414
46,768
48,164 -
252,337
32,782
52,609
54,181
138,356
185,125
233,288 -
19,048
13,734
66,343
120,524
0.25 0.75
0.25 1
0.22
-
AÑO
1.10 0.25 0.25
0.25 0.5
Dólar hoy Salario
3095.1 828116 267.5571
PERIODOS PRECIO DEMANDA VALOR CONTABLE CONSTRUCCIÓN VALOR CONTABLE MÁQUINARIA VALOR CONTABLE MÁQUINARIA 2
PERIODOS (+) INGRESOS (+) INGRESOS NO OPERACIONALES (-) COSTOS VARIABLES (-) COSTOS FIJOS (-) DEPRECIACIÓN CONSTRUCCIÓN (-) DEPRECIACIÓN MÁQUINARIA (-) VALOR EN LIBRO UAI (-) IMPUESTOS 33% UDI (+) DEPRECIACIÓN CONSTRUCCIÓN (+) DEPRECIACIÓN MÁQUINARIA (+) VALOR EN LIBRO (-) TERRENOS (-) CONSTRUCCIONES (-) MÁQUINARIA (-) CAPITAL DE TRABAJO (+) VALOR RESIDUAL FLUJO DE CAJA TIO VPN TIR
0
1 11.9 11,800
2 11.9 13,570
3 11.9 14,656
4 12.5 15,095
75,000 25,000
73,335 22,500
71,707 20,000
70,115 17,500
68,559 15,000
0
94,400 2,120 1,665 2,500
108,560 2,240 1,628 2,500
117,245 2,366 1,592 2,500
120,762 2,500 1,557 2,500
39,735 13,113 26,622 1,665 2,500
46,555 15,363 31,192 1,628 2,500
50,699 16,731 33,968 1,592 2,500
61,372 20,253 41,119 1,557 2,500
40,000 75,000 25,000 48,260
7,139.89
4,405.67
1,825.52
1,882.06
188,260
23,648
30,914
36,234
43,294
-
-
-
1 140,420
CONSTRUCCIÓN FLUJO DE CAJA 2 3 4 161,483 174,402 188,691
35% 83,997.47 NO ES VIABLE 20% NO ES VIABLE
El capital de trabajo corresponde a seis meses de operación.
5 12.5 15,548
6 12.5 16,015
7 12.5 16,495
8 12.5 16,990
9 12.5 17,500
10 12.5 18,025
67,037 12,500
65,548 10,000
64,093 7,500
62,670 5,000 25,000
61,279 2,500 22,500
59,919 20,000
5 194,352
6 200,182
7 206,188
9 218,744
10 225,307
124,385 2,641 1,522 2,500
128,117 2,791 1,488 2,500
131,960 2,948 1,455 2,500
139,996 3,291 1,391 2,500
144,196 3,477 1,360 2,500
63,303 20,890 42,413 1,522 2,500
65,287 21,545 43,742 1,488 2,500
67,324 22,217 45,107 1,455 2,500
8 212,373 15,000 135,919 3,115 1,423 2,500 5,000 79,417 26,208 53,209 1,423 2,500 5,000
71,566 23,617 47,949 1,391 2,500
73,773 24,345 49,428 1,360 2,500
1,940.39
2,000.58
2,062.69
25,000 2,126.77
44,495
45,730
47,000
35,005
FLUJO DE CAJA
2,192.91 49,648
73,836.48 119,919 247,044
PERIODOS PRECIO DEMANDA VALOR CONTABLE CONSTRUCCIÓN VALOR CONTABLE MÁQUINARIA 1 VALOR CONTABLE MÁQUINARIA 2
PERIODOS (+) INGRESOS OPERACIONALES (+) VENTA ACTIVOS (-) COSTOS VARIABLES (-) COSTOS FIJOS (-) DEPRECIACIÓN CONSTRUCCIÓN (-) DEPRECIACIÓN MAQUINARIA (-) VALOR EN LIBRO
UAI (-) IMPUESTO 33% UDI (+) DEPRECIACIÓN CONSTRUCCIÓN (+) DEPRECIACIÓN MAQUINARIA (+) VALOR EN LIBRO (-) TERRENOS (-) CONSTRUCCIONES (-) MAQUINARIA (-) CAPITAL DE TRABAJO (+) VALOR RESIDUAL
FLUJO DE CAJA
0
1 11.9 11,800
2 11.9 13,570
3 11.9 14,656
75,000 25,000
73,335 22,500
71,707 20,000
70,115 17,500
0 -
1 140,420
CONSTRUCCIÓN FLUJO DE CAJA 2 3 161,483 174,402
94,400 2,144 1,665 2,500
108,560 2,265 1,628 2,500
117,245 2,393 1,592 2,500
-
39,711
46,530
50,672
-
13,104.63
15,355
16,722
-
26,606
31,175
33,950
1,665 2,500
1,628 2,500
1,592 2,500
40,000 75,000 25,000 48,272
7,140.57
4,406.39
1,826.28
- 188,272
23,631
30,897
36,216
4 12.5 15,095
5 12.5 15,548
6 12.5 16,015
7 12.5 16,495
8 12.5 16,990
9 12.5 17,500
10 12.5 18,025
68,559 15,000
67,037 12,500
65,548 10,000
64,093 7,500
62,670 5,000 25,000
61,279
59,919
22,500
20,000
8 212,373 15,000 135,919 3,150 1,423 2,500 5,000
9 218,744
10 225,307
139,996 3,328 1,391 2,500
144,196 3,516 1,360 2,500
NSTRUCCIÓN FLUJO DE CAJA 4 5 188,691 194,352
6 200,182
7 206,188
120,762 2,528 1,557 2,500
124,385 2,671 1,522 2,500
128,117 2,822 1,488 2,500
131,960 2,982 1,455 2,500
61,344
63,273
65,255
67,291
79,381
71,529
73,734
20,243
20,880
21,534
22,206
26,196
23,604
24,332
41,100
42,393
43,721
45,085
53,186
47,924
49,402
1,557 2,500
1,522 2,500
1,488 2,500
1,455 2,500
1,423 2,500 5,000
1,391 2,500
1,360 2,500
1,882.86
1,941.24
2,001.47
2,063.63
25,000 2,127.77
2,193.96 -
43,274
44,474
45,708
46,976
34,981
49,622
73,856 119,919
247,037
More Documents from "Karen Torres"
Ejercicio-1.xlsx
April 2020 4
Actividad6.docx
May 2020 7
Rapport De Stage D'observation.docx
December 2019 27
