Google スプレッドシート関数

IPMT

Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.

AI で数式を生成 Excel の同じ関数

この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。

構文

IPMT(rate, per, nper, pv, [fv], [type])

The IPMT function calculates the interest portion of a loan or investment payment for a specific period. It assumes that payments are made at regular intervals and the interest rate remains constant throughout the term.

引数

rate必須The interest rate per period.
per必須The period for which you want to find the interest, must be in the range 1 to nper.
nper必須The total number of payment periods in an annuity.
pv必須The present value, or the total amount that a series of future payments is worth now.
fv省略可能The future value or a cash balance you want to attain after the last payment is made.
type省略可能The number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

例

=IPMT(0.05/12, 1, 36, 10000)

結果: -41.67

Calculates the interest for the first month of a $10,000 loan at 5% annual interest over 3 years.

よくある質問

Why is the result of IPMT negative?

The result is negative because it represents a cash outflow (payment) from the borrower's perspective.

IPMT

構文

引数

例

よくある質問

関連する関数

IPMT

構文

引数

例

よくある質問

関連する関数