0
How do you enter a pmt function to calculate the monthly payments based on the amount to be financed?
Wiki User
∙ 14y ago
PMT function returns the payment amount for a loan based on an interest rate and a constant payment schedule.
PMT(interest_rate,number_payments,PV,FV,Type)
interest_rate = interest rate for the loan
number_payments = number of payments for the loan
PV = present value or principal of the loan (amount to be financed)
FV (optional) = future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of 0.
Type (optional) = indicates when payments are due. Type can be one of the following values:
0 = payments due at the end of the period (default or if value is left out)
1 = payments due at the beginning of the period
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do I calculate my monthly car payments for it?
This is a very good website to calculate the monthly car payments: http://autos.aol.com/calculators/car-payment-calculator/ or http://www.carmax.com/enus/car-payment-estimates-calculator/default.html
What would I need a mortgage amortization calculator for?
The mortgage amortization calculator is for working out your monthly mortgage payments. It will also calculate into the equation when and if you make extra monthly payments on your mortgage.
What is a financed car?
A "financed" car is one that is purchased with money that is loaned to you. You then make monthly payments at a certain rate and percentage for a certain number of years and months. The car is owned outright by the one who lent the money.
Will a loan auto calculator help you figure out your monthly payments?
A loan auto calculator is made for precisely that, figuring out your monthly payments. They are straight forward to use and clearly state exactly what information they need to calculate your monthly payment.
What would be the monthly payments on a car finance of 32000 be over 4 years?
The amount for monthly payments on a car financed for $32,000 for 4 years will depend on the rate of interest that is charged. Banks might charge more interest to a person that has good but not excellent credit history.
How can I estimate my car payment?
You can calculate this on a monthly loan calculator, available online. You must input information and it will give you an estimate of your monthly loan payments.
What would the monthly house payment be of 199000?
Depends on how you financed the payments, and what time period you were looking at to pay it off in. Ball Park.. something like 30 year, somewhere between like $600-900 monthly
How much down and what are your monthly payments ?
How much down and what are your monthly payments
Is it a crime in Kentucky to pull the motor out of a financed car?
no its not!! it is technically your car so you can pull it out but you still have to make the monthly payments! you can't pull the engine out of a leased car though!!
What kind of information do I need to calculate the monthly payments on my loan?
You monthly payment on a loan is largely based on your monthly income. usually you are expected to pay 15% percent of you income to you debtors or creditors.
What does monthly housing payments mean?
It means that you have to make monthly payments on your house.
What is the best way to calculate mortgages?
The best way to calculate a mortgage is to use a mortgage calculator. This is a specialized tool that allows you to work out your monthly payments on your mortgage.
