Most of the time we get a couple of variables, and we’ll calculate the loan payments. For example, try $ 10,000 a car, financed at 12% interest for 5 years. Everything you want to know how much your monthly payment will be and whether the payment. Just a heads up – you need a calculator to calculate these payments. As you can probably buy a computer, use the calculator to use on your computer, or you can use Excel.
The example above and try to calculate your monthly payment. First, we will define a number of conditions. PV (present value) of the loan will increase to $ 10 000. Your annual interest rate will be .12. Since we are only trying to calculate the monthly payments, we will of 12% per year from a monthly fee. Simple as Division 12 of 0.12 which gives you 0.01% or 1. Finally, we will bring our number of payments n. We define five years know, but we need to put in months. As the proliferation of 5 to 12, your 60 months.
Ok, so here are our variables:
Number of Payments: n = 60
Interests: i = 0.01
Present Value: PV = 10,000
Payments are calculated with the simplest way to use a spreadsheet on your computer, such as Excel. . Open the program, simply select a cell and type the following command (without quotes): .. “= PMT (0.01,60,10000) Press Enter This then automatically calculates your monthly payment – $ 222.44 This. What your monthly payment should be on your auto loan because they are variables, I am sure that the loan payments, you must calculate the different variables, so here is the equation variables instead of values ??is: = PMT (I, N, PV). To calculate your loan payments to replace the single I with interest, the number of payments and the total PV of the loan n.
Use Excel to find out is by far the easiest way. Just plug in your variables and press Enter and you’re done. If you are afraid of death Excel you can use the old formula. Take a look at, and you may want to give a first glimpse Excel:
Monthly Payment = (pv) * (i / (1 – (1 + i) ^ (-n)))
Ok, we will solve our example:
Monthly Payment = (10000) * (.01 / (1 – (1.01) ^ (-60)))
Monthly Payment = (10000) * (.01 / (1-0.55045))
Monthly Payment = (10000) * (.01/.44955)
Monthly Payment = (10000) * (0.022244)
Monthly payment = $ 222.44
So we get the same answer of your monthly payment is $ 222.44. Piece of cake!
What we learn? You buy a car for $ 10k and you make only monthly payments of $ 222.44 for five years to repay the case. Does not seem unreasonable? If we add all the monthly payments, we find that you end up paying a total rent of $ 13,346 to $ 10,000 a car. And what your car is worth now? $ 3,000? So, when you pay the car, you are a total of about ten large!
What would happen if funding was not an available option for you? You bought something more economical, we say a $ 2,500 car Even if your car is now worth $ 500, now you only have two large, instead of a dozen great!
Keep this in mind the next time you calculate payments on your mortgage!