Go to www.realtor.com and enter a city where you think you would like to live. Search and
Question:
Go to www.realtor.com and enter a city where you think you would like to live. Search and find a home that you would want to buy. Post the link to that home with the price in the Excel file. Now assume that you are going to make a 20% down payment, and then select a 15-year, 20-year, or 30-year mortgage for the home. Prepare an amortization table for the payments, assuming you can get a 3% mortgage if you select a 15-year, 3.25% for 20-year, or 3.5% for a 30-year mortgage. Now on a separate tab, copy your amortization table, but now assume that after 12 payments, you will start paying an extra $100 on each payment starting with payment 13. Then increase your payment another $100 starting with payment 25, then another $100 starting with payment 37, and then 49, 61, 73 on so on until the mortgage is paid.