How to use the XNPV function

What is the XNPV function? The XNPV function calculates the net present value for cash flows that may or may […]

How to use the RRI function

What is the RRI function? The RRI function calculates the growth of an investment in percent per period. Table of […]

How to use the VDB function

What is the VDB function? The VDB function calculates the depreciation of an asset for a given period using the […]

How to use the YIELD function

What is the YIELD function? The YIELD function calculates the yield for a security that pays interest. The YIELD function […]

How to use the SYD function

What is the SYD function? The SYD function calculates the yearly asset depreciation of a given year. Table of Contents […]

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. Table of […]

How to use the TBILLYIELD function

What is the TBILLYIELD function? The TBILLYIELD function calculates the yield for a Treasury bill. Table of Contents Introduction Syntax […]