Please create a Google Sheet for me to answer this question and please write all formulas used.

Thank you - apologize for the side ways picture

Information Current Grade: 0.0/10 Remaining Time: Unlimited Origional Morgage Information for Project The Smith's purchased their home with a $206,500 mortgage. The bank's rate for this mortgage was 79 APRIor 30 years. The Smith's have payed this mortgage for 11 years while adding an extra payment of $825 every 6 months and pare now thinking about refinancing the loan through a new bank. Find a real bank, with real rates and real loan lengths to decide on how you think the Smith's should refinance this loan. Remember that all calculation (except the monthly payment) must be shown on the Google Sheet and not done in a calculator. s Information Current Grade: 0.0/10 Remaining Time: Unlimited Origional Morgage Information for Project The Smith's purchased their home with a $206,500 mortgage. The bank's rate for this mortgage was 79 APRIor 30 years. The Smith's have payed this mortgage for 11 years while adding an extra payment of $825 every 6 months and pare now thinking about refinancing the loan through a new bank. Find a real bank, with real rates and real loan lengths to decide on how you think the Smith's should refinance this loan. Remember that all calculation (except the monthly payment) must be shown on the Google Sheet and not done in a calculator. s