Discussion: Determine Input Values Using Goal Seek
Using the Home Loan worksheet, let's practice using Goal Seek. We want to determine the cost of a home in order to achieve a $600 monthly mortgage. Using your monthly payment, desired monthly payment, and current cost of home, calculate the new cost of home to have a $600 monthly mortgage. Save your work for tomorrow's practical question.
Where is Goal Seek located? What values do you need to input for Set cell, To value, and By changing cell? To achieve a $600 monthly mortgage, what is the new Cost of Home?