Question

In what cell is the Rate for PMT function where = PMT (C8, C9, C10, C11, C12)?

Options

• C8

• C9

• C10

• C12

Answer 1

C8

Explanation:

The standard syntax for the PMT financial function in spreadsheet software is =PMT(rate, nper, pv, [fv], [type]). Because rate (the interest rate for the loan or investment) is always required as the very first argument inside the parentheses, it directly maps to the first cell reference provided in your formula. Therefore, in the formula =PMT(C8, C9, C10, C11, C12), the cell C8.