C# Spreadsheet Component Amortization Sample for ASP.NET
Using DataSet, DataGrid and SpreadsheetGear
Loan Calculator
Loan Amount (pv)
Interest Rate (rate)
Total # of Periods (Nper)
Payment $673.30
Last Payment $673.05
Total Interest $1,158.95


 

Amortization Schedule
PeriodInterest for PeriodPrincipal for PeriodPayment for PeriodRemaining Principal
    $15,000.00
1$90.63$582.67$673.30$14,417.33
2$87.10$586.20$673.30$13,831.13
3$83.56$589.74$673.30$13,241.39
4$80.00$593.30$673.30$12,648.09
5$76.42$596.88$673.30$12,051.21
6$72.81$600.49$673.30$11,450.72
7$69.18$604.12$673.30$10,846.60
8$65.53$607.77$673.30$10,238.83
9$61.86$611.44$673.30$9,627.39
10$58.17$615.13$673.30$9,012.26
11$54.45$618.85$673.30$8,393.41
12$50.71$622.59$673.30$7,770.82
13$46.95$626.35$673.30$7,144.47
14$43.16$630.14$673.30$6,514.33
15$39.36$633.94$673.30$5,880.39
16$35.53$637.77$673.30$5,242.62
17$31.67$641.63$673.30$4,600.99
18$27.80$645.50$673.30$3,955.49
19$23.90$649.40$673.30$3,306.09
20$19.97$653.33$673.30$2,652.76
21$16.03$657.27$673.30$1,995.49
22$12.06$661.24$673.30$1,334.25
23$8.06$665.24$673.30$669.01
24$4.04$669.01$673.05 
Copyright 2005 © SpreadsheetGear LLC. All Rights Reserved.
www.spreadsheetgear.com