PMT C612 C7- C5 The last thing we may want to include is a total that shows our car buyer how much money she will end up paying. Your first stop should be our Incentives and Rebates page. Open a new Excel worksheet 2.
PMT r n P.
PMT r n P. Insert the correction function in the cell next to Monthly Payment. If you are building your model exactly like mine the formula for the monthly payment will look like this. Lets say you need to borrow 25000 to buy that car of your dreams and the interest rate will be 6 percent.