Developer Videos

Adding a Connection

Overview of how to add a connection to an accounting package with Modano.

Adding a MYOB Advanced Connection

Overview of how to add a connection to MYOB Advanced in Modano.

Adding Budget Variance Analysis

Add 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.

Budget Variance AnalysisGetting Started

Adding Business Units

Walkthrough of how to add another business unit within a business units model using Modano.

Adding Entities

Walkthrough of how to add another entity within an all periods or historical consolidation model using Modano.

Adding Scenario Analysis

Include 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.

Getting Startedscenario analysis

Aggregation Methods

Overview of the different aggregation method structures available within the Modano consolidation content libraries.

All Periods Consolidations Modeling

Overview of the structure and functionality of an all periods consolidation model with Modano's consolidations content libraries.

Annual Forecast Model - Corporate Tax

Development of the corporate taxation forecasts for the Wall Street Promotions annual forecast-only financial model.

Annual Forecast ModelCorporate TaxModano 8

Annual Forecast Model - Debt & Equity

Development of the basic debt and ordinary equity forecasts for the Wall Street Promotions annual forecast-only financial model.

Annual Forecast ModelDebtEquity

Annual Forecast Model - Debtors & Creditors

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 ModelCreditorsDebtors

Annual Forecast Model - Financial Statements

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 ModelFinancial Statements

Annual Forecast Model - Fixed Assets

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 ModelFixed Assets

Annual Forecast Model - Introduction

Introduction and overview of the Modano basic annual forecast model practical learning exercise.

Annual Forecast ModelModano 8

Annual Forecast Model - Learning Exercise

Provides 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

Annual Forecast Model - Other Financial Statement Items

Development of the interest on cash and other balance sheet items forecasts for the Wall Street Promotions annual forecast-only financial model.

Annual Forecast ModelOther Financial Statement Items

Annual Forecast Model - Presentation Outputs

Development of the presentation outputs for the Wall Street Promotions annual forecast-only financial model.

Annual Forecast ModelPresentation Outputs

Annual Forecast Model - Revenue & Expenses

Development of the revenue and expenses forecasts for the Wall Street Promotions annual forecast-only financial model.

Annual Forecast ModelExpensesRevenue

Annual Forecast Model - Summary

Summary, overview and review of the Wall Street Promotions annual forecast-only financial model.

Annual Forecast Model

Automation Fundamentals - Learning Exercise

Provides 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.

automation

Balance Sheet Eliminations

Overview of how to enter balance sheet eliminations within a consolidation model within the Modano consolidation content libraries.

Balance Sheet Report

Overview of the balance sheet report within the Modano content libraries.

Balance Sheet Summary Dashboard

Overview of the balance sheet summary dashboard within the Modano content libraries.

Budget Income Statement Summary Dashboard

Overview of the budget income statement summary dashboard within the Modano content libraries.

Budget Variance Analysis - Budget Creation

Demonstrates the creation of a budget within an historical & forecast financial model using the model forecasts as the initial budget.

Budget CreationBudget Variance Analysis

Budget Variance Analysis - Introduction

Introduction and overview of the Modano budget variance analysis practical learning exercise.

Budget Variance Analysis

Budget Variance Analysis - Learning Exercise

Demonstrates the ongoing comparison of projected performance to budget data using vairance analysis is tabulated and graphic formats.

budgeting

Budget Variance Analysis - Process Overview

Provides a summary of the rolling budgeting & planning process within the budget variance analysis learning exercise.

Budget Variance AnalysisProcess Overview

Budget Variance Analysis - Reforecasting

Provides a simple example of the amendment of forecast assumptions following model roll-forward.

Reforecasting

Budget Variance Analysis - Rolling Forward

Demonstrates the rolling-forward of an historical & forecast budgeting & planning model to allow for newly-available historical data.

Budget Variance AnalysisRoll-ForwardTime Series

Budget Variance Analysis - Updated Data Importation

Demonstrates the importation, mapping and reconciliation of newly-available financial data following model roll-forward.

Budget Variance AnalysisRoll-Forward

Budget Variance Analysis - Variance Analysis

Provides a simple example of the variance analysis process within a rolling budgeting & planning model.

Budget Variance Analysis

Build Your First Financial Model

Build 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.

Getting StartedOne Financial Model

Building a financial model from Xero or QuickBooks using Modano

Demonstrates 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.

budgetingQuickBooksXero

Business Units Modeling Overview

Overview of the key concepts involved in business units modeling within the Modano business units content libraries.

Capital Expenditure

Overview of capital expenditure analysis within a 3-way financial model.

Capital Payables

Overview of capital payables analysis within a 3-way financial model.

Cash Flow Statement Report

Overview of the cash flow statement report within the Modano content libraries.

Cash Flow Statement Summary Dashboard

Overview of the cash flow statement summary dashboard within the Modano content libraries.

Changing Drivers

Overview of the change driver tool within Modano 11.

Chart of Accounts

Overview of chart of accounts options available within the Modano content libraries.

Connecting Business Unit Data

Overview of how to connect your business unit model to your accounting package business unit data using Modano.

Connecting Your Model

Overview of how to connect your model to your accounting package using Modano.

Connections Overview

Overview of connections page and functionality with Modano.

Consolidation Model - Learning Exercise

Provides 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 modelconsolidations

Consolidation Modeling Overview

Overview of the key concepts involved in consolidation modeling within the Modano consolidations content libraries.

Corporate Taxation

Overview of corporate taxation analysis within a 3-way financial model.

Cost of Goods Sold

Overview of cost of goods sold analysis within a 3-way financial model.

Creating Forecasts & Changing Drivers

Creating forecasts within your financial model that reflect your specific business drivers.

Creating Modules - Training Exercise

Provides 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.

creating modules

Pages