LOAN AMORTIZATION SCHEDULE TEMPLATE

LOAN AMORTIZATION SCHEDULE TEMPLATE

LENDER NAME

LENDER ADDRESS

LENDER PHONE LENDER WEB

CONTACT EMAIL LOAN TYPE

DATE OF LOAN NAME ON LOAN

PYMT #

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

DATE OF PAYMENT

05/01/2018 06/01/2018 07/01/2018 08/01/2018 09/01/2018 10/01/2018 11/01/2018 12/01/2018 01/01/2019 02/01/2019 03/01/2019 04/01/2019 05/01/2019 06/01/2019 07/01/2019 08/01/2019 09/01/2019 10/01/2019

BEGINNING BALANCE

$9,300.00 $8,928.96 $8,556.52 $8,182.69 $7,807.46 $7,430.82 $7,052.77 $6,673.30 $6,292.40 $5,910.08 $5,526.32 $5,141.12 $4,754.48 $4,366.39 $3,976.84 $3,585.83 $3,193.36 $2,799.42

DATA

***Complete SHADED Fields Only

PURCHASE PRICE

PERCENT DOWN PAYMENT

TOTAL DOWN PAYMENT

LOAN AMOUNT

ANNUAL INTEREST RATE

LENGTH OF LOAN IN YEARS

PAYMENT FREQUENCY

Frequency

FIRST PAYMENT DATE

Annual

MONTHLY INTEREST RATE

Semi-Annual

MONTHLY PAYMENT

Quarterly

NUMBER OF PAYMENTS

Bi-Monthly

INTEREST TOTAL

LOAN AMORTIZATION SCHEDULE

SCHEDULED PAYMENT

ADDITIONAL PAYMENT

INTEREST

$405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92 $405.92

$34.88 $33.48 $32.09 $30.69 $29.28 $27.87 $26.45 $25.02 $23.60 $22.16 $20.72 $19.28 $17.83 $16.37 $14.91 $13.45 $11.98 $10.50

19 11/01/2019 20 12/01/2019 21 01/01/2020 22 02/01/2020 23 03/01/2020 24 04/01/2020

$2,404.00 $2,007.09 $1,608.70 $1,208.81

$807.42 $404.53

$405.92 $405.92 $405.92 $405.92 $405.92 $406.05

$9.01 $7.53 $6.03 $4.53 $3.03 $1.52

CLICK HERE TO CREATE LOAN AMORTIZATION SCHEDULE TEMPLATES IN SMARTSHEET

DATA

VALUE

***Complete SHADED Fields Only***

PURCHASE PRICE

$10,000.00

PERCENT DOWN PAYMENT

7.00%

TOTAL DOWN PAYMENT

$700.00

LOAN AMOUNT

$9,300.00

ANNUAL INTEREST RATE

4.50%

LENGTH OF LOAN IN YEARS

2

PAYMENT FREQUENCY

Monthly

FIRST PAYMENT DATE

05/01/2018

MONTHLY INTEREST RATE

MONTHLY PAYMENT

NUMBER OF PAYMENTS

INTEREST TOTAL

E

PRINCIPAL

$371.04 $372.44 $373.83 $375.23 $376.64 $378.05 $379.47 $380.90 $382.32 $383.76 $385.20 $386.64 $388.09 $389.55 $391.01 $392.47 $393.94 $395.42

0.375%

$405.92

24

$442.21

BALANCE $9,300.00 $8,928.96 $8,556.52 $8,182.69 $7,807.46 $7,430.82 $7,052.77 $6,673.30 $6,292.40 $5,910.08 $5,526.32 $5,141.12 $4,754.48 $4,366.39 $3,976.84 $3,585.83 $3,193.36 $2,799.42 $2,404.00

$396.91 $398.39 $399.89 $401.39 $402.89 $404.53

$2,007.09 $1,608.70 $1,208.81

$807.42 $404.53

$(0.00)

E TEMPLATES IN SMARTSHEET

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download