Interest-only | search
Click here to view Interest-only news from 60+ newspapers.
Bookmark or Share- Using Excel formulas to figure out payments and savingsMicrosoft Excel can help you manage your finances. Use Excel formulas to calculate interest on loans, savings plans, down payments, and more.
- Excel functions (by category) - Microsoft SupportDetect errors in formulas. Lists all Excel functions by their category, such as Logical functions or Text functions.
- IPMT function - Microsoft SupportReturns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. Syntax. IPMT(rate, per, nper, pv, [fv], [type]) The IPMT function syntax has the following arguments: Rate Required. The interest rate per period.
- Calculate multiple results by using a data tableUsing a 3.75% interest rate, D2 returns a monthly payment of $1,042.01 using this formula: =PMT(C2/12,$B$3,$B$4). You can use one or two variables, depending on the number of variables and formulas you want to test.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
More
