Reviewing Reports

By default, reports display account values as currencies—but, you can select alternative value formats. When reviewing reports, you can annotate an analysis, for example, to note how account values are calculated. Or, use Analyze to see how a value is calculated from constituent accounts, and how each affects the input data. You can change input assumptions on reports.

Accessing Reports

To access reports:

1. From the Report grouping label, click Report List.

2. Select a report:

   • Income Statement—Displays period results.

   • Balance Sheet—Reports the financial condition at the end of a period.

   • Funds Flow—Compares total sources of funds to total uses of funds.

   • Cash Flow—Displays the difference between operating and non-operating balances.

   • Indirect Cash Flow—Displays operating, investing, and financing cash flow in an indirect format.

   • Ratios—Displays corporate Profit Performance Ratios, Leverage Ratios, Activity Ratios, Liquidity Ratios, Per-Share Data, Valuation Ratios and Custom Ratios.

   • Debt—Summarizes and details analysis of capital structure and capital cost accounts.

   • FAS95—Provides a direct cash flow statement compliant with FAS 95 guidelines.

   • Executive Summary Report—Summarizes key income statement, balance sheet, cash flow and financial ratio accounts.

   • Statement of Retained Earnings—Reconciles the period-to-period activity in the Retained Earnings account.

   • SVA—Displays period-by-period discounted cash flow and Residual Value used to compute Corporate Value and Shareholder Value.

   • DDM—Displays the same information as the Cash Flows and Shareholder Value report, but uses the discounted equity cash flow method.

   • Economic Profit Report—Displays the discounted value of economic profit and residual value.

   • Custom 1-5—Enables you to design your own reports by inserting or pasting accounts, account notes and text rows and columns.

   • Freestyle Reports enable you to design all report characteristics.

   • Notes—Displays all account notes in an analysis.

   • OLE—Enables you to link or embed objects such as graphics.

Changing Report Formats

Note:

This procedure does not apply to freestyle reports.

To change report formats:

1. Select a Report. See Accessing Reports

2. From the Report grouping label, click Report Formats.

3. On Alternate Formats, select formats:

   • None

     Default—Displays values in currency format.

   • Currency and Growth Rate

     Displays values in growth rates from the prior period. Growth rates for periods under a year are based on the same time period length from the prior period, even if the prior period is a year. For example, if 2004 is modeled in quarters and 2003 as a year, the growth rate for 1st quarter 2004 is based on 4th quarter 2003. The value for 4th quarter 2003 is based on actual number of days.

   • Currency and Common Size

     Displays values in a common-size (percentage) format. This alternative format is only available for the Income Statement, Balance Sheet and Cash Flow Statement. Common-size values are calculated for the Income Statement and Cash Flow Statement based on Sales (v1000) and the Balance Sheet based on Total Assets (v2490).

   • Currency and Growth Rate Over Same Period One Year Ago

     Displays values in growth rates from the same period in the prior year. Growth rates for periods under a year are based on the same time period length from the same period in the prior year. For example, if 2004 is modeled in quarters and 2003 as a year, the growth rate for 1st quarter 2004 is calculated based on the 1st quarter 2003. The value for 1st quarter 2003 is based on actual number of days.

   • Current and Named Scenario

     Displays values for the current scenario and a second scenario select in the Scenarios list. You have options for displaying variances between the two scenarios:

     • Currency

       The currency difference.

     • Percent

       The percentage difference.

     • Both Currency and Percent

       The difference in both currency and percent.

     • None

       Displays accounts only—no variance columns.

4. On Cell text information, select the following:

   • Optional: Select Show Cell Text on Report to retrieve the textual content

   • Optional: Select Show Account Cell Text to retrieve an account information.

   • Optional: Select Show Input Cell Text to retrieve the input information.

   • Optional: Select Show Output Cell Text to retrieve the output information.

5. Optional: Select Suppress Zero Values to display only accounts containing non-zero values.

   Default—Reports hide accounts with zero values.

6. Optional: Select Apply Format to All Reports to apply the format to all reports.

   Without this option, only the currently selected report is modified.

7. Click OK.

Modifying Report Properties

To review or change report properties:

1. Select a Report. See Accessing Reports

2. From the Report grouping label, click Properties.

3. Optional: In Report Name, enter a name.

   Maximum: 20 characters

   Note:

   Standard report headers are generated using this Report Name, along with the Company Name that is entered into the model's summary information dialog.

4. Optional: In Tab Short-name, enter a short name for the report tab.

5. Optional: In Common Size Variable, select an account.

   Displays all accounts as percentages of this account. You must set the report to display using the Currency and Common Size format.

   Note:

   Does not apply to Freestyle Reports.

   Click Find Account to browse.

6. Click OK.

Changing the Display Options for Reports

To review or change report display options:

1. Select a Report. See Accessing Reports

2. Select an account, from the Report spreadsheet.

3. From the Report grouping label, click Display Options.

4. Optional: Select Expand Subaccounts to include all subaccounts when inserting main account.

5. Optional: Select Expand Dimensions to include all dimensions when inserting dimensional accounts.

6. Optional: Select Change Sign to reverse the +/- sign of accounts.

Accessing Notes Reports

To access the Notes Report:

1. Select View, then Reports, and then More Reports.

2. In Report(s) to view, select Notes Report.

3. Click OK.

Adding or Reviewing Notes

To add or review report notes:

1. Select a report.

2. Select an account in the report.

3. Select Accounts, then Account Notes.

4. Optional: To change accounts, select an account from the list.

   Tip:

   To scroll through accounts, click Next and Prev.

5. Optional: In Notes, enter comments for the account.

6. Optional: Select Display on reports to display Notes comments at the bottom of the report.

7. Optional: Select Show only accounts with notes to display only accounts with comments attached in the account list on Account Note.

8. Optional: To delete the comment, click Clear.

9. When you finish, click Exit.

Editing Input Account Values

To edit values using Input:

1. Highlight an account and click the input box.

2. Enter a value and press Enter.

3. Recalculate the model.

Editing Input Account Values

To edit account values using Account Input:

1. Select Accounts, then Account Input.

2. On Account Input, select an account.

3. In the historical and forecast rows, enter changes.

4. Click exit.

5. Recalculate the model.