answersLogoWhite

0

to detemine the interest portion of a loan

IPmt( interest_rate, period, number_payments, PV, FV, Type )

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the formula used in Excel to calculate interest?

The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.The most common function to do this is IPMT and you can also use ISPMT.


What function do you use in Excel 2010 for an amortization table?

PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.


You want ipmt 2009 question paper with soultion?

i want ipmt 2009 questio paper with soultion


Which Excel function would you use when you want to determine a monthly loan payment?

The PMT function.


What is full form of ipmt?

Idhar Pani Mat Talasho...


What is the meaning of IPMT lesion in pancreas?

Intraductal Papillary Mucinous Tumor


What formulas can be used to correctly calculate your annual loan payments to Aunt Tillie for the car loan?

Use PMT function in the excel sheet.


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.


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 are function of bank?

giving loan


Which Excel function calculates the principal portion of a loan payment?

The PPMT function.


How can I use Excel to calculate and track my car loan payments?

You can use Excel to calculate and track your car loan payments by setting up a loan amortization schedule. Input the loan amount, interest rate, loan term, and start date in Excel. Then, use the PMT function to calculate the monthly payment. Create a table to track each payment, including the principal and interest portions. Update the table each month to keep track of your remaining balance and progress on the loan.