SheetsHow to Use the TBILLEQ Function in Google Sheets to Calculate Treasury Bill Bond-Equivalent Yields
When investing in short-term money market instruments—specifically sovereign Treasury bills (T-bills)—securities are traditionally sold at...
SheetsHow to Use the MIRR Function in Google Sheets to Calculate Modified Internal Rate of Return with Reinvestment Rates
When evaluating capital investment proposals, corporate venture financing, or commercial real estate acquisitions, the standard...
SheetsHow to Use the FVSCHEDULE Function in Google Sheets to Calculate Future Investment Value with Variable Interest Rates
Standard financial forecasting models typically rely on the FV (Future Value) function, which assumes a...
SheetsHow to Use the COUPDAYBS and COUPDAYS Functions in Google Sheets to Calculate Bond Accrual Days
When valuing fixed-income debt securities—such as municipal bonds, corporate debentures, or sovereign treasury notes—settlement rarely...
SheetsHow to Use the NOMINAL and EFFECT Functions in Google Sheets to Calculate Effective Annual Interest Rates
When comparing financial products—such as consumer credit cards, business savings accounts, or corporate bonds—lenders and...
SheetsHow to Use the CUMIPMT and CUMPRINC Functions in Google Sheets to Calculate Cumulative Loan Payments
When modeling amortising mortgages, commercial debt facilities, or capital leases, financial analysts need to understand...
SheetsHow to Use the ACCRINT and ACCRINTM Functions in Google Sheets to Calculate Accrued Interest on Securities
In fixed-income portfolio management, fixed-rate coupon bonds pay interest periodically (annually, semi-annually, or quarterly) across...
SheetsHow to Use the PRICEDISC and DISC Functions in Google Sheets for Discounted Securities
In fixed-income portfolio management and corporate treasury operations, many short-term debt instruments—such as commercial paper,...
SheetsHow to Use the PRICEMAT and YIELDMAT Functions in Google Sheets for Securities Paying Interest at Maturity
Valuing fixed-income securities requires understanding how and when cash flows occur. While many standard corporate...
SheetsHow to Use the INTRATE and RECEIVED Functions in Google Sheets for Fully Invested Securities
While standard bonds distribute periodic coupon interest on a semi-annual or annual basis, many money...
SheetsHow to Use the DURATION and MDURATION Functions in Google Sheets for Bond Sensitivity Analysis
Evaluating interest rate risk in fixed-income investments requires understanding how sensitive a bond portfolio is...
SheetsHow to Use the TBILLPRICE and TBILLYIELD Functions in Google Sheets for Treasury Bill Valuation
Short-term sovereign debt securities, such as US Treasury bills (T-bills), do not pay periodic coupon...
SheetsHow to Use the COUPNCD and COUPNUM Functions in Google Sheets for Bond Coupon Schedules
Fixed-income financial analysis requires calculating exact cash flow dates and coupon payment counts. When managing...
SheetsHow to Use the MDETERM and MINVERSE Functions in Google Sheets for Matrix Operations
Linear algebra and system modelling frequently require computing matrix determinants and matrix inverses. Google Sheets...
SheetsHow to Use the LOGEST Function in Google Sheets for Exponential Trend Fitting and Growth Forecasting
While linear regression assumes that a dependent variable changes by a constant absolute amount for...
SheetsHow to Use the LINEST Function in Google Sheets for Linear Regression and Statistical Modelling
While simple trendlines in Google Sheets charts provide a quick visual approximation of linear relationships,...
SheetsHow to Use the CHISQ.TEST Function in Google Sheets to Test for Independence and Goodness of Fit
When analysing survey demographics, conversion experiments, or medical trial distributions, researchers frequently need to determine...