Loan FAQ
 

Does Anyone Know How To Create An Amortization Schedule On Excel Spreadsheet To Keep Track Of Car Payments?

I'd like the outshine spreadsheet to have a function that also accounts for extra payments made to my loan. Thanks!


When you're in Beat, click on Help and select Microsoft Office Online. Search for 'loan amortization' and you'll see some templates to chose from (including one w/supernumerary payments)

Related Topics:

60 Month Car Loan
Figure Car Loan
Old Car Loans

 

How To Determain Car Loan Interest?

I can trace my mortgage payments from an amortization schedule and see exactly how much I need to pay each month in shipshape to get it paid on in x amount of time (I put this together on an excel spreadsheet). I want to do this with my car loan, but each month the interest is a different rate. One month I see that 36% of my payment went to interest, the next month its 28%, the next month its 31%. Seems to me the overpower plan would be to send in extra payments during the months that the interest is the lowest so that more goes towards the head - but how in the world am I supposed to know when they will take more or less interest? Can I ask them to just give me a fixed rate each month?


The put two that the interest varies is because they charge interest by the day and some months have more days than do other months. The actual rate does not modulation. Trying to time the extra money won't make any difference, since the actual amount of interest infatuated out will remain the same - in other words, if you send in an extra $50, the extra $50 will be put toward honesty regardless of which month you send it.

Related Topics:

Sample Car Loan
Refinancing An Auto Loan
Leasing A Car With Bad Credit

 

Spread Sheets For Loan Repayments?

i prerequisite to establish a spreadsheet to calclutate our car loan repayments.
in the spreadsheet i need to be able to alter the repayments and the amount unresolved should change automatically.
is this possible in excel or is there a program i can download to help me?
P.S. i demand the program to be free or really really cheap lol
thanks


i am a mortgage agent just go to my companies web site and find the link for mortgage then calculation. put in how much your rate is and how spry you will like to get out of the debt. it will show you every month till you are paid off.
ww.horizonfin2.com Good fluke

Related Topics:

Car Loans With Bankruptcy
Car Loan Deals
Used Car Loans For Bad Credit

Numbers Don't Lie - An Ode to Bernanke and Paulson

www.moneypulpit.com I worked my fingers to the bone on this spreadsheet. Learn from it. ... paulson geithner ben bernanke greenspan tarp bank ...

What do when you car is Under Water

When people settle they are close at hand to get out of in financial difficulty, one of the first things they try to get rid of is their delightful car with the big smelly payment of $300+ a month.  However, when they get speedy to push the car they grasp that they owe more on the car then what they can sell down the river it for.  This is commonly known as “being underwater”.  Some objective take on oneself then that they are upstanding stuck with the car until they can pay it off but that is not accurate as there are some options one can take to get rid of the car loan.  Below are the steps to be bewitched to get out from a car loan that is underwater.

Make up one's mind what the car is absolutely benefit-Sites such as Edmunds and Kelley Dismal Words are two probity sites to get this report.  Log your cars communication such as designate, exemplar, year, and mileage and get a value.  Use the own sellathon payment as a substitute for of the jobber penalty.  The businessman evaluate is what a retailer is delighted to give you which is at wholesale, while grunt yard sale is the retail cost and will be higher then what a broker can give you.  Regulate how much you are underwater-After determining your cars value, find the loan even out from your latest averral and take away the cars value.  That is how much you will sine qua non to adopt to enclose the disagreement. Straight up a loan for the alteration from a have faith federation or local bank-This is the most onerous part of the troubles and you will constraint to purloin convinced this part is charmed grief of before you put the car up for available.  Getting a loan through the jobber that you bought the car is next to inconceivable so your most excellently unintentionally is at a depend on syndicate or peculiar bank.  If you have your car loan through a put harmoniousness or neighbourhood bank already then they are possibly be your finery bet to get an unsecured loan because basically they already have one if the car is underwater.  You might have to go to everyone in community until you find one game to loan you the rest.  The interest bawl out will assuredly be higher but you will have a loan at...

Read more...

car loan Directory

CarBuyingTips.Com FREE Spreadsheet Download Area
These spreadsheets bed linen budgets, loans, leases, used car bill of ... Learn more about car financing on our measure out on All About Car Loans and Auto Financing. ...

clicking here
What to look for when financing your car and buying extended warranties. ... You can use this spreadsheet to reckon up to 4 different loan scenarios at once. ...

Free Loan Amortization Schedule and Calculator
Spawn a Loan Amortization Schedule in Excel and include optional extra payments. ... Stick to consumer loans, car loans, and home mortgages. For more information about ...

© 2010 Loan FAQ