ANUAL
Inversión: S/ 170,000,000.00
Tiempo: 10 AÑOS Con la 1° alternativa si voy a poder
Salvamento: S/ 30,000,000.00
Alquiler: S/ 24,000,000.00 1 Anual
Periocidad: 1 anual 2 Semestral
Durabilidad(V/A;0/1): 0 Vencida 3 Cuatrimestral
Duración 10 años 4 Trimestral
Valor Rescate S/ 30,000,000.00 6 Bimestral
Tasa Interés 8.00% anual 12 Mensual
Vr actual -S/ 174,937,758.22
0 Vencida
1 Anticipada
on la 1° alternativa si voy a poder cubrir mi inversión dado que el van supera a la inversión
Resumen del escenario
Valores actuales: BASE Cobro semestral
Celdas cambiantes:
$B$6 S/ 24,000,000.00 S/ 24,000,000.00 S/ 12,000,000.00
$B$7 1 1 2
Celdas de resultado:
$B$12 -S/ 174,937,758.22 -S/ 174,937,758.22 -S/ 176,775,524.53
Notas: La columna de valores actuales representa los valores de las celdas cambiantes
en el momento en que se creó el Informe resumen de escenario. Las celdas cambiantes de
cada escenario se muestran en gris.
Cobro Trimestral Cobro mensual
S/ 5,800,000.00 S/ 2,000,000.00
4 12
-S/ 172,248,492.05 -S/ 178,358,665.61
ldas cambiantes
eldas cambiantes de
ANUAL
Inversión: S/ 170,000,000.00
Tiempo: 10 AÑOS
Salvamento: S/ 30,000,000.00
Alquiler: S/ 24,000,000.00 1 Anual
Periocidad: 1 anual 2 Semestral
Durabilidad(V/A;0/1): 0 Vencida 3 Cuatrimestral
Duración 10 años 4 Trimestral
Valor Rescate S/ 30,000,000.00 6 Bimestral
Tasa Interés 8.00% anual 12 Mensual
Vr actual -S/ 174,937,758.22
0 Vencida
1 Anticipada
-S/ 174,937,758.22
3% -227047685.529522
3.5% -220866092.153164
4.0% -214928423.769295
4.5% -209223066.711545
5.0% -203739035.906658
5.5% -198465937.268963
6.0% -193393932.541406
6.5% -188513706.411882
7.0% -183816435.746424
7.5% -179293760.792575
8.0% -174937758.217135
8.5% -170740915.852454
9.0% -166696109.034687
9.5% -162796578.425903
10.0% -159035909.219798
10.5% -155408011.638001
11.0% -151907102.630623
11.5% -148527688.70092
12.0% -145264549.779582
Con la 1° alternativa si voy a poder cubrir mi inversión dado que el van supera a la inversión
uatrimestral
ANUAL
Inversión: S/ 170,000,000.00
Tiempo: 10 AÑOS
Salvamento: S/ 30,000,000.00
Alquiler: S/ 2,000,000.00 1 Anual
Periocidad: 12 anual 2 Semestral
Durabilidad(V/A;0/1): 0 Vencida 3 Cuatrimestral
Duración 10 años 4 Trimestral
Valor Rescate S/ 30,000,000.00 6 Bimestral
Tasa Interés 9.02% anual 12 Mensual
Vr actual -S/ 170,000,000.00
0 Vencida
1 Anticipada
-S/ 170,000,000.00
3% -S/ 229,356,374.69
3.5% -S/ 223,404,785.65
4.0% -S/ 217,663,332.23
4.5% -S/ 212,123,599.02
5.0% -S/ 206,777,531.87
5.5% -S/ 201,617,421.61
6.0% -S/ 196,635,888.66
6.5% -S/ 191,825,868.24
7.0% -S/ 187,180,596.31
7.5% -S/ 182,693,596.16
8.0% -S/ 178,358,665.61
8.5% -S/ 174,169,864.78
9.0% -S/ 170,121,504.49
9.5% -S/ 166,208,135.09
10.0% -S/ 162,424,535.90
10.5% -S/ 158,765,705.08
11.0% -S/ 155,226,849.99
11.5% -S/ 151,803,377.94
12.0% -S/ 148,490,887.45
Con la 1° alternativa si voy a poder cubrir mi inversión dado que el van supera a la inversión
**Para hallar exactamente la tasa que me da 170000000
uatrimestral ponemos en buscar objetivos, igualq ue en los anteriores , se encuentra en datos
y con ello se cambio, generando elv alor de 9.02%
-S/ 170,000,000.00 S/ 800,000.00 S/ 1,000,000.00 S/ 1,200,000.00 S/ 1,400,000.00
3% -105082270.985 -125794621.6021 -146506972.219 -167219322.8355
3.5% -102052763.28 -122278100.3414 -142503437.403 -162728774.4637
4.0% -99139122.4001 -118893157.3716 -138647192.343 -158401227.3145
4.5% -96336410.2407 -115634275.038 -134932139.835 -154230004.6326
5.0% -93639911.4716 -112496181.5372 -131352451.603 -150208721.6685
5.5% -91045123.1214 -109473839.5354 -127902555.949 -146331272.3633
6.0% -88547744.6627 -106562435.3281 -124577125.994 -142591816.659
6.5% -86143668.5715 -103757368.5154 -121371068.459 -138984768.4034
7.0% -83828971.3384 -101054242.1666 -118279512.995 -135504783.8232
7.5% -81599904.9095 -98448853.45138 -115297801.993 -132146750.5351
8.0% -79452888.536 -95937184.7147 -112421480.893 -128905777.0721
8.5% -77384501.0124 -93515394.9741 -109646288.936 -125777182.8974
9.0% -75391473.2847 -91179811.81848 -106968150.352 -122756488.8861
9.5% -73470681.4103 -88926923.68956 -104383165.969 -119839408.248
10.0% -71619139.8533 -86753372.52724 -101887605.201 -117021837.8751
10.5% -69833995.0972 -84655946.7613 -99477898.4254 -114299850.0895
11.0% -68112519.5618 -82631574.63295 -97150629.7041 -111669684.7753
11.5% -66452105.8077 -80677317.83019 -94902529.8527 -109127741.8752
12.0% -64850261.0157 -78790365.42198 -92730469.8283 -106670574.2345
ncuentra en datos
S/ 1,600,000.00 S/ 1,800,000.00 S/ 2,000,000.00 S/ 2,200,000.00 S/ 2,400,000.00 S/ 2,600,000.00
-187931673.4521 -208644024.069 -229356374.6855 -250068725.3021 -270781075.9188 -291493426.53548
-182954111.5249 -203179448.586 -223404785.6471 -243630122.7083 -263855459.7694 -284080796.83055
-178155262.286 -197909297.257 -217663332.2289 -237417367.2004 -257171402.1719 -276925437.14333
-173527869.4299 -192825734.227 -212123599.0245 -231421463.8218 -250719328.6191 -270017193.41639
-169064991.7341 -187921261.8 -206777531.8654 -225633801.9311 -244490071.9967 -263346342.06238
-164759988.7773 -183188705.191 -201617421.6053 -220046138.0193 -238474854.4333 -256903570.84731
-160606507.3244 -178621197.99 -196635888.6553 -214650579.3207 -232665269.9861 -250679960.65156
-156598468.3474 -174212168.291 -191825868.2354 -209439568.1793 -227053268.1233 -244666968.06732
-152730054.6515 -169955325.48 -187180596.308 -204405867.1363 -221631137.9646 -238856408.79284
-148995699.077 -165844647.619 -182693596.1608 -199542544.7027 -216391493.2445 -233240441.78642
-145390073.2507 -161874369.429 -178358665.6081 -194842961.7868 -211327257.9654 -227811554.14412
-141908076.8591 -158038970.821 -174169864.7825 -190300758.7441 -206431652.7058 -222562546.6675
-138544827.4199 -154333165.954 -170121504.4875 -185909843.0213 -201698181.5551 -217486520.08888
-135295650.5273 -150751892.806 -166208135.0857 -181664377.3649 -197120619.6442 -212576861.92341
-132156070.549 -147290303.223 -162424535.8969 -177558768.5708 -192693001.2448 -207827233.91869
-129121801.7535 -143943753.418 -158765705.0817 -173587656.7458 -188409608.4099 -203231560.07394
-126188739.8464 -140707794.918 -155226849.9887 -169745905.0599 -184264960.1311 -198784015.20221
-123352953.8977 -137578165.92 -151803377.9427 -166028589.9653 -180253801.9878 -194479014.01028
-120610678.6408 -134550783.047 -148490887.4534 -162430991.8597 -176371096.2659 -190311200.67221
S/ 2,800,000.00 S/ 3,000,000.00 S/ 3,200,000.00
-312205777.1522 -332918127.7688 -353630478.3855
-304306133.8917 -324531470.9528 -344756808.014
-296679472.1148 -316433507.0863 -336187542.0577
-289315058.2137 -308612923.011 -327910787.8083
-282202612.128 -301058882.1937 -319915152.2593
-275332287.2613 -293761003.6753 -312189720.0893
-268694651.317 -286709341.9824 -304724032.6479
-262280668.0113 -279894367.9553 -297508067.8993
-256081679.6211 -273306950.4494 -290532221.2777
-250089390.3283 -266938338.8702 -283787287.4121
-244295850.3228 -260780146.5015 -277264442.6801
-238693440.6292 -254824334.5908 -270955228.5525
-233274858.6227 -249063197.1565 -264851535.6903
-228033104.2026 -243489346.4819 -258945588.7611
-222961466.5926 -238095699.2666 -253229931.9405
-218053511.738 -232875463.4021 -247697415.0662
-213303070.2734 -227822125.3445 -242341180.4157
-208704226.0328 -222929438.0553 -237154650.0778
-204251305.0785 -218191409.4848 -232131513.8911
ANUAL
Inversión: S/ 170,000,000.00
Tiempo: 10 AÑOS
Salvamento: S/ 30,000,000.00
Alquiler: S/ 2,100,110.32 1 Anual
Periocidad: 12 anual 2 Semestral
Durabilidad(V/A;0/1): 0 Vencida 3 Cuatrimestral
Duración 10 años 4 Trimestral
Valor Rescate S/ 30,000,000.00 6 Bimestral
Tasa Interés 10.00% anual 12 Mensual
Vr actual -S/ 170,000,000.00
0 Vencida
1 Anticipada
-S/ 170,000,000.00
3% -S/ 239,723,974.55
3.5% -S/ 233,528,610.10
4.0% -S/ 227,551,245.68
4.5% -S/ 221,783,175.77
5.0% -S/ 216,216,067.67
5.5% -S/ 210,841,944.76
6.0% -S/ 205,653,170.56
6.5% -S/ 200,642,433.60
7.0% -S/ 195,802,732.87
7.5% -S/ 191,127,364.00
8.0% -S/ 186,609,906.13
8.5% -S/ 182,244,209.27
9.0% -S/ 178,024,382.31
9.5% -S/ 173,944,781.61
10.0% -S/ 170,000,000.00
10.5% -S/ 166,184,856.43
11.0% -S/ 162,494,385.97
11.5% -S/ 158,923,830.32
12.0% -S/ 155,468,628.76
ANUALES S/ 25,784,355.28
SEMESTRAL S/ 12,733,962.21
TRIMESTRAL S/ 6,327,072.64
MENSUALES S/ 2,100,110.32
Con la 1° alternativa si voy a poder cubrir mi inversión dado que el van supera a la inversión
**Para hallar exactamente la tasa que me da 170000000
uatrimestral ponemos en buscar objetivos, igualq ue en los anteriores , se encuentra en datos
y con ello se cambio, generando elv alor de 9.02%
-S/ 170,000,000.00 S/ 800,000.00 S/ 1,000,000.00 S/ 1,200,000.00 S/ 1,400,000.00
3% -105082270.985 -125794621.6021 -146506972.219 -167219322.8355
3.5% -102052763.28 -122278100.3414 -142503437.403 -162728774.4637
4.0% -99139122.4001 -118893157.3716 -138647192.343 -158401227.3145
4.5% -96336410.2407 -115634275.038 -134932139.835 -154230004.6326
5.0% -93639911.4716 -112496181.5372 -131352451.603 -150208721.6685
5.5% -91045123.1214 -109473839.5354 -127902555.949 -146331272.3633
6.0% -88547744.6627 -106562435.3281 -124577125.994 -142591816.659
6.5% -86143668.5715 -103757368.5154 -121371068.459 -138984768.4034
7.0% -83828971.3384 -101054242.1666 -118279512.995 -135504783.8232
7.5% -81599904.9095 -98448853.45138 -115297801.993 -132146750.5351
8.0% -79452888.536 -95937184.7147 -112421480.893 -128905777.0721
8.5% -77384501.0124 -93515394.9741 -109646288.936 -125777182.8974
9.0% -75391473.2847 -91179811.81848 -106968150.352 -122756488.8861
9.5% -73470681.4103 -88926923.68956 -104383165.969 -119839408.248
10.0% -71619139.8533 -86753372.52724 -101887605.201 -117021837.8751
10.5% -69833995.0972 -84655946.7613 -99477898.4254 -114299850.0895
11.0% -68112519.5618 -82631574.63295 -97150629.7041 -111669684.7753
11.5% -66452105.8077 -80677317.83019 -94902529.8527 -109127741.8752
12.0% -64850261.0157 -78790365.42198 -92730469.8283 -106670574.2345
ncuentra en datos
S/ 1,600,000.00 S/ 1,800,000.00 S/ 2,000,000.00 S/ 2,200,000.00 S/ 2,400,000.00 S/ 2,600,000.00
-187931673.4521 -208644024.069 -229356374.6855 -250068725.3021 -270781075.9188 -291493426.53548
-182954111.5249 -203179448.586 -223404785.6471 -243630122.7083 -263855459.7694 -284080796.83055
-178155262.286 -197909297.257 -217663332.2289 -237417367.2004 -257171402.1719 -276925437.14333
-173527869.4299 -192825734.227 -212123599.0245 -231421463.8218 -250719328.6191 -270017193.41639
-169064991.7341 -187921261.8 -206777531.8654 -225633801.9311 -244490071.9967 -263346342.06238
-164759988.7773 -183188705.191 -201617421.6053 -220046138.0193 -238474854.4333 -256903570.84731
-160606507.3244 -178621197.99 -196635888.6553 -214650579.3207 -232665269.9861 -250679960.65156
-156598468.3474 -174212168.291 -191825868.2354 -209439568.1793 -227053268.1233 -244666968.06732
-152730054.6515 -169955325.48 -187180596.308 -204405867.1363 -221631137.9646 -238856408.79284
-148995699.077 -165844647.619 -182693596.1608 -199542544.7027 -216391493.2445 -233240441.78642
-145390073.2507 -161874369.429 -178358665.6081 -194842961.7868 -211327257.9654 -227811554.14412
-141908076.8591 -158038970.821 -174169864.7825 -190300758.7441 -206431652.7058 -222562546.6675
-138544827.4199 -154333165.954 -170121504.4875 -185909843.0213 -201698181.5551 -217486520.08888
-135295650.5273 -150751892.806 -166208135.0857 -181664377.3649 -197120619.6442 -212576861.92341
-132156070.549 -147290303.223 -162424535.8969 -177558768.5708 -192693001.2448 -207827233.91869
-129121801.7535 -143943753.418 -158765705.0817 -173587656.7458 -188409608.4099 -203231560.07394
-126188739.8464 -140707794.918 -155226849.9887 -169745905.0599 -184264960.1311 -198784015.20221
-123352953.8977 -137578165.92 -151803377.9427 -166028589.9653 -180253801.9878 -194479014.01028
-120610678.6408 -134550783.047 -148490887.4534 -162430991.8597 -176371096.2659 -190311200.67221
S/ 2,800,000.00 S/ 3,000,000.00 S/ 3,200,000.00
-312205777.1522 -332918127.7688 -353630478.3855
-304306133.8917 -324531470.9528 -344756808.014
-296679472.1148 -316433507.0863 -336187542.0577
-289315058.2137 -308612923.011 -327910787.8083
-282202612.128 -301058882.1937 -319915152.2593
-275332287.2613 -293761003.6753 -312189720.0893
-268694651.317 -286709341.9824 -304724032.6479
-262280668.0113 -279894367.9553 -297508067.8993
-256081679.6211 -273306950.4494 -290532221.2777
-250089390.3283 -266938338.8702 -283787287.4121
-244295850.3228 -260780146.5015 -277264442.6801
-238693440.6292 -254824334.5908 -270955228.5525
-233274858.6227 -249063197.1565 -264851535.6903
-228033104.2026 -243489346.4819 -258945588.7611
-222961466.5926 -238095699.2666 -253229931.9405
-218053511.738 -232875463.4021 -247697415.0662
-213303070.2734 -227822125.3445 -242341180.4157
-208704226.0328 -222929438.0553 -237154650.0778
-204251305.0785 -218191409.4848 -232131513.8911