What is a Credit and Collections Analyst? A credit and collections analyst is tasked with the responsibility of assessing a person’s or a company’s riskiness in terms of both extending credit and collecting repayments. The analysts must systematically review a customer’s financial history, financial statements, and any other information that would pertain to receiving a…
What is a Commercial Credit Analyst? A credit analyst is someone who assesses the creditworthiness of a borrower; a commercial credit analyst, specifically, works with business borrowers. Commercial credit analysts underwrite credit based on the strength of the business, including the experience of its management team, any competitive advantages it has, its overall financial health,…
What are the Best Corporate Finance Books? Many corporate finance books are available nowadays, covering various topics from beginner to advanced levels. Finance professionals can access a wide range of resources to learn more about the industry and improve their skills. By reading a book, they can access large volumes of information and research data…
What are Data Tables? Data tables are used in Excel to display a range of outputs given a range of different inputs. They are commonly used in financial modeling and analysis to assess a range of different possibilities for a company, given uncertainty about what will happen in the future. How to Create Excel Data…
Best Excel Books For anyone looking to master the art of financial analysis in MS Excel, these are the most important Excel books to read. In this guide, we’ve compiled the best books and a quick synopsis of the main points they cover. We always recommend additional reading to supplement the Excel training we provide…
What are Investment-Grade Bonds? An investment-grade bond is a bond classification used to denote bonds that carry a relatively low credit risk compared to other bonds. There are three major credit rating agencies (Standard & Poor’s, Moody’s, and Fitch) that provide ratings on bond. Each credit rating agency sets a minimum bond rank to be…
How to Alphabetize in Excel? This guide will show you how to alphabetize in Excel using the Sort and Filter functions to organize your data from A to Z. This feature is particularly useful for large datasets where it would take a very long time to alphabetize information in Excel manually. Before you go on…
How to Count Words in Excel The guide below will teach you how to count words in Excel with step-by-step instructions and screenshots. If you’re a fan of the word counting function in MS Word, you will, unfortunately, be disappointed to know that standard Excel Functions do not have the same feature. There is, however,…
What is Excel Solver? Excel Solver is an optimization tool that can be used to determine how the desired outcome can be achieved by changing the assumptions in a model. It is a type of what-if analysis and is particularly useful when trying to determine the “best” outcome, given a set of more than two…
