Car Loan

Assume you can afford to use 9% of your monthly gross income towards your monthly car payment. The terms of the loan are 6.75% APR for 5 years.  What is the highest price car you can afford based on the information above? Be sure to show and explain the Excel formula you used. Does this amount get a car that you like? What are some strategies that you could use to make sure the car that you purchase does not exceed your budget?  What is the highest priced car the high school graduate can afford based on the same information? Be sure to show and explain the Excel formula you used.  Use an absolute or relative change statement to compare the highest priced car of the high school graduate and yourself