On a new worksheet - You are buying a house. Youve determined that your budget is $4,000/month. Youve found a $1,000,000 home that you like. 30 Year fixed mortgage rates are currently offered at 5%. Using Goal Seek how much of a down payment would you need to make in order to afford the $4,000 per month payment? Hint: The amount of the mortgage is the difference between your down payment and the value of the house