Nothing Special   »   [go: up one dir, main page]

Capitulo Vi

Descargar como docx, pdf o txt
Descargar como docx, pdf o txt
Está en la página 1de 3

CAPITULO VI: Solución deseable, factible y viable

6.3.2. Análisis financiero

Pasivo
Activo
S/ 500,000
S/ 1'000,000 (Total)

S/ 200,000 (CT)
Patrimonio neto
S/ 800,000 (PPE)
S/ 500,000

Crecimiento de ventas 15%


Proporción de costo de ventas 60%

0 1 2 3 4 5
Ventas S/ 1,500,000.00 S/ 1,725,000.00 S/ 1,983,750.00 S/ 2,281,312.50 S/ 2,623,509.38
(Costo de ventas) -S/ 900,000.00 -S/ 1,035,000.00 -S/ 1,190,250.00 -S/ 1,368,787.50 -S/ 1,574,105.63
Utilidad bruta S/ 600,000.00 S/ 690,000.00 S/ 793,500.00 S/ 912,525.00 S/ 1,049,403.75
(Gastos administrativos) -S/ 120,000.00 -S/ 120,000.00 -S/ 120,000.00 -S/ 120,000.00 -S/ 120,000.00
(Gastos de ventas) -S/ 150,000.00 -S/ 150,000.00 -S/ 150,000.00 -S/ 150,000.00 -S/ 150,000.00
(Depreciación) -S/ 50,000.00 -S/ 50,000.00 -S/ 50,000.00 -S/ 50,000.00 -S/ 50,000.00
(Amortización) S/ 0.00 S/ 0.00 S/ 0.00 S/ 0.00 S/ 0.00
Utilidad operativa S/ 280,000.00 S/ 370,000.00 S/ 473,500.00 S/ 592,525.00 S/ 729,403.75
(Gastos financieros) -S/ 61,413.61 -S/ 50,823.76 -S/ 38,751.33 -S/ 24,988.77 -S/ 9,299.44
Utilidad antes de impuestos S/ 218,586.39 S/ 319,176.24 S/ 434,748.67 S/ 567,536.23 S/ 720,104.31
(Impuesto a la renta) -S/ 64,482.99 -S/ 94,156.99 -S/ 128,250.86 -S/ 167,423.19 -S/ 212,430.77
Utilidad neta S/ 154,103.41 S/ 225,019.25 S/ 306,497.81 S/ 400,113.04 S/ 507,673.54

0 1 2 3 4 5
Ventas S/ 1,500,000.00 S/ 1,725,000.00 S/ 1,983,750.00 S/ 2,281,312.50 S/ 2,623,509.38
(Costo de ventas) -S/ 900,000.00 -S/ 1,035,000.00 -S/ 1,190,250.00 -S/ 1,368,787.50 -S/ 1,574,105.63
Utilidad bruta S/ 600,000.00 S/ 690,000.00 S/ 793,500.00 S/ 912,525.00 S/ 1,049,403.75
(Gastos administrativos) -S/ 120,000.00 -S/ 120,000.00 -S/ 120,000.00 -S/ 120,000.00 -S/ 120,000.00
(Gastos de ventas) -S/ 150,000.00 -S/ 150,000.00 -S/ 150,000.00 -S/ 150,000.00 -S/ 150,000.00
(Depreciación) -S/ 50,000.00 -S/ 50,000.00 -S/ 50,000.00 -S/ 50,000.00 -S/ 50,000.00
(Amortización) S/ 0.00 S/ 0.00 S/ 0.00 S/ 0.00 S/ 0.00
Utilidad operativa S/ 280,000.00 S/ 370,000.00 S/ 473,500.00 S/ 592,525.00 S/ 729,403.75
Impuesto a la renta -S/ 82,600.00 -S/ 109,150.00 -S/ 139,682.50 -S/ 174,794.88 -S/ 215,174.11
Net operating profit after tax (NOPAT) S/ 197,400.00 S/ 260,850.00 S/ 333,817.50 S/ 417,730.13 S/ 514,229.64
Depreciación S/ 50,000.00 S/ 50,000.00 S/ 50,000.00 S/ 50,000.00 S/ 50,000.00
Amortización S/ 0.00 S/ 0.00 S/ 0.00 S/ 0.00 S/ 0.00
Capital de trabajo -S/ 200,000.00
Capital expenditure (CAPEX) -S/ 800,000.00
Flujo de caja libre o económico -S/ 1,000,000.00 S/ 247,400.00 S/ 310,850.00 S/ 383,817.50 S/ 467,730.13 S/ 564,229.64
Préstamo S/ 500,000.00 -S/ 75,641.77 -S/ 86,231.62 -S/ 98,304.05 -S/ 112,066.62 -S/ 127,755.94
Gastos financieros -S/ 61,413.61 -S/ 50,823.76 -S/ 38,751.33 -S/ 24,988.77 -S/ 9,299.44
Escudo fiscal S/ 18,117.01 S/ 14,993.01 S/ 11,431.64 S/ 7,371.69 S/ 2,743.34
Flujo de caja del accionista o financiero -S/ 500,000.00 S/ 128,461.63 S/ 188,787.63 S/ 258,193.76 S/ 338,046.43 S/ 429,917.60

Rendimiento libre de riesgo (Rf) 4.27% https://www.marketwatch.com/investing/bond/tmubmusd05y?countrycode=bx


Beta desapalancado 0.74 https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/Betas.html?destination=node/82181%3Fs%3D%25EC%2582%25AC%25EC

Deuda/Patrimonio 1
(1 - Impuesto a la renta) 0.705

Beta apalancado 1.2617 Bu*(1+(D/E)*(1-T))

(Rm - Rf) 6.94% https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html


Riesgo país (Rp) 2.34% https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html
Inflación (Inf) 2.00% https://www.bcrp.gob.pe

Capital asset pricing model (CAPM) 17.37019800% Rf + B*(Rm - Rf) + Inf + Rp


0 1 2 3 4 5
Flujo de caja del accionista -S/ 500,000.00 S/ 128,461.63 S/ 188,787.63 S/ 258,193.76 S/ 338,046.43 S/ 429,917.60
Valores actuales -S/ 500,000.00 S/ 109,449.96 S/ 137,043.31 S/ 159,687.98 S/ 178,133.25 S/ 193,017.21
VAN financiero S/ 277,331.72
TIR 35.12%
Período de recuperación descontado -S/ 500,000.00 -S/ 390,550.04 -S/ 253,506.73 -S/ 93,818.75 S/ 84,314.51 S/ 277,331.72
Índice de rentabilidad 55.47%

Vamos a suponer que el proyecto genera una sinergia o una


eficiencia que permite ahorrar 180 toneladas de CO2
emitido al año.

El Banco Mundial calcula que para que el planeta vuelva a


niveles normales de CO2, la tonelada de CO2 debería ser
cuantificada en US$ 100.00 para 2050.

Beneficio de emitir menos CO2 S/ 66,600.00 S/ 66,600.00 S/ 66,600.00 S/ 66,600.00 S/ 66,600.00

Vamos a suponer que el proyecto permite que las personas


involucradas se trasladarán 5 km menos por día en
transporte público. Son 100 personas.

Beneficio de emitir menos CO2 en transporte público S/ 9,377.28 S/ 9,377.28 S/ 9,377.28 S/ 9,377.28 S/ 9,377.28
132000

Vamos a suponer que una persona tiene que viajar en avión


una vez a la semana 1,000 km ida y vuelta producto del
negocio

Costo social de emitir CO2 en desplazamientos aéreos -S/ 5,541.12 -S/ 5,541.12 -S/ 5,541.12 -S/ 5,541.12 -S/ 5,541.12

Beneficio neto social S/ 70,436.16 S/ 70,436.16 S/ 70,436.16 S/ 70,436.16 S/ 70,436.16

Tasa de descuento social 8% https://www.mef.gob.pe/contenidos/inv_publica/anexos/anexo11_directiva001_2019EF6301.pdf

Valores actuales S/ 65,218.67 S/ 60,387.65 S/ 55,914.49 S/ 51,772.68 S/ 47,937.67

VAN social S/ 281,231.16

Pasivo S/ 500,000.00
Patrimonio neto S/ 500,000.00 S/ 1,000,000.00

Costo de la deuda 14.00%


Costo del patrimonio 17.37%
Impuesto a la renta 29.50%

WACC 13.62%

Cronograma de pagos
Monto S/ 500,000.00
TEA 14%
TEM 1.10%
Períodos 5 años
60 meses

Período Saldo inicial Intereses Cuota Amortización Saldo final


0 S/ 500,000.00
1 S/ 500,000.00 -S/ 5,489.43 -S/ 11,421.28 -S/ 5,931.86 S/ 494,068.14
2 S/ 494,068.14 -S/ 5,424.30 -S/ 11,421.28 -S/ 5,996.98 S/ 488,071.16
3 S/ 488,071.16 -S/ 5,358.46 -S/ 11,421.28 -S/ 6,062.82 S/ 482,008.34
4 S/ 482,008.34 -S/ 5,291.90 -S/ 11,421.28 -S/ 6,129.38 S/ 475,878.96
5 S/ 475,878.96 -S/ 5,224.60 -S/ 11,421.28 -S/ 6,196.68 S/ 469,682.28
6 S/ 469,682.28 -S/ 5,156.57 -S/ 11,421.28 -S/ 6,264.71 S/ 463,417.57
7 S/ 463,417.57 -S/ 5,087.79 -S/ 11,421.28 -S/ 6,333.49 S/ 457,084.08
8 S/ 457,084.08 -S/ 5,018.26 -S/ 11,421.28 -S/ 6,403.02 S/ 450,681.06
9 S/ 450,681.06 -S/ 4,947.96 -S/ 11,421.28 -S/ 6,473.32 S/ 444,207.74
10 S/ 444,207.74 -S/ 4,876.89 -S/ 11,421.28 -S/ 6,544.39 S/ 437,663.35
11 S/ 437,663.35 -S/ 4,805.04 -S/ 11,421.28 -S/ 6,616.24 S/ 431,047.11
12 S/ 431,047.11 -S/ 4,732.40 -S/ 11,421.28 -S/ 6,688.88 S/ 424,358.23
13 S/ 424,358.23 -S/ 4,658.97 -S/ 11,421.28 -S/ 6,762.32 S/ 417,595.91
14 S/ 417,595.91 -S/ 4,584.72 -S/ 11,421.28 -S/ 6,836.56 S/ 410,759.35
15 S/ 410,759.35 -S/ 4,509.67 -S/ 11,421.28 -S/ 6,911.62 S/ 403,847.74
16 S/ 403,847.74 -S/ 4,433.78 -S/ 11,421.28 -S/ 6,987.50 S/ 396,860.24
17 S/ 396,860.24 -S/ 4,357.07 -S/ 11,421.28 -S/ 7,064.21 S/ 389,796.03
18 S/ 389,796.03 -S/ 4,279.51 -S/ 11,421.28 -S/ 7,141.77 S/ 382,654.26
19 S/ 382,654.26 -S/ 4,201.10 -S/ 11,421.28 -S/ 7,220.18 S/ 375,434.08
20 S/ 375,434.08 -S/ 4,121.84 -S/ 11,421.28 -S/ 7,299.45 S/ 368,134.63
21 S/ 368,134.63 -S/ 4,041.70 -S/ 11,421.28 -S/ 7,379.59 S/ 360,755.05
22 S/ 360,755.05 -S/ 3,960.68 -S/ 11,421.28 -S/ 7,460.61 S/ 353,294.44
23 S/ 353,294.44 -S/ 3,878.77 -S/ 11,421.28 -S/ 7,542.51 S/ 345,751.93
24 S/ 345,751.93 -S/ 3,795.96 -S/ 11,421.28 -S/ 7,625.32 S/ 338,126.61
25 S/ 338,126.61 -S/ 3,712.24 -S/ 11,421.28 -S/ 7,709.04 S/ 330,417.57
26 S/ 330,417.57 -S/ 3,627.61 -S/ 11,421.28 -S/ 7,793.68 S/ 322,623.89
27 S/ 322,623.89 -S/ 3,542.04 -S/ 11,421.28 -S/ 7,879.24 S/ 314,744.65
28 S/ 314,744.65 -S/ 3,455.53 -S/ 11,421.28 -S/ 7,965.75 S/ 306,778.90
29 S/ 306,778.90 -S/ 3,368.08 -S/ 11,421.28 -S/ 8,053.20 S/ 298,725.70
30 S/ 298,725.70 -S/ 3,279.67 -S/ 11,421.28 -S/ 8,141.62 S/ 290,584.08
31 S/ 290,584.08 -S/ 3,190.28 -S/ 11,421.28 -S/ 8,231.00 S/ 282,353.08
32 S/ 282,353.08 -S/ 3,099.91 -S/ 11,421.28 -S/ 8,321.37 S/ 274,031.71
33 S/ 274,031.71 -S/ 3,008.55 -S/ 11,421.28 -S/ 8,412.73 S/ 265,618.98
34 S/ 265,618.98 -S/ 2,916.19 -S/ 11,421.28 -S/ 8,505.09 S/ 257,113.89
35 S/ 257,113.89 -S/ 2,822.82 -S/ 11,421.28 -S/ 8,598.47 S/ 248,515.42
36 S/ 248,515.42 -S/ 2,728.41 -S/ 11,421.28 -S/ 8,692.87 S/ 239,822.56
37 S/ 239,822.56 -S/ 2,632.98 -S/ 11,421.28 -S/ 8,788.31 S/ 231,034.25
38 S/ 231,034.25 -S/ 2,536.49 -S/ 11,421.28 -S/ 8,884.79 S/ 222,149.46
39 S/ 222,149.46 -S/ 2,438.95 -S/ 11,421.28 -S/ 8,982.34 S/ 213,167.12
40 S/ 213,167.12 -S/ 2,340.33 -S/ 11,421.28 -S/ 9,080.95 S/ 204,086.17
41 S/ 204,086.17 -S/ 2,240.63 -S/ 11,421.28 -S/ 9,180.65 S/ 194,905.52
42 S/ 194,905.52 -S/ 2,139.84 -S/ 11,421.28 -S/ 9,281.44 S/ 185,624.08
43 S/ 185,624.08 -S/ 2,037.94 -S/ 11,421.28 -S/ 9,383.34 S/ 176,240.74
44 S/ 176,240.74 -S/ 1,934.92 -S/ 11,421.28 -S/ 9,486.36 S/ 166,754.38
45 S/ 166,754.38 -S/ 1,830.77 -S/ 11,421.28 -S/ 9,590.51 S/ 157,163.87
46 S/ 157,163.87 -S/ 1,725.48 -S/ 11,421.28 -S/ 9,695.80 S/ 147,468.06
47 S/ 147,468.06 -S/ 1,619.03 -S/ 11,421.28 -S/ 9,802.25 S/ 137,665.81
48 S/ 137,665.81 -S/ 1,511.41 -S/ 11,421.28 -S/ 9,909.87 S/ 127,755.94
49 S/ 127,755.94 -S/ 1,402.61 -S/ 11,421.28 -S/ 10,018.67 S/ 117,737.27
50 S/ 117,737.27 -S/ 1,292.62 -S/ 11,421.28 -S/ 10,128.66 S/ 107,608.61
51 S/ 107,608.61 -S/ 1,181.42 -S/ 11,421.28 -S/ 10,239.86 S/ 97,368.75
52 S/ 97,368.75 -S/ 1,069.00 -S/ 11,421.28 -S/ 10,352.28 S/ 87,016.46
53 S/ 87,016.46 -S/ 955.34 -S/ 11,421.28 -S/ 10,465.94 S/ 76,550.52
54 S/ 76,550.52 -S/ 840.44 -S/ 11,421.28 -S/ 10,580.85 S/ 65,969.68
55 S/ 65,969.68 -S/ 724.27 -S/ 11,421.28 -S/ 10,697.01 S/ 55,272.67
56 S/ 55,272.67 -S/ 606.83 -S/ 11,421.28 -S/ 10,814.45 S/ 44,458.22
57 S/ 44,458.22 -S/ 488.10 -S/ 11,421.28 -S/ 10,933.18 S/ 33,525.03
58 S/ 33,525.03 -S/ 368.07 -S/ 11,421.28 -S/ 11,053.22 S/ 22,471.82
59 S/ 22,471.82 -S/ 246.71 -S/ 11,421.28 -S/ 11,174.57 S/ 11,297.25
60 S/ 11,297.25 -S/ 124.03 -S/ 11,421.28 -S/ 11,297.25 S/ 0.00

También podría gustarte