What is the Banking Industry Comps Template? The banking industry comps template allows investors to compare one banking company to other ones in the same industry. This method helps to determine the relative value of a particular company. This template looks at JPMorgan Chase & Co, one of the market leaders in the financial industry….
What is the UNICHAR Function? The UNICHAR Functionis categorized under Excel Text functions. UNICHAR gives the user a Unicode character of a specified number, where Unicode is a decimal number from 0 through 65535. The function was introduced in MS Excel 2013. Formula =UNICHAR(number) Where: The number argument is an integer. It is a…
What is the PRICEDISC Function? The PRICEDISC Function is categorized under Excel Financial functions. It will calculate the price of a bond per $100 face value of a discounted security. In financial analysis, PRICEDISC can be useful when we wish to borrow money by selling bonds instead of stocks. If we know the redemption value,…
What is the PRICEMAT Function? The PRICEMAT Function is categorized under Excel FINANCIAL functions. It will calculate the price of a bond that pays interest at maturity, per $100 face value. In financial analysis, the PRICEMAT function can be useful when we wish to borrow money by selling bonds instead of stocks. We need to…
What is the PRICE Function? The PRICE Function is categorized under Excel FINANCIAL functions. It will calculate the price of a bond per $100 face value that pays a periodic interest rate. In financial analysis, the PRICE function can be useful when we wish to borrow money by selling bonds instead of stocks. If we…
What is the PEARSON Function? The PEARSON Function is categorized under Excel Statistical functions. It will calculate the Pearson Product-Moment Correlation Coefficient for two sets of values. For example, we can find out the relationship between the age of a person and the appearance of grey hair. As a financial analyst, the PEARSON function is…
What is the SYD Function (Sum of Years Digits)? The SYD Function is an Excel Financial function. SYD is short for sum of years digits. This function helps in calculating the depreciation of an asset, specifically the sum-of-years’ digits depreciation for a specified period in the lifetime of an asset. Sum-of-years’ digits depreciation is a popular method in…
What are Directional Trading Strategies? Directional trading strategies are strategies that bet on the up or down movement of the market. For example, if an investor believes the market is rising, they would take a long position. On the other hand, if an investor believes the prices will drop, then they will take a short…
Pharmaceutical Industry Comps Template Comparable company analysis, also referred to as comps analysis or just comps, is a relative valuation method. CFI’s pharmaceutical industry comps template provides several companies that can be used to value Roche Holding AG, a company in the pharmaceutical industry. Comparable Company Analysis Comparable company analysis is a valuation method that uses…
Retail Industry Comps Template Comparable company analysis, often referred to as “comps,” is a valuation method that uses financial ratios of similar businesses to value a company. CFI’s retail industry comps template provides a number of comparable companies for Lululemon Athletica Inc. Comparable Company Analysis Comparable company analysis is a commonly used method of valuation. Comps…
