Function Type: Financial Description: Returns the price per $100 face value for a Treasury bill. Function Structure: =TBILLPRICE(settlement, maturity, discount). settlement – Settlement date of the security. maturity – Maturity date of the security. discount – The discount rate for the security. Example: Still need help with Excel and Google Sheets? Get Instant Expert HelpContinue reading “TBILLPRICE”
Author Archives: googlemo123
TBILLEQ
Function Type: Financial Description: Returns the bond-equivalent yield for a Treasury bill. Function Structure: =TBILLEQ(settlement, maturity, discount). Argument Breakdown: settlement – Settlement date of the security. maturity – Maturity date of the security. discount – Discount rate of the security. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in FiverrContinue reading “TBILLEQ”
SYD
Function Type: Financial Description: Returns the sum-of-years’ digits depreciation of an asset for a specified period. Function Structure: =SYD(cost, salvage, life, per). Argument Breakdown: cost – Initial cost of the asset. salvage – Asset value at the end of the depreciation. life – Periods over which asset is depreciated. per – Period to calculation depreciationContinue reading “SYD”
SLN
Function Type: Financial Description: Returns the straight-line depreciation of an asset for one period. Function Structure: =SLN(cost, salvage, life). Argument Breakdown: cost – Initial cost of asset. salvage – Asset value at the end of the depreciation. life – Periods over which asset is depreciated. Example: Still need help with Excel and Google Sheets? GetContinue reading “SLN”
RECEIVED
Function Type: Financial Description: Returns the amount received at maturity for a fully invested security. Function Structure: =RECEIVED(settlement, maturity, investment, discount, [basis]). Argument Breakdown: settlement – Settlement date of the security. maturity – Maturity date of the security. investment – Amount investment in the security. discount – The security’s discount rate. basis – Day countContinue reading “RECEIVED”
RATE
Function Type: Financial Description: Returns the interest rate per period of an annuity. Function Structure: =RATE(nper, pmt, pv, [fv], [type]). Argument Breakdown: nper – The total number of payment periods. pmt – The payment made each period. pv – The present value, or total value of all loan payments now. fv – The future value,Continue reading “RATE”
PV
Function Type: Financial Description: Returns the present value of an investment. Function Structure: =PV(rate, nper, pmt, [fv], [type]). Argument Breakdown: rate – The interest rate per period. nper – The total number of payment periods. pmt – The payment made each period. fv – A cash balance you want to attain after the last paymentContinue reading “PV”
PRICEMAT
Function Type: Financial Description: Returns the price per $100 face value of a security that pays interest at maturity. Function Structure: =PRICEMAT(settlement, maturity, issue, yld, [basis]). Argument Breakdown: settlement – The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. maturity –Continue reading “PRICEMAT”
PRICEDISC
Function Type: Financial Description: Returns the price per $100 face value of a discounted security. Function Structure: =PRICEDISC(settlement, maturity, discount, redemption, [basis]). Argument Breakdown: settlement – Settlement date of the security. maturity – Maturity date of the security. discount – Discount rate of the security. redemption – Redemption value per $100 face value. basis –Continue reading “PRICEDISC”