Community Forum

Topic Replies Activity
SB
How to adjust for scrap/ resale value for capital assets by Sonabh Bubna Normal topic
Every capital asset that is bought has a fixed life and generally some resale value at the end of its life. And the...
1 6y
WM
Error checks number of decimals by Winthrop Morgan Normal topic
Can anyone help me avoid having an error check flag a discrepancy of 0.00000001 between two dollar amounts?  My error...
1 6y
TK
Non- Modano specific - Excel to PowerPoint add-in by Tarjei Kirkesaether Normal topic
Hi all, Does anyone have any good recommendations for an easy to use Excel to PowerPoint add-in (which must work with...
0 6y
TK
Split Component? by Tarjei Kirkesaether Normal topic
Is there a way of splitting a component? I need to add Categories Layout Section to a section in the middle of a large...
2 6y
NO
Free Form Formulas versus Links Again by Nick Ogle Normal topic
Hello Team, I cannot get away from this ongoing problem. It probably me, but.... I am going around and around in...
2 6y
Ch
How to delete cell block by Chun hoe tan Normal topic
Hi Team, How do you go about deleting a cell block that is currrently referenced to other components within the active...
3 6y
NO
Module Content Report - Partially Linked Module Warning by Nick Ogle Normal topic
Hello Team I am running simultaneously as AS IS and Target Operating Model (TOM) case for 8 companies. Each Company...
1 6y
NO
To Freeform or NOT by Nick Ogle Normal topic
Hi I have built a modular spreadsheet showing the (1) Base case - As Is Cost (ie do nothing) Income Statement (2)...
2 6y
RS
Seasonality Adjustment to Enterprise Value by Ryan Shoemaker Normal topic
Has anyone amended the Enterprise / Equity Value modules to allow for adjustment from ending working capital to average...
1 6y
TK
Split Cell blocks? by Tarjei Kirkesaether Normal topic
Hey Modano team - Would it be possible to add another option on the "Cell Blocks" menu to 'split' cell block (in...
1 6y
MB
Standardized Naming Conventions by Monica Butler-Jones 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 6y
WM
How to link Subtotal headings between modules? by Winthrop Morgan Normal topic
Can some kind soul explain to me how I can link subtotal headings between modules?  I've been trying, without success,...
5 6y
To
Positioning of Duplicated Module Components by Tony Chau Normal topic
I have a particular module with many module components: Some of these module components are located on the same...
3 6y
NO
M&A Modelling by Nick Ogle Normal topic
We are considering 2 acquisitions over the next 2 years. The current modelling approach is (1) Value the target...
2 6y
TK
Using the issues register as glossary - workarounds for hyperlink?... by Tarjei Kirkesaether 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 6y
TK
Component Positioning by Tarjei Kirkesaether Normal topic
What are the criteria that must be met for the Positioning section of the module component properties window to be...
2 6y
NO
Consolidated Balance Sheet - Debt and Equity Links by Nick Ogle Normal topic
I have 4 companies, therefore 4 income statements, 4 balance sheets and 4 cashflow statements. Each companies equity...
2 6y
CB
Sensitivity Analysis by Cheyne Buckley Normal topic
Hi I was wondering if the sensitivity analysis capabilities of Modano are in the user manual or a module with it...
1 6y
PR
Sales Channel Split by Peter Rushton 1 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 6y
Split a category so two lines roll up to one by Josh B 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 6y
NO
NOT Scenario Modelling (All cases visible & results side by side... by Nick Ogle Normal topic
The client wishes to see workings for each business case at the same time - i.e. using the efficient datatable...
6 6y
Bi
Budget Income Statement for Quarterly periods by Billy O Dwyer 1 Normal topic
Hi, Do anybody know if there are Budget Income statements for quarterly periods? Regards, Billy    
1 6y
Bi
Aligning Time Series by Billy O Dwyer 1 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 6y
ER
Operating Expenditure - Opex Drivers by Edward Riches Normal topic
Hi Everyone, I am trying to create a operating expenditure drivers module, where opex amounts are calculated as a % of...
4 6y
Link between linked workbooks by Iman Lazuardi Normal topic
Hi, Currently I'm building multiple linked workbooks for a company with many outlets, and I have no problem on linking...
2 6y

Pages

Tags

32-bit64-bitAccruals vs. Cashalert checksAmounts & Growth Ratesannual assumptionsAnnual BudgetAPIAsset RevaluationsAsset Salesassumption stylesATPauditingauto-recoverAutoSavebackupBalance SheetBeginnerbowtiebudget balance sheetBudget Income Statementbudget variance analysisBusiness UnitsCalendar YearCapexCapital IQCapital structurecareers in modellingCash Flow StatementCash Forecastcash payment delaysCash SweepCategoriescategories within categoriesCategory Blockscategory layout sectionCell BlocksChange Versionchart of accountsChartscircular referencesclassifications Multi Business Unitscluster IDCo-AuthoringCOGSCollaborationcolorsColumn WidthcompatibilityConsolidationsContentContents SheetContra Accountconversion factorcopy and pasteCopy Pastecost of goods soldCover SheetcrashingCreating ModulescreditorsCreditors CategorycustomCustom Formulascustom modulescustom themesDashboardsDataData TablesdatabaseDays TermsDCFdebtdebt interestDebtor Daysdebtorsdenominationdiscussiondividendsdocument management systemsDrop Down Boxesdrop downsDuplicatedynamic textEliminationsEquityerror checksExample ModelsExcel File FormatsExcel PerformanceexportExport Modulesfactoringfailure to openfilteringFinancial Modeling World CupFixed AssetsFontsforecastformulasFreeformfreeform formulasFreeze PanesFund Managementfunds managementGANTTGantt ChartgearingGraphics AccelerationGraphsGridlineshardwareheadingsHide ColumnsHistorical Data MappingHyperlinksImport Assumptionsincome statementInputsInsert ColumnInsert CommentIntercompanyInvalid PrecedentsinventoryIRRkeyslanguagelaptopsLarge FilesLarge WorkbooksLast historical monthLBOLearning & AssessmentlibrariesLinked WorkbookslinksListed companiesLookup TableslookupsM&AMacMacromanufacturingMappingmemoryMemory LimitsMergeMergingMirrormirroringModano XModule As CategoryModule componentsModule Content ReportModule LinksModule Namesmodulesmodules as categoriesMove AssumptionsMulti Business UnitsMulti-Business Unit PerformanceMulti-WindowmultilingualMultiple Periodicitiesmultiple time seriesMultiple WorkbooksNamed Formulasnon-financeOneDriveOptimize ModanoOptimizingother expensesother revenueOther RevenuesOutputsOverview SheetPanel Boardpartially linked modulesperiodicitiespinch pointPowerQueryPrepaid ExpensesPresentationsProject ManagementPropertyProperty FeasibilityProperty Feasibility assumptionsProtected Sheetsrange namesRange Namingrecover filesredundant categoriesRegionsRevenue DebtorsRevenue driversReverse Time SeriesreviewrevolverRibbonrolluprough calculationsSaaSsalaries & wagesScenario AnalysisScenariossearch & repairSeasonalitySensitivitiesSharePointSharingSheet NamesSheet Namingshort term assetshort term liabilitysimple taxsimulationspecificationsStart-Upstylessubtotalstabstaxteam membersTeamsthemestime framestime seriesTime Series AssumptionsTime Series Sheet Columnstime series; monthlyTop 5 Expenses DashboardTotal Row On TopTrackingtracking categoriesTransfer AssumptionstranslationUI Runtime ErrorValuationVariable DriversVariance AnalysisVBAVersion Controlweeklyweekly cash flowsweekly cashflowweekly time seriesWindows 11Windows DefenderWorkbook StructureWorkbook ThemeWorking CapitalXeroXLSBXML metadata write errorYtd
New posts
No new posts
Hot topic with new posts
Hot topic without new posts
Sticky topic
Locked topic
Subscribe to RSS - Community Forum