Visual Basic .NET Spreadsheet Component Amortization Sample for
ASP.NET using DataSet, DataGrid and SpreadsheetGear for .NET
Loan Calculator
Loan Amount (pv)
Interest Rate (rate)
Total # of Periods (Nper)
Payment $673.29
Last Payment $673.31
Total Interest $1,158.98


 

Amortization Schedule
PeriodInterest for PeriodPrincipal for PeriodPayment for PeriodRemaining Principal
    $15,000.00
1$90.63$582.66$673.29$14,417.34
2$87.10$586.19$673.29$13,831.15
3$83.56$589.73$673.29$13,241.42
4$80.00$593.29$673.29$12,648.13
5$76.42$596.87$673.29$12,051.26
6$72.81$600.48$673.29$11,450.78
7$69.18$604.11$673.29$10,846.67
8$65.53$607.76$673.29$10,238.91
9$61.86$611.43$673.29$9,627.48
10$58.17$615.12$673.29$9,012.36
11$54.45$618.84$673.29$8,393.52
12$50.71$622.58$673.29$7,770.94
13$46.95$626.34$673.29$7,144.60
14$43.17$630.12$673.29$6,514.48
15$39.36$633.93$673.29$5,880.55
16$35.53$637.76$673.29$5,242.79
17$31.68$641.61$673.29$4,601.18
18$27.80$645.49$673.29$3,955.69
19$23.90$649.39$673.29$3,306.30
20$19.98$653.31$673.29$2,652.99
21$16.03$657.26$673.29$1,995.73
22$12.06$661.23$673.29$1,334.50
23$8.06$665.23$673.29$669.27
24$4.04$669.27$673.31 
Copyright 2005 © SpreadsheetGear LLC. All Rights Reserved.
www.spreadsheetgear.com