財務関数
Sheets の財務関数55個。通常の名前、引数、結果で使えます。
| 関数 | 機能 | 構文 |
|---|---|---|
| ACCRINT | 定期利払債の経過利息 | ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) |
| ACCRINTM | 満期時に利息が支払われる債券の経過利息 | ACCRINTM(issue, settlement, rate, par, [basis]) |
| AMORDEGRC | フランス方式の期間ごとの減価償却(逓減) | AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis]) |
| AMORLINC | フランス方式の期間ごとの減価償却(定額) | AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]) |
| COUPDAYBS | 利払期間の開始日から受渡日までの日数 | COUPDAYBS(settlement, maturity, frequency, [basis]) |
| COUPDAYS | 受渡日を含む利払期間の日数 | COUPDAYS(settlement, maturity, frequency, [basis]) |
| COUPDAYSNC | 受渡日から次の利払日までの日数 | COUPDAYSNC(settlement, maturity, frequency, [basis]) |
| COUPNCD | 受渡日後の次の利払日 | COUPNCD(settlement, maturity, frequency, [basis]) |
| COUPNUM | 満期までの利払回数 | COUPNUM(settlement, maturity, frequency, [basis]) |
| COUPPCD | 受渡日前の直前の利払日 | COUPPCD(settlement, maturity, frequency, [basis]) |
| CUMIPMT | 2期間の間に支払う利息の累計 | CUMIPMT(rate, nper, pv, start_period, end_period, type) |
| CUMPRINC | 2期間の間に支払う元金の累計 | CUMPRINC(rate, nper, pv, start_period, end_period, type) |
| DB | 定率法による減価償却費 | DB(cost, salvage, life, period, [month]) |
| DDB | 倍率法による減価償却費 | DDB(cost, salvage, life, period, [factor]) |
| DISC | 証券の割引率 | DISC(settlement, maturity, pr, redemption, [basis]) |
| DOLLARDE | 分数表記のドル価格を小数に変換 | DOLLARDE(fractional_dollar, fraction) |
| DOLLARFR | 小数表記のドル価格を分数に変換 | DOLLARFR(decimal_dollar, fraction) |
| DURATION | 債券のマコーレー・デュレーション | DURATION(settlement, maturity, coupon, yld, frequency, [basis]) |
| EFFECT | 実効年利率 | EFFECT(nominal_rate, npery) |
| FV | 投資の将来価値 | FV(rate, nper, pmt, [pv], [type]) |
| FVSCHEDULE | 変動金利を適用した将来価値 | FVSCHEDULE(principal, schedule) |
| INTRATE | 全額投資された証券の利率 | INTRATE(settlement, maturity, investment, redemption, [basis]) |
| IPMT | 支払額のうち利息分 | IPMT(rate, per, nper, pv, [fv], [type]) |
| IRR | キャッシュフローの内部収益率 | IRR(values, [guess]) |
| ISPMT | 元金均等払いの特定期間の利息 | ISPMT(rate, per, nper, pv) |
| MDURATION | 債券の修正デュレーション | MDURATION(settlement, maturity, coupon, yld, frequency, [basis]) |
| MIRR | 修正内部収益率 | MIRR(values, finance_rate, reinvest_rate) |
| NOMINAL | 名目年利率 | NOMINAL(effect_rate, npery) |
| NPER | 投資の期間数 | NPER(rate, pmt, pv, [fv], [type]) |
| NPV | 定期的なキャッシュフローの正味現在価値 | NPV(rate, value1, [value2, ...]) |
| ODDFPRICE | 最初の期間が半端な債券の価格 | ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) |
| ODDFYIELD | 最初の期間が半端な債券の利回り | ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) |
| ODDLPRICE | 最後の期間が半端な債券の価格 | ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis]) |
| ODDLYIELD | 最後の期間が半端な債券の利回り | ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]) |
| PDURATION | 投資が目標値に達するまでの期間数 | PDURATION(rate, pv, fv) |
| PMT例 | ローンまたは年金の定期支払額 | PMT(rate, nper, pv, [fv], [type]) |
| PPMT | 支払額のうち元金分 | PPMT(rate, per, nper, pv, [fv], [type]) |
| PRICE | 定期利払債の額面 100 ドルあたりの価格 | PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) |
| PRICEDISC | 割引債の額面 100 ドルあたりの価格 | PRICEDISC(settlement, maturity, discount, redemption, [basis]) |
| PRICEMAT | 満期利付債の額面 100 ドルあたりの価格 | PRICEMAT(settlement, maturity, issue, rate, yld, [basis]) |
| PV | 投資の現在価値 | PV(rate, nper, pmt, [fv], [type]) |
| RATE | 年金の期間ごとの利率 | RATE(nper, pmt, pv, [fv], [type], [guess]) |
| RECEIVED | 満期時の受取額 | RECEIVED(settlement, maturity, investment, discount, [basis]) |
| RRI | 投資の成長に対応する利率 | RRI(nper, pv, fv) |
| SLN | 定額法による期間ごとの減価償却費 | SLN(cost, salvage, life) |
| SYD | 級数法による減価償却費 | SYD(cost, salvage, life, per) |
| TBILLEQ | 米国財務省短期証券の債券換算利回り | TBILLEQ(settlement, maturity, discount) |
| TBILLPRICE | 米国財務省短期証券の額面 100 ドルあたりの価格 | TBILLPRICE(settlement, maturity, discount) |
| TBILLYIELD | 米国財務省短期証券の利回り | TBILLYIELD(settlement, maturity, pr) |
| VDB | 期間を指定した倍率法による減価償却費 | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]) |
| XIRR | 日付付きキャッシュフローの内部収益率 | XIRR(values, dates, [guess]) |
| XNPV | 日付付きキャッシュフローの正味現在価値 | XNPV(rate, values, dates) |
| YIELD | 定期利払債の利回り | YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) |
| YIELDDISC | 割引債の年利回り | YIELDDISC(settlement, maturity, pr, redemption, [basis]) |
| YIELDMAT | 満期利付債の年利回り | YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) |