answersLogoWhite

0

Loan payment is a function of the following:

Number of periods the loan will be payed (e.g. 36 months)

Interest rate per period

The loan amount

After having all of this use excel PMT function to calculate the payment

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Could you inform me about loan repayment calculator?

A loan repayment calculator helps you figure out your monthly payment for any given month over the term of your loan. This is helpful if you have an adjustable rate mortgage or a balloon payment.


Where can I find information about calculating car payment?

Many websites that deal with automobile related issues have special calculators designed to help you figure out your car payment. BankRate.com and Cars.com both offer features that have you put in your car and loan information to figure out your payment.


What info do I need to use a vehicle loan calculator?

A vehicle loan calculator will typically generate your monthly payment. To get this figure, you will need the total cost of the car, the amount of cash you are putting down, the rate for your loan and the duration of your loan.


How can one find the principal payment on a loan?

To find the principal payment on a loan, subtract the interest payment from the total payment made each period. The principal payment is the portion of the payment that goes towards reducing the original loan amount.


How can you lower loan payment for car?

You can lower your loan payment by refinancing your car loan. You can also negotiate with your current lender and see if he can reduce your payment amount.


Function takes rate payment and loan amount and outputs a monthly loan payment amount in excel?

The PMT function in Excel outputs a monthly loan payment amount.


What function in excel takes rate payment and loan amount and outputs a monthly loan payment amount?

The PMT function in Excel outputs a monthly loan payment amount.


A payday loan is a type of what?

Single Payment Loan


What happens to the monthly payment and total payment for a loan with a lower annual interest rate?

If a loan has a lower annual interest rate, the monthly payment will be lower and the total payment over the life of the loan will also be lower.


What is a loan payment calculator used for?

A loan payment calculator is used for helping you to calculate a monthly payment for any type of loan. You can use it for a mortgage, car, boat, cottage, etc.


What will my student loan payment be?

Your student loan payment will depend on the amount you borrowed, the interest rate, and the repayment term. You can use a loan calculator to estimate your monthly payment based on these factors.


What is the monthly mortgage payment on a 250000 loan at 4.5 percent?

For a 30-year loan, the monthly payment will be $1,266.71