Joanne Krol wants to purchase a newer model automobile to replace her rusty 1989 car. The bank where Joanne has a checking account, US Bank, is advertising an annual interest rate of 6.75 percent for a three-year loan on used cars. By selling her old car and using some cash she has accumulated, Joanne has $3,000 available as a down payment. Under her current budget, Joanne figures that the maximum monthly loan payment she can afford is $300. She wants to find out the maximum car price she can afford and keep the monthly payment no higher than $300. She cannot alter the interest rate or the three-year term. Use the Excel Goal Seek command to figure out the highest purchase price Joanne can afford.

Can someone show me step by step how to use goal seek. How do I fill it in?

AutoSave Off be Book1 - Excel Crystal L CL - File Home Insert Page Layout Formulas Data Review View Help Share Comment 2 I Data Sort Get Data Outline Refresh All Stocks Filter Geography Z PN Tools What-If Forecast Analysis Sheet Get & Transform Data Queries & Conn... Data Types Sort & Filter Forecast B9 300 B D E F G H J K 0.0675 0.005625 3 Goal Seek ? X 36 A 1 annual interest rate 2 monthly rate 3 number of years 4 number of months 5 6 monthly payment 7 8 down payment 9 loan amount 10 highest purchase price 11 SB59 1 $300.00 Set cell: To yalue: By changing cell: 300 SB$9 $3,000 OK Cancel $3,000