answersLogoWhite

0


Best Answer

If you have a set number of payments and a constant interest rate, use the PMT function.

PMT(rate,nper,pv,fv,type)

  • Rate = Interest rate for the loan
  • Nper = Total number of payments for the loan
  • Pv = Present Value (total amount a series of future payments is worth now). Also known as Principal
  • Fv = [optional] Future Value (cash balance after the last payment). If you omit Fv, it is assumed to be 0 (zero). (e.g., The loan is paid off.)
  • Type = [optional] Indicates when payments are due
    • 0 or omitted = End of the period
    • 1 = Beginning of the period
User Avatar

Wiki User

โˆ™ 2010-01-31 06:32:28
This answer is:
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate monthly installment payments with Microsoft Excel?
Write your answer...
Submit
Related questions

What describes an installment loan?

Installment loans require monthly payments to pay the loan.


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.


Cassandra is repaying an installment loan of 3500 with 20 equal monthly payments of 196 each what is the annual percentage rate of the loan?

C 12%


What is the difference between installment and annuity?

Instalments are payments for your debts which can be paid on monthly, quarterly or yearly basis or way to make payments. Annuity is insurance product which is contract between you and insurance company for your investments.


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 is monthly repayment?

You pay a monthly installment towards the balance you owe.


What happens when there are 3 mortgages on my land?

In that case you have three monthly mortgages payments.In that case you have three monthly mortgages payments.In that case you have three monthly mortgages payments.In that case you have three monthly mortgages payments.


Where you can get a installment for laptop at Hyderabad?

where i can get a new laptops in installment in hyderabad monthly Rs. 2000


How much down and what are your monthly payments ?

How much down and what are your monthly payments


Will a credit report tell you your debt to income ratio?

No. To calculate your debt to income ratio, add up you total monthly bills (only the bills that will report to the credit bureaus like credit card payments, car loans etc. , do not include the utilities, cell phone bills, insurance etc.) Take your monthly payments and divide them by you monthly income, this will give you the debt ratio. If you owe less than 10 months on an installment loan, most banks will not count that in your monthly debt. (An installment loan is like a car loan...somethingthat eventually you will payoff. Not like a credit card, this is a revolving debt you can payoff and use it again


What is the method called that is used to compute equal periodic payments for an installment loan?

I don't know the "name" of the formula, which is: payment = {loanamount} * i / (1 - (1+i) ^ -{#payments}), where i = monthly rate, i.e. 6% would be 0.06/12.


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.


Types of credit?

There are four basic types of credit. Service credit is monthly payments for utilities, loans let you borrow cash, installment credit, and credit cards.


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.


You want to buy laptop by installment?

dell offers monthly installment pay on all of their computers and laptops


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.


What does a mortgage amortization calculator do?

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. So it will help you keep track of your mortgage and let you know how things stand.


How do you calculate Interest rate if loan amount and monthly payments and loan amount is given?

17k 300 per month


If you win a lottery, is it better to take a lump sum of cash or take your money in installment monthly payments?

If you take it in a lump sum of cash, you will lose money because they take more taxes out of it.


Will an interest only loan calculator help me determine my monthly payments?

An interest only loan calculator will not help you to determine your overall monthly payments. This will only calculate your total interest payment. To know the total cost of your loan use a loan calculator.


What type of software would be best suited to help calculate a monthly budget?

A spreadsheet such as Microsoft Excel or Open Office Calc.


How is buying on margin simullar to buying on an installment plan?

An individual buying securities on margin and buying merchandise on an installment plan have an important feature in common. The commonality is based on the fact that in each of these transactions, interest is charged and must be paid. Generally speaking, the interest is paid when buying on margin upon the sale of the securities. Buying on margin is usually a short term arrangement. With an installment plan, the interest is usually built into the monthly payments. These payments can be over an extended amount of time.


Where can I calculate monthly payments for loans?

You can find a good monthly loan calculator on and decent bank sites. They are easy to use and all automatic so there is very little work involved. Hope this helps.


What is the full form of EMI?

Equated Monthly Installment & Electric & Musical Instrument