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

Finance

XNPV

  • May 31, 2023
Definition: The XNPV function in Excel is used to calculate the net present value of a series of cash flows that occur at irregular intervals. Syntax: ==XNPV(rate, values,...
Read More

VDB

  • May 31, 2023
Definition: The VDB function in Excel is used to calculate the depreciation of an asset for a specific period using the variable declining balance method. Syntax: ==VDB(cost, salvage,...
Read More

XIRR

  • May 31, 2023
Definition: The XIRR function in Excel is used to calculate the internal rate of return for a series of cash flows that occur at irregular intervals. Syntax: ==XIRR(values,...
Read More

SYD

  • May 31, 2023
Definition: The SYD function in Excel is used to calculate the depreciation of an asset for a specified period using the sum of the years' digits method. Syntax:...
Read More

TBILLEQ

  • May 31, 2023
Definition: The TBILLEQ function in Excel is used to calculate the bond-equivalent yield for a US Treasury bill. Syntax: ==TBILLEQ(settlement, maturity, discount). Situation: This formula is appropriate in...
Read More

TBILLPRICE

  • May 31, 2023
Definition: The TBILLPRICE function in Excel is used to calculate the price per $100 face value of a US Treasury bill. Syntax: ==TBILLPRICE(settlement, maturity, discount). Situation: This formula...
Read More

TBILLYIELD

  • May 31, 2023
Definition: The TBILLYIELD function in Excel is used to calculate the yield of a US Treasury bill. Syntax: ==TBILLYIELD(settlement, maturity, price). Situation: This formula is appropriate in situations...
Read More

SLN

  • May 31, 2023
Definition: The SLN function in Excel calculates the straight-line depreciation of an asset. Syntax: ==SLN(cost, salvage, life). Situation: This function is appropriate when calculating the depreciation of an...
Read More

NPER

  • May 31, 2023
Definition: NPER is a function that calculates the number of payment periods for a loan or investment. Syntax: =NPER(rate, payment, present_value, [future_value], [type]) Situation: This formula is appropriate...
Read More

NPV

  • May 31, 2023
Definition: NPV is a function that calculates the net present value of a series of cash flows. Syntax: =NPV(rate, value1, [value2], ...) Situation: This formula is appropriate when...
Read More