Entering Account Data

You enter account data (historical values, project forecast assumptions, and estimate valuation assumptions) in the Accounts spreadsheet or reports. You customize financial accounts to match financial statements you are analyzing, add account detail, change the order in which accounts display, and select accounts for display in reports. To enter negative values, start the value with a minus sign (-).

Changing Account Names

In Strategic Modeling, financial accounts have standard names. You can modify them to reflect descriptions in your analysis by entering names over those in the Accounts spreadsheet. Name changes appear in all reports.

Data Formats

Strategic Modeling reliably stores and manipulates numbers containing up to 16 significant digits, before and/or after the decimal point. You can change the number of decimal places displayed.

Entering ‘#’ or ‘##’ Overrides

On the Strategic Modeling spreadsheet, you can enter ‘#’ or ‘##’ into a cell to override current values.

Note:

The ‘#’ and ‘##’ overrides are not valid for use within historical time periods unless those periods are calculated using Freeform Formulas.

Overriding Missing Cell Values With Zero

To override missing cell values with zeros during overrides:

1. In Oracle Smart View for Office ensure that you are on the Smart View tab.

2. Click , and then select Data options.

3. From #NoData/Missing Label, select #NumericZero.

4. Select Submit Zero, and then click OK.

Submitting Data

From the Data grouping label, click Submit Data to save the data back to the Strategic Modeling provider.

Note:

You can click Calculate to save the data.

Note:

Data are not permanently saved until the models are checked-in to the database.

Finding and Replacing Data

To use Find and Replace:

1. From any Strategic Modeling view, select the Accounts view.

2. Select Edit, and then Find & Replace.

3. In Search For text, enter a term, which can be words, numbers, or a combination of words and numbers.

4. Select one:

   • Find—Locates the term.

   • Replace With—Locates and replaces the term with another.

5. Under Search, select either:

   • All—Search the entire model.

   • Range—Search part of the model.

6. Optional: Select Match case to make the action case-sensitive.

7. Click OK.

8. Perform an action:

   • Click Replace to replace one instance of the term.

   • Click Replace All to replace all instances of the term.

   • Click Find Next to skip an instance.

   • Click Close.

Deleting Cell Text

To delete notes:

1. Select Accounts.

2. Select cells or accounts containing notes.

3. Select Accounts, then Cell Text, and then Delete.

Protecting Account Input Status

You can change the input status of accounts. Turn OFF accounts that are not in use.

Note:

To maintain accounting integrity, Strategic Modeling does not enable you to turn 6 input accounts off. These accounts are on: Gain on Sale of Assets (1170), Unrealized Tax Benefit of Losses (1620), Excess Marketable Securities (2015), L-T Debt: Excess (2690), Unrealized Benefit of Tax Loss (3242), and Proceeds from Asset Sales (4000).

To write protect accounts:

To turn OFF accounts are not in use or turn ON the account input status:

1. From the Strategic Modeling spreadsheet, select Account Input Status.

2. Select the Accounts tab.

3. Change the input status of accounts:

   • Input enabled

     To enable input, select accounts in the list.

   • Turn OFF accounts

     You can change the input status of an account by not selecting the accounts from the list. However, by doing this, you can turn OFF accounts are not in use.

4. Optional: To find accounts, enter text or numbers to search.

5. Optional: Select Show selected accounts only to view the selected accounts list.

6. Optional: To change historical averages, see Changing the Historical Averages of Accounts.

7. Click OK.

Changing the Historical Averages of Accounts

To change historical averages of accounts:

1. From the Strategic Modeling spreadsheet, select Account Input Status.

2. Select the Historical Average tab.

3. In the Accounts column, locate the account row.

4. In the Historical Average column, select an option for the account row:

   • Default

     The default historical average is taken from the Years for Historical Average setting in Time Periods. That is applied to all accounts in the model, unless overwritten here.

   • All

     Includes all time periods in the model in the historical average.

   • Any number

     There is a number for each time period in the model. Select one, and the historical average includes periods from the beginning up to that number.

5. Click OK.