BIS

profileTTT12

Determine Input Values Using Goal Seek (Chapter 6): 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?

    • 7 years ago
    • 3
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      in_order_to_perform_goal_seek.docx