Transcript
Page 1: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 1/25

* Actual number of payments may be shortened by making extra payments.

Numero de

Pagos

fecha de

pagosBalance Inicial

Pago

establecidoPago Extra Pago Total

1 2/1/2013 $1,500,000.00 $42,637.23 $0.00 $42,637.23

2 3/1/2013 $1,459,237.77 $42,637.23 $0.00 $42,637.23

3 4/1/2013 $1,418,424.59 $42,637.23 $0.00 $42,637.23

4 5/1/2013 $1,377,560.39 $42,637.23 $0.00 $42,637.23

5 6/1/2013 $1,336,645.11 $42,637.23 $0.00 $42,637.23

6 7/1/2013 $1,295,678.69 $42,637.23 $0.00 $42,637.23

7 8/1/2013 $1,254,661.06 $42,637.23 $0.00 $42,637.23

8 9/1/2013 $1,213,592.15 $42,637.23 $0.00 $42,637.23

9 10/1/2013 $1,172,471.91 $42,637.23 $0.00 $42,637.23

10 11/1/2013 $1,131,300.27 $42,637.23 $0.00 $42,637.23

11 12/1/2013 $1,090,077.17 $42,637.23 $0.00 $42,637.23

12 1/1/2014 $1,048,802.54 $42,637.23 $0.00 $42,637.23

13 2/1/2014 $1,007,476.31 $42,637.23 $0.00 $42,637.23

14 3/1/2014 $966,098.43 $42,637.23 $0.00 $42,637.23

15 4/1/2014 $924,668.82 $42,637.23 $0.00 $42,637.2316 5/1/2014 $883,187.43 $42,637.23 $0.00 $42,637.23

17 6/1/2014 $841,654.18 $42,637.23 $0.00 $42,637.23

18 7/1/2014 $800,069.02 $42,637.23 $0.00 $42,637.23

19 8/1/2014 $758,431.88 $42,637.23 $0.00 $42,637.23

20 9/1/2014 $716,742.69 $42,637.23 $0.00 $42,637.23

21 10/1/2014 $675,001.38 $42,637.23 $0.00 $42,637.23

22 11/1/2014 $633,207.91 $42,637.23 $0.00 $42,637.23

23 12/1/2014 $591,362.19 $42,637.23 $0.00 $42,637.23

Enter Loan Information in Light Blue Cells Below

Loan Summary

Scheduled Payment Amount (Per Period) $42,637.23

Number of Payments Per Year 

number of Payments Per Year 

Face Value of Loan (Original Amount)

Loan Commencement Date

 Annual Interest Rate

Loan Period in Years

Extra Payment Per Period (If Any)

ROGER PRESTAMOS

$1,500,000.00

1.50%

3

12

TABLA DE AMORTIZACION

Total Amount of Extra Payments $0.00

Total Interest Paid $34,940.26

$0.001/1/2013

Loan Payoff Date 1/1/2016

 Actual Number of Payments* 36

Scheduled Number of Payments 36

Page 2: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 2/25

24 1/1/2015 $549,464.16 $42,637.23 $0.00 $42,637.23

25 2/1/2015 $507,513.76 $42,637.23 $0.00 $42,637.23

26 3/1/2015 $465,510.92 $42,637.23 $0.00 $42,637.23

27 4/1/2015 $423,455.58 $42,637.23 $0.00 $42,637.23

28 5/1/2015 $381,347.67 $42,637.23 $0.00 $42,637.23

29 6/1/2015 $339,187.13 $42,637.23 $0.00 $42,637.23

30 7/1/2015 $296,973.88 $42,637.23 $0.00 $42,637.2331 8/1/2015 $254,707.87 $42,637.23 $0.00 $42,637.23

32 9/1/2015 $212,389.03 $42,637.23 $0.00 $42,637.23

33 10/1/2015 $170,017.28 $42,637.23 $0.00 $42,637.23

34 11/1/2015 $127,592.57 $42,637.23 $0.00 $42,637.23

35 12/1/2015 $85,114.84 $42,637.23 $0.00 $42,637.23

36 1/1/2016 $42,584.00 $42,584.00 $0.00 $42,584.00

Page 3: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 3/25

Principal Intereses Balance Final

$40,762.23 $1,875.00 $1,459,237.77

$40,813.18 $1,824.05 $1,418,424.59

$40,864.20 $1,773.03 $1,377,560.39

$40,915.28 $1,721.95 $1,336,645.11

$40,966.42 $1,670.81 $1,295,678.69

$41,017.63 $1,619.60 $1,254,661.06

$41,068.90 $1,568.33 $1,213,592.15

$41,120.24 $1,516.99 $1,172,471.91

$41,171.64 $1,465.59 $1,131,300.27

$41,223.10 $1,414.13 $1,090,077.17

$41,274.63 $1,362.60 $1,048,802.54

$41,326.23 $1,311.00 $1,007,476.31

$41,377.88 $1,259.35 $966,098.43

$41,429.61 $1,207.62 $924,668.82

$41,481.39 $1,155.84 $883,187.43$41,533.25 $1,103.98 $841,654.18

$41,585.16 $1,052.07 $800,069.02

$41,637.14 $1,000.09 $758,431.88

$41,689.19 $948.04 $716,742.69

$41,741.30 $895.93 $675,001.38

$41,793.48 $843.75 $633,207.91

$41,845.72 $791.51 $591,362.19

$41,898.03 $739.20 $549,464.16

Page 4: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 4/25

$41,950.40 $686.83 $507,513.76

$42,002.84 $634.39 $465,510.92

$42,055.34 $581.89 $423,455.58

$42,107.91 $529.32 $381,347.67

$42,160.54 $476.68 $339,187.13

$42,213.25 $423.98 $296,973.88

$42,266.01 $371.22 $254,707.87$42,318.84 $318.38 $212,389.03

$42,371.74 $265.49 $170,017.28

$42,424.71 $212.52 $127,592.57

$42,477.74 $159.49 $85,114.84

$42,530.84 $106.39 $42,584.00

$42,530.77 $53.23 ($0.00)

Page 5: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 5/25

* Actual number of payments may be shortened by making extra payments.

Numero de

pagosFecha De Pago Balance Inicial Pago Estipulado Pago Extra Pago Total

1 2/1/2013 $1,719,000.00 $48,862.27 $0.00 $48,862.27

2 3/1/2013 $1,672,286.48 $48,862.27 $0.00 $48,862.27

3 4/1/2013 $1,625,514.58 $48,862.27 $0.00 $48,862.27

4 5/1/2013 $1,578,684.21 $48,862.27 $0.00 $48,862.27

5 6/1/2013 $1,531,795.30 $48,862.27 $0.00 $48,862.27

6 7/1/2013 $1,484,847.78 $48,862.27 $0.00 $48,862.27

7 8/1/2013 $1,437,841.57 $48,862.27 $0.00 $48,862.27

8 9/1/2013 $1,390,776.61 $48,862.27 $0.00 $48,862.27

9 10/1/2013 $1,343,652.81 $48,862.27 $0.00 $48,862.27

10 11/1/2013 $1,296,470.11 $48,862.27 $0.00 $48,862.27

11 12/1/2013 $1,249,228.44 $48,862.27 $0.00 $48,862.27

12 1/1/2014 $1,201,927.71 $48,862.27 $0.00 $48,862.27

13 2/1/2014 $1,154,567.85 $48,862.27 $0.00 $48,862.27

14 3/1/2014 $1,107,148.80 $48,862.27 $0.00 $48,862.27

15 4/1/2014 $1,059,670.47 $48,862.27 $0.00 $48,862.2716 5/1/2014 $1,012,132.79 $48,862.27 $0.00 $48,862.27

17 6/1/2014 $964,535.69 $48,862.27 $0.00 $48,862.27

18 7/1/2014 $916,879.10 $48,862.27 $0.00 $48,862.27

19 8/1/2014 $869,162.93 $48,862.27 $0.00 $48,862.27

20 9/1/2014 $821,387.12 $48,862.27 $0.00 $48,862.27

21 10/1/2014 $773,551.59 $48,862.27 $0.00 $48,862.27

22 11/1/2014 $725,656.26 $48,862.27 $0.00 $48,862.27

23 12/1/2014 $677,701.07 $48,862.27 $0.00 $48,862.27

Enter Loan Information in Light Blue Cells Below

Loan Summary

Scheduled Payment Amount (Per Period) $48,862.27

Number of Payments Per Year 

Name of Loan And/Or Lender 

Face Value of Loan (Original Amount)

Loan Commencement Date

 Annual Interest Rate

Loan Period in Years

Extra Payment Per Period (If Any)

ROGER PRESTAMOS

$1,719,000.00

1.50%

3

12

Tabla De Amortizacion

Total Amount of Extra Payments $0.00

Total Interest Paid $40,041.54

$0.001/1/2013

Loan Payoff Date 1/1/2016

 Actual Number of Payments* 36

Scheduled Number of Payments 36

Page 6: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 6/25

24 1/1/2015 $629,685.93 $48,862.27 $0.00 $48,862.27

25 2/1/2015 $581,610.77 $48,862.27 $0.00 $48,862.27

26 3/1/2015 $533,475.52 $48,862.27 $0.00 $48,862.27

27 4/1/2015 $485,280.10 $48,862.27 $0.00 $48,862.27

28 5/1/2015 $437,024.43 $48,862.27 $0.00 $48,862.27

29 6/1/2015 $388,708.45 $48,862.27 $0.00 $48,862.27

30 7/1/2015 $340,332.07 $48,862.27 $0.00 $48,862.2731 8/1/2015 $291,895.22 $48,862.27 $0.00 $48,862.27

32 9/1/2015 $243,397.82 $48,862.27 $0.00 $48,862.27

33 10/1/2015 $194,839.81 $48,862.27 $0.00 $48,862.27

34 11/1/2015 $146,221.09 $48,862.27 $0.00 $48,862.27

35 12/1/2015 $97,541.60 $48,862.27 $0.00 $48,862.27

36 1/1/2016 $48,801.26 $48,801.26 $0.00 $48,801.26

Page 7: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 7/25

Principal Intereses Balance Final

$46,713.52 $2,148.75 $1,672,286.48

$46,771.91 $2,090.36 $1,625,514.58

$46,830.37 $2,031.89 $1,578,684.21

$46,888.91 $1,973.36 $1,531,795.30

$46,947.52 $1,914.74 $1,484,847.78

$47,006.21 $1,856.06 $1,437,841.57

$47,064.96 $1,797.30 $1,390,776.61

$47,123.79 $1,738.47 $1,343,652.81

$47,182.70 $1,679.57 $1,296,470.11

$47,241.68 $1,620.59 $1,249,228.44

$47,300.73 $1,561.54 $1,201,927.71

$47,359.86 $1,502.41 $1,154,567.85

$47,419.06 $1,443.21 $1,107,148.80

$47,478.33 $1,383.94 $1,059,670.47

$47,537.68 $1,324.59 $1,012,132.79$47,597.10 $1,265.17 $964,535.69

$47,656.60 $1,205.67 $916,879.10

$47,716.17 $1,146.10 $869,162.93

$47,775.81 $1,086.45 $821,387.12

$47,835.53 $1,026.73 $773,551.59

$47,895.33 $966.94 $725,656.26

$47,955.19 $907.07 $677,701.07

$48,015.14 $847.13 $629,685.93

El Monto a pagar mensual seria de RD$ 48,862.27 sin incluir la otra partida

calculando exclusivamente el costo de los contenedores y el elevador de

contenedores ;tambien habria que incluir los gastos de cierre.

Page 8: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 8/25

$48,075.16 $787.11 $581,610.77

$48,135.25 $727.01 $533,475.52

$48,195.42 $666.84 $485,280.10

$48,255.66 $606.60 $437,024.43

$48,315.98 $546.28 $388,708.45

$48,376.38 $485.89 $340,332.07

$48,436.85 $425.42 $291,895.22$48,497.40 $364.87 $243,397.82

$48,558.02 $304.25 $194,839.81

$48,618.72 $243.55 $146,221.09

$48,679.49 $182.78 $97,541.60

$48,740.34 $121.93 $48,801.26

$48,740.26 $61.00 $0.00

Page 9: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 9/25

* Actual number of payments may be shortened by making extra payments.

Numero De

pagos

Fecha De

pagoBalance Inicial Pago Estipulado Pago Extra Pago Total

1 2/1/2013 $3,319,000.00 $94,341.98 $0.00 $94,341.98

2 3/1/2013 $3,228,806.77 $94,341.98 $0.00 $94,341.98

3 4/1/2013 $3,138,500.81 $94,341.98 $0.00 $94,341.98

4 5/1/2013 $3,048,081.95 $94,341.98 $0.00 $94,341.98

5 6/1/2013 $2,957,550.08 $94,341.98 $0.00 $94,341.98

6 7/1/2013 $2,866,905.04 $94,341.98 $0.00 $94,341.98

7 8/1/2013 $2,776,146.70 $94,341.98 $0.00 $94,341.98

8 9/1/2013 $2,685,274.90 $94,341.98 $0.00 $94,341.98

9 10/1/2013 $2,594,289.52 $94,341.98 $0.00 $94,341.98

10 11/1/2013 $2,503,190.41 $94,341.98 $0.00 $94,341.98

11 12/1/2013 $2,411,977.42 $94,341.98 $0.00 $94,341.98

12 1/1/2014 $2,320,650.41 $94,341.98 $0.00 $94,341.98

13 2/1/2014 $2,229,209.25 $94,341.98 $0.00 $94,341.98

14 3/1/2014 $2,137,653.78 $94,341.98 $0.00 $94,341.98

15 4/1/2014 $2,045,983.87 $94,341.98 $0.00 $94,341.9816 5/1/2014 $1,954,199.38 $94,341.98 $0.00 $94,341.98

17 6/1/2014 $1,862,300.15 $94,341.98 $0.00 $94,341.98

18 7/1/2014 $1,770,286.05 $94,341.98 $0.00 $94,341.98

19 8/1/2014 $1,678,156.93 $94,341.98 $0.00 $94,341.98

20 9/1/2014 $1,585,912.65 $94,341.98 $0.00 $94,341.98

21 10/1/2014 $1,493,553.06 $94,341.98 $0.00 $94,341.98

22 11/1/2014 $1,401,078.03 $94,341.98 $0.00 $94,341.98

23 12/1/2014 $1,308,487.40 $94,341.98 $0.00 $94,341.98

Informacion Del Prestamo

Resumen Del Prestamo

Scheduled Payment Amount (Per Period) $94,341.98

Number of Payments Per Year 

Name of Loan And/Or Lender 

Face Value of Loan (Original Amount)

Loan Commencement Date

 Annual Interest Rate

Loan Period in Years

Extra Payment Per Period (If Any)

ROGER PRESTAMOS

$3,319,000.00

1.50%

3

12

Tabla De Amortizacion

Total Amount of Extra Payments $0.00

Total Interest Paid $77,311.16

$0.001/1/2013

Loan Payoff Date 1/1/2016

 Actual Number of Payments* 36

Scheduled Number of Payments 36

Page 10: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 10/25

24 1/1/2015 $1,215,781.03 $94,341.98 $0.00 $94,341.98

25 2/1/2015 $1,122,958.78 $94,341.98 $0.00 $94,341.98

26 3/1/2015 $1,030,020.50 $94,341.98 $0.00 $94,341.98

27 4/1/2015 $936,966.05 $94,341.98 $0.00 $94,341.98

28 5/1/2015 $843,795.28 $94,341.98 $0.00 $94,341.98

29 6/1/2015 $750,508.05 $94,341.98 $0.00 $94,341.98

30 7/1/2015 $657,104.21 $94,341.98 $0.00 $94,341.9831 8/1/2015 $563,583.61 $94,341.98 $0.00 $94,341.98

32 9/1/2015 $469,946.12 $94,341.98 $0.00 $94,341.98

33 10/1/2015 $376,191.57 $94,341.98 $0.00 $94,341.98

34 11/1/2015 $282,319.84 $94,341.98 $0.00 $94,341.98

35 12/1/2015 $188,330.76 $94,341.98 $0.00 $94,341.98

36 1/1/2016 $94,224.20 $94,224.20 $0.00 $94,224.20

Page 11: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 11/25

Principal Intereses Balance Final

$90,193.23 $4,148.75 $3,228,806.77

$90,305.97 $4,036.01 $3,138,500.81

$90,418.85 $3,923.13 $3,048,081.95

$90,531.87 $3,810.10 $2,957,550.08

$90,645.04 $3,696.94 $2,866,905.04

$90,758.35 $3,583.63 $2,776,146.70

$90,871.79 $3,470.18 $2,685,274.90

$90,985.38 $3,356.59 $2,594,289.52

$91,099.11 $3,242.86 $2,503,190.41

$91,212.99 $3,128.99 $2,411,977.42

$91,327.00 $3,014.97 $2,320,650.41

$91,441.16 $2,900.81 $2,229,209.25

$91,555.46 $2,786.51 $2,137,653.78

$91,669.91 $2,672.07 $2,045,983.87

$91,784.50 $2,557.48 $1,954,199.38$91,899.23 $2,442.75 $1,862,300.15

$92,014.10 $2,327.88 $1,770,286.05

$92,129.12 $2,212.86 $1,678,156.93

$92,244.28 $2,097.70 $1,585,912.65

$92,359.59 $1,982.39 $1,493,553.06

$92,475.04 $1,866.94 $1,401,078.03

$92,590.63 $1,751.35 $1,308,487.40

$92,706.37 $1,635.61 $1,215,781.03

El Monto a Pagar seria de RD$ 94,341.98 /mes y aqui se esta inc

costo del camion contenedor(RD$ 1.6 millones) sin incluir la otr 

cuota a determinar;este es el paquete completo de contene

camiones.

Page 12: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 12/25

$92,822.25 $1,519.73 $1,122,958.78

$92,938.28 $1,403.70 $1,030,020.50

$93,054.45 $1,287.53 $936,966.05

$93,170.77 $1,171.21 $843,795.28

$93,287.23 $1,054.74 $750,508.05

$93,403.84 $938.14 $657,104.21

$93,520.60 $821.38 $563,583.61$93,637.50 $704.48 $469,946.12

$93,754.54 $587.43 $376,191.57

$93,871.74 $470.24 $282,319.84

$93,989.08 $352.90 $188,330.76

$94,106.56 $235.41 $94,224.20

$94,106.42 $117.78 $0.00

Page 13: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 13/25

luyendo el

a partida o

ores y

Page 14: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 14/25

* Actual number of payments may be shortened by making extra payments.

Numero de

PagoFecha del Pago Balance Inicial

Pago

EstipuladoPago Extra Pago Total

1 2/1/2013 $1,600,000.00 $45,479.71 $0.00 $45,479.71

2 3/1/2013 $1,556,520.29 $45,479.71 $0.00 $45,479.71

3 4/1/2013 $1,512,986.23 $45,479.71 $0.00 $45,479.71

4 5/1/2013 $1,469,397.75 $45,479.71 $0.00 $45,479.71

5 6/1/2013 $1,425,754.78 $45,479.71 $0.00 $45,479.71

6 7/1/2013 $1,382,057.27 $45,479.71 $0.00 $45,479.71

7 8/1/2013 $1,338,305.13 $45,479.71 $0.00 $45,479.71

8 9/1/2013 $1,294,498.30 $45,479.71 $0.00 $45,479.71

9 10/1/2013 $1,250,636.71 $45,479.71 $0.00 $45,479.71

10 11/1/2013 $1,206,720.29 $45,479.71 $0.00 $45,479.71

11 12/1/2013 $1,162,748.98 $45,479.71 $0.00 $45,479.71

12 1/1/2014 $1,118,722.71 $45,479.71 $0.00 $45,479.71

13 2/1/2014 $1,074,641.40 $45,479.71 $0.00 $45,479.71

14 3/1/2014 $1,030,504.99 $45,479.71 $0.00 $45,479.71

15 4/1/2014 $986,313.41 $45,479.71 $0.00 $45,479.7116 5/1/2014 $942,066.59 $45,479.71 $0.00 $45,479.71

17 6/1/2014 $897,764.46 $45,479.71 $0.00 $45,479.71

18 7/1/2014 $853,406.95 $45,479.71 $0.00 $45,479.71

19 8/1/2014 $808,994.00 $45,479.71 $0.00 $45,479.71

20 9/1/2014 $764,525.53 $45,479.71 $0.00 $45,479.71

21 10/1/2014 $720,001.48 $45,479.71 $0.00 $45,479.71

22 11/1/2014 $675,421.77 $45,479.71 $0.00 $45,479.71

23 12/1/2014 $630,786.33 $45,479.71 $0.00 $45,479.71

Informacion Del Prestamo

Resumen Del Prestamo

Scheduled Payment Amount (Per Period) $45,479.71

Number of Payments Per Year 

Name of Loan And/Or Lender 

Face Value of Loan (Original Amount)

Loan Commencement Date

 Annual Interest Rate

Loan Period in Years

Extra Payment Per Period (If Any)

ROGER PRESTAMOS

$1,600,000.00

1.50%

3

12

Tabla De Amortizacion

Total Amount of Extra Payments $0.00

Total Interest Paid $37,269.61

$0.001/1/2013

Loan Payoff Date 1/1/2016

 Actual Number of Payments* 36

Scheduled Number of Payments 36

Page 15: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 15/25

24 1/1/2015 $586,095.10 $45,479.71 $0.00 $45,479.71

25 2/1/2015 $541,348.01 $45,479.71 $0.00 $45,479.71

26 3/1/2015 $496,544.99 $45,479.71 $0.00 $45,479.71

27 4/1/2015 $451,685.96 $45,479.71 $0.00 $45,479.71

28 5/1/2015 $406,770.85 $45,479.71 $0.00 $45,479.71

29 6/1/2015 $361,799.60 $45,479.71 $0.00 $45,479.71

30 7/1/2015 $316,772.14 $45,479.71 $0.00 $45,479.7131 8/1/2015 $271,688.39 $45,479.71 $0.00 $45,479.71

32 9/1/2015 $226,548.29 $45,479.71 $0.00 $45,479.71

33 10/1/2015 $181,351.77 $45,479.71 $0.00 $45,479.71

34 11/1/2015 $136,098.75 $45,479.71 $0.00 $45,479.71

35 12/1/2015 $90,789.16 $45,479.71 $0.00 $45,479.71

36 1/1/2016 $45,422.93 $45,422.93 $0.00 $45,422.93

Page 16: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 16/25

Principal Intereses Balance Final

$43,479.71 $2,000.00 $1,556,520.29

$43,534.06 $1,945.65 $1,512,986.23

$43,588.48 $1,891.23 $1,469,397.75

$43,642.96 $1,836.75 $1,425,754.78

$43,697.52 $1,782.19 $1,382,057.27

$43,752.14 $1,727.57 $1,338,305.13

$43,806.83 $1,672.88 $1,294,498.30

$43,861.59 $1,618.12 $1,250,636.71

$43,916.42 $1,563.30 $1,206,720.29

$43,971.31 $1,508.40 $1,162,748.98

$44,026.28 $1,453.44 $1,118,722.71

$44,081.31 $1,398.40 $1,074,641.40

$44,136.41 $1,343.30 $1,030,504.99

$44,191.58 $1,288.13 $986,313.41

$44,246.82 $1,232.89 $942,066.59$44,302.13 $1,177.58 $897,764.46

$44,357.51 $1,122.21 $853,406.95

$44,412.95 $1,066.76 $808,994.00

$44,468.47 $1,011.24 $764,525.53

$44,524.05 $955.66 $720,001.48

$44,579.71 $900.00 $675,421.77

$44,635.43 $844.28 $630,786.33

$44,691.23 $788.48 $586,095.10

El Monto a pagar seria de RD$ 45,479.71 y seria exclusivamente el

precio del camion contenedor sin ninguno de los otros costos.

Page 17: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 17/25

$44,747.09 $732.62 $541,348.01

$44,803.03 $676.69 $496,544.99

$44,859.03 $620.68 $451,685.96

$44,915.10 $564.61 $406,770.85

$44,971.25 $508.46 $361,799.60

$45,027.46 $452.25 $316,772.14

$45,083.75 $395.97 $271,688.39$45,140.10 $339.61 $226,548.29

$45,196.53 $283.19 $181,351.77

$45,253.02 $226.69 $136,098.75

$45,309.59 $170.12 $90,789.16

$45,366.23 $113.49 $45,422.93

$45,366.15 $56.78 $0.00

Page 18: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 18/25

* Actual number of payments may be shortened by making extra payments.

Numero de

PagoFecha del Pago Balance Inicial

Pago

EstipuladoPago Extra Pago Total

1 2/1/2013 $500,000.00 $14,212.41 $0.00 $14,212.41

2 3/1/2013 $486,412.59 $14,212.41 $0.00 $14,212.41

3 4/1/2013 $472,808.20 $14,212.41 $0.00 $14,212.41

4 5/1/2013 $459,186.80 $14,212.41 $0.00 $14,212.41

5 6/1/2013 $445,548.37 $14,212.41 $0.00 $14,212.41

6 7/1/2013 $431,892.90 $14,212.41 $0.00 $14,212.41

7 8/1/2013 $418,220.35 $14,212.41 $0.00 $14,212.41

8 9/1/2013 $404,530.72 $14,212.41 $0.00 $14,212.41

9 10/1/2013 $390,823.97 $14,212.41 $0.00 $14,212.41

10 11/1/2013 $377,100.09 $14,212.41 $0.00 $14,212.41

11 12/1/2013 $363,359.06 $14,212.41 $0.00 $14,212.41

12 1/1/2014 $349,600.85 $14,212.41 $0.00 $14,212.41

13 2/1/2014 $335,825.44 $14,212.41 $0.00 $14,212.41

14 3/1/2014 $322,032.81 $14,212.41 $0.00 $14,212.41

15 4/1/2014 $308,222.94 $14,212.41 $0.00 $14,212.4116 5/1/2014 $294,395.81 $14,212.41 $0.00 $14,212.41

17 6/1/2014 $280,551.39 $14,212.41 $0.00 $14,212.41

18 7/1/2014 $266,689.67 $14,212.41 $0.00 $14,212.41

19 8/1/2014 $252,810.63 $14,212.41 $0.00 $14,212.41

20 9/1/2014 $238,914.23 $14,212.41 $0.00 $14,212.41

21 10/1/2014 $225,000.46 $14,212.41 $0.00 $14,212.41

22 11/1/2014 $211,069.30 $14,212.41 $0.00 $14,212.41

23 12/1/2014 $197,120.73 $14,212.41 $0.00 $14,212.41

Informacion Del Prestamo

Resumen del Prestamo

Scheduled Payment Amount (Per Period) $14,212.41

Number of Payments Per Year 

Name of Loan And/Or Lender 

Face Value of Loan (Original Amount)

Loan Commencement Date

 Annual Interest Rate

Loan Period in Years

Extra Payment Per Period (If Any)

ROGER PRESTAMOS

$500,000.00

1.50%

3

12

Tabla De Amortizacion

Total Amount of Extra Payments $0.00

Total Interest Paid $11,646.75

$0.001/1/2013

Loan Payoff Date 1/1/2016

 Actual Number of Payments* 36

Scheduled Number of Payments 36

Page 19: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 19/25

24 1/1/2015 $183,154.72 $14,212.41 $0.00 $14,212.41

25 2/1/2015 $169,171.25 $14,212.41 $0.00 $14,212.41

26 3/1/2015 $155,170.31 $14,212.41 $0.00 $14,212.41

27 4/1/2015 $141,151.86 $14,212.41 $0.00 $14,212.41

28 5/1/2015 $127,115.89 $14,212.41 $0.00 $14,212.41

29 6/1/2015 $113,062.38 $14,212.41 $0.00 $14,212.41

30 7/1/2015 $98,991.29 $14,212.41 $0.00 $14,212.4131 8/1/2015 $84,902.62 $14,212.41 $0.00 $14,212.41

32 9/1/2015 $70,796.34 $14,212.41 $0.00 $14,212.41

33 10/1/2015 $56,672.43 $14,212.41 $0.00 $14,212.41

34 11/1/2015 $42,530.86 $14,212.41 $0.00 $14,212.41

35 12/1/2015 $28,371.61 $14,212.41 $0.00 $14,212.41

36 1/1/2016 $14,194.67 $14,194.67 $0.00 $14,194.67

Page 20: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 20/25

Principal Intereses Balance Final

$13,587.41 $625.00 $486,412.59

$13,604.39 $608.02 $472,808.20

$13,621.40 $591.01 $459,186.80

$13,638.43 $573.98 $445,548.37

$13,655.47 $556.94 $431,892.90

$13,672.54 $539.87 $418,220.35

$13,689.63 $522.78 $404,530.72

$13,706.75 $505.66 $390,823.97

$13,723.88 $488.53 $377,100.09

$13,741.03 $471.38 $363,359.06

$13,758.21 $454.20 $349,600.85

$13,775.41 $437.00 $335,825.44

$13,792.63 $419.78 $322,032.81

$13,809.87 $402.54 $308,222.94

$13,827.13 $385.28 $294,395.81$13,844.42 $367.99 $280,551.39

$13,861.72 $350.69 $266,689.67

$13,879.05 $333.36 $252,810.63

$13,896.40 $316.01 $238,914.23

$13,913.77 $298.64 $225,000.46

$13,931.16 $281.25 $211,069.30

$13,948.57 $263.84 $197,120.73

$13,966.01 $246.40 $183,154.72

El Monto a pagar seria de RD$ 14,212.41 para un prestamo de RD$

500,000.00 sin incluir ninguno de las demas partidas.

Page 21: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 21/25

$13,983.47 $228.94 $169,171.25

$14,000.95 $211.46 $155,170.31

$14,018.45 $193.96 $141,151.86

$14,035.97 $176.44 $127,115.89

$14,053.51 $158.89 $113,062.38

$14,071.08 $141.33 $98,991.29

$14,088.67 $123.74 $84,902.62$14,106.28 $106.13 $70,796.34

$14,123.91 $88.50 $56,672.43

$14,141.57 $70.84 $42,530.86

$14,159.25 $53.16 $28,371.61

$14,176.95 $35.46 $14,194.67

$14,176.92 $17.74 $0.00

Page 22: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 22/25

* Actual number of payments may be shortened by making extra payments.

Numero del

PagoFecha de Pago Balance Inicial

Pago

EstipuladoPago Extra Pago Total

1 2/1/2013 $1,000,000.00 $28,424.82 $0.00 $28,424.82

2 3/1/2013 $972,825.18 $28,424.82 $0.00 $28,424.82

3 4/1/2013 $945,616.39 $28,424.82 $0.00 $28,424.82

4 5/1/2013 $918,373.59 $28,424.82 $0.00 $28,424.82

5 6/1/2013 $891,096.74 $28,424.82 $0.00 $28,424.82

6 7/1/2013 $863,785.79 $28,424.82 $0.00 $28,424.82

7 8/1/2013 $836,440.70 $28,424.82 $0.00 $28,424.82

8 9/1/2013 $809,061.44 $28,424.82 $0.00 $28,424.82

9 10/1/2013 $781,647.94 $28,424.82 $0.00 $28,424.82

10 11/1/2013 $754,200.18 $28,424.82 $0.00 $28,424.82

11 12/1/2013 $726,718.11 $28,424.82 $0.00 $28,424.82

12 1/1/2014 $699,201.69 $28,424.82 $0.00 $28,424.82

13 2/1/2014 $671,650.87 $28,424.82 $0.00 $28,424.82

14 3/1/2014 $644,065.62 $28,424.82 $0.00 $28,424.82

15 4/1/2014 $616,445.88 $28,424.82 $0.00 $28,424.8216 5/1/2014 $588,791.62 $28,424.82 $0.00 $28,424.82

17 6/1/2014 $561,102.79 $28,424.82 $0.00 $28,424.82

18 7/1/2014 $533,379.35 $28,424.82 $0.00 $28,424.82

19 8/1/2014 $505,621.25 $28,424.82 $0.00 $28,424.82

20 9/1/2014 $477,828.46 $28,424.82 $0.00 $28,424.82

21 10/1/2014 $450,000.92 $28,424.82 $0.00 $28,424.82

22 11/1/2014 $422,138.60 $28,424.82 $0.00 $28,424.82

23 12/1/2014 $394,241.46 $28,424.82 $0.00 $28,424.82

Informacion Del Prestamo

Resumen Del Prestamo

Scheduled Payment Amount (Per Period) $28,424.82

Number of Payments Per Year 

Name of Loan And/Or Lender 

Face Value of Loan (Original Amount)

Loan Commencement Date

 Annual Interest Rate

Loan Period in Years

Extra Payment Per Period (If Any)

ROGER PRESTAMOS

$1,000,000.00

1.50%

3

12

Tabla De Amortizacion

Total Amount of Extra Payments $0.00

Total Interest Paid $23,293.51

$0.001/1/2013

Loan Payoff Date 1/1/2016

 Actual Number of Payments* 36

Scheduled Number of Payments 36

Page 23: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 23/25

24 1/1/2015 $366,309.44 $28,424.82 $0.00 $28,424.82

25 2/1/2015 $338,342.51 $28,424.82 $0.00 $28,424.82

26 3/1/2015 $310,340.62 $28,424.82 $0.00 $28,424.82

27 4/1/2015 $282,303.72 $28,424.82 $0.00 $28,424.82

28 5/1/2015 $254,231.78 $28,424.82 $0.00 $28,424.82

29 6/1/2015 $226,124.75 $28,424.82 $0.00 $28,424.82

30 7/1/2015 $197,982.59 $28,424.82 $0.00 $28,424.8231 8/1/2015 $169,805.25 $28,424.82 $0.00 $28,424.82

32 9/1/2015 $141,592.68 $28,424.82 $0.00 $28,424.82

33 10/1/2015 $113,344.85 $28,424.82 $0.00 $28,424.82

34 11/1/2015 $85,061.72 $28,424.82 $0.00 $28,424.82

35 12/1/2015 $56,743.22 $28,424.82 $0.00 $28,424.82

36 1/1/2016 $28,389.33 $28,389.33 $0.00 $28,389.33

Page 24: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 24/25

Principal Intereses Balance Final

$27,174.82 $1,250.00 $972,825.18

$27,208.79 $1,216.03 $945,616.39

$27,242.80 $1,182.02 $918,373.59

$27,276.85 $1,147.97 $891,096.74

$27,310.95 $1,113.87 $863,785.79

$27,345.09 $1,079.73 $836,440.70

$27,379.27 $1,045.55 $809,061.44

$27,413.49 $1,011.33 $781,647.94

$27,447.76 $977.06 $754,200.18

$27,482.07 $942.75 $726,718.11

$27,516.42 $908.40 $699,201.69

$27,550.82 $874.00 $671,650.87

$27,585.26 $839.56 $644,065.62

$27,619.74 $805.08 $616,445.88

$27,654.26 $770.56 $588,791.62$27,688.83 $735.99 $561,102.79

$27,723.44 $701.38 $533,379.35

$27,758.10 $666.72 $505,621.25

$27,792.79 $632.03 $477,828.46

$27,827.53 $597.29 $450,000.92

$27,862.32 $562.50 $422,138.60

$27,897.15 $527.67 $394,241.46

$27,932.02 $492.80 $366,309.44

El Monto a Pagar seria de RD$ 28,424.82 para un prestamo de un RD$

1,000,000.00 sin incluir las demas partidas.

Page 25: Tablas de Amortizacion Prestamos

7/30/2019 Tablas de Amortizacion Prestamos

http://slidepdf.com/reader/full/tablas-de-amortizacion-prestamos 25/25

$27,966.93 $457.89 $338,342.51

$28,001.89 $422.93 $310,340.62

$28,036.89 $387.93 $282,303.72

$28,071.94 $352.88 $254,231.78

$28,107.03 $317.79 $226,124.75

$28,142.16 $282.66 $197,982.59

$28,177.34 $247.48 $169,805.25$28,212.56 $212.26 $141,592.68

$28,247.83 $176.99 $113,344.85

$28,283.14 $141.68 $85,061.72

$28,318.49 $106.33 $56,743.22

$28,353.89 $70.93 $28,389.33

$28,353.85 $35.49 $0.00


Top Related