![]() | Adding a ConnectionOverview of how to add a connection to an accounting package with Modano. |
![]() | Adding a MYOB Advanced ConnectionOverview of how to add a connection to MYOB Advanced in Modano. |
![]() | Adding Budget Variance AnalysisAdd a budget to your financial model, then perform rolling variance analysis. This video provides an overview of the rolling budgeting and planning process, including reforecasting. |
![]() | Adding Business UnitsWalkthrough of how to add another business unit within a business units model using Modano. |
![]() | Adding EntitiesWalkthrough of how to add another entity within an all periods or historical consolidation model using Modano. |
![]() | Adding Scenario AnalysisInclude scalable what-if-analysis in your model for side-by-side case comparisons. Includes inserting a scenario manager and sensitivity assumptions for revenue, cost of goods sold, and operating expenditure. |
![]() | Aggregation MethodsOverview of the different aggregation method structures available within the Modano consolidation content libraries. |
![]() | All Periods Consolidations ModelingOverview of the structure and functionality of an all periods consolidation model with Modano's consolidations content libraries. |
![]() | Annual Forecast Model - Corporate TaxDevelopment of the corporate taxation forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Debt & EquityDevelopment of the basic debt and ordinary equity forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Debtors & CreditorsDevelopment 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 StatementsDevelopment 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 AssetsDevelopment 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 - IntroductionIntroduction and overview of the Modano basic annual forecast model practical learning exercise. |
![]() | Annual Forecast Model - Learning ExerciseProvides an understanding of the key concepts required to build and use a basic annual forecast-only financial model of any business, including revenue & expenses, working capital, fixed assets, debt & equity, corporate taxation and other financial statement items. |
![]() | Annual Forecast Model - Other Financial Statement ItemsDevelopment of the interest on cash and other balance sheet items forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Presentation OutputsDevelopment of the presentation outputs for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - Revenue & ExpensesDevelopment of the revenue and expenses forecasts for the Wall Street Promotions annual forecast-only financial model. |
![]() | Annual Forecast Model - SummarySummary, overview and review of the Wall Street Promotions annual forecast-only financial model. |
![]() | Automation Fundamentals - Learning ExerciseProvides an understanding of how to use Modano to automate spreadsheets using modular spreadsheet development and automating common tasks such as time series extension, historical data importation and categories addition. |
![]() | Balance Sheet EliminationsOverview of how to enter balance sheet eliminations within a consolidation model within the Modano consolidation content libraries. |
![]() | Balance Sheet ReportOverview of the balance sheet report within the Modano content libraries. |
![]() | Balance Sheet Summary DashboardOverview of the balance sheet summary dashboard within the Modano content libraries. |
![]() | Budget Income Statement Summary DashboardOverview of the budget income statement summary dashboard within the Modano content libraries. |
![]() | Budget Variance Analysis - Budget CreationDemonstrates the creation of a budget within an historical & forecast financial model using the model forecasts as the initial budget. |
![]() | Budget Variance Analysis - IntroductionIntroduction and overview of the Modano budget variance analysis practical learning exercise. |
![]() | Budget Variance Analysis - Learning ExerciseDemonstrates the ongoing comparison of projected performance to budget data using vairance analysis is tabulated and graphic formats. |
![]() | Budget Variance Analysis - Process OverviewProvides a summary of the rolling budgeting & planning process within the budget variance analysis learning exercise. |
![]() | Budget Variance Analysis - ReforecastingProvides a simple example of the amendment of forecast assumptions following model roll-forward. |
![]() | Budget Variance Analysis - Rolling ForwardDemonstrates the rolling-forward of an historical & forecast budgeting & planning model to allow for newly-available historical data. |
![]() | Budget Variance Analysis - Updated Data ImportationDemonstrates the importation, mapping and reconciliation of newly-available financial data following model roll-forward. |
![]() | Budget Variance Analysis - Variance AnalysisProvides a simple example of the variance analysis process within a rolling budgeting & planning model. |
![]() | Build Your First Financial ModelBuild your first financial model live linked to Xero, QuickBooks, MYOB or Sage. Start by choosing the most suitable dynamic template, then live link historical data, customize forecasts, and roll forward as new historical data becomes available. |
![]() | Building a financial model from Xero or QuickBooks using ModanoDemonstrates the building of rolling monthly budgeting and planning model using Modano directly from Xero or QuickBooks, which can also be used for strategic planning and transactions. |
![]() | Business Units Modeling OverviewOverview of the key concepts involved in business units modeling within the Modano business units content libraries. |
![]() | Capital ExpenditureOverview of capital expenditure analysis within a 3-way financial model. |
![]() | Capital PayablesOverview of capital payables analysis within a 3-way financial model. |
![]() | Cash Flow Statement ReportOverview of the cash flow statement report within the Modano content libraries. |
![]() | Cash Flow Statement Summary DashboardOverview of the cash flow statement summary dashboard within the Modano content libraries. |
![]() | Changing DriversOverview of the change driver tool within Modano 11. |
![]() | Chart of AccountsOverview of chart of accounts options available within the Modano content libraries. |
![]() | Connecting Business Unit DataOverview of how to connect your business unit model to your accounting package business unit data using Modano. |
![]() | Connecting Your ModelOverview of how to connect your model to your accounting package using Modano. |
![]() | Connections OverviewOverview of connections page and functionality with Modano. |
![]() | Consolidation Model - Learning ExerciseProvides an understanding of the key concepts required to build and use a multi-entity consolidation model, including entity addition, assumptions mapping and reconciling, eliminations, and customization. |
![]() | Consolidation Modeling OverviewOverview of the key concepts involved in consolidation modeling within the Modano consolidations content libraries. |
![]() | Corporate TaxationOverview of corporate taxation analysis within a 3-way financial model. |
![]() | Cost of Goods SoldOverview of cost of goods sold analysis within a 3-way financial model. |
![]() | Creating Forecasts & Changing DriversCreating forecasts within your financial model that reflect your specific business drivers. |
![]() | Creating Modules - Training ExerciseProvides an understanding of how to create a custom standalone module (*.modm) file which will link to other modules when inserted into a modular workbook when reused or shared. |