If you buy a car for 40,000 and for the next 5 years you pay 500 a mont.( at the end of each month) and you have the car paid for you. Which excel formula do you have to use? if you do not use a formula, how would you make the development of your spreadsheet? how much money did you pay for the car? what is the rate for the loan? how much money do you save if you pay cash for the car.