Answer 1: The price range of the Home I am considering is $250k to $325K. The down payment will be some portion of my saving. I will look around to make a down payment of upto $60k which is 50% of my saving. The house price range which I am looking for is depended on that rule that the house price will be less than 3.5 times of my Salary. My Annual salary would be around $100k.
Answer 2: The House I am looking for is in Austin Texas. The house should be nearby to the School, park, etc. The Neighborhood should be close to trailing hikes with a community pool and the toll away access should also be near around. The Austin Airport should also be near my house. The house can be one store or two story, both are acceptable to me. I am looking for a house with atleast 2-3 rooms with atleast 2 bathrooms. The square footage of the house should be more than 1500.
Answer 3: Yes, I have found the right house based on my Search Criteria. The House address is 13325 Alysheba Dr, Del Valle, TX 78617. The price of the house is $288,000 with 3 bedrooms, 2 baths and 1752 sq. Ft. It is about 5-10 minutes’ drive to Tesla Gigafactory and Austin International Airport. The neighborhood has great schools nearby with park and hiking trails along with a community pool. Berdoll Farms community gives you the proximity needed to navigate this growing city. The 130-tollway access is a short few minutes away from destinations like The Domain, Apple, UT Campus and Round Rock.
Answer 4: The research, I have found that the mortgage rate which is near to my credit score is 2.48%. I want a 30-year fixed loan with equal monthly installments. The estimated closing cost of my house which includes Application fees, attorney fees, Courier fees, Credit report fees, Origination fees, House Inspection fees, Homeowner’s Insurance etc. around upto 4% of my house price.
Based on this, that Total price of my House is $299,520 ($288000 my house price and $11,520 is the closing costs). I will make the down payment of $60 and will take a mortgage of $239,520. It is will be 30-year fixed loan at a rate of 2.48% with monthly payment. Using the PMT function in excel, I calculated that my monthly payment of principal and Interest would be $943.90. Total Mortgage pack will be $339,805.74 and the Interest paid during the 30 years would be $100,285.74.
The Property tax of my house is $329 and Home Insurance would be 5760 basis the 2% of my home’s purchase price.
Answer 5: My Amortization Table is as Follows:
    Month
    Opening Loan Balance
    Interest Due
    Monthly Repayment
    Closing Monthly Loan Balance
    1
     239,520.00
     495.01
     943.90
     239,071.10
    2
     239,071.10
     494.08
     943.90
     238,621.28
    3
     238,621.28
     493.15
     943.90
     238,170.52
    4
     238,170.52
     492.22
     943.90
     237,718.84
    5
     237,718.84
     491.29
     943.90
     237,266.22
    6
     237,266.22
     490.35
     943.90
     236,812.66
    7
     236,812.66
     489.41
     943.90
     236,358.17
    8
     236,358.17
     488.47
     943.90
     235,902.74
    9
     235,902.74
     487.53
     943.90
     235,446.37
    10
     235,446.37
     486.59
     943.90
     234,989.05
    11
     234,989.05
     485.64
     943.90
     234,530.79
    12
     234,530.79
     484.70
     943.90
     234,071.58
    13
     234,071.58
     483.75
     943.90
     233,611.43
    14
     233,611.43
     482.80
     943.90
     233,150.32
    15
     233,150.32
     481.84
     943.90
     232,688.26
    16
     232,688.26
     480.89
     943.90
     232,225.24
    17
     232,225.24
     479.93
     943.90
     231,761.27
    18
     231,761.27
     478.97
     943.90
     231,296.34
    19
     231,296.34
     478.01
     943.90
     230,830.45
    20
     230,830.45
     477.05
     943.90
     230,363.59
    21
     230,363.59
     476.08
     943.90
     229,895.77
    22
     229,895.77
     475.12
     943.90
     229,426.98
    23
     229,426.98
     474.15
     943.90
     228,957.23
    24
     228,957.23
     473.18
     943.90
     228,486.50
    25
     228,486.50
     472.21
     943.90
     228,014.80
    26
     228,014.80
     471.23
     943.90
     227,542.13
    27
     227,542.13
     470.25
     943.90
     227,068.48
    28
     227,068.48
     469.27
     943.90
     226,593.85
    29
     226,593.85
     468.29
     943.90
     226,118.24
    30
     226,118.24
     467.31
     943.90
     225,641.64
    31
     225,641.64
     466.33
     943.90
     225,164.06
    32
     225,164.06
     465.34
     943.90
     224,685.50
    33
     224,685.50
     464.35
     943.90
     224,205.94
    34
     224,205.94
     463.36
     943.90
     223,725.40
    35
     223,725.40
     462.37
     943.90
     223,243.86
    36
     223,243.86
     461.37
     943.90
     222,761.32
    37
     222,761.32
     460.37
     943.90
     222,277.79
    38
     222,277.79
     459.37
     943.90
     221,793.26
    39
     221,793.26
     458.37
     943.90
     221,307.73
    40
     221,307.73
     457.37
     943.90
     220,821.19
    41
     220,821.19
     456.36
     943.90
     220,333.65
    42
     220,333.65
     455.36
     943.90
     219,845.10
    43
     219,845.10
     454.35
     943.90
     219,355.55
    44
     219,355.55
     453.33
     943.90
     218,864.98
    45
     218,864.98
     452.32
     943.90
     218,373.39
    46
     218,373.39
     451.31
     943.90
     217,880.79
    47
     217,880.79
     450.29
     943.90
     217,387.18
    48
     217,387.18
     449.27
     943.90
     216,892.54
    49
     216,892.54
     448.24
     943.90
     216,396.88
    50
     216,396.88
     447.22
     943.90
     215,900.19
    51
     215,900.19
     446.19
     943.90
     215,402.48
    52
     215,402.48
     445.17
     943.90
     214,903.74
    53
     214,903.74
     444.13
     943.90
     214,403.97
    54
     214,403.97
     443.10
     943.90
     213,903.17
    55
     213,903.17
     442.07
     943.90
     213,401.33
    56
     213,401.33
     441.03
     943.90
     212,898.45
    57
     212,898.45
     439.99
     943.90
     212,394.54
    58
     212,394.54
     438.95
     943.90
     211,889.58
    59
     211,889.58
     437.91
     943.90
     211,383.58
    60
     211,383.58
     436.86
     943.90
     210,876.54
    61
     210,876.54
     435.81
     943.90
     210,368.44
    62
     210,368.44
     434.76
     943.90
     209,859.30
    63
     209,859.30
     433.71
     943.90
     209,349.11
    64
     209,349.11
     432.65
     943.90
     208,837.86
    65
     208,837.86
     431.60
     943.90
     208,325.55
    66
     208,325.55
     430.54
     943.90
     207,812.18
    67
     207,812.18
     429.48
     943.90
     207,297.76
    68
     207,297.76
     428.42
     943.90
     206,782.27
    69
     206,782.27
     427.35
     943.90
     206,265.71
    70
     206,265.71
     426.28
     943.90
     205,748.09
    71
     205,748.09
     425.21
     943.90
     205,229.40
    72
     205,229.40
     424.14
     943.90
     204,709.63
    73
     204,709.63
     423.07
     943.90
     204,188.80
    74
     204,188.80
     421.99
     943.90
     203,666.88
    75
     203,666.88
     420.91
     943.90
     203,143.89
    76
     203,143.89
     419.83
     943.90
     202,619.81
    77
     202,619.81
     418.75
     943.90
     202,094.66
    78
     202,094.66
     417.66
     943.90
     201,568.41
    79
     201,568.41
     416.57
     943.90
     201,041.08
    80
     201,041.08
     415.48
     943.90
     200,512.66
    81
     200,512.66
     414.39
     943.90
     199,983.15
    82
     199,983.15
     413.30
     943.90
     199,452.55
    83
     199,452.55
     412.20
     943.90
     198,920.84
    84
     198,920.84
     411.10
     943.90
     198,388.04
    85
     198,388.04
     410.00
     943.90
     197,854.14
    86
     197,854.14
     408.90
     943.90
     197,319.13
    87
     197,319.13
     407.79
     943.90
     196,783.02
    88
     196,783.02
     406.68
     943.90
     196,245.80
    89
     196,245.80
     405.57
     943.90
     195,707.47
    90
     195,707.47
     404.46
     943.90
     195,168.03
    91
     195,168.03
     403.35
     943.90
     194,627.47
    92
     194,627.47
     402.23
     943.90
     194,085.80
    93
     194,085.80
     401.11
     943.90
     193,543.00
    94
     193,543.00
     399.99
     943.90
     192,999.09
    95
     192,999.09
     398.86
     943.90
     192,454.05
    96
     192,454.05
     397.74
     943.90
     191,907.88
    97
     191,907.88
     396.61
     943.90
     191,360.58
    98
     191,360.58
     395.48
     943.90
     190,812.16
    99
     190,812.16
     394.35
     943.90
     190,262.60
    100
     190,262.60
     393.21
     943.90
     189,711.90
    101
     189,711.90
     392.07
     943.90
     189,160.07
    102
     189,160.07
     390.93
     943.90
     188,607.09
    103
     188,607.09
     389.79
     943.90
     188,052.98
    104
     188,052.98
     388.64
     943.90
     187,497.72
    105
     187,497.72
     387.50
     943.90
     186,941.31
    106
     186,941.31
     386.35
     943.90
     186,383.75
    107
     186,383.75
     385.19
     943.90
     185,825.03
    108
     185,825.03
     384.04
     943.90
     185,265.17
    109
     185,265.17
     382.88
     943.90
     184,704.14
    110
     184,704.14
     381.72
     943.90
     184,141.96
    111
     184,141.96
     380.56
     943.90
     183,578.62
    112
     183,578.62
     379.40
     943.90
     183,014.11
    113
     183,014.11
     378.23
     943.90
     182,448.43
    114
     182,448.43
     377.06
     943.90
     181,881.59
    115
     181,881.59
     375.89
     943.90
     181,313.57
    116
     181,313.57
     ...