Financial functions
The XNPV function calculates the net present value for cash flows that may or may not be periodic. Net present […]
What is the RRI function? The RRI function calculates the growth of an investment in percent per period. What is […]
What is the VDB function? The VDB function calculates the depreciation of an asset for a given period using the […]
How to use the AMORDEGRC function
What is the AMORDEGRC function? The AMORDEGRC function calculates the depreciation for each accounting period. This function is designed for […]
What is the YIELD function? The YIELD function calculates the yield for a security that pays interest. The YIELD function […]
What is the SYD function? The SYD function calculates the yearly asset depreciation of a given year. What is SYD […]
How to use the TBILLEQ function
What is the TBILLEQ function? The TBILLEQ function calculates the equivalent bond yield for a Treasury bill. It converts the […]
How to use the TBILLPRICE function
What is the TBILLPRICE function? The TBILLPRICE function calculates the par amount (face value) for a Treasury bill. What is […]
How to use the TBILLYIELD function
What is the TBILLYIELD function? The TBILLYIELD function calculates the yield for a Treasury bill. What is the yield of […]