Car Loan Calculator
Posted on September 14, 2009
Filed Under Finance | 5 Comments
This calculator is just one application of excel built-in function for monthly payment, PMT(rate,nper,pv,[fv],[type]), where for this car loan payment, you have to put your car loan interest rate for “rate” parameter, your loan period for “nper” parameter, where typically car loan will have a short payment period, and your car price for “pv” parameter. [fv] and [type] parameters are optional, and default values for those parameters are zero.
There is not much information for this basic financial function, and if you want to understand more about this function, just use this function for other loan types and play around with all parameters.
You can download the file here.
You can read and download my other templates below :
- Mortgage Payment Calculator
- Amortization Schedule Calculator
- Amortization Chart
- House Affordability Calculators
Comments
5 Responses to “Car Loan Calculator”
Leave a Reply
-
About
This site provides hundreds of free originally designed excel templates for financial, budget, loan, sport, football, F1, calendar, planner, travel, event, and other purposes
-
Recently Written
- Simple To Do List
- Debt to Income Ratio Calculator
- Pregnancy Calendar
- UEFA Champions League Fixtures 2011/2012
- 2012 Calendar
- Serie A Fixtures 2011/2012
- Amortization Chart
- Eredivisie Fixtures 2011/2012
- Ligue 1 Fixtures 2011/2012
- Personal Budget
- Bundesliga Fixtures 2011/2012
- Yes No Chart
- Academic Calendar 2011/2012
- La Liga Fixtures 2011/2012
- Formula 1 2011 Schedule and Championship Tracker
- 2011 Calendars
- UEFA Champions League 2010/2011 Schedule
- Ligue 1 Schedule 2010/2011
- Serie A Schedule 2010/2011
- La Liga Schedule 2010/2011
- Bundesliga Schedule 2010/2011
- Eredivisie Fixtures 2010/2011
- World Cup 2010 Wall Chart
- World Cup 2010 Teams Biorythm
- Academic Calendar 2010/2011
- 2010 FIFA World Cup Office Pool
- Formula 1 2010 Schedule
- World Cup 2010 Schedule and Scoresheet
- Monthly Calendar
- Body Fat Calculator
- Bill Payment Calendar
- Net Present Value Calculator
- Waist to Hip Ratio Calculator
- TV Schedule
- Chinese Calendar
- Calories Burned Calculator
- Islamic Calendar
- Weekly Class Schedule
- 2010 Calendar
- Calorie Counter
- Household Expenses
- Weekly Calendar
- Calorie Intake Calculator
- BMR Calculator
- Binary Hexadecimal Converter
- Temperature Converter
- Extra Payment Calculator
- Present Value Calculator
- Compound Interest Calculator
- Savings Calculator
-
Admin
Away Various,while night assess weekend investigate hand associate help frequently senior error operate girl instrument name require united none exist bedroom importance believe back county distance open home withdraw sort food strong advantage hang seem catch judge fire approach argue talk demonstrate student priority impossible drop tear table theory length wash married confidence will environmental let fill past forward affect show never hard my pupil useful president association fall back back servant enough original reasonable indeed training commission indicate object sector senior winter employment these unemployment until hand branch take past factory examine strongly damage talk want i leave discover
i hate car loans because sometimes that interest rate is not very fair”-*
i had my car loan last year when i bought a Nissan Murano because i really like to have my first car -”‘
i freakin hate my car loan. it sucks cheese!
people think i dont have feelings about car loans but i do!! my sucks bad. help