![]() | Standardization Fundamentals - Training ExerciseProvides an understanding of how to use Modano to efficiently create standardized, best practice spreadsheets. |
![]() | Adding Categories (Modano 8)Automatically adding and removing categories in your financial model. |
![]() | Adding Checks (Modano 8)Demonstrates the addition of checks to module components, the updating of checks summaries, and the triggering of error checks. |
![]() | Adding Module Components (Modano 8)Inserting sheets, adding components, assumptions vs. outputs. |
![]() | Adding Module Links (Modano 8)Introduces module links, discussing how they are sourced from module links libraries or other modules and then assigned to rows and category blocks within module components. |
![]() | Annual Forecast Model - Corporate Tax (Modano 8)Development of the corporate taxation forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Debt & Equity (Modano 8)Development of the basic debt and ordinary equity forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Debtors & Creditors (Modano 8)Development of the debtors and creditors forecasts for the Wall Street Promotions annual forecast-only financial model using the debtors days and creditors days forecast method. |
![]() | Annual Forecast Model - Financial Statements (Modano 8)Development of the opening balance sheet, income statement, balance sheet and cash flow statement for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Fixed Assets (Modano 8)Development of the forecast capital expenditure and fixed assets for the Wall Street Promotions annual forecast-only financial model using the straight-line depreciation method. |
![]() | Annual Forecast Model - Introduction (Modano 8)Introduction and overview of the Modano basic annual forecast model practical learning exercise. |
![]() | Annual Forecast Model - Other Financial Statement Items (Modano 8)Development of the interest on cash and other balance sheet items forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Revenue & Expenses (Modano 8)Development of the revenue and expenses forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Summary (Modano 8)Summary, overview and review of the Wall Street Promotions annual forecast-only financial model. |
![]() | Budget Creation (Modano 8)Demonstrates the creation of a budget within an historical & forecast financial model using the model forecasts as the initial budget. |
![]() | Budget Process Overview (Modano 8)Provides a summary of the rolling budgeting & planning process. |
![]() | Budget Variance Analysis (Modano 8)Demonstrates the ongoing comparison of projected performance to budget data using vairance analysis is tabulated and graphic formats. |
![]() | Category Blocks (Modano 8)Explains the purpose of category blocks, how to identify them within module components, addition via formula entry, and categories groups. |
![]() | Cell Blocks (Modano 8)Introducing cell blocks, identifying using cell block shading, creating, editing, understanding. |
![]() | Checks (Modano 8)Demonstrates the use of a centralized automated flag-based checks system when building and maintaining standardized, best practice spreadsheets. |
![]() | Choosing a Module Area (Modano 8)Discusses the importance of choosing an appropriate module area for your module, and how to access and download existing module areas. |
![]() | Choosing a Theme (Modano 8)Choosing or customizing the theme to use for your Modano financial models. |
![]() | Choosing a Theme - Standardize (Modano 8)Demonstrates how to choose a Modano theme for your organization or personal use, using either the Change Theme dialog or Options dialog. |
![]() | Choosing a Time Series Module (Modano 8)Discusses the considerations when choosing a time series module for your module, including compatibility and the benefits of downloading an existing time series module. |
![]() | Creating a Categories Group (Modano 8)Demonstrates the different ways of creating a new categories group and setting its initial properties. |
![]() | Creating a New Empty Module (Modano 8)Introduces the different ways of creating a new module (*.modm) file and the initial content within its workbook. |
![]() | Creating Modules - Introduction (Modano 8)Overview of the module to be created during the Creating Modules learning exercise. |
![]() | Customizing Modules - Introduction (Modano 8)Overview of modular workbook to be customized during the Customizing Modules learning exercise. |
![]() | Duplicating Modules (Modano 8)Creating duplicates of a module within a modular workbook when building financial models with multiple business units, regions, etc. |
![]() | Entering Values & Formulas (Modano 8)Assumptions vs. outputs, automated consistent formulas, editing categories. |
![]() | Exporting to File (Modano 8)Exporting modules from a modular workbook for reuse and sharing. |
![]() | Extending Time Series (Modano 8)Automatic shortening, extending and rolling all time series sheets in your financial model. |
![]() | Historical & Forecast Model - All Periods Financial Statements (Modano 8)Review of the all periods income statement, balance sheet and cash flow statement in the Wall Street Promotions annual historical & forecast financial model and discussion of the relationships between these financial statements and the other areas of the financial model. |
![]() | Historical & Forecast Model - Corporate Taxation (Modano 8)Entry of the corporate taxation forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how corporate taxation flow through the financial model into the all periods financial statements. |
![]() | Historical & Forecast Model - Debt & Ordinary Equity (Modano 8)Entry of the debt and ordinary equity forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how debt and ordinary equity flow through the financial model into the all periods financial statements. |
![]() | Historical & Forecast Model - Debtors & Creditors (Modano 8)Entry of the debtors and creditors forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how debtors and creditors flow through the financial model into the all periods financial statements. |
![]() | Historical & Forecast Model - Financial Model Creation (Modano 8)Development of the annual historical & forecast financial model of Wall Street Promotions including the importation and mapping of historical financial statements data. |
![]() | Historical & Forecast Model - Fixed Assets (Modano 8)Entry of the capital expenditure and fixed assets forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how fixed assets flow through the financial model into the all periods financial statements. |
![]() | Historical & Forecast Model - Historical Financial Statements (Modano 8)Provides an overview of the historical income statement and balance sheet used in an historical & forecast financial model to collect and reconcile historical financial statement data. |
![]() | Historical & Forecast Model - Introduction (Modano 8)Introduction and overview of the Modano basic annual historical & forecast model practical learning exercise. |
![]() | Historical & Forecast Model - Other Financial Statement Items (Modano 8)Entry of the interest on cash and other balance sheet items forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how these other financial statement items flow through the financial model into the all periods financial statements. |
![]() | Historical & Forecast Model - Revenue & Expenses (Modano 8)Entry of the revenue and expenses forecast assumptions for the Wall Street Promotions annual historical & forecast financial model and explanation of how revenue and expenses flow through the financial model into the all periods financial statements. |
![]() | Inserting Hyperlinks (Modano 8)Demonstrates how to insert custom hyperlinks into module components to facilitate quick and easy navigating between the components within a module. |
![]() | Inserting Modules (Modano 8)Inserting modules from file or web. |
![]() | Inserting Subtotals (Modano 8)Automatically inserting and deleting category sub-totals within your financial model. |
![]() | Managing Modules (Modano 8)Introducing the Project Manager as a tool for visualizing, managing and editing the content within a modular financial model. |
![]() | Modano Magic (Modano 8)Provides an overview of the ways in which the Modano financial modeling platform extends Microsoft Excel to include modular content management and sharing. |
![]() | Model Roll-Forward (Modano 8)Demonstrates the rolling-forward of an historical & forecast budgeting & planning model to allow for newly-available historical data. |
![]() | Module Components (Modano 8)Introducing module components, module component ranges, assumptions vs. outputs. |
![]() | Opening & Saving Modules (Modano 8)Opening module (*.modm) files from file or web, versioning, saving. |