 |
How do you calculate monthly payment on a car loan using paperpencil or excel not an online calculator? |
[Edit] |
Answer
Excel certainly helps...you'll find a number of options, including several for calculating payments using "formulas" (the Fx features) that may get you there...even an amortization one.
So presuming you know interest rate, principal and time variables (like payment at start or end of period, how long a term, etc) - and - this is even more important - they are defined the same by the lender simularly to how the function thinks - you can calculate it and should really be pretty close.
Pen and paper would rely on reference tables/charts for giving a payment amount per 100 (or thousand) dollars at a number of rates (hopefully one is the right one) and over specified terms. Available at most any lender, charts are common in most newspapers for at least the ranges they are dealing with commonly.
Of course any unusual aspect to the loan your calculating....variable rates, fixed payments, early payoffs, etc., complicates it more so.
First answer by IamLostRU. Last edit by IamLostRU. Contributor trust: 777 [recommend contributor]. Question popularity: 6 [recommend question]
|
Also see on Answers.com
Research your answer: |
- If you are preapproved for a car loan through your credit union when you go to the dealer to buy a car are they going to do another credit check even though you have your own financing and if so why?
- What is the arizona law for returning a vehicle you did not get financing for after driving out the lot for 2 weeks?
- The effects of the increment of oil consumption to the consumers?
Answers.com > Wiki Answers > Categories > Business and Finance > Personal Finance > Money Management > Loans > Auto Loans and Financing > How do you calculate monthly payment on a car loan using paperpencil or excel not an online calculator?
Our contributors said this page should be displayed for the questions below. (Where do these come from ) |
| If any of these are not a genuine rephrasing of the question, please help out and edit these alternates. |
