View Single Post
  #38  
Old 02-09-2013, 06:18 PM
PeterC4 PeterC4 is online now
Officially Welcomed to the 'Fest
Location: Toronto
 
Join Date: Mar 2011
Posts: 957
Mein Auto: 535xi,328xiC
Quote:
Originally Posted by smashhell View Post
How would it be 300 payment?
Can anyone do some calculation?
The fast way to do it in Excel is to use the PMT function - you need the following

Monthly interest rate
Number of months
Current Value (Current Purchase Price - net of down payments)
Future Value (Residual Value)

Make sure you enter the Future value as a negative.
You can use the annual interest rate divided by 12 to get to monthly interest rate.
Down payments lower monthly payments, but money is out the door.
__________________
2012 535xi M-Sport, Carbon Black, Cinnamon-Alum Hex, Exec Pack, Tech Pack, HUD, Damper Control, BMW Apps, Heated Rear Seats

Last edited by PeterC4; 02-09-2013 at 06:20 PM.
Reply With Quote