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. [. . . ] 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. 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. 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. 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. Cash Flow Analyzer utilizes a unique and efficient calculation methodology. When an Excel spreadsheet is filled with many complex formulas, the Excel calculation time increases dramatically. To maximize efficiency, the Cash Flow Analyzer calculation engine uses the Instrument Calculation Settings section in coordination with the Cash Flow Calculation and Variable Sections to update the cash flow calculations, by processing each instrument in the Variable Section sequentially through the Master Calculation Section. The results of the calculations ­ not the formulas ­ are then saved to the database. [. . . ] Choose Utilities from the Plan menu or Treeview and select the appropriate import utility. You may have more than one utility if you are pulling instrument data from more than one outside system. (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. [. . . ]