Amortizacion leasing.xlsx - AMORTIZACION DE LEASING ACION DE LEASING AMORTIZACION DE LEASING Formula R V F i N A\u00d1O Q17,869.96 Q 100,000.00 Q 10,000.00

Amortizacion leasing.xlsx - AMORTIZACION DE LEASING ACION...

This preview shows page 1 - 5 out of 8 pages.

AMORTIZACIO
Image of page 1
ON DE LEASING
Image of page 2
AMORTIZACION DE LEASING Formula AÑO CUOTA INTERESES 0 1 Q 17,869.96 Q 10,000.00 2 Q 17,869.96 Q 9,213.00 3 Q 17,869.96 Q 8,347.31 4 Q 17,869.96 Q 7,395.04 R Q17,869.96 5 Q 17,869.96 Q 6,347.55 V Q 100,000.00 6 Q 17,869.96 Q 5,195.31 F Q 10,000.00 7 Q 17,869.96 Q 3,927.84 i 10% 8 Q 27,869.96 Q 2,533.63 N 8 F R Q1,449.01 AÑO CUOTA INTERESES V Q 100,000.00 0 F Q 10,000.00 1 Q 1,449.01 Q 833.33 i 10% 2 Q 1,449.01 Q 828.20 j 0.0083333333 3 Q 1,449.01 Q 823.03 N 8 4 Q 1,449.01 Q 817.81 m 96 5 Q 1,449.01 Q 812.55 6 Q 1,449.01 Q 807.25 7 Q 1,449.01 Q 801.90 8 Q 1,449.01 Q 796.51 9 Q 1,449.01 Q 791.07 10 Q 1,449.01 Q 785.59 11 Q 1,449.01 Q 780.06 12 Q 1,449.01 Q 774.49 13 Q 1,449.01 Q 768.86 14 Q 1,449.01 Q 763.20 15 Q 1,449.01 Q 757.48 16 Q 1,449.01 Q 751.72 17 Q 1,449.01 Q 745.91 18 Q 1,449.01 Q 740.05 19 Q 1,449.01 Q 734.14 20 Q 1,449.01 Q 728.18 21 Q 1,449.01 Q 722.18 22 Q 1,449.01 Q 716.12 23 Q 1,449.01 Q 710.01 24 Q 1,449.01 Q 703.85 25 Q 1,449.01 Q 697.64 26 Q 1,449.01 Q 691.38 R = (?? (1 ) +? ^ )/(( ?−?? 1 ) +? −1) ^? R = (?? (1 ) +? ^ )/(( ?−?? 1 ) +? −1) ^?
Image of page 3
27 Q 1,449.01 Q 685.07 28 Q 1,449.01 Q 678.70 29 Q 1,449.01 Q 672.28 30 Q 1,449.01 Q 665.81 31 Q 1,449.01 Q 659.28 32 Q 1,449.01 Q 652.70 33 Q 1,449.01 Q 646.07 34 Q 1,449.01 Q 639.38 35 Q 1,449.01 Q 632.63 36 Q 1,449.01 Q 625.83 37 Q 1,449.01 Q 618.97 38 Q 1,449.01 Q 612.05 39 Q 1,449.01 Q 605.07 40 Q 1,449.01 Q 598.04 41 Q 1,449.01 Q 590.95 42 Q 1,449.01 Q 583.80 43 Q 1,449.01 Q 576.59 44 Q 1,449.01 Q 569.32 45 Q 1,449.01 Q 561.99 46 Q 1,449.01 Q 554.60 47 Q 1,449.01 Q 547.14 48 Q 1,449.01 Q 539.63 49 Q 1,449.01 Q 532.05 50 Q 1,449.01 Q 524.41 51 Q 1,449.01 Q 516.70 52 Q 1,449.01 Q 508.93 53 Q 1,449.01 Q 501.10 54 Q 1,449.01 Q 493.20 55 Q 1,449.01 Q 485.24 56 Q 1,449.01 Q 477.21 57 Q 1,449.01 Q 469.11 58 Q 1,449.01 Q 460.94 59 Q 1,449.01 Q 452.71 60 Q 1,449.01 Q 444.40 61 Q 1,449.01 Q 436.03 62 Q 1,449.01 Q 427.59 63 Q 1,449.01 Q 419.08 64 Q 1,449.01 Q 410.50 65 Q 1,449.01 Q 401.84 66 Q 1,449.01 Q 393.12 67 Q 1,449.01 Q 384.32 68 Q 1,449.01 Q 375.44 69 Q 1,449.01 Q 366.50 70 Q 1,449.01 Q 357.48 71 Q 1,449.01 Q 348.38 72 Q 1,449.01 Q 339.21
Image of page 4

Want to read all 8 pages?

Image of page 5

Want to read all 8 pages?

You've reached the end of your free preview.

Want to read all 8 pages?

  • Winter '17
  • Santisteban

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture