Sheet1SUPUESTOSAO 1AO 2AO 3SP tipo de cambio spot (al contado)334Sp = Tipo de Cambio spot (al contado) RS/. Tasa de inters en soles (efectiva anual)2.3%2.5%2.4%RS/.= Tasa de inters en soles (efectiva anual)R$ Tasa de inters en dlares (efectiva anual)2.0%2.2%2.2%R$ = Tasa de inters en dlares (efectiva anual)n (aos) Plazo111n = PlazoFp = Tipo de Cambio forward 10.0666666667Calcular:6.66666666671. La depreciacin del Sol por cada ao, graficar y explicar el posible impacto financiero entre cada ao.6.67%9.38%Ao 02Ao 032. La prdida de la capacidad adquisitiva del sol por cada ao, graficar y explicar el posible impacto financiero entre cada ao.8.00%-4.17%3. El tipo de cambio forward por cada ao proyectado, graficar y explicar el posible impacto financiero entre cada ao.FP3.00882352943.20939334643.50684931514. La depreciacin del Sol respecto al tipo de cambio forward por cada ao, graficar y explicar el posible impacto financiero entre cada ao.FP3.00882352943.20939334643.50684931516.67%9.27%AO 02AO 035. El riesgo econmico agregado por cada ao, suponiendo el valor de mercado y el coeficiente de riesgo de las cuentas del balance, graficar y explicar el posible impacto financiero entre cada ao

tc spotAO 01T.C. SPSP01COEF. RIESGORIESGOAO 02T.C. SPSP02COEF. RIESGORIESGOAO 03T.C. SPSP02COEF. RIESGORIESGOActivo Corriente33.23.5Caja90.0030.0030.001.0030.00100.0031.2532.001.0032.00110.0031.4332.001.0032.00Valores Negociables308.00102.67105.001.00105.00320.00100.00120.001.00120.00300.0085.71250.001.00250.00Cuentas por Cobrar2,800.00933.331,500.000.901,350.003,970.001,240.631,800.001.001,800.003,000.00857.141,500.001.001,500.00inventarios3,200.001,066.672,500.000.802,000.003,770.001,178.132,600.000.902,340.003,400.00971.432,000.000.901,800.00Existencias por recibirTotal Activo Corriente6,398.004,135.003,485.008,160.004,552.004,292.006,810.003,782.003,582.00

Maquinaria y Equipo7,000.002,333.332,000.000.901,800.007,500.002,343.752,000.000.901,800.008,000.002,285.712,000.000.901,800.00Depreciacin Acumulada-2,400.00-800.00-800.001.00-800.00-2,700.00-843.75-850.001.00-850.00-3,000.00-857.14-850.001.00-850.00Goodwill540.00180.00200.000.90180.00520.00162.50250.000.90225.00500.00142.86250.000.80200.00Otros Activos920.00306.67500.000.90450.00950.00296.88350.000.90315.001,000.00285.71500.001.00500.00Total Activo No Corriente6,060.001,900.001,630.006,270.001,750.001,490.006,500.001,900.001,650.00

TOTAL ACTIVO12,458.006,035.005,115.0014,430.006,302.005,782.0013,310.005,682.005,232.00Pasivo CorrienteCuentas por pagar1,980.00660.00660.001.00660.002,050.00640.63640.001.00640.002,000.00571.43571.431.00571.43impuestos por pagar880.00293.33293.500.90264.15900.00281.25300.000.90270.001,000.00285.71285.000.90256.50Deuda por pagar al CP1,063.00354.33354.331.00354.331,500.00468.75550.001.00550.00596.00170.29550.001.00550.00Total Pasivo Corriente3,923.001,307.831,278.484,450.001,490.001,460.003,596.001,406.431,377.93Deudas LP3,400.001,133.331,133.331.001,133.333,500.001,093.751,500.001.001,500.003,500.001,000.001,000.001.001,000.00Provisin BBSS380.00126.67126.671.00126.67400.00125.00150.001.00150.00500.00142.86150.001.00150.00Total pasivo no corriente3,780.001,260.001,260.003,900.001,650.001,650.004,000.001,150.001,150.00Capital Social1,250.00416.67416.671.00416.671,150.00359.38360.001.00360.001,510.00431.43360.001.00360.00Utilidades Retenidas3,505.001,168.331,168.331.001,168.334,931.001,540.941,540.001.001,540.004,204.001,201.141,540.001.001,540.00Total Patrimonio4,755.001,585.001,585.006,081.001,900.001,900.005,714.001,900.001,900.00Total Pasivo y Patrimonio12,458.004,152.830.04,123.4814,431.005,040.000.05,010.0013,310.004,456.430.04,427.93991.52772.00804.07REA24%15%18%

tc forwardAO 01T.C. FWSP01COEF. RIESGORIESGOAO 02T.C. FWSP02COEF. RIESGORIESGOAO 03T.C. FWSP02COEF. RIESGORIESGOActivo Corriente3.00882352943.20939334643.5068493151Caja90.0029.9130.001.0030.00100.0031.1632.001.0032.00110.0031.3732.001.0032.00Valores Negociables308.00102.37105.001.00105.00320.0099.71120.001.00120.00300.0085.55250.001.00250.00Cuentas por Cobrar2,800.00930.601,500.000.801,200.003,970.001,236.991,800.001.001,800.003,000.00855.471,500.001.001,500.00inventarios3,200.001,063.542,500.000.701,750.003,770.001,174.682,600.000.802,080.003,400.00969.532,000.000.801,600.00Existencias por recibirTotal Activo Corriente6,398.004,135.003,085.008,160.004,552.004,032.006,810.003,782.003,382.00

Maquinaria y Equipo7,000.002,326.492,000.000.901,800.007,500.002,336.892,000.000.901,800.008,000.002,281.252,000.000.901,800.00Depreciacin Acumulada-2,400.00-797.65-800.001.00-800.00-2,700.00-841.28-850.001.00-850.00-3,000.00-855.47-850.001.00-850.00Goodwill540.00179.47200.000.80160.00520.00162.02250.000.80200.00500.00142.58250.000.80200.00Otros Activos920.00305.77500.000.80400.00950.00296.01350.000.80280.001,000.00285.16500.001.00500.00Total Activo No Corriente6,060.001,900.001,560.006,270.001,750.001,430.006,500.001,900.001,650.00

TOTAL ACTIVO12,458.006,035.004,645.0014,430.006,302.005,462.0013,310.005,682.005,032.00Pasivo CorrienteCuentas por pagar1,980.00658.06660.001.00660.002,050.00638.75640.001.00640.002,000.00570.31571.431.00571.43impuestos por pagar880.00292.47293.500.80234.80900.00280.43300.000.80240.001,000.00285.16285.000.80228.00Deuda por pagar al CP1,063.00353.29354.331.00354.331,500.00467.38550.001.00550.00596.00169.95550.001.00550.00Total Pasivo Corriente3,923.001,307.831,249.134,450.001,490.001,430.003,596.001,406.431,349.43Deudas LP3,400.001,130.011,133.331.001,133.333,500.001,090.551,500.001.001,500.003,500.00998.051,000.001.001,000.00Provisin BBSS380.00126.30126.671.00126.67400.00124.63150.001.00150.00500.00142.58150.001.00150.00Total pasivo no corriente3,780.001,260.001,260.003,900.001,650.001,650.004,000.001,150.001,150.00Capital Social1,250.00415.44416.671.00416.671,150.00358.32360.001.00360.001,510.00430.59360.001.00360.00Utilidades Retenidas3,505.001,164.911,168.331.001,168.334,931.001,536.431,540.001.001,540.004,204.001,198.801,540.001.001,540.00Total Patrimonio4,755.001,585.001,585.006,081.001,900.001,900.005,714.001,900.001,900.00Total Pasivo y Patrimonio12,458.004,152.830.04,094.1314,431.005,040.000.04,980.0013,310.004,456.430.04,399.43550.87482.00632.57REA13%10%14%