View Single Post
Old 02-09-2013, 06:18 PM
PeterC4 PeterC4 is offline
Officially Welcomed to the 'Fest
Location: Toronto
Join Date: Mar 2011
Posts: 963
Mein Auto: 535xi,328xiC
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, BMS Tune

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