 |
| Advanced | Simple | Discount Points | Early Payoff | Lump Sum | Refinance | HELOC | Recast | Interest Only | Balloon | Widget |
Loan Calculator Excel
Loan Calculator Excel to calculate the monthly payments for your loan. You can use the loan calculator to calculate any type of loans, such as personal loans, student loans, and etc. You can generate an amortization table that shows you all the details of your monthly payment, and the result is exportable as an excel and pdf file. Enter the loan amount, terms, interest rate to get started. The loan calculator has the option to download the loan repayment schedule (amortization schedule) in an excel spreadsheet in monthly or yearly form.
| https://mortgage-calculator.net | ||||||
Loan & Payment Summary |
||||||
Loan Amount: |
$60,000.00 | |||||
Monthly Payment: |
$1,132.27 | |||||
Total # Of Payments: |
60 | |||||
Start Date: |
Jun, 2026 | |||||
Payoff Date: |
May, 2031 | |||||
Total Interest Paid: |
$7,936.44 | |||||
Total Payment: |
$67,936.44 | |||||
Amortization Schedule |
||||||
| Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
|---|---|---|---|---|---|---|
| Jun, 2026 | 1 | $250.00 | $882.27 | $1,132.27 | $59,117.73 | |
| Jul, 2026 | 2 | $246.32 | $885.95 | $1,132.27 | $58,231.78 | |
| Aug, 2026 | 3 | $242.63 | $889.64 | $1,132.27 | $57,342.13 | |
| Sep, 2026 | 4 | $238.93 | $893.35 | $1,132.27 | $56,448.79 | |
| Oct, 2026 | 5 | $235.20 | $897.07 | $1,132.27 | $55,551.71 | |
| Nov, 2026 | 6 | $231.47 | $900.81 | $1,132.27 | $54,650.91 | |
| Dec, 2026 | 7 | $227.71 | $904.56 | $1,132.27 | $53,746.34 | |
| Jan, 2027 | 8 | $223.94 | $908.33 | $1,132.27 | $52,838.01 | |
| Feb, 2027 | 9 | $220.16 | $912.12 | $1,132.27 | $51,925.90 | |
| Mar, 2027 | 10 | $216.36 | $915.92 | $1,132.27 | $51,009.98 | |
| Apr, 2027 | 11 | $212.54 | $919.73 | $1,132.27 | $50,090.25 | |
| May, 2027 | 12 | $208.71 | $923.56 | $1,132.27 | $49,166.68 | |
| Jun, 2027 | 13 | $204.86 | $927.41 | $1,132.27 | $48,239.27 | |
| Jul, 2027 | 14 | $201.00 | $931.28 | $1,132.27 | $47,307.99 | |
| Aug, 2027 | 15 | $197.12 | $935.16 | $1,132.27 | $46,372.84 | |
| Sep, 2027 | 16 | $193.22 | $939.05 | $1,132.27 | $45,433.78 | |
| Oct, 2027 | 17 | $189.31 | $942.97 | $1,132.27 | $44,490.82 | |
| Nov, 2027 | 18 | $185.38 | $946.90 | $1,132.27 | $43,543.92 | |
| Dec, 2027 | 19 | $181.43 | $950.84 | $1,132.27 | $42,593.08 | |
| Jan, 2028 | 20 | $177.47 | $954.80 | $1,132.27 | $41,638.28 | |
| Feb, 2028 | 21 | $173.49 | $958.78 | $1,132.27 | $40,679.50 | |
| Mar, 2028 | 22 | $169.50 | $962.78 | $1,132.27 | $39,716.72 | |
| Apr, 2028 | 23 | $165.49 | $966.79 | $1,132.27 | $38,749.93 | |
| May, 2028 | 24 | $161.46 | $970.82 | $1,132.27 | $37,779.12 | |
| Jun, 2028 | 25 | $157.41 | $974.86 | $1,132.27 | $36,804.26 | |
| Jul, 2028 | 26 | $153.35 | $978.92 | $1,132.27 | $35,825.33 | |
| Aug, 2028 | 27 | $149.27 | $983.00 | $1,132.27 | $34,842.33 | |
| Sep, 2028 | 28 | $145.18 | $987.10 | $1,132.27 | $33,855.23 | |
| Oct, 2028 | 29 | $141.06 | $991.21 | $1,132.27 | $32,864.02 | |
| Nov, 2028 | 30 | $136.93 | $995.34 | $1,132.27 | $31,868.68 | |
| Dec, 2028 | 31 | $132.79 | $999.49 | $1,132.27 | $30,869.19 | |
| Jan, 2029 | 32 | $128.62 | $1,003.65 | $1,132.27 | $29,865.54 | |
| Feb, 2029 | 33 | $124.44 | $1,007.83 | $1,132.27 | $28,857.71 | |
| Mar, 2029 | 34 | $120.24 | $1,012.03 | $1,132.27 | $27,845.67 | |
| Apr, 2029 | 35 | $116.02 | $1,016.25 | $1,132.27 | $26,829.42 | |
| May, 2029 | 36 | $111.79 | $1,020.48 | $1,132.27 | $25,808.94 | |
| Jun, 2029 | 37 | $107.54 | $1,024.74 | $1,132.27 | $24,784.20 | |
| Jul, 2029 | 38 | $103.27 | $1,029.01 | $1,132.27 | $23,755.20 | |
| Aug, 2029 | 39 | $98.98 | $1,033.29 | $1,132.27 | $22,721.90 | |
| Sep, 2029 | 40 | $94.67 | $1,037.60 | $1,132.27 | $21,684.30 | |
| Oct, 2029 | 41 | $90.35 | $1,041.92 | $1,132.27 | $20,642.38 | |
| Nov, 2029 | 42 | $86.01 | $1,046.26 | $1,132.27 | $19,596.12 | |
| Dec, 2029 | 43 | $81.65 | $1,050.62 | $1,132.27 | $18,545.49 | |
| Jan, 2030 | 44 | $77.27 | $1,055.00 | $1,132.27 | $17,490.49 | |
| Feb, 2030 | 45 | $72.88 | $1,059.40 | $1,132.27 | $16,431.09 | |
| Mar, 2030 | 46 | $68.46 | $1,063.81 | $1,132.27 | $15,367.28 | |
| Apr, 2030 | 47 | $64.03 | $1,068.24 | $1,132.27 | $14,299.04 | |
| May, 2030 | 48 | $59.58 | $1,072.69 | $1,132.27 | $13,226.34 | |
| Jun, 2030 | 49 | $55.11 | $1,077.16 | $1,132.27 | $12,149.18 | |
| Jul, 2030 | 50 | $50.62 | $1,081.65 | $1,132.27 | $11,067.53 | |
| Aug, 2030 | 51 | $46.11 | $1,086.16 | $1,132.27 | $9,981.37 | |
| Sep, 2030 | 52 | $41.59 | $1,090.68 | $1,132.27 | $8,890.68 | |
| Oct, 2030 | 53 | $37.04 | $1,095.23 | $1,132.27 | $7,795.45 | |
| Nov, 2030 | 54 | $32.48 | $1,099.79 | $1,132.27 | $6,695.66 | |
| Dec, 2030 | 55 | $27.90 | $1,104.38 | $1,132.27 | $5,591.29 | |
| Jan, 2031 | 56 | $23.30 | $1,108.98 | $1,132.27 | $4,482.31 | |
| Feb, 2031 | 57 | $18.68 | $1,113.60 | $1,132.27 | $3,368.71 | |
| Mar, 2031 | 58 | $14.04 | $1,118.24 | $1,132.27 | $2,250.47 | |
| Apr, 2031 | 59 | $9.38 | $1,122.90 | $1,132.27 | $1,127.58 | |
| May, 2031 | 60 | $4.70 | $1,127.58 | $1,132.27 | $0.00 | |
Share My Mortgage Calculation
Today's HELOC Rates
Check Today's Mortgage Rates
Amortization Calculator Excel
Additional Mortgage Payment Calculator
Mortgage Calculator | Terms | Privacy | Disclaimer | Contact
©2026 Mortgage Calculator