amortizaciÓn

2
plan de pagos A B C P 1p 5,000.00 0 5,000.00 2i 0.03 1 5,000.00 3q 2.00 2 5,000.00 4n 12.00 3 5,000.00 5R 586.15 4 4,563.85 6 5 4,114.61 6 3,651.90 7 3,175.30 8 2,684.41 9 2,178.79 10 1,658.00 11 1,121.59 12 569.08

Upload: angelica-pecho-schrader

Post on 18-Feb-2016

2 views

Category:

Documents


0 download

DESCRIPTION

excel

TRANSCRIPT

Page 1: AMORTIZACIÓN

plan de pagos

A B C N° P I1 p 5,000.00 0 5,000.002 i 0.03 1 5,000.003 q 2.00 2 5,000.004 n 12.00 3 5,000.00 150.005 R 586.15 4 4,563.85 136.926 5 4,114.61 123.44

6 3,651.90 109.567 3,175.30 95.268 2,684.41 80.539 2,178.79 65.36

10 1,658.00 49.7411 1,121.59 33.6512 569.08 17.07

861.53

Page 2: AMORTIZACIÓN

AMORTIZACIÓN CUOTA SALDO D ESALIDA 5,000.005,000.005,000.00

436.15 586.15 4,563.85449.24 586.15 4,114.61462.71 586.15 3,651.90476.60 586.15 3,175.30490.89 586.15 2,684.41505.62 586.15 2,178.79520.79 586.15 1,658.00536.41 586.15 1,121.59552.50 586.15 569.08569.08 586.15 0.00

5,000.00