Archives: Resources

Financial Modeling Time-Lapse

CFI Financial Modeling Time-Lapse (With Music!) In celebration of the 2018 CFI Financial Modeling Competition and World Championships, we released this financial modeling time-lapse video of a financial model being built in under 2 minutes! We hope you enjoy watching this Excel model being built, set to the music of Les Toreadors. You can register…

Continue reading

Monte Carlo Simulation

What is Monte Carlo Simulation? Monte Carlo Simulation is a statistical method applied in financial modeling where the probability of different outcomes in a problem cannot be simply solved due to the interference of a random variable. The simulation relies on the repetition of random samples to achieve numerical results. It can be used to…

Continue reading

Forecasting Cash Flow

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…

Continue reading

Forecasting Finance (Equity, Debt, Interest)

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…

Continue reading

Types of Financial Models

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…

Continue reading

Top Financial Modeling Courses to Build Real-World Excel Modeling Skills

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…

Continue reading

Monthly Cash Flow Forecast Model

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…

Continue reading

How to Calculate CapEx – Formula

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…

Continue reading

LBO Modeling

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…

Continue reading

National Association of Certified Valuators and Analysts (NACVA)

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…

Continue reading
0 search results for ‘