Community Forum

Topic Replies Activity
Module Content Report - Partially Linked Module Warning Normal topic
Hello Team I am running simultaneously as AS IS and Target Operating Model (TOM) case for 8 companies. Each Company...
1 7y
To Freeform or NOT Normal topic
Hi I have built a modular spreadsheet showing the (1) Base case - As Is Cost (ie do nothing) Income Statement (2)...
2 7y
Seasonality Adjustment to Enterprise Value Normal topic
Has anyone amended the Enterprise / Equity Value modules to allow for adjustment from ending working capital to average...
1 7y
Split Cell blocks? Normal topic
Hey Modano team - Would it be possible to add another option on the "Cell Blocks" menu to 'split' cell block (in...
1 7y
Standardized Naming Conventions Normal topic
Does anyone know if I can I create my own standardized naming conventions so that the auto prefix tool uses my naming...
1 7y
How to link Subtotal headings between modules? Normal topic
Can some kind soul explain to me how I can link subtotal headings between modules?  I've been trying, without success,...
5 7y
Positioning of Duplicated Module Components Normal topic
I have a particular module with many module components: Some of these module components are located on the same...
3 7y
M&A Modelling Normal topic
We are considering 2 acquisitions over the next 2 years. The current modelling approach is (1) Value the target...
2 7y
Using the issues register as glossary - workarounds for hyperlink?... Normal topic
Are there any workarounds (offset/indirect etc.) to add a hyperlink in a module to a freeform sheet (i.e. the issues...
4 7y
Component Positioning Normal topic
What are the criteria that must be met for the Positioning section of the module component properties window to be...
2 7y
Consolidated Balance Sheet - Debt and Equity Links Normal topic
I have 4 companies, therefore 4 income statements, 4 balance sheets and 4 cashflow statements. Each companies equity...
2 7y
Sensitivity Analysis Normal topic
Hi I was wondering if the sensitivity analysis capabilities of Modano are in the user manual or a module with it...
1 7y
Integrated BI and Modano Model Normal topic
I am thinking of experimenting on building a model that leverages the use of Power Pivot, Power View and Modano by...
3 7y
Sales Channel Split Normal topic
I am looking to take total historical sales and increase them by a YOY growth rate, and then split out the sales to...
8 7y
Split a category so two lines roll up to one Normal topic
I am looking to split a category into two or more parts. Perhaps I am asking too narrow question, let me present the...
4 7y
NOT Scenario Modelling (All cases visible & results side by side... Normal topic
The client wishes to see workings for each business case at the same time - i.e. using the efficient datatable...
6 7y
Budget Income Statement for Quarterly periods Normal topic
Hi, Do anybody know if there are Budget Income statements for quarterly periods? Regards, Billy    
1 7y
Aligning Time Series Normal topic
Hi, I have saved a number of modules which were built using the Monthly time series. I now want to use those modules in...
2 7y
Unprotecting multiple non-freeform sheets Normal topic
Hi Modano I saved the view of my model before sending it to a partner of mine, however he is unable to unprotect...
9 7y
Operating Expenditure - Opex Drivers Normal topic
Hi Everyone, I am trying to create a operating expenditure drivers module, where opex amounts are calculated as a % of...
4 7y
Link between linked workbooks Normal topic
Hi, Currently I'm building multiple linked workbooks for a company with many outlets, and I have no problem on linking...
2 7y
Unlinking categories in mirrored workbook Normal topic
My model contains 5 modules, one is for 'global' assumptions (Global), and the other 4 are mirrored and calculates...
2 7y
Dividend declared and payment without delay Normal topic
Hi all, Trying to have a dividend payment come out in the same month as being declared, meaning I want to set the...
2 7y
To mirror or not to mirror Normal topic
In terms of system usage, how much extra processing power does keeping modules mirrored add? I am in the process of...
1 7y
Dashboard Scoping by James Longden Normal topic
Quick note. Thought I'd drop this into the forum for those with more client-facing roles. The attached file contains a...
0 7y

Pages

Tags

32-bit64-bitalert checksAmounts & Growth RatesAnnual BudgetAnnual OutputsAPIArray FormulasAsset RevaluationsAsset SalesATPauditingauto-recoverbackupBalance Sheetbowtiebudget balance sheetBudget Income Statementbudget variance analysisBusiness UnitsCalendar YearCapexCapital IQCapital structurecareers in modellingCash Flow Statementcash payment delaysCash SweepCategoriescategories within categoriesCategory Blockscategory layout sectionCell BlocksChange Versionchart of accountsChartscircular referencesclassifications Multi Business UnitsClientscluster IDCo-AuthoringCOGSCollaborationcolorsColumn WidthCommunity EditioncompatibilityConsolidationsContentContents Sheetcontrolsconversion factorcopy and pasteCopy Pastecost of goods soldCover SheetcrashingCreating ModulescreditorscustomCustom Formulascustom modulescustom themesDashboardsDataData SourcingData TablesdatabaseDays TermsDCFdebtdebt interestDebtor Daysdebtorsdenominationdividendsdocument management systemsdrop down box bugDuplicatedynamic textEquityerror checksExample ModelsExcel File FormatsExcel PerformanceexportExport Modulesfactoringfailure to openfilteringFinancial Modeling World CupFixed AssetsFontsforecastformulasFreeformfreeform formulasFreeze PanesFund Managementfunds managementGANTTGantt ChartgearingGraphics AccelerationGraphsGridlinesGroupinghardwareheadingsHide ColumnsHistorical Data MappingHyperlinksImport Assumptionsincome statementInputsInsert ColumnInvalid PrecedentsinventoryIRRkeyslaptopsLarge FilesLarge WorkbooksLBOLearning & AssessmentlibrariesLinked WorkbookslinksListed companiesLookup TableslookupsM&AMacMacromanufacturingMappingmemoryMirrormirroringModano XModule componentsModule Content ReportModule LinksModule Namesmodulesmodules as categoriesMove AssumptionsMulti Business UnitsMulti-Business Unit PerformanceMulti-WindowMultiple Periodicitiesmultiple time seriesMultiple Workbooksnon-financeOneDriveOptimizingother expensesother revenueOther Revenuesoutline levelsOutputsOverview SheetPanel Boardpartially linked modulesperiodicitiespinch pointPowerQueryPrepaid ExpensesPresentationsProject ManagementPropertyProperty FeasibilityProperty Feasibility assumptionsProtected SheetsProtectionrange namesRange Namingrecover filesredundant categoriesRegionsRelease Excel Workbookrelease workbookRevenue DebtorsRevenue driversReverse Time Seriesreviewrevolverrolluprough calculationssalaries & wagesScalingScenario AnalysisScenariossearch & repairSeasonalitySensitivitiesSharePointSharingSheet NamesSheet Namingshort term assetshort term liabilitysimple taxspecificationsStart-UpstylessubtotalstabstaxTeamsthemestime framestime seriesTime Series AssumptionsTime Series Sheet Columnstime series; monthlyTop 5 Expenses DashboardTotal Row On TopTrackingtracking categoriesTransfer AssumptionsTraverseValuationVariance AnalysisVBAVersion Controlweeklyweekly cash flowsweekly time seriesWindows 11Windows DefenderWindows UpdatesWorkbook StructureWorkbook ThemeWorking CapitalWorking Capital; Creditors Category; drop down box bugXeroXLSBXML metadata write error
New posts
No new posts
Hot topic with new posts
Hot topic without new posts
Sticky topic
Locked topic
Subscribe to RSS - Community Forum