Vision Upload Format: CompanyBalanceSheetQ

Vision Portfolio Management Application Layer: Application

| Headstart Applications | 

Application: CompanyBalanceSheetQ

 

Summary:

The CompanyBalanceSheetQ application is used to display the last five fiscal quarters of balance sheet information for a company.

Inputs:

Position Form Id Description 
1  id  Id of the company 

Analysis:

  • The id must reference an existing Company instance.
  • The basic report displays the balance sheet line items as rows and the last five fiscal quarter end dates as columns.

Key Data Feeds:

Related Reports:

Sample Usage:

    Interface ApplicationWS runWith: "CompanyBalanceSheetQ", "DELL" ;

Sample Input:

Enter Security: 
Date:
Currency:

Sample Output:

    DELL COMPUTER CORP COM

    Data As Of: 1/15/1999 --- Currency: United States Dollar

    Quarterly Balance Sheet
      10/97 07/97 04/97 01/97 10/96
               
    ASSETS          
    Current Assets          
       Cash     1,615     1,515     1,442     1,352     1,183
       Accounts Receivables     1,350     1,133       991       903       915
       Inventories       301       273       266       251       216
       Other Current Assets       341       331       280       241       177
       --------  --------  --------  --------  --------
    Total Current Assets     3,607     3,252     2,979     2,747     2,491
               
    Net Plant       301       288       252       235       223
    Other Assets        13        12        12        11        10
               
    Total Assets     3,921     3,552     3,243     2,993     2,724
       ========  ========  ========  ========  ========
               
               
       LIABILITIES AND NET WORTH          
               
    Debt In Cur Liabilities       NA        NA        NA         27         7
    Accounts Payable     1,488     1,285     1,146     1,040       911
    Income Taxes Payable       NA        NA         73         0         6
    Other Current Liabilities       891       778       634       591       544
       --------  --------  --------  --------  --------
    Total Current Liabilities     2,379     2,063     1,853     1,658     1,468
               
    Total Lt Debt        17       NA         18        18        18
    Other Liabilities       267       277       251       232       216
    Def Taxes And ITC         0         0         0         0         0
    Minority Interest         0         0         0         0         0
       --------  --------  --------  --------  --------
    Total Liabilities     2,663     2,340     2,122     1,908     1,702
               
      Preferred Stock        51        85       264       279       171
      Common Equity     1,207     1,127       857       806       851
       --------  --------  --------  --------  --------
    Total Stockholder's Equity     1,258     1,212     1,121     1,085     1,022
               
    Total Liab. + Net Worth     3,921     3,552     3,243     2,993     2,724
       ========  ========  ========  ========  ========