Skip to main content
Home
  • Training
    • Financial Modeling Fundamentals
      • Introduction
        • Overview
        • Model Scope
        • Why Apple?
        • Financial Model Components
        • Model Build Process
        • Starting Workbook
      • Financial Statements
        • Overview
        • Opening Balance Sheet
        • Income Statement
        • Cash Flow Statement
        • Balance Sheet
      • Revenue & Expenses
        • Overview
        • Revenue
        • Cost of Goods Sold
        • Operating Expenditure
      • Working Capital
        • Overview
        • Debtors
        • Inventory
        • Creditors
      • Fixed Assets
        • Overview
        • Capital Expenditure
        • Depreciation
        • Written Down Values
      • Debt & Equity
        • Overview
        • Debt
        • Ordinary Equity
      • Corporate Taxation
      • Other Financial Statement Items
        • Overview
        • Interest on Cash
        • Other Revenue & Expenses
        • Other Balance Sheet Items
    • Modano Fundamentals
      • Automation Fundamentals
        • Developer Mode
        • Modular Workbooks
          • Introduction
          • Creating
        • Inserting Modules
          • Revenue Module
          • Operating Expenditure Module
          • Income Statement Module
        • Managing Modules
        • Adding Categories
        • Duplicating Modules
        • Replacing Modules
        • Renaming Modules
        • Inserting Subtotals
        • Extending Time Series
      • Customizing Modules
        • Introduction
        • Module Components
        • Cell Blocks
        • Styles & Formats
        • Category Blocks
        • Entering Values & Formulas
        • Reviewing Module Content
        • Exporting to File
      • Creating Modules
        • Introduction
        • Creating a New Empty Module
        • Specifying Module Properties
        • Choosing a Module Area
        • Choosing a Time Series Module
        • Adding Module Components
          • Assumptions Component
          • Outputs Component
        • Creating a Categories Group
        • Inserting Hyperlinks
        • Outputs Category Block Addition
        • Adding Checks
        • Adding Module Links
        • Reviewing Module Content
        • Version Monitoring
        • Reusing & Sharing
    • Modano Financial Modeling
      • Annual Forecast Model
        • Introduction
          • Model Scope
          • Financial Model Components
          • Model Build Process
          • Assumptions
        • Financial Statements
          • Overview
          • Opening Balance Sheet
          • Balance Sheet
          • Income Statement
          • Cash Flow Statement
        • Revenue & Expenses
          • Overview
          • Revenue
          • Operating Expenditure
          • Other Revenue & Expenses
        • Debtors & Creditors
          • Overview
          • Debtors
          • Creditors
        • Fixed Assets
          • Overview
          • Capital Expenditure
          • Fixed Assets
        • Debt & Equity
          • Overview
          • Debt
          • Ordinary Equity
        • Corporate Taxation
        • Other Financial Statement Items
          • Overview
          • Interest on Cash
          • Other Balance Sheet Items
        • Presentation Outputs
        • Summary
          • Model Review
          • Automation
          • Completed Model
      • Historical & Forecast Model
        • Introduction
          • Model Scope
          • Financial Model Structure
          • Assumptions
        • Dynamic Template Selection
        • Time Series Assumptions
        • Historical Income Statement
          • Source Data
          • Source Row Ranges
          • Import Criteria
          • Accounts Mapping
          • Reconciliation
          • Module Links
        • Historical Balance Sheet
          • Assumptions Import
          • Reconciliation
          • Module Links
        • Forecasts
          • Overview
          • Revenue & Expenses
          • Debtors & Creditors
          • Fixed Assets
          • Debt
          • Ordinary Equity
          • Corporate Taxation
          • Other Financial Statement Items
        • All Periods Financial Statements
          • Income Statement
          • Balance Sheet
          • Cash Flow Statement
        • Presentation Outputs
        • Appendices
          • Income Statement Mapping Summary
          • Balance Sheet Mapping Summary
      • Budget Variance Analysis
        • Introduction
        • Process Overview
        • Budget Creation
        • Rolling Forward
        • Updated Data Importation
        • Reforecasting
        • Variance Analysis
      • Certification
    • Modular Financial Modeling II
      • Cost of Goods Sold
        • Introduction
          • Model Scope
          • Inventory Modeling
          • Build Process
          • Assumptions
        • Financial Statements
          • Overview
          • Opening Balance Sheet
          • Income Statement
          • Balance Sheet
          • Cash Flow Statement
        • Cost of Goods Sold
          • Overview
          • Build Process
        • Inventory
          • Overview
          • Build Process
        • Inventory Payables
          • Overview
          • Build Process
        • Summary
          • Financial Statements Summary Dashboard
          • Completed Model Review
          • Automation
      • Sales Taxes
        • Introduction
          • Model Scope
          • Sales Taxes Modeling
          • Build Process
          • Assumptions
        • Financial Statements
          • Overview
          • Opening Balance Sheet
          • Balance Sheet
          • Cash Flow Statement
        • GST
          • GST Rate
          • Applicable Revenue & Expenses
          • GST Assessments
          • GST Assessment Basis
          • GST Payment Timing
          • Financial Statements Impacts
        • Debtors & Creditors
          • Overview
          • Debtors
          • Creditors
        • Summary
          • Financial Statement Summary Dashboard
          • Completed Model
          • Model Review
          • Automation
      • Corporate Taxation
        • Introduction
          • Model Scope
          • Corporate Taxation Modeling
          • Exercise Process
          • Assumptions
        • Basic Modeling
          • Overview
          • Basic Tax Terminology
          • Tax Expense
          • Permanent Differences
          • Tax Payment Timing
          • Summary
        • Required Model Amendments
          • Overview
          • Opening Balance Sheet
          • Income Statement
          • Balance Sheet
          • Cash Flow Statement
          • Intangibles Capital Expenditure
          • Intangible Assets
          • Tax Assets
        • Detailed Modeling
          • Overview
          • Detailed Corporate Taxation
          • Tax Losses
          • Deferred Tax Terminology
          • Deferred Tax Liabilities
          • Deferred Tax Assets
        • Summary
          • Financial Statements Summary Dashboard
          • Model Review
          • Automation
      • DCF Valuations
        • Introduction
          • Model Scope
          • Valuation Modeling
          • Exercise Process
          • Assumptions
        • Equity DCF Valuation
          • Overview
          • DCF Valuation
          • Time Value of Money
          • Discounting Cash Flows
          • Valuation Dates & Cash Flow Timing
          • Terminal Value
          • Valuation Method
        • Enterprise DCF Valuation
          • Overview
          • DCF Valuation
          • Pre-Tax vs Post-Tax Valuations
        • Summary
          • Completed Model
          • Model Review
      • Scenario Analysis
        • Introduction
          • Model Scope
          • Scenario Analysis Modeling
          • Build Process
          • Assumptions
        • Scenario Manager
        • Incorporating Scenarios
          • Overview
          • Revenue
          • Operating Expenditure
          • Capital Expenditure
        • Adding Scenarios
        • Dashboard Outputs
          • Scenario Summary Dashboard
          • Completed Model
          • Model Review
    • Microsoft Excel
      • Introducing Excel
        • What is Excel?
        • Excel Interface
        • File Formats
        • Editing Cell Content
        • Cut, Copy & Paste
      • Formats & Styles
        • Formats vs. Styles
        • Creating & Applying Styles
        • Copying Formats & Styles
      • Creating Formulas
        • Basic Formula Creation Principles
        • More Advanced Formula Creation Principles
      • Mixing Text & Formula
        • Creating 'Live Sentences'
      • Calculation Modes
        • Introducing Calculation Modes
        • Changing Calculation Modes
      • Auditing Tools
        • Introducing Auditing Tools
        • Tracing Precedents & Dependents
        • Error Checking
      • Grouping & Hiding
        • Grouping vs. Hiding
        • Hiding Rows or Columns
        • Grouping Rows or Columns
        • Benefits of Grouping over Hiding
      • Hyperlinks
        • Introduction to Hyperlinks
        • Inserting Hyperlinks
        • Hyperlink Properties
      • Protection
        • Different Levels of Protection
        • Benefits of Security & Protection
        • Workbook Protection
        • Sheet Protection
      • Data Validation
        • Introduction to Data Validation
        • Applying Data Validation
    • Standardization
      • Mode Selection
      • Choosing a Theme
      • Workbook Structure
        • New Workbook
        • Overview Sheet
        • Inserting Sheets
        • Updating the Table of Contents
      • Styles & Formats
        • Cell Content
        • Cell Purpose
        • Data Alignment
      • Time Series Analysis
        • Time Series Assumptions
        • Time Series Lookups
        • Time Series Sheets
      • Checks
        • Checks Summaries
        • Adding Checks
        • Triggered Checks
      • Workbook Viewing
        • View Levels
        • Save View
    • Review
      • Error Detection
        • Search & Repair Tool
        • Locating Errors
        • Locating Error Source Ranges
      • Formula Analysis
        • Traversing Formulas
        • Viewing Formula Logic
      • Work In Progress
        • WIP Fill Coloring
        • Locating WIP
      • Issues Tracking
        • Issues Register
        • Reporting Issues
        • Opening & Closing Issues
        • Deleting Issues
      • Error Resolution
  • Content Libraries
    • Generic Financial Model
      • Chart of Accounts
      • Time Series
      • Region
      • Variant
        • Separate Assumptions & Outputs
        • Single Component
        • Template
      • Sales Taxes
      • Budgeting & Planning
      • DCF Valuations
      • Scenario Analysis
        • Example Models
        • Including Scenario Analysis
        • Scenario Manager Modules
        • Sensitivity Methods
        • Scenarios Summaries
        • Data Tables
        • Scenarios Within Scenarios
        • Custom Scenarios
      • Strategic Planning
      • Customizing
        • Automated Customizations
        • Manual Customizations
        • Training & Support
      • Example Models
        • Daily Cash Flow
        • Equity Valuation
    • Multi-Business Units
      • Overview
        • Prerequisite Knowledge
        • Example Models
        • Dynamic Templates
        • Sheets & Sections
        • Modules
      • Business Units
        • Adding
        • Naming
        • Classifying
        • Revenue & Expenses
        • Category vs. Total Links
      • Business Units Summary
      • Business Units Categories
      • Business Units EBITDA
      • Customizing
        • Automated Customizations
        • Manual Customizations
        • Training & Support
    • Consolidations
      • Overview
        • General Concepts
        • Structural Options
        • Prerequisite Knowledge
        • Example Models
        • Dynamic Templates
      • Entities Summary
      • Consolidation Types
        • All Periods Consolidation
        • Historical Consolidation
      • Aggregation Methods
        • Categories
        • Totals
        • Reclassification
      • Eliminations
        • Centralized
        • Distributed
      • Multiple Currencies
        • Overview
        • Exchange Rates
        • Financial Statements
      • Multiple Workbooks
        • Creating New
        • Adding & Deleting Entities
      • Customizing
        • Adding & Deleting Entities
        • Inserting Modules
        • Consolidations Model Nuances
        • Manual Customizations
        • Training & Support
    • Funds Management
      • Infrastructure
        • Modano Software
        • Model Theme
        • Workbook Protection
      • Functionality
        • Model Duration
        • Update Historicals
        • Inserting Content
      • Library Content
        • Chart of Accounts
        • Module Areas
        • Income & Fees
        • Working Capital
        • Investments
        • Unitholder Equity
        • Financial Statements
        • Outputs
      • Outputs
        • Performance Summary
        • Financial Statement Summary
        • Classboard
    • Project Appraisal
      • Infrastructure
        • Modano Software
        • Model Theme
        • Workbook Protection
        • Best Practice Modelling
      • Functionality
        • Time Series & Scenarios
        • Insert Categories
        • Modular Structure
      • Module Types
        • Scenario Analysis
        • Assumption Periodicity
        • Single Component Modules
        • Assessment Dashboard
    • Property Feasibility
      • Infrastructure
        • Modano Software
        • Model Theme
        • Workbook Protection
        • Best Practice Modelling
      • Time
      • Inflation
      • Development
        • Stage Information
        • Direct Costs
        • Relative Costs
        • Land Tax
      • Custom
      • Historicals
      • Finance
        • Interest
        • Cash Waterfall
        • Debt
        • Ordinary Equity
        • Dividends
      • Tax
        • GST
        • Corporate Tax
      • Financials
        • Cash Flow Statement
        • Balance Sheet
        • Income Statement
      • LandStamp
      • Checks
      • Dashboard
      • Replacement Modules
      • Additional Modules
        • Common Costs
        • Financial Statements
        • Cash Flow Budget
        • Stage Consolidation
        • Charts
    • Property Planning
      • Infrastructure
        • Modano Software
        • Model Theme
        • Workbook Protection
        • Best Practice Modelling
      • Functionality
        • Model Duration
        • Update Historicals
        • Modular Structure
        • Insert Categories
      • Starting Model Modules
        • Time Series
        • Financial Statements
        • GST
        • Corporate Tax
        • Financials
        • Checks
      • Working With Modules
        • Insert Module
        • Delete Module
        • Duplicate Module
        • Mirror Module
        • Replace Module
      • Property Planning Modules
        • Property Modules
        • Fixed Assets Modules
        • Intangibles Modules
        • Working Capital Modules
        • Capital Modules
        • Sundry Item Modules
        • Financial Statements
        • Valuation Modules
        • Reporting
        • Financial Statement Exports
      • Example Model Build
        • Model Set-Up
        • Operations Development
        • Capital Structure
        • Dashboard Insertion
    • Wealth Planning
      • Infrastructure
        • Modano
        • Best Practice Modelling
        • Workbook Theme
        • Worksheets
      • Model Set-Up
        • Year & Duration
        • Individuals
        • Categories
        • Modules
      • Assumptions
        • Time Series Assumptions
        • Individuals
        • Opening Position
        • Timing & Growth Assumptions
        • Profile Movements
      • Outputs
        • Summary
        • Panel Board
  • Add-In User Guide
    • Overview
      • Accessing
      • Standardize & Review Mode
      • Training & Support
    • Standardization
      • Workbook Structure
        • Accessing
        • New Workbook
        • Base Sheets System
        • Insert Sheet
        • Presentation Sheets
        • Freeform Sheets
        • Update Table of Contents
        • Base Sheets
        • Insert Base Workbook
        • Restructure Workbook
        • Delete Unused Sheets
        • Name Base Sheet
        • Export to Import
        • Model Composition
        • Invalid Sheets List
        • Sheet Properties
      • Styles & Formats
        • Overview
        • Purpose-Based Styles
        • Presentation Styles
        • Using Formats
      • Time Series
        • Time Series Infrastructure
        • Historical & Forecast Period Titles
        • Data & Projections
        • Inserting Time Series Assumptions
        • Managing Time Series Assumptions
        • Time Series Lookup Tables
        • Insertion
        • Removal
        • Update Time Series Columns
      • Forms / Controls
        • Overview
        • Forms / Controls
        • Inserting Controls
        • Insert Controls Dialog Box
        • Main Tab
        • Placement Tab
        • Settings Tab
        • Properties Tab
        • Protection Tab
        • Insert Group Box(es)
        • Insert Button(s)
        • Insert Check Box(es)
        • Insert Option Button(s)
        • Insert List Box(es)
        • Insert Drop Down Box(es)
        • Insert Scroll Bar(s)
        • Insert Spin Button(s)
        • Size Control to Range
      • Checks
        • Adding Checks
        • Deleting Checks
        • Checks Summaries
        • Inserting Checks Modules
        • Updating Checks Summaries
        • Removing Checks Summaries
        • Check Conditional Formatting
    • Review
      • Auditing
        • Traverse Formula
        • View Formula Logic
        • Sketch Formula Logic
        • Shade/Unshade Formulas
        • Trace All Precedents / Dependents
        • Trace All Errors
        • Module Content Report
        • Search and Repair
        • Locate Error Source Ranges
        • Locate Errors
        • Error Values
        • Error Types
        • Locate WIP Ranges
        • Locate Invalid Conditional Formats
        • Locate Invalid Names
        • Audit Cell Content
        • Locate Links
        • Locate Formats
        • Protect Multiple Sheets
        • Unprotect Multiple Sheets
        • Protected Sheets Summary
        • Multi Watch Window
      • Work In Progress
      • Workbook View
        • Zoom Commands
        • Views
        • Best View
        • Compacted View
        • Expanded View
        • Print View
        • Save View
      • Issues Tracking
    • Automation
      • Fundamentals
        • Basic Terminology
        • File Types
        • Project Manager
        • Using vs Creating
        • Development Process
      • Modular Development
        • Introduction
        • Module Areas
        • Modules
        • Module Components
        • Module Component Types
        • Module Links
        • Core Modules
        • Time Series Modules
        • Checks Modules
        • Keys Modules
        • Benefits
      • Modular Workbooks
        • Overview
        • Creating Modular Workbooks
        • Workbook Composition
        • Workbook Contents
        • Workbook Links
        • Workbook Properties
        • Version Control
        • Workbook Protection
        • Open without Modano
        • Unmanage Excel Workbook
        • Sheets
      • Module Areas
        • Overview
        • In-Built Module Areas
        • Adding
        • Ordering
        • Deleting
        • Composition
        • Links
        • Properties
        • Module Areas Libraries
        • Workbook Module Areas
      • Using Modules
        • In-Built Modules
        • Inserting
          • Inserting From Web
          • Insert From File
        • Replacing
        • Duplicating
        • Mirroring
        • Renaming
        • Deleting
        • Linking & Unlinking
          • Overview
          • Project Manager
          • Precedent Links Pane
        • Categories
        • Sub-Totals
        • Time Series Analysis
          • Overview
          • Time Series Module Insertion
          • Shortening & Extending Period Titles
          • Time Series Compatibility
        • Composition
        • Properties
      • Developing Modules
        • Creating
          • Creating a new Empty Module file
          • Creating a New Module file using the New Module Wizard
          • Inserting a new module into the active workbook
          • Inserting a module from an existing file
          • Inserting a new module
        • Ordering
        • Duplicating
        • Mirroring
          • Mirroring Modules
          • Aligning Mirrored Objects
          • Managing Mirrored Modules
        • Module Components
          • Overview
          • Module Component Types
          • Managing Module Components
          • Module Component Properties
          • Capturing Print Settings
        • Sections
        • Cell Blocks
          • Overview
          • Cell Block Shading
          • Creation & Editing
          • Styling
          • Dynamic Text
          • Default Assumptions
          • Reset Assumptions
          • Random Assumptions
        • Categories
          • Overview
          • Categories Groups
          • Inserting Category Blocks
          • Adding Category Blocks
          • Category Block Insertion Formulas
          • Time Series-Based Categories Groups
          • Global List Categories Groups
          • Merging Categories Groups
          • Spinning Off Category Blocks
          • Category Block Totals
          • Categories Layout Sections
        • Sub-Totals
        • Categories Charts
          • Overview
          • Inserting
          • Invalid Charts
        • Lookup Tables
        • Module Links
          • Overview
          • Understanding Module Links
          • Creating Links Between Modules
          • Locating Module Links
          • Module Links Libraries
          • Workbook Module Links
        • Exporting to Module File
        • Editing Module Properties
      • Time Series Analysis
        • Overview
        • Time Series Module Insertion
        • Creating Time Series Modules
        • Adding Period Titles Sets
        • Editing Time Series Assumptions
        • Editing Period Titles Sets
        • Managing Period Titles Sets
        • Automating Time Series Period Titles
        • Move Assumptions
        • Compatibility
      • Multiple Workbooks
        • Overview
        • Linking Workbooks
        • Creating Export Modules
        • Managing Linked Workbooks
      • Module Suites
        • Overview
        • Creating Module Suites
        • Editing Module Suites
        • Properties
        • Module Groups
        • Functionalities
        • Inclusion
      • Content Repositories
        • Web Repositories
          • Overview
          • Creation
          • Uploading Content
          • Accessing from Excel
          • Sharing
        • Local Repositories
      • Freeform Content
        • Overview
        • Freeform Sheets
        • Freeform Formulas
      • Integrations
        • Connections
          • Sharing Connections
        • Live Linking
        • Updating
          • Model Roll Forward
          • Updating Assumptions
    • Tools
      • Content
        • Accessories
          • Partially Transpose Formula
          • Formula Conditional Formatting
          • Increasing Find and Replace
          • Copy Column Widths
          • Insert Rows
          • Insert Columns
          • Multiple Sheet Copy
          • Hide / Show Developer Tab
          • Clear Status Bar
        • Cells
        • Charting
          • Size Chart to Range
          • Copy Chart to Range
          • Locate Invalid Charts
        • Fill Color
        • Font
          • Overview
          • Content Based Font Color
        • Hyperlinks
          • Editing Hyperlinks
          • Custom Hyperlink
          • Cover Sheet Hyperlink
          • Table Of Contents Hyperlink
          • Sheet Top Hyperlink
          • Sheet Left / Right Hyperlinks
          • Update Hyperlink Arrows
          • Checks Hyperlinks
          • Update Checks Hyperlinks
          • Add Custom TOC Hyperlink Entry
          • Manage Custom TOC Hyperlink Entries
          • Follow Hyperlink
        • Keys
          • Inserting & Removing Keys
          • Formats & Styles Key
          • Sheet Naming Key
          • Range Naming Key
        • Logos
          • Workbook Logos
          • Header / Footer Logo
        • Names
          • Name Range
          • Named Formula
          • Manage Module Names
          • Delete Names in Range
          • Implied Names
          • Names List
          • Locate Named Ranges
          • Delete Redundant Names
        • Schematics
          • Dashboard Examples
          • Create Dashboard Template
          • Insert Shape(s)
          • Size Shape to Range
          • Copy Shape to Range
          • Range Stats
        • Validation
      • Finalization
        • Page Setups
          • Applying Page Setups
          • Example
        • Printing & Viewing
          • Sheet Left / Sheet Right Navigation
          • Print Scaling
          • Show Hide Gridlines
          • Repaginate Workbook
          • Print Modano Workbook
          • Hide Sheets
          • Hide Selected Sheets
          • Reset / Remove Panes
          • Reset / Remove Splits
      • Themes
        • Managing Styles
          • Add Modano Styles
          • Remove Modano Styles
          • Remove Non-Modano Styles
          • Apply Modano Theme Fonts
          • Change Theme
        • Managing Colors
          • Add Modano Colors
          • Reset Color Palette
          • Apply Modano Theme Colors
          • Reset Theme Colors
    • Options
      • Options Dialog
        • Theme
        • Styles
        • Number Formats
        • Accessories
        • Auditing
        • Base Sheets
        • Base Workbook
        • Checks
        • Contents
        • Controls
        • Cover Sheet
        • Hyperlinks
        • Logos
        • Names
        • Page Setups
        • Printing / Viewing
        • Ribbon
        • Time Series
        • Modules
        • Import
        • Export
      • Active Workbook Theme
      • Import Theme from Web
      • Workbook Options

Our Company

  • About Us
  • Careers
  • Contact Us

Solutions

  • Budgeting & Planning
  • Cash Flow Forecasting
  • Consolidations
  • Financial Modeling
  • Forecasting
  • Scenario Analysis

Resources

  • Installation
  • Updates
  • System Requirements
  • Help Center
  • FAQs

Connect

Stay up to date with the latest news

Copyright © 2025 Modano Pty Ltd. All rights reserved.
Privacy Statement | Terms of Use | Refund Policy