What is the COUPNUM Function? The COUPNUM Function is a financial function. It helps calculate the number of coupon payments that we will receive from the settlement date of a bond to its maturity date. Formula =COUPNUM(settlement, maturity, frequency, [basis]) The COUPNUM function uses the following arguments: Settlement (required argument) – This is the settlement…
What is the COUPNCD Function? The COUPNCD Function is an Excel financial function. It calculates the number that is the next coupon date after settlement. After purchasing a bond, we can calculate the date when the first coupon payment is due using COUPNCD. Formula =COUPNCD(settlement, maturity, frequency, [basis]) The COUPNCD function uses the following arguments:…
The 5-Hour Rule Used by Bill Gates and Barack Obama Bill Gates, Barack Obama, Jack Ma, Elon Musk, Oprah Winfrey – they are all successful in their respective careers, and they have one thing in common – all of them follow the 5-hour rule. This means allotting one hour per weekday for reading and learning…
The IFS function in Excel is a logical function that returns a value corresponding to the first TRUE condition in a series of logical tests. Introduced in Excel 2016, it simplifies multiple conditional checks compared to nested IF functions. The function’s syntax is =IFS(logical_test1, value1, [logical_test2, value2], …), allowing up to 127 conditions. It is…
Analyst Trifecta eBook – Analytics, Presentation, and Soft Skills Our Analyst Trifecta eBook is free and available for anyone to download as a pdf. Welcome to the official Analyst Trifecta eBook from the Corporate Finance Institute. In this 141-page guide, you will learn industry-leading best practices to stand out from the crowd and become a world-class financial analyst….
Investment Banking Manual Covering accounting fundamentals, valuation, financial modeling, & Excel skills, this 400+ page guide to investment banking is a must-have for new analysts & associates. Welcome to the official investment banking eBook from the Corporate Finance Institute. In this 466-page analyst manual, we walk through all the important skills and the body of…
Comprehensive Trading & Investing eBook From capital markets to trading and technical analysis strategies, CFI’s 115-page trading & investing eBook covers all the major topics a world-class analyst needs to know. Welcome to the official trading eBook from the Corporate Finance Institute. In this 116-page trading manual, we walk through all the important skills and…
What is Breakup Value? Breakup value is the value of a company if its components were to be sold or spun off and operated independently. The breakup value is obtained by taking the total assets of each component and deducting the total liabilities. If the current breakup value exceeds the current market value of the…
What is Deviation Risk Measure? Deviation risk measure is a function that is used to measure financial risk, and it differs from general risk measurements. Risk measurement is primarily used in the finance industry to measure the movement and volatility of an investment. When investing in stocks, options, and other investments, traders are interested in…
Reference Letter Template This reference letter template will help you draft letters to aid colleagues and employees in their job hunt. A reference letter can be a very strong tool when looking for a job. Here is a quick preview of CFI’s reference letter template: Download the Free Template Download CFI’s customizable Word Doc template…
