Time Value of Money: Computation of Annual Amount of Loan and Interest Rate

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.
Please use this property -- https://www(dot)zillow(dot)com/homedetails/62-Sols-Cliff-Rd-Bar-Harbor-ME-04609/217987773_zpid/
It is in Bar Harbor, Maine -- selling price of $8,900,000.
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.
In response to your peers, provide feedback on their chosen financing method (even the property). Are there any similarities or differences in your peers' responses compared to your own?