Main Menu | Budgeting | Process/Review | View Detail
After selecting the View Detail button, the View Account Detail summary of the selected account is displayed as shown below.
The simulation projection results data can be reviewed for detail projected information by type for any account that has application detail data tied to it. The View Detail button will automatically enable when an application account is selected. The button will be disabled when a non-application account is selected.
Export Data
All of this data can be exported to other applications for presentation or other purposes. The file can be exported as a "CSV" (comma separated value) file or to an Excel file. Simply right click anywhere inside the grid area and select one of the two options below:
View Account Summary Info
See the Account Information Tools topic in the Advanced Income Shock/Reinvestment Rates/Assumption Interface chapter for an explanation of this feature.
Simulation Selection
All information displayed is based upon the currently selected budget simulation in the radio box. To switch the view, simply select a different simulation.
Detail by Type
By default (Enable is unchecked) the information displayed is a summation of all the items in the selected account. However, by checking the Enable check box, the resulting remaining balance after runoff and reinvestment information can be displayed by item type (fixed, floating, adjustable.)
The information in the grid is divided into two sections. The left hand side shows the remaining balance after runoff information for the items currently on the books in the account selected as shown in the example above.
Rate - This is the weighted average rate of all the items still active in the given period.
Avg. Balance - This is the average remaining balance after runoff of all the items in the account. This balance takes into account the day a particular instrument's payment is received.
Yield - The yield is the resulting return of all the items based upon the current payments and payment day basis.
Earnings - This is the resulting income from all the items in the given period.
The right hand side shows the system reinvestment information based upon the assumptions the user made.
Reinvestment - This amount is the amount calculated to return the account's balance to the target volume selected by the user. Negative amounts in this column could indicate that the user decided to shrink the account past the normal runoff.
Yield - Is the resulting yield based upon the assumptions determined by the user.
Earnings - This column is the earnings produced from the reinvestment amount given the reinvestment yield.