What was the overall amount of interest paid over the term of the loan?

Since the 2008 subprime mortgage crisis occurred, homebuyers have become more aware of their rights and responsibilities of understanding the various terms and conditions offered by lenders. First, find a dream house you might be interested in purchasing. It could be anywhere in United States, even a Hollywood mansion. Provide the city and state where the home is located and also the current value of the home. You can even include a picture, but make sure you credit the actual source. Please note, you don’t have sufficient cash to purchase this property outright and will need to finance.

Next, fill out the Mortgage Payment Spreadsheet with the following information (but don’t share it):

• Annual Amount of Loan: Price of the property minus the down payment; for the initial payment, use 20% of the price of the property
• Annual Interest Rate: Use the 30-year fixed rate mortgage from FRED
• # Periods: Total number of monthly payments to be made over the life of the loan (e.g., 30-year loan = 360 months)

In your initial post, address the following:

• What was the overall amount of interest paid over the term of the loan?
• Change multiple variables (such as interest rate, down payment) and describe the impact of each.