Scribd
Upload
33 views4 pages

Mortgage Calculator

The document provides a mortgage payment calculator and amortization schedule for a house and a condo, detailing loan amounts, interest rates, monthly payments, and total costs. For the house, the loan amount is $450,000 with a total cost of $644,086.01 at a 3.875% interest rate, while the condo has a loan amount of $150,000 and a total cost of $248,028.67 at the same interest rate. Each schedule includes a breakdown of the beginning and ending balances, principal and interest paid over a 15-year term.

Uploaded by

yasmanypoolivera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
33 views4 pages

Mortgage Calculator

The document provides a mortgage payment calculator and amortization schedule for a house and a condo, detailing loan amounts, interest rates, monthly payments, and total costs. For the house, the loan amount is $450,000 with a total cost of $644,086.01 at a 3.875% interest rate, while the condo has a loan amount of $150,000 and a total cost of $248,028.67 at the same interest rate. Each schedule includes a breakdown of the beginning and ending balances, principal and interest paid over a 15-year term.

Uploaded by

yasmanypoolivera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Mortgage Payment Calculator Amortization Schedule

Date 19-Jul-2025 Rate 3.875% Year Beginning Balance Ending Balance Paid on Principal Interest Paid
Item House Term 15 1 $450,000.00 $427,433.78 $22,566.22 $17,039.51
Price $500,000.00 Montlhy Payment $3,300.48 2 427,433.78 403,977.42 23,456.36 16,149.37
Down Pymt $50,000.00 Total Interest $144,086.01 3 403,977.42 379,595.81 24,381.61 15,224.12
Loan Amount $450,000.00 Total Cost $644,086.01 4 379,595.81 354,252.45 25,343.36 14,262.37

Varying Interest Rate Schedule 5 354,252.45 327,909.40 26,343.05 13,262.69


Rate Montlhy Payment Total Interest Total Cost 6 327,909.40 300,527.23 27,382.17 12,223.57
$3,300.48 $144,086.01 $644,086.01 7 300,527.23 272,064.96 28,462.27 11,143.46
3.000% 609,371.13 8 272,064.96 242,479.97 29,584.99 10,020.75
3.125% 614,253.57 9 242,479.97 211,727.98 30,751.99 8,853.75
3.250% 619,161.70 10 211,727.98 179,762.96 31,965.02 7,640.71
3.375% 624,095.48 11 179,762.96 146,537.06 33,225.90 6,379.83
3.500% 629,054.86 12 146,537.06 112,000.53 34,536.52 5,069.21
3.625% 634,039.78 13 112,000.53 76,101.70 35,898.84 3,706.90
3.750% 639,050.18 14 76,101.70 38,786.80 37,314.89 2,290.84
3.875% 644,086.01 15 38,786.80 0.00 38,786.80 818.93
4.000% 649,147.22 Subtotal $450,000.00 $144,086.01
4.125% 654,233.74 Down Pymt $50,000.00
4.250% 659,345.51 Total Cost $644,086.01
Mortgage Payment Calculator Amortization Schedule
Date 19-Jul-2025 Rate 3.875% Year Beginning Balance Ending Balance Paid on Principal Interest Paid
Item Condo Term 15 1 $150,000.00 $142,477.93 $7,522.07 $5,679.84
Price $200,000.00 Montlhy Payment $1,100.16 2 142,477.93 134,659.14 7,818.79 5,383.12
Down Payment $50,000.00 Total Interest $48,028.67 3 134,659.14 126,531.94 8,127.20 5,074.71
Loan Amount $150,000.00 Total Cost $248,028.67 4 126,531.94 118,084.15 8,447.79 4,754.12

Varying Interest Rate Schedule 5 118,084.15 109,303.13 8,781.02 4,420.90


Rate Montlhy Payment Total Interest Total Cost 6 109,303.13 100,175.74 9,127.39 4,074.52
$1,100.16 $48,028.67 $248,028.67 7 100,175.74 90,688.32 9,487.42 3,714.49
3.000% 236,457.04 8 90,688.32 80,826.66 9,861.66 3,340.25
3.125% 238,084.52 9 80,826.66 70,575.99 10,250.66 2,951.25
3.250% 239,720.57 10 70,575.99 59,920.99 10,655.01 2,546.90
3.375% 241,365.16 11 59,920.99 48,845.69 11,075.30 2,126.61
3.500% 243,018.29 12 48,845.69 37,333.51 11,512.17 1,689.74
3.625% 244,679.93 13 37,333.51 25,367.23 11,966.28 1,235.63
3.750% 246,350.06 14 25,367.23 12,928.93 12,438.30 763.61
3.875% 248,028.67 15 12,928.93 0.00 12,928.93 272.98
4.000% 249,715.74 Subtotal $150,000.00 $48,028.67
4.125% 251,411.25 Down Pymt. $50,000.00
4.250% 253,115.17 Total Cost $248,028.67

You might also like