examen-final.xlsx

Mensual 34.49%Bimestral 34.01%Trimestral 33.55%Semestral 32%Anual 30%

N° 0359% Trimestral55% Semestral49% Anual

VA 15000000 S/. 5,285,971.71NPER 3TASA 17% 2.8%

S/. 16,311,466.18 18%S/. 1,311,466.18

VA 24000000NPER 6TASA 39.6% 3%PAGO S/. 4,474,491.75

PAGO + INT. S/. 26,846,950.50

INTERES TOTAL S/. 2,846,950.50

INTERESES A 6 MESES S/. 474,491.75

VA 10000000NPER 24TASA 2%PAGO S/. 528,710.97

VA S/. 65,000,000.00 S/. 58,500,000.00 TASA 1.78%PAGO S/. 250,000.00 NPER 93

VA S/. 7,500,000.00 TASA 24% 2%NPER 12Ej-aPAGO A 1 AÑO S/. 709,196.97Ej-bEL PLAZO PAGANDO $85.000 = 51Ej-cTASA MENSUAL 2%

TABLA DE AMORTIZACION

PERIODO CUOTAAMORTIZACION CAPITAL

01 S/. 528,710.97 S/. 328,710.972 S/. 528,710.97 S/. 335,285.193 S/. 528,710.97 S/. 341,990.904 S/. 528,710.97 S/. 348,830.715 S/. 528,710.97 S/. 355,807.336 S/. 528,710.97 S/. 362,923.477 S/. 528,710.97 S/. 370,181.948 S/. 528,710.97 S/. 377,585.589 S/. 528,710.97 S/. 385,137.29

10 S/. 528,710.97 S/. 392,840.0411 S/. 528,710.97 S/. 400,696.8412 S/. 528,710.97 S/. 408,710.7813 S/. 528,710.97 S/. 416,884.9914 S/. 528,710.97 S/. 425,222.6915 S/. 528,710.97 S/. 433,727.1516 S/. 528,710.97 S/. 442,401.6917 S/. 528,710.97 S/. 451,249.7218 S/. 528,710.97 S/. 460,274.7219 S/. 528,710.97 S/. 469,480.2120 S/. 528,710.97 S/. 478,869.8221 S/. 528,710.97 S/. 488,447.2122 S/. 528,710.97 S/. 498,216.1623 S/. 528,710.97 S/. 508,180.4824 S/. 528,710.97 S/. 518,344.09


PERIODO CUOTAAMORTIZACION CAPITAL

01 S/. 250,000.00 S/. 250,000.002 S/. 250,000.00 S/. 254,450.003 S/. 250,000.00 S/. 258,979.214 S/. 250,000.00 S/. 263,589.045 S/. 250,000.00 S/. 268,280.926 S/. 250,000.00 S/. 273,056.337 S/. 250,000.00 S/. 277,916.738 S/. 250,000.00 S/. 282,863.659 S/. 250,000.00 S/. 287,898.62

10 S/. 250,000.00 S/. 293,023.2111 S/. 250,000.00 S/. 298,239.0312 S/. 250,000.00 S/. 303,547.6813 S/. 250,000.00 S/. 308,950.8314 S/. 250,000.00 S/. 314,450.1615 S/. 250,000.00 S/. 320,047.3716 S/. 250,000.00 S/. 325,744.2117 S/. 250,000.00 S/. 331,542.4618 S/. 250,000.00 S/. 337,443.9119 S/. 250,000.00 S/. 343,450.4220 S/. 250,000.00 S/. 349,563.8321 S/. 250,000.00 S/. 355,786.0722 S/. 250,000.00 S/. 362,119.0623 S/. 250,000.00 S/. 368,564.7824 S/. 250,000.00 S/. 375,125.2325 S/. 250,000.00 S/. 381,802.4626 S/. 250,000.00 S/. 388,598.5527 S/. 250,000.00 S/. 395,515.6028 S/. 250,000.00 S/. 402,555.7829 S/. 250,000.00 S/. 409,721.2730 S/. 250,000.00 S/. 417,014.3131 S/. 250,000.00 S/. 424,437.1632 S/. 250,000.00 S/. 431,992.1533 S/. 250,000.00 S/. 439,681.6134 S/. 250,000.00 S/. 447,507.9435 S/. 250,000.00 S/. 455,473.5836 S/. 250,000.00 S/. 463,581.0137 S/. 250,000.00 S/. 471,832.7538 S/. 250,000.00 S/. 480,231.3839 S/. 250,000.00 S/. 488,779.4940 S/. 250,000.00 S/. 497,479.7741 S/. 250,000.00 S/. 506,334.9142 S/. 250,000.00 S/. 515,347.67

43 S/. 250,000.00 S/. 524,520.8644 S/. 250,000.00 S/. 533,857.3345 S/. 250,000.00 S/. 543,359.9946 S/. 250,000.00 S/. 553,031.8047 S/. 250,000.00 S/. 562,875.7648 S/. 250,000.00 S/. 572,894.9549 S/. 250,000.00 S/. 583,092.4850 S/. 250,000.00 S/. 593,471.5351 S/. 250,000.00 S/. 604,035.3252 S/. 250,000.00 S/. 614,787.1553 S/. 250,000.00 S/. 625,730.3654 S/. 250,000.00 S/. 636,868.3655 S/. 250,000.00 S/. 648,204.6256 S/. 250,000.00 S/. 659,742.6657 S/. 250,000.00 S/. 671,486.0858 S/. 250,000.00 S/. 683,438.5359 S/. 250,000.00 S/. 695,603.7460 S/. 250,000.00 S/. 707,985.4961 S/. 250,000.00 S/. 720,587.6362 S/. 250,000.00 S/. 733,414.0963 S/. 250,000.00 S/. 746,468.8664 S/. 250,000.00 S/. 759,756.0065 S/. 250,000.00 S/. 773,279.6666 S/. 250,000.00 S/. 787,044.0467 S/. 250,000.00 S/. 801,053.4268 S/. 250,000.00 S/. 815,312.1769 S/. 250,000.00 S/. 829,824.7370 S/. 250,000.00 S/. 844,595.6171 S/. 250,000.00 S/. 859,629.4172 S/. 250,000.00 S/. 874,930.8273 S/. 250,000.00 S/. 890,504.5874 S/. 250,000.00 S/. 906,355.5775 S/. 250,000.00 S/. 922,488.6976 S/. 250,000.00 S/. 938,908.9977 S/. 250,000.00 S/. 955,621.5778 S/. 250,000.00 S/. 972,631.6479 S/. 250,000.00 S/. 989,944.4880 S/. 250,000.00 S/. 1,007,565.4981 S/. 250,000.00 S/. 1,025,500.1682 S/. 250,000.00 S/. 1,043,754.0683 S/. 250,000.00 S/. 1,062,332.8884 S/. 250,000.00 S/. 1,081,242.4185 S/. 250,000.00 S/. 1,100,488.5286 S/. 250,000.00 S/. 1,120,077.2287 S/. 250,000.00 S/. 1,140,014.5988 S/. 250,000.00 S/. 1,160,306.8589 S/. 250,000.00 S/. 1,180,960.3290 S/. 250,000.00 S/. 1,201,981.41

91 S/. 250,000.00 S/. 1,223,376.6892 S/. 250,000.00 S/. 1,245,152.7893 S/. 250,000.00 S/. 1,267,316.50

El pago es de S/.250.000, EL SALDO DEUDOR ES S/.80.071.00

S/. 85,000.00

Ej-dTABLA DE AMORTIZACION

PERIODO CUOTAPAGO INTERESES

01 S/. 85,000.00 S/. 559,196.97 S/. 150,000.002 S/. 85,000.00 S/. 570,380.91 S/. 138,816.063 S/. 85,000.00 S/. 581,788.53 S/. 127,408.444 S/. 85,000.00 S/. 593,424.30 S/. 115,772.675 S/. 85,000.00 S/. 605,292.79 S/. 103,904.196 S/. 85,000.00 S/. 617,398.64 S/. 91,798.337 S/. 85,000.00 S/. 629,746.62 S/. 79,450.368 S/. 85,000.00 S/. 642,341.55 S/. 66,855.429 S/. 85,000.00 S/. 655,188.38 S/. 54,008.59

10 S/. 85,000.00 S/. 668,292.15 S/. 40,904.8311 S/. 85,000.00 S/. 681,657.99 S/. 27,538.9812 S/. 85,000.00 S/. 695,291.15 S/. 13,905.82

AMORTIZACION CAPITAL


PAGO INTERESES CAPITAL PENDIENTE S/. 10,000,000

S/. 200,000.00 S/. 9,671,289.03 S/. 193,425.78 S/. 9,336,003.84 S/. 186,720.08 S/. 8,994,012.94 S/. 179,880.26 S/. 8,645,182.23 S/. 172,903.64 S/. 8,289,374.90 S/. 165,787.50 S/. 7,926,451.42 S/. 158,529.03 S/. 7,556,269.48 S/. 151,125.39 S/. 7,178,683.90 S/. 143,573.68 S/. 6,793,546.60 S/. 135,870.93 S/. 6,400,706.56 S/. 128,014.13 S/. 6,000,009.72 S/. 120,000.19 S/. 5,591,298.94 S/. 111,825.98 S/. 5,174,413.95 S/. 103,488.28 S/. 4,749,191.25

S/. 94,983.83 S/. 4,315,464.11 S/. 86,309.28 S/. 3,873,062.42 S/. 77,461.25 S/. 3,421,812.69 S/. 68,436.25 S/. 2,961,537.97 S/. 59,230.76 S/. 2,492,057.76 S/. 49,841.16 S/. 2,013,187.94 S/. 40,263.76 S/. 1,524,740.73 S/. 30,494.81 S/. 1,026,524.57 S/. 20,530.49 S/. 518,344.09 S/. 10,366.88 S/. -0.00


PAGO INTERESES CAPITAL PENDIENTE S/. 58,500,000

S/. 1,041,300.00 S/. 58,250,000.00 S/. 1,036,850.00 S/. 57,995,550.00 S/. 1,032,320.79 S/. 57,736,570.79 S/. 1,027,710.96 S/. 57,472,981.75 S/. 1,023,019.08 S/. 57,204,700.83 S/. 1,018,243.67 S/. 56,931,644.50 S/. 1,013,383.27 S/. 56,653,727.77 S/. 1,008,436.35 S/. 56,370,864.13 S/. 1,003,401.38 S/. 56,082,965.51

S/. 998,276.79 S/. 55,789,942.29 S/. 993,060.97 S/. 55,491,703.27 S/. 987,752.32 S/. 55,188,155.58 S/. 982,349.17 S/. 54,879,204.75 S/. 976,849.84 S/. 54,564,754.60 S/. 971,252.63 S/. 54,244,707.23 S/. 965,555.79 S/. 53,918,963.02 S/. 959,757.54 S/. 53,587,420.56 S/. 953,856.09 S/. 53,249,976.65 S/. 947,849.58 S/. 52,906,526.23 S/. 941,736.17 S/. 52,556,962.40 S/. 935,513.93 S/. 52,201,176.33 S/. 929,180.94 S/. 51,839,057.27 S/. 922,735.22 S/. 51,470,492.49 S/. 916,174.77 S/. 51,095,367.25 S/. 909,497.54 S/. 50,713,564.79 S/. 902,701.45 S/. 50,324,966.24 S/. 895,784.40 S/. 49,929,450.64 S/. 888,744.22 S/. 49,526,894.86 S/. 881,578.73 S/. 49,117,173.59 S/. 874,285.69 S/. 48,700,159.28 S/. 866,862.84 S/. 48,275,722.12 S/. 859,307.85 S/. 47,843,729.97 S/. 851,618.39 S/. 47,404,048.37 S/. 843,792.06 S/. 46,956,540.43 S/. 835,826.42 S/. 46,501,066.85 S/. 827,718.99 S/. 46,037,485.84 S/. 819,467.25 S/. 45,565,653.08 S/. 811,068.62 S/. 45,085,421.71 S/. 802,520.51 S/. 44,596,642.21 S/. 793,820.23 S/. 44,099,162.45 S/. 784,965.09 S/. 43,592,827.54 S/. 775,952.33 S/. 43,077,479.87

S/. 766,779.14 S/. 42,552,959.01 S/. 757,442.67 S/. 42,019,101.68 S/. 747,940.01 S/. 41,475,741.69 S/. 738,268.20 S/. 40,922,709.89 S/. 728,424.24 S/. 40,359,834.13 S/. 718,405.05 S/. 39,786,939.18 S/. 708,207.52 S/. 39,203,846.69 S/. 697,828.47 S/. 38,610,375.16 S/. 687,264.68 S/. 38,006,339.84 S/. 676,512.85 S/. 37,391,552.69 S/. 665,569.64 S/. 36,765,822.33 S/. 654,431.64 S/. 36,128,953.97 S/. 643,095.38 S/. 35,480,749.35 S/. 631,557.34 S/. 34,821,006.69 S/. 619,813.92 S/. 34,149,520.60 S/. 607,861.47 S/. 33,466,082.07 S/. 595,696.26 S/. 32,770,478.33 S/. 583,314.51 S/. 32,062,492.85 S/. 570,712.37 S/. 31,341,905.22 S/. 557,885.91 S/. 30,608,491.13 S/. 544,831.14 S/. 29,862,022.27 S/. 531,544.00 S/. 29,102,266.27 S/. 518,020.34 S/. 28,328,986.61 S/. 504,255.96 S/. 27,541,942.57 S/. 490,246.58 S/. 26,740,889.15 S/. 475,987.83 S/. 25,925,576.98 S/. 461,475.27 S/. 25,095,752.25 S/. 446,704.39 S/. 24,251,156.64 S/. 431,670.59 S/. 23,391,527.22 S/. 416,369.18 S/. 22,516,596.41 S/. 400,795.42 S/. 21,626,091.83 S/. 384,944.43 S/. 20,719,736.26 S/. 368,811.31 S/. 19,797,247.57 S/. 352,391.01 S/. 18,858,338.57 S/. 335,678.43 S/. 17,902,717.00 S/. 318,668.36 S/. 16,930,085.36 S/. 301,355.52 S/. 15,940,140.88 S/. 283,734.51 S/. 14,932,575.39 S/. 265,799.84 S/. 13,907,075.23 S/. 247,545.94 S/. 12,863,321.17 S/. 228,967.12 S/. 11,800,988.29 S/. 210,057.59 S/. 10,719,745.88 S/. 190,811.48 S/. 9,619,257.35 S/. 171,222.78 S/. 8,499,180.14 S/. 151,285.41 S/. 7,359,165.54 S/. 130,993.15 S/. 6,198,858.69 S/. 110,339.68 S/. 5,017,898.37

S/. 89,318.59 S/. 3,815,916.96

S/. 67,923.32 S/. 2,592,540.29 S/. 46,147.22 S/. 1,347,387.50 S/. 23,983.50 S/. 80,071.00

El pago es de S/.250.000, EL SALDO DEUDOR ES S/.80.071.00


CAPITAL PENDIENTE S/. 7,500,000 S/. 6,940,803.03 S/. 6,370,422.11 S/. 5,788,633.58 S/. 5,195,209.28 S/. 4,589,916.49 S/. 3,972,517.84 S/. 3,342,771.22 S/. 2,700,429.67 S/. 2,045,241.29 S/. 1,376,949.14 S/. 695,291.15 S/. -

examen-final.xlsx

Documents