loan amortization 1

1
Loan Amortization Schedule Loan amount 26,000.00 $ Scheduled payment 1,253.25 $ Annual interest rate 14.40 % Scheduled number of payments 24 Loan period in years 2 Actual number of payments 24 Number of payments per year 12 Total early payments - $ Start date of loan 10/10/2014 Total interest 4,078.09 $ Optional extra payments Lender name: Pmt. No. Payment Date Beginning Balance Scheduled Payment Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest 1 11/10/2014 26,000.00 $ 1,253.25 $ - $ 1,253.25 $ 941.25 $ 312.00 $ 25,058.75 $ 312.00 $ 2 12/10/2014 25,058.75 $ 1,253.25 $ - $ 1,253.25 $ 952.55 $ 300.70 $ 24,106.20 $ 612.70 $ 3 1/10/2015 24,106.20 $ 1,253.25 $ - $ 1,253.25 $ 963.98 $ 289.27 $ 23,142.22 $ 901.98 $ 4 2/10/2015 23,142.22 $ 1,253.25 $ - $ 1,253.25 $ 975.55 $ 277.71 $ 22,166.67 $ 1,179.69 $ 5 3/10/2015 22,166.67 $ 1,253.25 $ - $ 1,253.25 $ 987.25 $ 266.00 $ 21,179.42 $ 1,445.69 $ 6 4/10/2015 21,179.42 $ 1,253.25 $ - $ 1,253.25 $ 999.10 $ 254.15 $ 20,180.32 $ 1,699.84 $ 7 5/10/2015 20,180.32 $ 1,253.25 $ - $ 1,253.25 $ 1,011.09 $ 242.16 $ 19,169.23 $ 1,942.00 $ 8 6/10/2015 19,169.23 $ 1,253.25 $ - $ 1,253.25 $ 1,023.22 $ 230.03 $ 18,146.00 $ 2,172.03 $ 9 7/10/2015 18,146.00 $ 1,253.25 $ - $ 1,253.25 $ 1,035.50 $ 217.75 $ 17,110.50 $ 2,389.79 $ 10 8/10/2015 17,110.50 $ 1,253.25 $ - $ 1,253.25 $ 1,047.93 $ 205.33 $ 16,062.57 $ 2,595.11 $ 11 9/10/2015 16,062.57 $ 1,253.25 $ - $ 1,253.25 $ 1,060.50 $ 192.75 $ 15,002.07 $ 2,787.86 $ 12 10/10/2015 15,002.07 $ 1,253.25 $ - $ 1,253.25 $ 1,073.23 $ 180.02 $ 13,928.84 $ 2,967.89 $ 13 11/10/2015 13,928.84 $ 1,253.25 $ - $ 1,253.25 $ 1,086.11 $ 167.15 $ 12,842.74 $ 3,135.03 $ 14 12/10/2015 12,842.74 $ 1,253.25 $ - $ 1,253.25 $ 1,099.14 $ 154.11 $ 11,743.59 $ 3,289.15 $ 15 1/10/2016 11,743.59 $ 1,253.25 $ - $ 1,253.25 $ 1,112.33 $ 140.92 $ 10,631.26 $ 3,430.07 $ 16 2/10/2016 10,631.26 $ 1,253.25 $ - $ 1,253.25 $ 1,125.68 $ 127.58 $ 9,505.59 $ 3,557.64 $ 17 3/10/2016 9,505.59 $ 1,253.25 $ - $ 1,253.25 $ 1,139.19 $ 114.07 $ 8,366.40 $ 3,671.71 $ 18 4/10/2016 8,366.40 $ 1,253.25 $ - $ 1,253.25 $ 1,152.86 $ 100.40 $ 7,213.54 $ 3,772.11 $ 19 5/10/2016 7,213.54 $ 1,253.25 $ - $ 1,253.25 $ 1,166.69 $ 86.56 $ 6,046.85 $ 3,858.67 $ 20 6/10/2016 6,046.85 $ 1,253.25 $ - $ 1,253.25 $ 1,180.69 $ 72.56 $ 4,866.16 $ 3,931.23 $ 21 7/10/2016 4,866.16 $ 1,253.25 $ - $ 1,253.25 $ 1,194.86 $ 58.39 $ 3,671.30 $ 3,989.63 $ 22 8/10/2016 3,671.30 $ 1,253.25 $ - $ 1,253.25 $ 1,209.20 $ 44.06 $ 2,462.10 $ 4,033.68 $ 23 9/10/2016 2,462.10 $ 1,253.25 $ - $ 1,253.25 $ 1,223.71 $ 29.55 $ 1,238.39 $ 4,063.23 $ 24 10/10/2016 1,238.39 $ 1,253.25 $ - $ 1,238.39 $ 1,223.53 $ 14.86 $ - $ 4,078.09 $ First gulf bank Enter values Loan summary

Upload: nawazeee2840

Post on 02-Feb-2016

14 views

Category:

Documents


0 download

DESCRIPTION

loan amortization

TRANSCRIPT

Page 1: Loan Amortization 1

Loan Amortization Schedule

Loan amount 26,000.00$ Scheduled payment 1,253.25$ Annual interest rate 14.40 % Scheduled number of payments 24

Loan period in years 2 Actual number of payments 24Number of payments per year 12 Total early payments -$

Start date of loan 10/10/2014 Total interest 4,078.09$ Optional extra payments

Lender name:

Pmt. No. Payment Date Beginning Balance Scheduled

Payment Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest

1 11/10/2014 26,000.00$ 1,253.25$ -$ 1,253.25$ 941.25$ 312.00$ 25,058.75$ 312.00$ 2 12/10/2014 25,058.75$ 1,253.25$ -$ 1,253.25$ 952.55$ 300.70$ 24,106.20$ 612.70$ 3 1/10/2015 24,106.20$ 1,253.25$ -$ 1,253.25$ 963.98$ 289.27$ 23,142.22$ 901.98$ 4 2/10/2015 23,142.22$ 1,253.25$ -$ 1,253.25$ 975.55$ 277.71$ 22,166.67$ 1,179.69$ 5 3/10/2015 22,166.67$ 1,253.25$ -$ 1,253.25$ 987.25$ 266.00$ 21,179.42$ 1,445.69$ 6 4/10/2015 21,179.42$ 1,253.25$ -$ 1,253.25$ 999.10$ 254.15$ 20,180.32$ 1,699.84$ 7 5/10/2015 20,180.32$ 1,253.25$ -$ 1,253.25$ 1,011.09$ 242.16$ 19,169.23$ 1,942.00$ 8 6/10/2015 19,169.23$ 1,253.25$ -$ 1,253.25$ 1,023.22$ 230.03$ 18,146.00$ 2,172.03$ 9 7/10/2015 18,146.00$ 1,253.25$ -$ 1,253.25$ 1,035.50$ 217.75$ 17,110.50$ 2,389.79$ 10 8/10/2015 17,110.50$ 1,253.25$ -$ 1,253.25$ 1,047.93$ 205.33$ 16,062.57$ 2,595.11$ 11 9/10/2015 16,062.57$ 1,253.25$ -$ 1,253.25$ 1,060.50$ 192.75$ 15,002.07$ 2,787.86$ 12 10/10/2015 15,002.07$ 1,253.25$ -$ 1,253.25$ 1,073.23$ 180.02$ 13,928.84$ 2,967.89$ 13 11/10/2015 13,928.84$ 1,253.25$ -$ 1,253.25$ 1,086.11$ 167.15$ 12,842.74$ 3,135.03$ 14 12/10/2015 12,842.74$ 1,253.25$ -$ 1,253.25$ 1,099.14$ 154.11$ 11,743.59$ 3,289.15$ 15 1/10/2016 11,743.59$ 1,253.25$ -$ 1,253.25$ 1,112.33$ 140.92$ 10,631.26$ 3,430.07$ 16 2/10/2016 10,631.26$ 1,253.25$ -$ 1,253.25$ 1,125.68$ 127.58$ 9,505.59$ 3,557.64$ 17 3/10/2016 9,505.59$ 1,253.25$ -$ 1,253.25$ 1,139.19$ 114.07$ 8,366.40$ 3,671.71$ 18 4/10/2016 8,366.40$ 1,253.25$ -$ 1,253.25$ 1,152.86$ 100.40$ 7,213.54$ 3,772.11$ 19 5/10/2016 7,213.54$ 1,253.25$ -$ 1,253.25$ 1,166.69$ 86.56$ 6,046.85$ 3,858.67$ 20 6/10/2016 6,046.85$ 1,253.25$ -$ 1,253.25$ 1,180.69$ 72.56$ 4,866.16$ 3,931.23$ 21 7/10/2016 4,866.16$ 1,253.25$ -$ 1,253.25$ 1,194.86$ 58.39$ 3,671.30$ 3,989.63$ 22 8/10/2016 3,671.30$ 1,253.25$ -$ 1,253.25$ 1,209.20$ 44.06$ 2,462.10$ 4,033.68$ 23 9/10/2016 2,462.10$ 1,253.25$ -$ 1,253.25$ 1,223.71$ 29.55$ 1,238.39$ 4,063.23$ 24 10/10/2016 1,238.39$ 1,253.25$ -$ 1,238.39$ 1,223.53$ 14.86$ -$ 4,078.09$

First gulf bank

Enter values Loan summary