Question: Please Use Excel to demonstrate on how to get the answer Compute The customer has budgeted a maximum of $500 per month for the car
Please Use Excel to demonstrate on how to get the answer


Compute The customer has budgeted a maximum of $500 per month for the car payment. Currently based on a purchase price of $50,000, a 10% down payment, and 7% sales tax you estimate monthly payments as $688.76. You will use Goal Seek to calculate the optimal purchase price to meet the customer's budget. 6. Use Goal Seek to determine the optimal purchase price to reach a $500 monthly payment with all other variables remaining unchanged. Compute The customer has budgeted a maximum of $500 per month for the car payment. Currently based on a purchase price of $50,000, a 10% down payment, and 7% sales tax you estimate monthly payments as $688.76. You will use Goal Seek to calculate the optimal purchase price to meet the customer's budget. 6. Use Goal Seek to determine the optimal purchase price to reach a $500 monthly payment with all other variables remaining unchanged
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
