. You owe $9,000 in student loans and would like to pay it all off with...

 
 

Transcribed Image Text:

. You owe $9,000 in student loans and would like to pay it all off with your commissions. Use Goal Seek to determine the amount you must sell (cell G5) in order for cell G3 (your commission) to equal $9,000 so you can fully pay off your student loans. Accept the Goal Seek solution. 1 Sales MASSIKE 10 12 A 14 5 17,000.00 Rate Commission 5% 5 5.50% S 6% 5 6.50% 5 7% 5 7.50% 5 8% 5 8.50% 5 9% 5 9.50% $ 10% 850.00 935.00 1,020.00 1,105.00 1,190,00 1,275.00 1,360.00 1,445.00 1,530.00 1,615.00 1,700,00 с Student Loan $ 9,000.00 Minimum Commission Rate Commission $ 5% 600.00 Sales Goal $ 17,000.00 H Goal Seek Set cell: A3 To value: By changing cell: Cancel OK Q . You owe $9,000 in student loans and would like to pay it all off with your commissions. Use Goal Seek to determine the amount you must sell (cell G5) in order for cell G3 (your commission) to equal $9,000 so you can fully pay off your student loans. Accept the Goal Seek solution. 1 Sales MASSIKE 10 12 A 14 5 17,000.00 Rate Commission 5% 5 5.50% S 6% 5 6.50% 5 7% 5 7.50% 5 8% 5 8.50% 5 9% 5 9.50% $ 10% 850.00 935.00 1,020.00 1,105.00 1,190,00 1,275.00 1,360.00 1,445.00 1,530.00 1,615.00 1,700,00 с Student Loan $ 9,000.00 Minimum Commission Rate Commission $ 5% 600.00 Sales Goal $ 17,000.00 H Goal Seek Set cell: A3 To value: By changing cell: Cancel OK Q

Answer rating: 100% (QA)

To use Goal Seek in Excel to determine the amount you must sell in order to pay off your student loa... View the full answer