25.1 Process Manual Revaluation

This topic describes the systematic instructions to process manual revaluation.

1. On Home page, specify SEDXMRTU in the text-box, and click next arrow.

   Manual Revaluation screen is displayed.

   Figure 25-1 Manual Revaluation

   
   
   Description of "Figure 25-1 Manual Revaluation "
   
2. On the Manual Revaluation screen, specify the details as required.

   Click a new icon from the toolbar. The screen is displayed with no value in the fields. To view details of records previously maintained, call on the Summary View screen. The details of all the records maintained is displayed in a tabular format. Highlight the record of your choice and double click it.

   For more information on these fields, refer to the below table.

   Table 25-1 Manual Revaluation- Field Description

   Field	Description
   Branch Code	The system displays the branch code for which you need to perform the adhoc back dated revaluation MTM processing.
   Module code	The system displays the module that supports the back dated revaluation MTM processing.
   Revaluation Date	Specify the revaluation date as a past date. If the date specified is beyond the number of days allowed at the branch parameter level, then there will be no records displayed in the Uploaded Price Details section
   Manual Reval Ref	The system displays a unique reference number generated for each price upload.
   Source System	Specify the source from which the system gets the price details.
   File Name	Specify the name of the file which is to be uploaded.
   Security code	The system displays the security code or instrument for which the back dated revaluation is to be processed.
   Market Price Code	The system displays the market price code maintained at the instrument definition level.
   Last Reval Price	The system displays the old market price or price maintained at the price maintenance level.
   New Reval Price	The system displays the price updated in the upload market price file.
   Price source	The system displays the source from where the price is published/uploaded.
   Status Description	The system displays the status of the file that is uploaded.

3. Click the Upload Price Details button. The system displays the details.

   If the back dated revaluation is not required, then you can delete a specific security price details record by clicking ‘Delete’ button. You can also select the multiple records at a time and delete it.

   If you are ready to update the new reval price to perform the back dated revaluation, then click on the Authorize button to authorize.

4. On the Manual Revaluation screen, click Reval Details.

   Manual revaluation- Reval details is displayed.

   Figure 25-2 Manual revaluation- Reval details

   
   Description of the illustration sedxmrtu_reval_details_tab.jpg
5. On the Reval Details tab, click the Populate button. The system displays the details required.

   For more information on these fields, refer to the below table

   Table 25-2 Reval Tab - Field Descriptions

   Field	Description
   Security code	The system displays the security code or instrument for which the back dated revaluation is to be processed.
   Portfolio Code	Bank Portfolio where the position level revaluation entries are passed.
   Position Reference	Bank Leg Reference number in SE Deal Screen.
   Market Price Code	The system displays the market price code maintained at the instrument definition level.
   Revaluation Date	The system displays the revaluation date.
   Last Reval Price	The system displays the old market price or price maintained at the price maintenance level.
   New Reval Price	The system displays the price updated in the upload market price file.
   Price Quotation	The system displays the absolute price citation.
   Interest Quotation	The system displays the interest quoted.
   Revaluation Level	The system displays the revaluation level which was configured at the branch parameter and portfolio level.
   Unsettled Revaluation	The system displays the revaluation option setup at the portfolio preference, which level of position the back dated revaluation to be processed. This field will display Y when Settled and Unsettled Position Revaluation options are enabled at the portfolio preference. This field will display N when Settled Position option is enabled only at the portfolio preference.
   Face Value	The system displays the price at which the bond is issued at the security definition level.
   Quantity	The system displays the number of bonds purchased at SE deal.
   Book Value	The system displays the value/price at which the deal is purchased.
   Market value	The system displays the new price/value for which the deal quantity is calculated. On clicking the ‘Calculate’ button, the system calculates and updates the revaluation details for the new market price
   Last Revaluation PL	The system displays the revaluation (per unit) posted for the old market price value. Negative sign will be indicated if the Revaluation is in loss.
   Revaluation PL	The system displays the new Revaluation (per unit) value calculated with the new market price.
   Reval Profit	If the back dated revaluation processing is on profit side, then the profit amount/value is displayed in this field. The old Profit value calculated for old price is overwritten.
   Reval Loss	If the back dated revaluation processing is on loss side, then the loss amount/value is displayed in this field. The old Profit value calculated for old price is overwritten.
   Reval Change	The system displays the difference of book value and the new market value.
   MTM Income	If the revaluation is in profit side, the income GL is credited.
   MTM Expense	If the revaluation is in Loss side, the expense GL is debited

   This topic has the following sub-topic:

• Manual Revaluation Processing