Forecasting Cash Flow in a Financial Model This article on forecasting cash flow is the last part of the four-step financial forecasting model in Excel. Having completed our income statement and balance sheet forecasts, we can now turn to the cash flow statement to complete the four-step forecast modeling framework. By the end of this…
Forecasting Finance: Equity, Debt and Interest This article on forecasting finance is part three of the four-step financial forecasting model in Excel and focuses on how to model equity, debt, and interest. Having completed revenue forecasts down to EBIT for the income statement and operating assets forecast for the balance sheet, we can now move…
Top 10 Types of Financial Models There are many different types of financial models. In this guide, we will outline the top ten most common models used in corporate finance by financial modeling professionals. Here is a list of the ten most common types of financial models: Three-Statement Model Discounted Cash Flow (DCF) Model Merger Model…
What Makes These Financial Modeling Courses So Popular? If you want to learn how to build Excel-based financial models like a financial analyst with the top financial modeling courses, you’re in the right place. The courses below are among the most popular in CFI’s Financial Modeling & Valuation Analyst (FMVA®) Certification — designed to teach…
Monthly Cash Flow Forecast Model With a rolling monthly cash flow forecast, the number of periods in the forecast remains constant (e.g., 12 months, 18 months, etc.). The forecast is rolled forward every time there is a month of historical data to input. Rolling forecasts work best when key cash flow drivers are modeled explicitly…
What is CapEx? CapEx (short for capital expenditures) is the money invested by a company in acquiring, maintaining, or improving fixed assets such as property, buildings, factories, equipment, and technology. CapEx is included in the cash flow statement section of a company’s three financial statements, but it can also be derived from the income statement…
What is LBO Modeling? LBO Modeling is used to value a leveraged buyout (LBO) transaction where a target company is acquired using a significant amount of debt. The use of high leverage increases the potential returns on investors’ equity investments in the long run. An LBO model is usually built in Excel to help investors…
What is the National Association of Certified Valuators and Analysts (NACVA)? The National Association of Certified Valuators and Analysts, typically referred to as NACVA, was established to facilitate the appraisal process for businesses seeking valuation services. NACVA offers a variety of services, one of the most important being certifications for business appraisers. It is particularly…
What is the National Association of Federally-Insured Credit Unions (NAFCU)? The National Association of Federally-Insured Credit Unions (NAFCU) is a membership-based trade organization for credit unions insured by the federal government. In an overall effort to help the credit union industry grow, NAFCU works with its member credit unions, acting as a representative and assistant,…
What is the National Association of Investors Corporation (NAIC)? The National Association of Investors Corporation (NAIC) was first founded in 1951 as the National Association of Investment Clubs. Today, the NAIC conducts its business as BetterInvesting. The NAIC works as a sort of school/think tank. It offers broad investment advice, educational information, and support that…
