Make sure to show all calculation $-$ as always, use Excel fu

A friend of yours is considering buying or building a new home. Upon discussing with lenders and considering the pros and cons of the two options, your friend has asked you for advice on which option is better. The options are:

Option $1$ entrails buying a new home valued at $$460,000$ by getting a $$420,000$ mortgage and a $$40,000$ down payment. Your friend would like to finance the house as a $30-$year mortgage with an interest rate of $7$ percent. Your friend anticipates selling the home in ten years. You estimate that the home value will appreciate annually by $3\mathrm{.}5$ percent. Your friend wants to know the home's value in ten years and how much equity, if any, would be earned from the house sale.Make sure to show all calculation $-$ as always, use Excel fu

A friend of yours is considering buying or building a new home. Upon discussing with lenders and considering the pros and cons of the two options, your friend has asked you for advice on which option is better. The options are:

Option $1$ entrails buying a new home valued at $$460,000$ by getting a $$420,000$ mortgage and a $$40,000$ down payment. Your friend would like to finance the house as a $30-$year mortgage with an interest rate of $7$ percent. Your friend anticipates selling the home in ten years. You estimate that the home value will appreciate annually by $3\mathrm{.}5$ percent. Your friend wants to know the home's value in ten years and how much equity, if any, would be earned from the house sale.