Advance Center

See how to use the CUMIPMT function to calculate the total interest paid for two different loans.

See how to create an array formula that will extract loan records that are past due. The formula is dynamic so that as loans come due or as loans are added to the database, the extract area updates. See the functions: COUNTIFS, SUMPRODUCT, IF, ROWS, INDEX, SMALL, ROW

operators and parenthesis 4)Formula for Effective Annual Interest Rate 5)How to find Excel functions to use in formulas 6)Search for Excel functions 7)EFFECT function 8)Formula for month interest rate 9)Formula for total number of periods 10)Formula for monthly payment on a loan using the PMT function 11)Formula for text string that use cell references, Text [...]

See the Beauty of the PMT function and an Amortization Table. For consumers, you can see how much the bank takes from you each month as interest and how much is left over for the loan reduction. For accountants (financial and tax), you can see how much of each cash flow goes toward an Expense [...]

incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!! The Excel Finance [...]