HELOC Payment Calculator Excel



HELOC Payment Calculator excel calculates the monthly payments of a HELOC loan and export the HELOC amortization schedule in an excel spreadsheet.

HELOC Calculator Excel

Current HELOC Balance
Interest Rate
Interest Only Period
years
Repayment Period
years
First Payment Date
Amortization schedule
Show By Month Show By Year

HELOC Payment Results

Current HELOC Balance:
$240,000.00
Monthly Payment:
$1,250.00 for 60 payments
$4,667.82 for 60 payments
Interest Only Terms:
5 years
Total Terms:
10 years
Total # Of Payments:
120
Start Date:
Mar, 2023
Payoff Date:
Feb, 2033
Total Interest Paid:
$115,069.44
Total Payment:
$355,069.44

HELOC Payment Amortization Schedule

Payment Date Payment # Interest Paid Principal Paid Total Payment Remaining Balance
Mar, 2023 1 $1,250.00 $0.00 $1,250.00 $240,000.00
Apr, 2023 2 $1,250.00 $0.00 $1,250.00 $240,000.00
May, 2023 3 $1,250.00 $0.00 $1,250.00 $240,000.00
Jun, 2023 4 $1,250.00 $0.00 $1,250.00 $240,000.00
Jul, 2023 5 $1,250.00 $0.00 $1,250.00 $240,000.00
Aug, 2023 6 $1,250.00 $0.00 $1,250.00 $240,000.00
Sep, 2023 7 $1,250.00 $0.00 $1,250.00 $240,000.00
Oct, 2023 8 $1,250.00 $0.00 $1,250.00 $240,000.00
Nov, 2023 9 $1,250.00 $0.00 $1,250.00 $240,000.00
Dec, 2023 10 $1,250.00 $0.00 $1,250.00 $240,000.00
Jan, 2024 11 $1,250.00 $0.00 $1,250.00 $240,000.00
Feb, 2024 12 $1,250.00 $0.00 $1,250.00 $240,000.00
Mar, 2024 13 $1,250.00 $0.00 $1,250.00 $240,000.00
Apr, 2024 14 $1,250.00 $0.00 $1,250.00 $240,000.00
May, 2024 15 $1,250.00 $0.00 $1,250.00 $240,000.00
Jun, 2024 16 $1,250.00 $0.00 $1,250.00 $240,000.00
Jul, 2024 17 $1,250.00 $0.00 $1,250.00 $240,000.00
Aug, 2024 18 $1,250.00 $0.00 $1,250.00 $240,000.00
Sep, 2024 19 $1,250.00 $0.00 $1,250.00 $240,000.00
Oct, 2024 20 $1,250.00 $0.00 $1,250.00 $240,000.00
Nov, 2024 21 $1,250.00 $0.00 $1,250.00 $240,000.00
Dec, 2024 22 $1,250.00 $0.00 $1,250.00 $240,000.00
Jan, 2025 23 $1,250.00 $0.00 $1,250.00 $240,000.00
Feb, 2025 24 $1,250.00 $0.00 $1,250.00 $240,000.00
Mar, 2025 25 $1,250.00 $0.00 $1,250.00 $240,000.00
Apr, 2025 26 $1,250.00 $0.00 $1,250.00 $240,000.00
May, 2025 27 $1,250.00 $0.00 $1,250.00 $240,000.00
Jun, 2025 28 $1,250.00 $0.00 $1,250.00 $240,000.00
Jul, 2025 29 $1,250.00 $0.00 $1,250.00 $240,000.00
Aug, 2025 30 $1,250.00 $0.00 $1,250.00 $240,000.00
Sep, 2025 31 $1,250.00 $0.00 $1,250.00 $240,000.00
Oct, 2025 32 $1,250.00 $0.00 $1,250.00 $240,000.00
Nov, 2025 33 $1,250.00 $0.00 $1,250.00 $240,000.00
Dec, 2025 34 $1,250.00 $0.00 $1,250.00 $240,000.00
Jan, 2026 35 $1,250.00 $0.00 $1,250.00 $240,000.00
Feb, 2026 36 $1,250.00 $0.00 $1,250.00 $240,000.00
Mar, 2026 37 $1,250.00 $0.00 $1,250.00 $240,000.00
Apr, 2026 38 $1,250.00 $0.00 $1,250.00 $240,000.00
May, 2026 39 $1,250.00 $0.00 $1,250.00 $240,000.00
Jun, 2026 40 $1,250.00 $0.00 $1,250.00 $240,000.00
Jul, 2026 41 $1,250.00 $0.00 $1,250.00 $240,000.00
Aug, 2026 42 $1,250.00 $0.00 $1,250.00 $240,000.00
Sep, 2026 43 $1,250.00 $0.00 $1,250.00 $240,000.00
Oct, 2026 44 $1,250.00 $0.00 $1,250.00 $240,000.00
Nov, 2026 45 $1,250.00 $0.00 $1,250.00 $240,000.00
Dec, 2026 46 $1,250.00 $0.00 $1,250.00 $240,000.00
Jan, 2027 47 $1,250.00 $0.00 $1,250.00 $240,000.00
Feb, 2027 48 $1,250.00 $0.00 $1,250.00 $240,000.00
Mar, 2027 49 $1,250.00 $0.00 $1,250.00 $240,000.00
Apr, 2027 50 $1,250.00 $0.00 $1,250.00 $240,000.00
May, 2027 51 $1,250.00 $0.00 $1,250.00 $240,000.00
Jun, 2027 52 $1,250.00 $0.00 $1,250.00 $240,000.00
Jul, 2027 53 $1,250.00 $0.00 $1,250.00 $240,000.00
Aug, 2027 54 $1,250.00 $0.00 $1,250.00 $240,000.00
Sep, 2027 55 $1,250.00 $0.00 $1,250.00 $240,000.00
Oct, 2027 56 $1,250.00 $0.00 $1,250.00 $240,000.00
Nov, 2027 57 $1,250.00 $0.00 $1,250.00 $240,000.00
Dec, 2027 58 $1,250.00 $0.00 $1,250.00 $240,000.00
Jan, 2028 59 $1,250.00 $0.00 $1,250.00 $240,000.00
Feb, 2028 60 $1,250.00 $0.00 $1,250.00 $240,000.00
Mar, 2028 61 $1,250.00 $3,417.82 $4,667.82 $236,582.18
Apr, 2028 62 $1,232.20 $3,435.62 $4,667.82 $233,146.56
May, 2028 63 $1,214.31 $3,453.51 $4,667.82 $229,693.05
Jun, 2028 64 $1,196.32 $3,471.50 $4,667.82 $226,221.55
Jul, 2028 65 $1,178.24 $3,489.58 $4,667.82 $222,731.97
Aug, 2028 66 $1,160.06 $3,507.76 $4,667.82 $219,224.21
Sep, 2028 67 $1,141.79 $3,526.03 $4,667.82 $215,698.18
Oct, 2028 68 $1,123.43 $3,544.39 $4,667.82 $212,153.79
Nov, 2028 69 $1,104.97 $3,562.85 $4,667.82 $208,590.94
Dec, 2028 70 $1,086.41 $3,581.41 $4,667.82 $205,009.53
Jan, 2029 71 $1,067.76 $3,600.06 $4,667.82 $201,409.47
Feb, 2029 72 $1,049.01 $3,618.81 $4,667.82 $197,790.66
Mar, 2029 73 $1,030.16 $3,637.66 $4,667.82 $194,153.00
Apr, 2029 74 $1,011.21 $3,656.61 $4,667.82 $190,496.39
May, 2029 75 $992.17 $3,675.65 $4,667.82 $186,820.74
Jun, 2029 76 $973.02 $3,694.80 $4,667.82 $183,125.94
Jul, 2029 77 $953.78 $3,714.04 $4,667.82 $179,411.90
Aug, 2029 78 $934.44 $3,733.38 $4,667.82 $175,678.52
Sep, 2029 79 $914.99 $3,752.83 $4,667.82 $171,925.69
Oct, 2029 80 $895.45 $3,772.37 $4,667.82 $168,153.32
Nov, 2029 81 $875.80 $3,792.02 $4,667.82 $164,361.30
Dec, 2029 82 $856.05 $3,811.77 $4,667.82 $160,549.53
Jan, 2030 83 $836.20 $3,831.62 $4,667.82 $156,717.91
Feb, 2030 84 $816.24 $3,851.58 $4,667.82 $152,866.33
Mar, 2030 85 $796.18 $3,871.64 $4,667.82 $148,994.69
Apr, 2030 86 $776.01 $3,891.81 $4,667.82 $145,102.88
May, 2030 87 $755.74 $3,912.08 $4,667.82 $141,190.80
Jun, 2030 88 $735.37 $3,932.45 $4,667.82 $137,258.35
Jul, 2030 89 $714.89 $3,952.93 $4,667.82 $133,305.42
Aug, 2030 90 $694.30 $3,973.52 $4,667.82 $129,331.90
Sep, 2030 91 $673.60 $3,994.22 $4,667.82 $125,337.68
Oct, 2030 92 $652.80 $4,015.02 $4,667.82 $121,322.66
Nov, 2030 93 $631.89 $4,035.93 $4,667.82 $117,286.73
Dec, 2030 94 $610.87 $4,056.95 $4,667.82 $113,229.78
Jan, 2031 95 $589.74 $4,078.08 $4,667.82 $109,151.70
Feb, 2031 96 $568.50 $4,099.32 $4,667.82 $105,052.38
Mar, 2031 97 $547.15 $4,120.67 $4,667.82 $100,931.71
Apr, 2031 98 $525.69 $4,142.13 $4,667.82 $96,789.58
May, 2031 99 $504.11 $4,163.71 $4,667.82 $92,625.87
Jun, 2031 100 $482.43 $4,185.39 $4,667.82 $88,440.48
Jul, 2031 101 $460.63 $4,207.19 $4,667.82 $84,233.29
Aug, 2031 102 $438.72 $4,229.10 $4,667.82 $80,004.19
Sep, 2031 103 $416.69 $4,251.13 $4,667.82 $75,753.06
Oct, 2031 104 $394.55 $4,273.27 $4,667.82 $71,479.79
Nov, 2031 105 $372.29 $4,295.53 $4,667.82 $67,184.26
Dec, 2031 106 $349.92 $4,317.90 $4,667.82 $62,866.36
Jan, 2032 107 $327.43 $4,340.39 $4,667.82 $58,525.97
Feb, 2032 108 $304.82 $4,363.00 $4,667.82 $54,162.97
Mar, 2032 109 $282.10 $4,385.72 $4,667.82 $49,777.25
Apr, 2032 110 $259.26 $4,408.56 $4,667.82 $45,368.69
May, 2032 111 $236.30 $4,431.52 $4,667.82 $40,937.17
Jun, 2032 112 $213.21 $4,454.61 $4,667.82 $36,482.56
Jul, 2032 113 $190.01 $4,477.81 $4,667.82 $32,004.75
Aug, 2032 114 $166.69 $4,501.13 $4,667.82 $27,503.62
Sep, 2032 115 $143.25 $4,524.57 $4,667.82 $22,979.05
Oct, 2032 116 $119.68 $4,548.14 $4,667.82 $18,430.91
Nov, 2032 117 $95.99 $4,571.83 $4,667.82 $13,859.08
Dec, 2032 118 $72.18 $4,595.64 $4,667.82 $9,263.44
Jan, 2033 119 $48.25 $4,619.57 $4,667.82 $4,643.87
Feb, 2033 120 $24.19 $4,643.87 $4,668.06 $0.00


HELOC Amortization Calculator

HELOC Calculator | Terms | Privacy | Disclaimer | Contact

©2023 HELOC Calculator