1
DIAMANTES ROJOS, S.L. 3 AÑO ANUALIDAD INTERESES AMORTIZACIÓN TOTAL AMORTIZACIÓN CAPITAL PENDIENTE 1/1/2013 0.00 € 0.00 € 0.00 € 0.00 € 200,000.00 € Tipo interés 2/1/2013 3,710.44 € 716.67 € 2,993.78 € 2,993.78 € 197,006.22 € 0 3/1/2013 3,710.44 € 705.94 € 3,004.50 € 5,998.28 € 194,001.72 € 4/1/2013 3,710.44 € 695.17 € 3,015.27 € 9,013.55 € 190,986.45 € 5/1/2013 3,710.44 € 684.37 € 3,026.07 € 12,039.62 € 187,960.38 € 6/1/2013 3,710.44 € 673.52 € 3,036.92 € 15,076.54 € 184,923.46 € 7/1/2013 3,710.44 € 662.64 € 3,047.80 € 18,124.34 € 181,875.66 € 8/1/2013 3,710.44 € 651.72 € 3,058.72 € 21,183.07 € 178,816.93 € 9/1/2013 3,710.44 € 640.76 € 3,069.68 € 24,252.75 € 175,747.25 € 10/1/2013 3,710.44 € 629.76 € 3,080.68 € 27,333.43 € 172,666.57 € 11/1/2013 3,710.44 € 618.72 € 3,091.72 € 30,425.15 € 169,574.85 € 12/1/2013 3,710.44 € 607.64 € 3,102.80 € 33,527.95 € 166,472.05 € 1/1/2014 3,710.44 € 596.52 € 3,113.92 € 36,641.87 € 163,358.13 € 2/1/2014 3,710.44 € 585.37 € 3,125.08 € 39,766.94 € 160,233.06 € 3/1/2014 3,710.44 € 574.17 € 3,136.27 € 42,903.22 € 157,096.78 € 4/1/2014 3,710.44 € 562.93 € 3,147.51 € 46,050.73 € 153,949.27 € 5/1/2014 3,710.44 € 551.65 € 3,158.79 € 49,209.52 € 150,790.48 € 6/1/2014 3,710.44 € 540.33 € 3,170.11 € 52,379.63 € 147,620.37 € 7/1/2014 3,710.44 € 528.97 € 3,181.47 € 55,561.10 € 144,438.90 € 8/1/2014 3,710.44 € 517.57 € 3,192.87 € 58,753.97 € 141,246.03 € 9/1/2014 3,710.44 € 506.13 € 3,204.31 € 61,958.28 € 138,041.72 € 10/1/2014 3,710.44 € 494.65 € 3,215.79 € 65,174.08 € 134,825.92 € 11/1/2014 3,710.44 € 483.13 € 3,227.32 € 68,401.39 € 131,598.61 € 12/1/2014 3,710.44 € 471.56 € 3,238.88 € 71,640.27 € 128,359.73 € 1/1/2015 3,710.44 € 459.96 € 3,250.49 € 74,890.76 € 125,109.24 € 2/1/2015 3,710.44 € 448.31 € 3,262.13 € 78,152.90 € 121,847.10 € 3/1/2015 3,710.44 € 436.62 € 3,273.82 € 81,426.72 € 118,573.28 € 4/1/2015 3,710.44 € 424.89 € 3,285.56 € 84,712.28 € 115,287.72 € 5/1/2015 3,710.44 € 413.11 € 3,297.33 € 88,009.60 € 111,990.40 € 6/1/2015 3,710.44 € 401.30 € 3,309.14 € 91,318.75 € 108,681.25 € 7/1/2015 3,710.44 € 389.44 € 3,321.00 € 94,639.75 € 105,360.25 € 8/1/2015 3,710.44 € 377.54 € 3,332.90 € 97,972.65 € 102,027.35 € 9/1/2015 3,710.44 € 365.60 € 3,344.84 € 101,317.50 € 98,682.50 € 10/1/2015 3,710.44 € 353.61 € 3,356.83 € 104,674.33 € 95,325.67 € 11/1/2015 3,710.44 € 341.58 € 3,368.86 € 108,043.19 € 91,956.81 € 12/1/2015 3,710.44 € 329.51 € 3,380.93 € 111,424.12 € 88,575.88 € 1/1/2016 3,710.44 € 317.40 € 3,393.05 € 114,817.16 € 85,182.84 € 2/1/2016 3,710.44 € 305.24 € 3,405.20 € 118,222.37 € 81,777.63 € 3/1/2016 3,710.44 € 293.04 € 3,417.41 € 121,639.77 € 78,360.23 € 4/1/2016 3,710.44 € 280.79 € 3,429.65 € 125,069.43 € 74,930.57 € 5/1/2016 3,710.44 € 268.50 € 3,441.94 € 128,511.37 € 71,488.63 € 6/1/2016 3,710.44 € 256.17 € 3,454.28 € 131,965.64 € 68,034.36 € 7/1/2016 3,710.44 € 243.79 € 3,466.65 € 135,432.30 € 64,567.70 € 8/1/2016 3,710.44 € 231.37 € 3,479.08 € 138,911.37 € 61,088.63 € 9/1/2016 3,710.44 € 218.90 € 3,491.54 € 142,402.91 € 57,597.09 € 10/1/2016 3,710.44 € 206.39 € 3,504.05 € 145,906.97 € 54,093.03 € 11/1/2016 3,710.44 € 193.83 € 3,516.61 € 149,423.58 € 50,576.42 € 12/1/2016 3,710.44 € 181.23 € 3,529.21 € 152,952.79 € 47,047.21 € 1/1/2017 3,710.44 € 168.59 € 3,541.86 € 156,494.64 € 43,505.36 € 2/1/2017 3,710.44 € 155.89 € 3,554.55 € 160,049.19 € 39,950.81 € 3/1/2017 3,710.44 € 143.16 € 3,567.29 € 163,616.48 € 36,383.52 € 4/1/2017 3,710.44 € 130.37 € 3,580.07 € 167,196.55 € 32,803.45 € 5/1/2017 3,710.44 € 117.55 € 3,592.90 € 170,789.44 € 29,210.56 € 6/1/2017 3,710.44 € 104.67 € 3,605.77 € 174,395.21 € 25,604.79 € 7/1/2017 3,710.44 € 91.75 € 3,618.69 € 178,013.91 € 21,986.09 € 8/1/2017 3,710.44 € 78.78 € 3,631.66 € 181,645.57 € 18,354.43 € 9/1/2017 3,710.44 € 65.77 € 3,644.67 € 185,290.24 € 14,709.76 € 10/1/2017 3,710.44 € 52.71 € 3,657.73 € 188,947.97 € 11,052.03 € 11/1/2017 3,710.44 € 39.60 € 3,670.84 € 192,618.81 € 7,381.19 € 12/1/2017 3,710.44 € 26.45 € 3,683.99 € 196,302.81 € 3,697.19 € 1/1/2018 3,710.44 € 13.25 € 3,697.19 € 200,000.00 € 0.00 €

cuadro amortizacion prestamo

Embed Size (px)

DESCRIPTION

cuadro amortizacion prestamo

Citation preview

Page 1: cuadro amortizacion prestamo

DIAMANTES ROJOS, S.L.

3

AÑO ANUALIDAD INTERESES AMORTIZACIÓN TOTAL AMORTIZACIÓN CAPITAL PENDIENTE

1/1/2013 0.00 € 0.00 € 0.00 € 0.00 € 200,000.00 € Tipo interés2/1/2013 3,710.44 € 716.67 € 2,993.78 € 2,993.78 € 197,006.22 € 03/1/2013 3,710.44 € 705.94 € 3,004.50 € 5,998.28 € 194,001.72 €

4/1/2013 3,710.44 € 695.17 € 3,015.27 € 9,013.55 € 190,986.45 €

5/1/2013 3,710.44 € 684.37 € 3,026.07 € 12,039.62 € 187,960.38 €

6/1/2013 3,710.44 € 673.52 € 3,036.92 € 15,076.54 € 184,923.46 €

7/1/2013 3,710.44 € 662.64 € 3,047.80 € 18,124.34 € 181,875.66 €

8/1/2013 3,710.44 € 651.72 € 3,058.72 € 21,183.07 € 178,816.93 €

9/1/2013 3,710.44 € 640.76 € 3,069.68 € 24,252.75 € 175,747.25 €

10/1/2013 3,710.44 € 629.76 € 3,080.68 € 27,333.43 € 172,666.57 €

11/1/2013 3,710.44 € 618.72 € 3,091.72 € 30,425.15 € 169,574.85 €

12/1/2013 3,710.44 € 607.64 € 3,102.80 € 33,527.95 € 166,472.05 €

1/1/2014 3,710.44 € 596.52 € 3,113.92 € 36,641.87 € 163,358.13 €

2/1/2014 3,710.44 € 585.37 € 3,125.08 € 39,766.94 € 160,233.06 €

3/1/2014 3,710.44 € 574.17 € 3,136.27 € 42,903.22 € 157,096.78 €

4/1/2014 3,710.44 € 562.93 € 3,147.51 € 46,050.73 € 153,949.27 €

5/1/2014 3,710.44 € 551.65 € 3,158.79 € 49,209.52 € 150,790.48 €

6/1/2014 3,710.44 € 540.33 € 3,170.11 € 52,379.63 € 147,620.37 €

7/1/2014 3,710.44 € 528.97 € 3,181.47 € 55,561.10 € 144,438.90 €

8/1/2014 3,710.44 € 517.57 € 3,192.87 € 58,753.97 € 141,246.03 €

9/1/2014 3,710.44 € 506.13 € 3,204.31 € 61,958.28 € 138,041.72 €

10/1/2014 3,710.44 € 494.65 € 3,215.79 € 65,174.08 € 134,825.92 €

11/1/2014 3,710.44 € 483.13 € 3,227.32 € 68,401.39 € 131,598.61 €

12/1/2014 3,710.44 € 471.56 € 3,238.88 € 71,640.27 € 128,359.73 €

1/1/2015 3,710.44 € 459.96 € 3,250.49 € 74,890.76 € 125,109.24 €

2/1/2015 3,710.44 € 448.31 € 3,262.13 € 78,152.90 € 121,847.10 €

3/1/2015 3,710.44 € 436.62 € 3,273.82 € 81,426.72 € 118,573.28 €

4/1/2015 3,710.44 € 424.89 € 3,285.56 € 84,712.28 € 115,287.72 €

5/1/2015 3,710.44 € 413.11 € 3,297.33 € 88,009.60 € 111,990.40 €

6/1/2015 3,710.44 € 401.30 € 3,309.14 € 91,318.75 € 108,681.25 €

7/1/2015 3,710.44 € 389.44 € 3,321.00 € 94,639.75 € 105,360.25 €

8/1/2015 3,710.44 € 377.54 € 3,332.90 € 97,972.65 € 102,027.35 €

9/1/2015 3,710.44 € 365.60 € 3,344.84 € 101,317.50 € 98,682.50 €

10/1/2015 3,710.44 € 353.61 € 3,356.83 € 104,674.33 € 95,325.67 €

11/1/2015 3,710.44 € 341.58 € 3,368.86 € 108,043.19 € 91,956.81 €

12/1/2015 3,710.44 € 329.51 € 3,380.93 € 111,424.12 € 88,575.88 €

1/1/2016 3,710.44 € 317.40 € 3,393.05 € 114,817.16 € 85,182.84 €

2/1/2016 3,710.44 € 305.24 € 3,405.20 € 118,222.37 € 81,777.63 €

3/1/2016 3,710.44 € 293.04 € 3,417.41 € 121,639.77 € 78,360.23 €

4/1/2016 3,710.44 € 280.79 € 3,429.65 € 125,069.43 € 74,930.57 €

5/1/2016 3,710.44 € 268.50 € 3,441.94 € 128,511.37 € 71,488.63 €

6/1/2016 3,710.44 € 256.17 € 3,454.28 € 131,965.64 € 68,034.36 €

7/1/2016 3,710.44 € 243.79 € 3,466.65 € 135,432.30 € 64,567.70 €

8/1/2016 3,710.44 € 231.37 € 3,479.08 € 138,911.37 € 61,088.63 €

9/1/2016 3,710.44 € 218.90 € 3,491.54 € 142,402.91 € 57,597.09 €

10/1/2016 3,710.44 € 206.39 € 3,504.05 € 145,906.97 € 54,093.03 €

11/1/2016 3,710.44 € 193.83 € 3,516.61 € 149,423.58 € 50,576.42 €

12/1/2016 3,710.44 € 181.23 € 3,529.21 € 152,952.79 € 47,047.21 €

1/1/2017 3,710.44 € 168.59 € 3,541.86 € 156,494.64 € 43,505.36 €

2/1/2017 3,710.44 € 155.89 € 3,554.55 € 160,049.19 € 39,950.81 €

3/1/2017 3,710.44 € 143.16 € 3,567.29 € 163,616.48 € 36,383.52 €

4/1/2017 3,710.44 € 130.37 € 3,580.07 € 167,196.55 € 32,803.45 €

5/1/2017 3,710.44 € 117.55 € 3,592.90 € 170,789.44 € 29,210.56 €

6/1/2017 3,710.44 € 104.67 € 3,605.77 € 174,395.21 € 25,604.79 €

7/1/2017 3,710.44 € 91.75 € 3,618.69 € 178,013.91 € 21,986.09 €

8/1/2017 3,710.44 € 78.78 € 3,631.66 € 181,645.57 € 18,354.43 €

9/1/2017 3,710.44 € 65.77 € 3,644.67 € 185,290.24 € 14,709.76 €

10/1/2017 3,710.44 € 52.71 € 3,657.73 € 188,947.97 € 11,052.03 €

11/1/2017 3,710.44 € 39.60 € 3,670.84 € 192,618.81 € 7,381.19 €

12/1/2017 3,710.44 € 26.45 € 3,683.99 € 196,302.81 € 3,697.19 €

1/1/2018 3,710.44 € 13.25 € 3,697.19 € 200,000.00 € 0.00 €