Learn with our quick and practical microtraining method

No more long on-line courses! Learn the concepts with bite-sized practical lessons, step by step, with detailed explanations of the calculations and in as much detail as you need. This is a part of the concepts that are integrated in a financial model.

Learn how to integrate Revenues, Cogs, Opex and Capex in Financial Statements. You can practice with all the exercises in Excel files we provide you during the course.

Revenues

· How to project Accounts Receivable

· Accounts Receivable in Financial Statements

Cogs (Cost of Goods and Sold)

· Cogs and Inventory in Financial Statements

· How to calculate Days Inventory, inventory End Balance, Days Payable.

· How to project Account Payable Balance and integrate in Financial Statements

Opex (Operating Expenses)

· Opex or SG&A

· Different methods to calculate Opex

Financial modeling is an essential skill for those working in the finance and investment sectors.

Capex (Capital Expenditures)

· Depreciation

General Skills tested in this course

· Command of Excel

· General operation financial modeling knowledge

· Operation integration in Financial statement

These concepts you need to know at entry-level in:

· Investment banking

· Equity research

· Consulting and advisory

· FP&A

· Corporate development

You can become a modeling expert in weeks instead of months with the other courses Financing, Financial Statements, Finance and ratios and Timeline and Structure!