User manual BUSINESS OBJECTS PLANNING 10.8 CASH FLOW ANALYZER RESOURCE GUIDE

[. . . ] BusinessObjects Cash Flow Analyzer Resource Guide Business Objects Planning 10. 8 Patents Business Objects owns the following U. S. patents, which may cover products that are offered and sold by Business Objects: 5, 555, 403, 6, 247, 008 B1, 6, 578, 027 B2, 6, 490, 593 and 6, 289, 352. Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] The Calculation Engine has two main sections; the Instrument Calculation Section and the Cash Flow Calculation Section. Additionally, there are two control buttons at the top of 12 BusinessObjects Cash Flow Analyzer Resource Guide The Cash Flow Analyzer Workbook the Calculation Engine. The following screenshot shows an example system with various sections labeled. Figure 2-2 Calculation Engine of the Report Sheet Control Buttons Instrument Detail Row Instrument Calculation Section Cash Flow Calculation Section Control Buttons The Report Sheet has two control buttons: Calculate Cash Flows and Calculate Current Row. Clicking the Calculate Cash Flows button repopulates the Variable Section from the InstrumentDetail data source based on the cost center selected on the Setup Sheet. Cash Flow Analyzer processes each item in the Variable Section through the Calculation Engine. The Output Sheet is cleared of any data that was previously processed, and then the newly processed cash flow records are posted to the Output Sheet for further analysis or to be saved back to the CashFlow data source. Calculate Current Row is used for ad hoc analysis of a specific instrument. If you want to see the cash flow calculations for an individual instrument, go to the Variable Section, place your cursor anywhere on the row (instrument detail record) that you want calculated, and then click the Calculate Current Row but- BusinessObjects Cash Flow Analyzer Resource Guide 13 The Cash Flow Analyzer Workbook ton. The Report Sheet and all the Cash Flow Analyzer calculations are updated. Pressing Calculate Current Row does not update the Output Sheet. Instrument Calculation Section At the top of the Instrument Calculation Section, the yellow-shaded row displays the information for the current item (Instrument Information Row). The example screenshot shows the system that the record was generated from, the item number (customer account number), the cost center, interest rate, etc. Underneath the Instrument Information Row are a series of rows used to calculate information about the instrument. This section is used as a basis for the principal and interest calculations depending on the current type of instrument being calculated. It has different sections for deposit instruments, loans, etc. This section is configured to your specific needs depending on the types of instruments in your InstrumentDetail data source. It contains the necessary field values and parameters used to calculate the cash flows. This section can be expanded or altered based on your needs and the incoming instrument detail. Please contact Support if you feel alterations are necessary in this area. Cash Flow Calculation Section This section displays the results of the cash flow calculations for the current instrument, based on the parameters of the Instrument Calculation Section. The cash flows are categorized by data type. Additional cash flow calculations / data types are often hidden on the Report Sheet for clarity, but the results are saved to the database and/or displayed on the Output Sheet. [. . . ] (You may also have these utilities scheduled for automated execution using Scheduler. ) Once you are done importing the data, open the Cash Flow Analyzer by choosing Cash Flow Analyzer from the Plan menu or Treeview. When you enter Cash Flow Analyzer, you may be prompted to perform a recalculation and/or to update the summary fields. These prompts typically mean that something has been changed in Dimensions, Global Assumptions or Custom Tables. Unless a change was made to your account dimension, most likely you do not need to perform the recalculation or the summary field update before using Cash Flow Analyzer. [. . . ]