Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Finance

PDURATION

  • May 31, 2023
Definition: PDURATION is a function that calculates the duration of an investment with a constant periodic payment and a constant interest rate. Syntax: =PDURATION(rate, payment, present_value, [future_value], [type])...
Read More

MIRR

  • May 31, 2023
Definition: MIRR is a function that calculates the modified internal rate of return for a series of periodic cash flows. Syntax: =MIRR(values, finance_rate, reinvest_rate) Situation: This formula is...
Read More

NOMINAL

  • May 31, 2023
Definition: NOMINAL is a function that returns the annual nominal interest rate given the effective rate and the number of compounding periods per year. Syntax: =NOMINAL(effect_rate, npery) Situation:...
Read More

IPMT

  • May 31, 2023
Definition: IPMT is a function that calculates the interest payment for a given period of a loan or investment, assuming periodic, constant payments and a constant interest rate....
Read More

FV

  • May 31, 2023
Definition: FV is a function that returns the future value of an investment. Syntax: =FV(rate, nper, pmt, [pv], [type]) Situation: This formula is suitable when you need to...
Read More

FVSCHEDULE

  • May 31, 2023
Definition: FVSCHEDULE is a function that returns the future value of an initial principal after applying a series of compound interest rates. Syntax: =FVSCHEDULE(principal, schedule) Situation: This formula...
Read More

DURATION

  • May 31, 2023
Definition: DURATION is a function that returns the Macaulay duration of a security, which is a measure of the security's interest rate risk. Syntax: =DURATION(settlement, maturity, coupon, yld,...
Read More

EFFECT

  • May 31, 2023
Definition: EFFECT is a function that returns the effective annual interest rate based on a nominal interest rate and the number of compounding periods per year. Syntax: =EFFECT(nominal_rate,...
Read More

DB

  • May 31, 2023
Definition: DB is a function that returns the depreciation of an asset for a specified period using the fixed-declining balance method. Syntax: =DB(cost, salvage, life, period, [month]) Situation:...
Read More

DDB

  • May 31, 2023
Definition: DDB is a function that returns the depreciation of an asset for a specified period using the double-declining balance method. Syntax: =DDB(cost, salvage, life, period, [factor]) Situation:...
Read More