Loan Amortization Schedule © 2005 Vertex42, LLC

Vertex42.com

Inputs This
Thisspreadsheet
spreadsheetcreates
createsaapayment
payment
schedule
schedulefor
foraafixed-rate
fixed-rateloan,
loan,with
with
Loan Amount Rs 1,000,000 optional
optionalextra
extrapayments.
payments.The The
Annual Interest Rate 9.00% payment
paymentfrequency
frequencycancanbebeannual,
annual,
Term of Loan in Years 4 semi-annual, quarterly, bi-monthly,
semi-annual, quarterly, bi-monthly,
First Payment Date 9/1/2018 orormonthly.
monthly.Values
Valuesare
arerounded
roundedtoto
the
thenearest
nearestcent.
cent.The
Thelast
lastpayment
payment
Frequency of Payment Monthly
isisadjusted
adjustedtotobring
bringthe
thebalance
balancetoto
zero.
zero.
Summary
Note:
Note:You
Youmust
musthave
havethetheAnalysis
AnalysisToolPak
ToolPak
Rate (per period) 0.750% (Tools
(Tools>>Add-ins...)
Add-ins...)installed
installedto
touse
usethe
the
CUMIPMT
CUMIPMTformula.
formula.
Payment (per period) Rs24,885.04

Total Payments Rs1,194,482.09

Due Payment
No. Date Due Additional Payment Interest Principal Balance
Rs1,000,000.00
1 9/1/2018 24,885.04 0.00 7,500.00 17,385.04 982,614.96
2 10/1/2018 24,885.04 0.00 7,369.61 17,515.43 965,099.53
3 11/1/2018 24,885.04 0.00 7,238.25 17,646.79 947,452.74
4 12/1/2018 24,885.04 0.00 7,105.90 17,779.14 929,673.60
5 1/1/2019 24,885.04 0.00 6,972.55 17,912.49 911,761.11
6 2/1/2019 24,885.04 0.00 6,838.21 18,046.83 893,714.28
7 3/1/2019 24,885.04 0.00 6,702.86 18,182.18 875,532.10
8 4/1/2019 24,885.04 0.00 6,566.49 18,318.55 857,213.55
9 5/1/2019 24,885.04 0.00 6,429.10 18,455.94 838,757.61
10 6/1/2019 24,885.04 0.00 6,290.68 18,594.36 820,163.25
11 7/1/2019 24,885.04 0.00 6,151.22 18,733.82 801,429.43
12 8/1/2019 24,885.04 0.00 6,010.72 18,874.32 782,555.11
13 9/1/2019 24,885.04 0.00 5,869.16 19,015.88 763,539.23
14 10/1/2019 24,885.04 0.00 5,726.54 19,158.50 744,380.73
15 11/1/2019 24,885.04 0.00 5,582.86 19,302.18 725,078.55
16 12/1/2019 24,885.04 0.00 5,438.09 19,446.95 705,631.60
17 1/1/2020 24,885.04 0.00 5,292.24 19,592.80 686,038.80
18 2/1/2020 24,885.04 0.00 5,145.29 19,739.75 666,299.05
19 3/1/2020 24,885.04 0.00 4,997.24 19,887.80 646,411.25
20 4/1/2020 24,885.04 0.00 4,848.08 20,036.96 626,374.29
21 5/1/2020 24,885.04 0.00 4,697.81 20,187.23 606,187.06
22 6/1/2020 24,885.04 0.00 4,546.40 20,338.64 585,848.42
23 7/1/2020 24,885.04 0.00 4,393.86 20,491.18 565,357.24
24 8/1/2020 24,885.04 0.00 4,240.18 20,644.86 544,712.38
May 25000
Jun 25000
July 25000
Aug 25000
Sep 25000
Oct 25000
Nov 25000
Dec 25000
Jan 25000
Feb 25000
Mar 25000
200000

475000
 93000 845.4545
12681.82

1414205
939205
 Loan Amortization Schedule © 2005 Vertex42, LLC
Vertex42.com

Inputs
Recording
Recording Actual
Actual Payments
Payments
Loan Amount $ 1,000,000 This
Thisspreadsheet
spreadsheetprovides
providesananalternate
alternate
Annual Interest Rate 9.00% way
way to record the payments,assuming
to record the payments, assuming
Term of Loan in Years 4 the
thesame
sameloanloaninformation
informationasasininthe
the
First Payment Date 9/1/2018 Schedule worksheet. The actual
Schedule worksheet. The actual
Frequency of Payment Monthly payment
paymentisisrecorded
recordedeach
eachpay
payperiod.
period.
Any
Any amount above the paymentdue
amount above the payment dueisis
Loan Summary used to pay off the principal. If
used to pay off the principal. If nono
payment
paymentisismade,
made,thetheinterest
interestdue
dueisis
added
addedto tothe
thebalance.
balance.This
Thisassumes
assumes
Rate (per period) 0.750%
there
thereare
arenonopenalties
penaltiesfor
forlate
latepayments,
payments,
Payment (per period) $24,885.04
missing payments, or prepayments.
missing payments, or prepayments.
Total Payments $1,194,482.09
Total Interest $194,482.09
Interest Savings ($0.06)

Due Payment
No. Date Due Payment Interest Principal Balance
$1,000,000.00
1 9/1/2018 24,885.04 24,885.04 7,500.00 17,385.04 982,614.96
2 10/1/2018 24,885.04 24,885.04 7,369.61 17,515.43 965,099.53
3 11/1/2018 24,885.04 24,885.04 As 7,238.25 17,646.79 947,452.74
Aspayments
paymentsare
aremade,
made,
4 12/1/2018 24,885.04 24,885.04 enter
enter the
theamount
amountpaid
7,105.90 in
paid17,779.14
in 929,673.60
this
thiscolumn.
column.
5 1/1/2019 24,885.04 24,885.04 6,972.55 17,912.49 911,761.11
6 2/1/2019 24,885.04 24,885.04 6,838.21 18,046.83 893,714.28
7 3/1/2019 24,885.04 24,885.04 6,702.86 18,182.18 875,532.10
8 4/1/2019 24,885.04 24,885.04 6,566.49 18,318.55 857,213.55
9 5/1/2019 24,885.04 24,885.04 6,429.10 18,455.94 838,757.61
10 6/1/2019 24,885.04 24,885.04 6,290.68 18,594.36 820,163.25
11 7/1/2019 24,885.04 24,885.04 6,151.22 18,733.82 801,429.43
12 8/1/2019 24,885.04 24,885.04 6,010.72 18,874.32 782,555.11
13 9/1/2019 24,885.04 24,885.04 5,869.16 19,015.88 763,539.23
14 10/1/2019 24,885.04 24,885.04 5,726.54 19,158.50 744,380.73
15 11/1/2019 24,885.04 24,885.04 5,582.86 19,302.18 725,078.55
16 12/1/2019 24,885.04 24,885.04 5,438.09 19,446.95 705,631.60
17 1/1/2020 24,885.04 24,885.04 5,292.24 19,592.80 686,038.80
18 2/1/2020 24,885.04 24,885.04 5,145.29 19,739.75 666,299.05
19 3/1/2020 24,885.04 24,885.04 4,997.24 19,887.80 646,411.25
20 4/1/2020 24,885.04 24,885.04 4,848.08 20,036.96 626,374.29
21 5/1/2020 24,885.04 24,885.04 4,697.81 20,187.23 606,187.06
22 6/1/2020 24,885.04 24,885.04 4,546.40 20,338.64 585,848.42
23 7/1/2020 24,885.04 24,885.04 4,393.86 20,491.18 565,357.24
24 8/1/2020 24,885.04 24,885.04 4,240.18 20,644.86 544,712.38
25 9/1/2020 24,885.04 24,885.04 4,085.34 20,799.70 523,912.68
26 10/1/2020 24,885.04 24,885.04 3,929.35 20,955.69 502,956.99
27 11/1/2020 24,885.04 24,885.04 3,772.18 21,112.86 481,844.13
28 12/1/2020 24,885.04 24,885.04 3,613.83 21,271.21 460,572.92
29 1/1/2021 24,885.04 24,885.04 3,454.30 21,430.74 439,142.18
30 2/1/2021 24,885.04 24,885.04 3,293.57 21,591.47 417,550.71
31 3/1/2021 24,885.04 24,885.04 3,131.63 21,753.41 395,797.30
32 4/1/2021 24,885.04 24,885.04 2,968.48 21,916.56 373,880.74
33 5/1/2021 24,885.04 24,885.04 2,804.11 22,080.93 351,799.81
34 6/1/2021 24,885.04 24,885.04 2,638.50 22,246.54 329,553.27
35 7/1/2021 24,885.04 24,885.04 2,471.65 22,413.39 307,139.88
36 8/1/2021 24,885.04 24,885.04 2,303.55 22,581.49 284,558.39
37 9/1/2021 24,885.04 24,885.04 2,134.19 22,750.85 261,807.54
38 10/1/2021 24,885.04 24,885.04 1,963.56 22,921.48 238,886.06
39 11/1/2021 24,885.04 24,885.04 1,791.65 23,093.39 215,792.67
40 12/1/2021 24,885.04 24,885.04 1,618.45 23,266.59 192,526.08
41 1/1/2022 24,885.04 24,885.04 1,443.95 23,441.09 169,084.99
42 2/1/2022 24,885.04 24,885.04 1,268.14 23,616.90 145,468.09
43 3/1/2022 24,885.04 24,885.04 1,091.01 23,794.03 121,674.06
44 4/1/2022 24,885.04 24,885.04 912.56 23,972.48 97,701.58
45 5/1/2022 24,885.04 24,885.04 732.76 24,152.28 73,549.30
46 6/1/2022 24,885.04 24,885.04 551.62 24,333.42 49,215.88
47 7/1/2022 24,885.04 24,885.04 369.12 24,515.92 24,699.96
48 8/1/2022 24,885.21 24,885.21 185.25 24,699.96 0.00
s

lternate
alternate
ssuming
ssuming
nnthe
the
l
al
period.
period.
nt
ntdue
dueisis
nono
due
dueisis
umes
umes
payments,
payments,
ents.
ments.