Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Monitor your Companies’ Real-time Updates

Stockholders and investors are now in dilemma of how the US stock Market will behave on the trade policies enforced by the newly-elected US president as he is now starts to put into action his economic approach. With his recent immigration executive order, business professionals are now uncertain on how the will market take such adjustments..

Even multinational companies are experiencing its drastic effects, and is not giving them good results as well. Major US carriers are now significantly declining their stock values due to decreasing travel demand resulted by immigration ban and travel policy tweaks. Many believe that these may eventually result to cancellation of customers shipments and flight tickets which might impact their revenue and cash flows.

Even perplexed by revamped market, executives must still be ready to face these challenges and shall not let things happen without being equipped with the right tools and plans to sustain their business.  With this travel ban policy affecting US airlines, cash availability to support customer refunds must be considered as one of its short-term outcomes. Additionally, income from operations must be carefully monitored and analyze, in order to plan ahead some possible actions to forthcoming events.

Circumstances requiring for immediate solution is fully supported by XBRLAnalyst. Its fundamental metrics and analysis tools are readily available and designed to automatically upload real-time values, giving you an edge to track and save the most updated facts from the market. So lets try and analyze the income and cash status of the affected US airlines:

  • First is to get the CID of the companies you will include in your report. In our example, we included the six major carriers in US  – DAL, AAL, UAL, SKYW, ALK, LUV and JBLU.
  • By using XBRLFact or FINValue functions, get each companies financial value for the related metrics with its most recent period filed in SEC by using“XBRLPeriod”.  Here, we will be comparing each company’s share price, income and cash related metrics of their most recent data (2016-Q3).  “Share price” function gives the end of the day trading value from live database of stock market data from all equity markets in US.
  • Apply your report visualization thru pivot and chart, and you will have your reports easily without worrying on data updates. Once you are connected to the system, these functions will automatically update the values with the system’s database and market providers’ data.

For more comprehensive market monitoring analysis,  an Investment  Portfolio Monitor  is available for download from our website. Try and experience our secured tools providing you the most updated and reliable data from the market.

This post first appeared on Financial Models In Excel, please read the originial post: here

Share the post

Monitor your Companies’ Real-time Updates


Subscribe to Financial Models In Excel

Get updates delivered right to your inbox!

Thank you for your subscription