MS Excel: Pmt FunctionIn Excel, the Pmt function returns the payment amount for a loan based on an interest rate and a constant payment schedule.The syntax for the Pmt function is: Pmt(RATE,NPER, PV, FV, Type )
RATE is the interest rate for the loan.
NPER is the number of payments for the loan.
PV is the present value or principal of the loan.
FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the Pmt function assumes a FV value of 0.
Type is optional. It indicates when the payments are due. Type can be one of the following values:
| Value | Explanation |
| 0 | Payments are due at the end of the period. (default) |
| 1 | Payments are due at the beginning of the period. |
MS Excel: VLookup Function
In Excel, the VLookup function searches for value in the left-most column of table_array and returns the value in the same row based on the index_number.The syntax for the VLookup function is:
VLookup( value, table_array, index_number, not_exact_match )
value is the value to search for in the first column of the table_array.
table_array is two or more columns of data that is sorted in ascending order.
index_number is the column number in table_array from which the matching value must be returned.
The first column is 1.
not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.
MS Excel: HLookup Function
In Excel, the HLookup function searches for value in the top row of table_array and returns the value in the same column based on the index_number.The syntax for the HLookup function is:
HLookup( value, table_array, index_number, not_exact_match )
value is the value to search for in the first row of the table_array.
table_array is two or more rows of data that is sorted in ascending order.
index_number is the row number in table_array from which the matching value must be returned. The first row is 1.
not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the HLookup function will look for the next largest value that is less than value.
