What is a Bermuda Swaption? A Bermuda swaption is an option that offers the buyer the right – but not the obligation – to take part in an interest rate swap on specified dates during the life of the option. Similar to Bermuda options, the Bermuda swaption is so called because the dates for interest…
What is a Synthetic Long Asset? Sometimes referred to as a synthetic long stock, a synthetic long asset is a strategy for options trading that is designed to mimic a long stock position. Traders create a synthetic long asset by purchasing at-the-money (ATM) calls and then selling an equivalent number of ATM puts with the…
What is the SLN Function (Straight Line)? The SLN Function will calculate the depreciation of an asset on a straight-line basis for one period. In financial modeling, the SLN function helps calculate the straight line depreciation of a fixed asset when building a budget. Learn more about various types of depreciation methods. Formula =SLN(cost, salvage,…
What is a Non-Deliverable Forward (NDF)? A non-deliverable forward (NDF) is a straight futures or forward contract, where, much like a non-deliverable swap (NDS), the parties involved establish a settlement between the leading spot rate and the contracted NDF rate. The settlement is made when both parties agree on a notional amount. NDFs are settled…
What is COUNTA (Excel Countif Not Blank)? The COUNTA Function is categorized under Excel Statistical functions. It will calculate the number of cells that are not blank within a given set of values. The COUNTA function is also commonly referred to as the Excel COUNTIF Not Blank formula. As a financial analyst, the COUNTA function…
T Confidence Interval in Excel The T Confidence Interval Function is categorized under Excel Statistical functions. The function calculates the confidence value that can be used to construct the confidence interval for a population mean for a supplied probability and sample size. It is often used in determining the t value for a 95 confidence…
What is the CONFIDENCE.NORM Function? The CONFIDENCE.NORM Function is categorized underExcel Statistical functions. It will use the normal distribution to calculate and return the confidence interval for a population mean. The confidence interval is the range that a population parameter is likely to fall into for a given probability. In financial analysis, the CONFIDENCE.NORM function…
What is the Excel Confidence Interval Function? The CONFIDENCE Function is categorized under Excel Statistical functions. It will use the normal distribution to calculate and return the confidence interval for a population mean. The confidence interval Excel formula can be extremely useful for financial analysis. As a financial analyst, =CONFIDENCE() is helpful in predicting and…
What is the INDIRECT Function? The INDIRECT Function is categorized under Excel Lookup and Reference functions. It will convert a text string into a cell reference. For example, if we type the reference A1 in a formula, Excel will understand that it refers to cell A1. However, if the cell reference given takes the form…
What is the CHOOSE Function? The CHOOSE Function is categorized under Excel Lookup and Reference functions. It will return a value from an array corresponding to the index number provided. The function will return the nth entry in a given list. As a financial analyst, the CHOOSE function is very useful when creating scenarios in…
