loan calculator


Loan Calculator Excel

Loan calculator excel is used to calculate the monthly loan payments. Get a printable loan amortization schedule that is exportable into excel or text files.

Loan Calculator

Loan Amount
Loan Terms
years
Interest Rate
First Payment Date
Amortization Schedule
Show By Month Year

Loan Summary

Loan Amount:
$75,000.00
Monthly Payment:
$1,075.97
Total # Of Payments:
84
Start Date:
Dec, 2024
Payoff Date:
Nov, 2031
Total Interest Paid:
$15,381.83
Total Payment:
$90,381.83

Amortization Schedule

Payment Date Payment # Interest Paid Principal Paid Total Payment Remaining Balance
Dec, 2024 1 $340.63 $735.35 $1,075.97 $74,264.65
Jan, 2025 2 $337.29 $738.69 $1,075.97 $73,525.96
Feb, 2025 3 $333.93 $742.04 $1,075.97 $72,783.92
Mar, 2025 4 $330.56 $745.41 $1,075.97 $72,038.50
Apr, 2025 5 $327.17 $748.80 $1,075.97 $71,289.71
May, 2025 6 $323.77 $752.20 $1,075.97 $70,537.50
Jun, 2025 7 $320.36 $755.62 $1,075.97 $69,781.89
Jul, 2025 8 $316.93 $759.05 $1,075.97 $69,022.84
Aug, 2025 9 $313.48 $762.50 $1,075.97 $68,260.35
Sep, 2025 10 $310.02 $765.96 $1,075.97 $67,494.39
Oct, 2025 11 $306.54 $769.44 $1,075.97 $66,724.95
Nov, 2025 12 $303.04 $772.93 $1,075.97 $65,952.02
Dec, 2025 13 $299.53 $776.44 $1,075.97 $65,175.58
Jan, 2026 14 $296.01 $779.97 $1,075.97 $64,395.61
Feb, 2026 15 $292.46 $783.51 $1,075.97 $63,612.10
Mar, 2026 16 $288.90 $787.07 $1,075.97 $62,825.03
Apr, 2026 17 $285.33 $790.64 $1,075.97 $62,034.38
May, 2026 18 $281.74 $794.23 $1,075.97 $61,240.15
Jun, 2026 19 $278.13 $797.84 $1,075.97 $60,442.31
Jul, 2026 20 $274.51 $801.47 $1,075.97 $59,640.84
Aug, 2026 21 $270.87 $805.11 $1,075.97 $58,835.74
Sep, 2026 22 $267.21 $808.76 $1,075.97 $58,026.97
Oct, 2026 23 $263.54 $812.43 $1,075.97 $57,214.54
Nov, 2026 24 $259.85 $816.12 $1,075.97 $56,398.41
Dec, 2026 25 $256.14 $819.83 $1,075.97 $55,578.58
Jan, 2027 26 $252.42 $823.55 $1,075.97 $54,755.03
Feb, 2027 27 $248.68 $827.30 $1,075.97 $53,927.73
Mar, 2027 28 $244.92 $831.05 $1,075.97 $53,096.68
Apr, 2027 29 $241.15 $834.83 $1,075.97 $52,261.85
May, 2027 30 $237.36 $838.62 $1,075.97 $51,423.24
Jun, 2027 31 $233.55 $842.43 $1,075.97 $50,580.81
Jul, 2027 32 $229.72 $846.25 $1,075.97 $49,734.56
Aug, 2027 33 $225.88 $850.10 $1,075.97 $48,884.46
Sep, 2027 34 $222.02 $853.96 $1,075.97 $48,030.50
Oct, 2027 35 $218.14 $857.84 $1,075.97 $47,172.67
Nov, 2027 36 $214.24 $861.73 $1,075.97 $46,310.94
Dec, 2027 37 $210.33 $865.65 $1,075.97 $45,445.29
Jan, 2028 38 $206.40 $869.58 $1,075.97 $44,575.71
Feb, 2028 39 $202.45 $873.53 $1,075.97 $43,702.19
Mar, 2028 40 $198.48 $877.49 $1,075.97 $42,824.69
Apr, 2028 41 $194.50 $881.48 $1,075.97 $41,943.22
May, 2028 42 $190.49 $885.48 $1,075.97 $41,057.73
Jun, 2028 43 $186.47 $889.50 $1,075.97 $40,168.23
Jul, 2028 44 $182.43 $893.54 $1,075.97 $39,274.69
Aug, 2028 45 $178.37 $897.60 $1,075.97 $38,377.08
Sep, 2028 46 $174.30 $901.68 $1,075.97 $37,475.41
Oct, 2028 47 $170.20 $905.77 $1,075.97 $36,569.63
Nov, 2028 48 $166.09 $909.89 $1,075.97 $35,659.75
Dec, 2028 49 $161.95 $914.02 $1,075.97 $34,745.73
Jan, 2029 50 $157.80 $918.17 $1,075.97 $33,827.56
Feb, 2029 51 $153.63 $922.34 $1,075.97 $32,905.21
Mar, 2029 52 $149.44 $926.53 $1,075.97 $31,978.69
Apr, 2029 53 $145.24 $930.74 $1,075.97 $31,047.95
May, 2029 54 $141.01 $934.96 $1,075.97 $30,112.98
Jun, 2029 55 $136.76 $939.21 $1,075.97 $29,173.77
Jul, 2029 56 $132.50 $943.48 $1,075.97 $28,230.30
Aug, 2029 57 $128.21 $947.76 $1,075.97 $27,282.53
Sep, 2029 58 $123.91 $952.07 $1,075.97 $26,330.47
Oct, 2029 59 $119.58 $956.39 $1,075.97 $25,374.08
Nov, 2029 60 $115.24 $960.73 $1,075.97 $24,413.34
Dec, 2029 61 $110.88 $965.10 $1,075.97 $23,448.25
Jan, 2030 62 $106.49 $969.48 $1,075.97 $22,478.77
Feb, 2030 63 $102.09 $973.88 $1,075.97 $21,504.88
Mar, 2030 64 $97.67 $978.31 $1,075.97 $20,526.58
Apr, 2030 65 $93.22 $982.75 $1,075.97 $19,543.83
May, 2030 66 $88.76 $987.21 $1,075.97 $18,556.62
Jun, 2030 67 $84.28 $991.70 $1,075.97 $17,564.92
Jul, 2030 68 $79.77 $996.20 $1,075.97 $16,568.72
Aug, 2030 69 $75.25 $1,000.72 $1,075.97 $15,568.00
Sep, 2030 70 $70.70 $1,005.27 $1,075.97 $14,562.73
Oct, 2030 71 $66.14 $1,009.84 $1,075.97 $13,552.89
Nov, 2030 72 $61.55 $1,014.42 $1,075.97 $12,538.47
Dec, 2030 73 $56.95 $1,019.03 $1,075.97 $11,519.44
Jan, 2031 74 $52.32 $1,023.66 $1,075.97 $10,495.78
Feb, 2031 75 $47.67 $1,028.31 $1,075.97 $9,467.48
Mar, 2031 76 $43.00 $1,032.98 $1,075.97 $8,434.50
Apr, 2031 77 $38.31 $1,037.67 $1,075.97 $7,396.83
May, 2031 78 $33.59 $1,042.38 $1,075.97 $6,354.45
Jun, 2031 79 $28.86 $1,047.11 $1,075.97 $5,307.34
Jul, 2031 80 $24.10 $1,051.87 $1,075.97 $4,255.47
Aug, 2031 81 $19.33 $1,056.65 $1,075.97 $3,198.82
Sep, 2031 82 $14.53 $1,061.45 $1,075.97 $2,137.38
Oct, 2031 83 $9.71 $1,066.27 $1,075.97 $1,071.11
Nov, 2031 84 $4.86 $1,071.11 $1,075.97 $0.00



Loan Calculator | Terms | Privacy | Disclaimer | Contact

©2024 Loan Calculator