[go: up one dir, main page]
Scribd
Upload
170 views1 page

Financial Model Audit with Macabacus

This document provides guidelines and tips for auditing financial models using the Macabacus software, including exploring the model structure using the Explorer pane, using autoformatting and visualization tools like AutoColor, Functional Map, and Magnitude Map to identify errors and anomalies, checking formulas and values across rows and columns, and using keyboard shortcuts to cycle numbers, colors, and visualizations.

Uploaded by

Kayerinna Pardosi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
170 views1 page

Financial Model Audit with Macabacus

This document provides guidelines and tips for auditing financial models using the Macabacus software, including exploring the model structure using the Explorer pane, using autoformatting and visualization tools like AutoColor, Functional Map, and Magnitude Map to identify errors and anomalies, checking formulas and values across rows and columns, and using keyboard shortcuts to cycle numbers, colors, and visualizations.

Uploaded by

Kayerinna Pardosi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Audit a Financial Model with Macabacus

Default Macabacus formatting shortcuts are shown below.

Auditing Guidelines
• Auditing financial models is critically important. Models are important decision-making tools.
Models must be peer reviewed and error-free to instill confidence in the key stakeholders.

• Use the Explorer Pane in Macabacus to see an inventory of all elements present in a financial model.
This can help you locate Conditional Formats, Hyperlinks, Hidden Sheets & Buried Sheets.

• The AutoColor tools are very effective for formatting as well as auditing financial models.
These tools provide insight into the contents of each cell. They are particularly useful for locating partial inputs.

• The Functional Map categorizes cell contents in a similar fashion to the AutoColor tools.
We recommend running the Functional Map tool to add shading on top of AutoColors.

• Use the Dependency Density tool to confirm that every model input has at lease one dependency.
The density of dependencies across horizontally adjacent cells should usually be consistent in financial models.

• The Magnitude Map tool can also be very helpful on schedules containing financial model inputs.
This tool helps to identify positive and negative numbers, patterns, and anomalies in the model inputs.

• Check one column of the model in detail and verify row differences horizontally from left to right.
Use the Formula Flow tool to evaluate horizontal and vertical consistency in the financial model.
The Uniformulas tool shows the formula in the active cell and selects the area that has formulaic consistency.

View Keystroke Modeling Keystroke


Maximize View CTRL ALT SHIFT W Fast Fill Right CTRL SHIFT R
Zoom Out / In CTRL ALT -/= Fast Fill Down CTRL SHIFT D
Toggle Gridlines CTRL ALT G Flip Sign CTRL SHIFT N

Auditing Keystroke Autocolor Keystroke


Pro Precedents CTRL SHIFT [ AutoColor Selection CTRL ALT A
Pro Dependents CTRL SHIFT ] AutoColor Sheet CTRL ALT S
Show All Precedents CTRL ALT [ AutoColor Workbook CTRL ALT Q
Show All Dependents CTRL ALT ]
Clear Arrows CTRL ALT \
Uniformulas CTRL Q Colors Keystroke
Row Differences CTRL \ Blue-Black Toggle CTRL ;
Column Differences 1 CTRL SHIFT \ Fill Color Cycle CTRL SHIFT K

Numbers Keystroke Visualizations 2 Keystroke


General Number Cycle CTRL SHIFT 1 Functional Map ALT UVN
Local Currency Cycle CTRL SHIFT 4 Magnitude Map ALT UVG
Percent Cycle CTRL SHIFT 5 Dependency Density ALT UVI
Multiple Cycle CTRL SHIFT 8 Formula Flow ALT UVM
Date Cycle CTRL SHIFT 2 Clear Visualizations ALT UVC
Binary Cycle CTRL SHIFT Y

The Last Audited Cell shortcut should be disabled or reassigned for this to work. ⁽¹ ⁾
Add these shortcuts to the Quick Access Toolbar to improve efficiency. ⁽² ⁾
Our accelerator key has been set to 'U' for these keystrokes.

Audit a Financial Model with Macabacus Page 1 of 1

You might also like