Loan Amortization Schedule © 2005 Vertex42, LLC

Vertex42.com

Inputs This
Thisspreadsheet
spreadsheetcreates
createsaapayment
payment
schedule
schedule for a fixed-rateloan,
for a fixed-rate loan,with
with
Loan Amount Rs 572,000 optional
optionalextra
extrapayments.
payments.The The
Annual Interest Rate 12.62% payment
paymentfrequency
frequencycan
canbebeannual,
annual,
Term of Loan in Years 4 semi-annual, quarterly, bi-monthly,
semi-annual, quarterly, bi-monthly,
First Payment Date 3/1/2008 or
ormonthly.
monthly.Values
Valuesare
arerounded
roundedto to
Frequency of Payment Monthly the
the nearest cent. The lastpayment
nearest cent. The last paymentisis
adjusted
adjustedtotobring
bringthe
thebalance
balanceto tozero.
zero.
Summary Note:
Note:You
Youmust
musthave
havethetheAnalysis
AnalysisToolPak
ToolPak
(Tools
(Tools > Add-ins...) installedtotouse
> Add-ins...) installed usethe
the
Rate (per period) 1.052% CUMIPMT
CUMIPMTformula.
formula.
Payment (per period) Rs15,237.67

Total Payments Rs731,407.91

Total Interest Rs159,407.91
Interest Savings office premises 5602 sq ft.
coop bank loan

Payment Additional
No. Due Date Due Payment Interest Principal Balance
Rs572,000.00
1 3/1/2008 15,237.67 0.00 6,015.53 9,222.14 562,777.86
2 4/1/2008 15,237.67 0.00 5,918.55 9,319.12 553,458.74
3 5/1/2008 15,237.67 0.00 5,820.54 9,417.13 544,041.61
4 6/1/2008 15,237.67 0.00 5,721.50 9,516.17 534,525.44
5 7/1/2008 15,237.67 0.00 5,621.43 9,616.24 524,909.20
6 8/1/2008 15,237.67 0.00 5,520.30 9,717.37 515,191.83
7 9/1/2008 15,237.67 0.00 5,418.10 9,819.57 505,372.26
8 10/1/2008 15,237.67 0.00 5,314.83 9,922.84 495,449.42
9 11/1/2008 15,237.67 0.00 5,210.48 10,027.19 485,422.23
10 12/1/2008 15,237.67 0.00 5,105.02 10,132.65 475,289.58
11 1/1/2009 15,237.67 0.00 4,998.46 10,239.21 465,050.37
12 2/1/2009 15,237.67 0.00 4,890.78 10,346.89 454,703.48
13 3/1/2009 15,237.67 0.00 4,781.96 10,455.71 444,247.77
14 4/1/2009 15,237.67 0.00 4,672.01 10,565.66 433,682.11
15 5/1/2009 15,237.67 0.00 4,560.89 10,676.78 423,005.33
16 6/1/2009 15,237.67 0.00 4,448.61 10,789.06 412,216.27
17 7/1/2009 15,237.67 0.00 4,335.14 10,902.53 401,313.74
18 8/1/2009 15,237.67 0.00 4,220.48 11,017.19 390,296.55
19 9/1/2009 15,237.67 0.00 4,104.62 11,133.05 379,163.50
20 10/1/2009 15,237.67 0.00 3,987.54 11,250.13 367,913.37
21 11/1/2009 15,237.67 0.00 3,869.22 11,368.45 356,544.92
22 12/1/2009 15,237.67 0.00 3,749.66 11,488.01 345,056.91
23 1/1/2010 15,237.67 0.00 3,628.85 11,608.82 333,448.09
24 2/1/2010 15,237.67 0.00 3,506.76 11,730.91 321,717.18
 Loan Amortization Schedule © 2005 Vertex42, LLC
Vertex42.com

Inputs
Recording
RecordingActual
ActualPayments
Payments
Loan Amount $ 4,700,000
This
Thisspreadsheet
spreadsheetprovides
providesan analternate
alternate
Annual Interest Rate 18.00% way
way to record the payments,assuming
to record the payments, assuming
Term of Loan in Years 4 the
thesame
sameloan
loaninformation
informationas asininthe
the
First Payment Date 3/1/2008 Schedule worksheet. The actual
Schedule worksheet. The actual
Frequency of Payment Monthly payment
paymentisisrecorded
recordedeacheachpaypayperiod.
period.
Any amount above the paymentdue
Any amount above the payment dueisis
Loan Summary used to pay off the principal. If
used to pay off the principal. If no no
payment
paymentisismade,
made,the theinterest
interestdue
dueisis
Rate (per period) 1.052% added to the balance. This assumes
added to the balance. This assumes
Payment (per period) $15,237.67 there
thereare
arenonopenalties
penaltiesforforlate
late
payments,
payments, missing payments,or
missing payments, or
Total Payments $731,407.91 prepayments.
prepayments.
Total Interest $159,407.91
Interest Savings rajendra surana
maruti Swift Car loan

Due Payment
No. Date Due Payment Interest Principal Balance
$572,000.00
1 3/1/2008 15,237.67 15,237.67 6,015.53 9,222.14 562,777.86
2 4/1/2008 15,237.67 15,237.67 5,918.55 9,319.12 553,458.74
3 5/1/2008 15,237.67 15,237.67 As 5,820.54 9,417.13 544,041.61
Aspayments
paymentsare
aremade,
made,
4 6/1/2008 15,237.67 15,237.67 enter the amount paid in
enter the amount paid9,516.17
5,721.50 in 534,525.44
this
thiscolumn.
column.
5 7/1/2008 15,237.67 15,237.67 5,621.43 9,616.24 524,909.20
6 8/1/2008 15,237.67 15,237.67 5,520.30 9,717.37 515,191.83
7 9/1/2008 15,237.67 15,237.67 5,418.10 9,819.57 505,372.26
8 10/1/2008 15,237.67 15,237.67 5,314.83 9,922.84 495,449.42
9 11/1/2008 15,237.67 15,237.67 5,210.48 10,027.19 485,422.23
10 12/1/2008 15,237.67 15,237.67 5,105.02 10,132.65 475,289.58
11 1/1/2009 15,237.67 15,237.67 4,998.46 10,239.21 465,050.37
12 2/1/2009 15,237.67 15,237.67 4,890.78 10,346.89 454,703.48
13 3/1/2009 15,237.67 15,237.67 4,781.96 10,455.71 444,247.77
14 4/1/2009 15,237.67 15,237.67 4,672.01 10,565.66 433,682.11
15 5/1/2009 15,237.67 15,237.67 4,560.89 10,676.78 423,005.33
16 6/1/2009 15,237.67 15,237.67 4,448.61 10,789.06 412,216.27
17 7/1/2009 15,237.67 15,237.67 4,335.14 10,902.53 401,313.74
18 8/1/2009 15,237.67 15,237.67 4,220.48 11,017.19 390,296.55
19 9/1/2009 15,237.67 15,237.67 4,104.62 11,133.05 379,163.50
20 10/1/2009 15,237.67 15,237.67 3,987.54 11,250.13 367,913.37
21 11/1/2009 15,237.67 15,237.67 3,869.22 11,368.45 356,544.92
22 12/1/2009 15,237.67 15,237.67 3,749.66 11,488.01 345,056.91
23 1/1/2010 15,237.67 15,237.67 3,628.85 11,608.82 333,448.09
24 2/1/2010 15,237.67 15,237.67 3,506.76 11,730.91 321,717.18
25 3/1/2010 15,237.67 15,237.67 3,383.39 11,854.28 309,862.90
26 4/1/2010 15,237.67 15,237.67 3,258.72 11,978.95 297,883.95
27 5/1/2010 15,237.67 15,237.67 3,132.75 12,104.92 285,779.03
28 6/1/2010 15,237.67 15,237.67 3,005.44 12,232.23 273,546.80
29 7/1/2010 15,237.67 15,237.67 2,876.80 12,360.87 261,185.93
30 8/1/2010 15,237.67 15,237.67 2,746.81 12,490.86 248,695.07
31 9/1/2010 15,237.67 15,237.67 2,615.44 12,622.23 236,072.84
32 10/1/2010 15,237.67 15,237.67 2,482.70 12,754.97 223,317.87
33 11/1/2010 15,237.67 15,237.67 2,348.56 12,889.11 210,428.76
34 12/1/2010 15,237.67 15,237.67 2,213.01 13,024.66 197,404.10
35 1/1/2011 15,237.67 15,237.67 2,076.03 13,161.64 184,242.46
36 2/1/2011 15,237.67 15,237.67 1,937.62 13,300.05 170,942.41
37 3/1/2011 15,237.67 15,237.67 1,797.74 13,439.93 157,502.48
38 4/1/2011 15,237.67 15,237.67 1,656.40 13,581.27 143,921.21
39 5/1/2011 15,237.67 15,237.67 1,513.57 13,724.10 130,197.11
40 6/1/2011 15,237.67 15,237.67 1,369.24 13,868.43 116,328.68
41 7/1/2011 15,237.67 15,237.67 1,223.39 14,014.28 102,314.40
42 8/1/2011 15,237.67 15,237.67 1,076.01 14,161.66 88,152.74
43 9/1/2011 15,237.67 15,237.67 927.07 14,310.60 73,842.14
44 10/1/2011 15,237.67 15,237.67 776.57 14,461.10 59,381.04
45 11/1/2011 15,237.67 15,237.67 624.49 14,613.18 44,767.86
46 12/1/2011 15,237.67 15,237.67 470.81 14,766.86 30,001.00
47 1/1/2012 15,237.67 15,237.67 315.51 14,922.16 15,078.84
48 2/1/2012 15,237.42 15,237.42 158.58 15,078.84 0.00