BCM - Upload ResearchWise Financial Model - V7.3.3

BCM - Upload ResearchWise Financial Model - V7.3.3

Understanding ResearchWise Sheet
The ResearchWise sheet is a Microsoft Excel based template provided by ANALEC for uploading the information. This database template contains all the important financial & Static data fields to be uploaded into the system.

There are two different types of ResearchWise sheets:
  1. Industrial ResearchWise sheet contains data fields pertaining to the industrial sector companies (viz. Utilities, Telecommunications, Infrastructure, Pharmaceuticals, and Consumer Goods etc.).
  2. REIT ResearchWise sheet contains data fields pertaining to the Real Estate Investment Trust sector companies (viz. Real Estate etc.).

The ResearchWise sheet is linked to the financial model before the data is uploaded into the central database.

Linking ResearchWise Sheet to Financial Model
In order to upload the financial model data into the central database, the ResearchWise sheet/template must be linked to the financial model built by the user/analyst. The procedure of linking the financial model to the ResearchWise template is outlined below.

1) Open the excel financial model of a company and the respective ResearchWise Sheet. Once the ResearchWise sheet opens, right click on the worksheet name and select ‘Move or Copy…’ option.

2) The pop-up appears on the screen, as shown below. Select the financial model from the “To Book” drop down as the destination to copy the sheet. Select “Create a copy” option and click on OK.

3) The RESEARCHWISE spreadsheet has now been added to the company’s financial model. 
 Note: Please DO NOT change the name of the RESEARCHWISE sheet since the ANALEC Verifier recognizes the RESEARCHWISE sheet by its default name only.

The Static Input Items
The Static Items: The “Static items” are the basic information related to an instrument which does not change on a regular basis. The major sections are
1) Company Static Items
2) Items for Estimates Changes section
3) Items for Key Data section: - Single Data Point Items & CAGR Items
4) Items for Front Page
5) Items for Backpage Financials

Company Static Items: 
The basic company specific Static items needs to be inputted in the ResearchWise sheet. Kindly follow the guideline comments.

Code

Description

Value

Guideline Comments

 

@CODE

Ticker

NLS US

Input the Bloomberg ticker for the stock e.g., "WMT US" for Wal-Mart Stores.

 

@MULT

Multiplier

1000000

The Reporting Multiplier in which the numbers are denominated in the financial model. For e.g., if the financials being entered are in millions then choose the million multiplier. Please note that the system automatically applies the multiplier only where applicable. For e.g., Applied in P&L, BS and CF items and not on ratios or growth items. Allowable values are One, Thousand, Million & Billion

 

@ANALYST

Lead Analyst

Sam.England

The lead Analyst's system/login username for the ANALEC system.

 

@REC

Stock rating

BUY

It is the trading recommendation for the instrument as recommended by the Analyst. Allowable values are BUY, HOLD, SELL, NOT RATED, UNDER REVIEW & SUSPENDED.

@TARGET

Target Price

5.24

The target price for the shares is to be given here

@FREEFLOAT

Free Float

20

The proportion of instrument that is freely available to the investing public i.e. % of shares not with the promoter shareholders. Please enter the free float value as a number. For e.g., if free float is 88.35%, then simply enter 88.35

Items for Estimates Changes section:
This section is for choosing the items that you wish to retrieve under the "Estimates Changes" section on the Front Page of the Company Note. System will compare these numbers with live source (previous data) numbers and populate the Growth/Change Percentage.
1. Enter the code of the item in Column D that you wish to retrieve in the report. For e.g., if you wish to retrieve Sales and estimate changes in "Sales" as the first item, then enter the code for Sales i.e.,"@BBIK0265".
2. Items entered here will appear in the same order in the report. For e.g., if code for Sales is entered against ECItem1 and code for EBIT is entered against ECItem2, the section in the Company Note will have Sales as first item and then EBIT.
3. You need to input at least 1 item and a maximum of 3 items for this section. If you wish to have less items, simply leave them blank here.

Items for Key Data section: - Single Data Point Items & CAGR Items
This section is for choosing the items that you wish to retrieve under the "Key Data" section on the Front Page of the Company Note. There are two kinds of data items within this section in the report:
      a) Single Data Point Items - These are items for which you simply wish to retrieve the value of the first forecast year for e.g., P/BV or Net Debt/Equity. All you need to do is enter the codes of the items you wish to retrieve. For e.g., if you wish to retrieve P/BV then enter "@BBIK0195".
      b) CAGR Items - These are items for which you wish to retrieve the CAGR percentage in the report based on the start/end year defined by you as well as your item selection.
Items entered here i.e., both sections will appear in the same order in the report. You need to input at least 1 item and a maximum of 4 items. You can however choose which items between these two sections you want in any combination for e.g., All 4 Single Data Point Items or All 4 CAGR Items or 2 from each section and so on. Please note the system would automatically remove the extra items from the report, if more than 4 are provided.


Items for Front Page
This section is for choosing the items that you wish to retrieve on the Front Page table of the Company Note. 
Enter the code of the item in Column D that you wish to retrieve in the report. For e.g., if you wish to retrieve "Sales" as the first item, then enter "@BBIK0265". 
Items entered here will appear in the same order in the report. For e.g., if code for Sales is entered against Item 1 and code for EBIT is entered against Item 2, the table in the Company Note will have Sales as first item and then EBIT.
You can choose to have a maximum of 20 items on the Front Page Table, however, if you wish to have less items, simply leave them blank here i.e., if you wish to have 15 items, just enter the code for first 15 items here.
 
Items for Backpage Financials
Here Enter the Start Year and No of years of data to be shown in the back page Financials.

The Forecast Financial Input Items
Financial year & period information: The year (i.e. 2014, 2015, etc.) & period (i.e. FY, 1H, etc.) for which the data is present in the financial model is entered here.

  1. Year: This is an automatic field and does not require any input data. It will change according to the inputs in “Reporting Financial Year”, “Accounts Status” & “Reporting Period” fields.
  2. Reporting Financial Year: Represents the financial year of the reporting period e.g. 2014, 2015, 2016, etc.
  3. Accounts Status: If the data for reporting period is actual, use “A” or if the actual reporting period is being restated, use “R” and if it is for future period, then use “F”.
  4. Reporting Period: Represents the reporting period. Use “FY” for full Year, “1H” for first half or “2H” for second half, “1Q” for first quarter, “2Q” for second quarter “3Q” for third quarter or “4Q” for fourth quarter.
  5. Financial Year End (month): Represents the month of the financial year-end for the company. Use first three letters of the month as a code e.g., “Sep” for company having financial year-end as September.
Forecast Data section of industrial ResearchWise sheet has following sub-sections. 
  1. Section I - Profit & Loss 
  2. Section II - Balance Sheet
  3. Section III - Cash Flow Statement
  4. Section IV - General Information
  5. Section V - Growth Rates
  6. Section VI - Ratios & Per Share Data
  7. Section VII – Berenberg
  8. Section VIII - Aggregated Items
Note down all the data fields of each sections which need to be linked with the ResearchWise sheet. Now link the data fields in the data section to the data fields in the financial model.
Once linking is complete, it is recommended that the user check all the fields of each sections in the financial model to ensure that each data field of the ResearchWise sheet has been appropriately linked to the financial model.

Upload ResearchWise Financial Model
Open the linked Financial model and login to ResearchWise. Under the ANALEC ResearchWise tab, click on Quick Verification dropdown and select the option 'Stepwise Verification' to upload the financial model for the stock.

Verification and Integrity Check
The first step in the verification process asks user to select the forecast source in which numbers will be uploaded. Draft forecast source is analyst specific work area and information uploaded in this source is not visible externally.

Select ‘Draft Forecast Source’ and click ‘Ok’ to proceed to the next stage where system would carry out mandatory error & integrity checks as shown in screenshot below. Information uploaded on Live forecast source is visible to all the ResearchWise users as well as external clients. Therefore, the users are given access to upload their model only to the Draft Source.

Errors and Warnings
Once the integrity checks are complete, all Errors and Warnings associated with the model would appear. 
Errors are the accounting inaccuracies in the financial model that must be rectified before the data is allowed to be uploaded into the Central Database.
Warnings are the accounting inaccuracies in the financial model which are not mandated to rectify before model upload as warnings will not stop the model from uploading into the Central Database.
Click on the ResearchWise Tab to view the error and warnings in a quick view mode.

Press the button ‘Export to worksheet’ to see the details of ‘Errors & Warnings’ and to export them to a separate excel sheet.

Successful Model Upload 
After correction of errors user needs to initiate the process again and need to press the ‘Post Update’ button to upload the numbers into the database. 

As soon as ‘Post Update’ button is clicked, system will display the screen; Data from the selected ResearchWise sheets will be uploaded to database. 

Comparison of data in a ResearchWise Model with data in the Live Source.
If we want to compare the numbers with the Live numbers (the numbers from the report which was published last time and are publically available) already available in the database then click on ‘Compare to Live’. It will show the below screen asking you to insert the Tolerance % for the comparison and the name of the comparison sheet. 
After you click on ‘Show Changes’ it will show a confirmation message and open the comparison sheet in the existing ResearchWise sheet when you click on ‘Close’.



Copyright

This document is the property of ANALEC and its subsidiaries. Under no circumstances, should any of this material be copied, transmitted, forwarded to any individual and/or organization without the explicit approval of the ANALEC and/or any of its Group companies. This information is strictly private and confidential between the ANALEC and their Customers. Any unauthorized distribution of this document is illegal.

© ANALEC. All Rights Reserved 

    • Related Articles

    • Upload ResearchWise Financial Model - V7.3.3

      Understanding ResearchWise Sheet The ResearchWise sheet is a Microsoft Excel based template provided by ANALEC for uploading the information. This database template contains all the important financial & Static data fields to be uploaded into the ...

    • ResearchWise Automatic Update Guide - V7.3.3

      Downloading ResearchWise Update (ANALEC ResearchWise toolbar) Important Note: Please save all your Office documents (Word, Excel, Outlook, PowerPoint), before starting the update. The system will start downloading the new version as soon as you ...

    • Steps to manage country mapping from Research Upload - V7.3.3

      ResearchUpload allows the administrator to add the country mapping in system. To do so, administrator has to follow the subsequent steps: Adding Country Mapping 1. Click on “Manage County” under ResearchUpload after logging into Researchwisewebapps ...

    • Upload word template in the system - V7.3.3

      1. Login to ResearchWise Web Apps -> ResearchFlowSysAdmin and click on ‘Report Type’ option to select a report type. 2. For example, select report type name ‘Company Short Note’ and check the ‘research category description’. 3. Then Go to ‘Research ...

    • Steps To Re-Upload Historical Price For A Stock - V7.3.3

      To re-upload the historical price for a stock, please follow the below steps: 1. Log in to ADBMS and navigate the Instrument subsection under the Instrument section. 2. Search for the instrument for which the historical data needs to be updated and ...