Hoja1Aos (n)Saldo insoluto ( c )Abono anual ( R )interes sobre saldo ( I=Ci)IVA pago anual ( R+ I+ IVA)Acomulado0$1,000,000.00$0.00$0.00$0.00$0.00$0.001$800,000.00$200,000.00$240,000.00$36,000.00$476,000.00$476,000.002$600,000.00$200,000.00$192,000.00$28,800.00$420,800.00$896,800.003$400,000.00$200,000.00$144,000.00$21,600.00$365,600.00$1,262,400.004$200,000.00$200,000.00$96,000.00$14,400.00$310,400.00$1,572,800.005$0.00$200,000.00$48,000.00$7,200.00$255,200.00$1,828,000.00SUMA$1,000,000.00$720,000.00$108,000.00$1,828,000.00

R= C/N$200,000.00i=0.24IVA=0.15

Hoja2Aos (n)Saldo insoluto ( c )Abono anual ( R )interes sobre saldo ( I=Ci) pago anual ( R- I)Acomulado0$1,000,000.00$0.00$0.00$0.00$0.001$875,752.29$364,247.71$240,000.00$124,247.71$124,247.712$721,685.12$364,247.71$210,180.55$154,067.17$278,314.883$530,641.83$364,247.71$173,204.43$191,043.29$469,358.174$293,748.16$364,247.71$127,354.04$236,893.68$706,251.845$0.00$364,247.71$70,499.56$293,748.16$1,000,000.00SUMA$1,821,238.57$821,238.57$1,000,000.00R=( C ) ( i) ( i) [1 + i) ^ n / ( 1 + i) ^ n - 1R=703590.0149761.9316250624R=$364,247.71i=0.24

Hoja3