Depreciation Methods
Effective financial modeling requires a solid grasp of various depreciation methods to accurately forecast asset values and expenses. Mastering these methods is crucial for creating dynamic and accurate financial models that drive informed decision-making. Here are key types of depreciation calculations you should know.Why is Working Capital Important?
Working capital is a key indicator of a company’s financial health and operational efficiency. It represents the difference between a company’s current assets and current liabilities. Managing working capital effectively ensures a company can meet its short-term obligations and invest in its growth.How to Customize the Quick Access Toolbar in Excel
Will you spend 15 minutes to save hours of unnecessary work this year? Whether you’re an experienced financial modeler or new to Excel, this tutorial is for everyone. FMI’s Executive Director, Ian Schnoor, will guide you through an 8-step process to instantly increase your speed and efficiency in Excel. No third-party add-ins required. This approach uses built-in Excel features that can significantly improve your work.Custom Number Formatting in Excel
In this video Ian Schnoor, FMI’s Executive Director, explores how to customize number formatting in Excel, helping you present financial data clearly and efficiently. These techniques will streamline your workflow and improve data presentation. Watch now for practical Excel formatting tips that enhance your financial models.Excel’s Watch Window
The best Excel tip you've never heard of. Try Excel’s Watch Window explained by FMI’s Executive Director, Ian Schnoor, CFA, CFM, and use it to monitor how changes to your assumptions impact key metrics like KPIs.How to Create a Scenario Switch in Excel?
In financial modeling, switching mechanisms are used to toggle between different assumptions, scenarios, or outcomes. In this video, FMI’s Executive Director, Ian Schnoor, CFA, CFM, explains how to make models more dynamic and flexible for analysis and decision-making using switching mechanisms.Scenario Manager Excel
Managing scenarios is a key skill for any advanced financial modeler. In this video, Ian Schnoor, FMI’s Executive Director walks through essential techniques to help you build a flexible, clear, and professional scenarios page, whether you're preparing for the AFM exam or improving your day-to-day modeling.How to Find Hardcoded Values in Excel
Are dead inputs and hardcoded values sneaking into your financial models? Dead inputs and hardcoded values can ruin a model. In this video, Ian Schnoor, FMI’s Executive Director, explains why it is essential to check your financial model for dead inputs and hard coded values.How to Review a Financial Model
Have you ever reviewed a financial model that contains errors? Most people have. The reality is that many models contain errors. This Guide will help you check and review a financial model to ensure that it is accurate. Together these tips are a powerful suite of options to help find errors in a model.Purpose of an Executive Summary
The executive summary is your opportunity to present your findings clearly and succinctly. It should be tailored to your audience and reflect the unique aspects of the project, industry, or decision-making scenario the model supports. Learn why executive summaries are so important and what you should consider when building one.
