The Library is Open!

Hello, Wharton students! Welcome to Lippincott Library and a new academic year. Find us online, chat with us during the day, email us after hours, call us at 215-898-5924 or head up to the second floor of Van Pelt-Dietrich Library and say hello! We’re here to support your research and academic needs. We offer a number of library services to do that.

 

RESEARCH TO GO. Have a question between classes? Visit us in Huntsman Hall! We hold office hours every Monday through Thursday 12:30 – 1:30 in JMHH 251.  Drop in and get quick answers for your job search or research questions.

 

business FAQ

Our Business FAQ is your 24/7 librarian. Search by keyword or concept to find resources on topics such as market research, company financials, analyst reports and more.

DOCUMENT DELIVERY. Available to undergraduate students, MBAs,  PhD candidates and Wharton faculty. Email docdel@wharton.upenn.edu to request articles and book chapters. Include the full citation for the fastest reply.

BUSINESS NEWS. Put away your wallet! Lippincott Library subscribes to major newspapers like the Wall Street Journal, the Financial Times, the New York Times, and many other business periodicals such as the Harvard Business Review and The Economist. You can read them in print in the library or online through several of our databases. You also now have access to WSJ Pro through Factiva. To limit your results to articles from WSJ Pro, click “Search” and then click “Source” below the “Free Text Search” box. Type WSJ Pro in the “Source” search bar and select any WSJ Pro sections of interest.

GROUP STUDY ROOMS.  Have a team project or group presentation?  Reserve a room  for your meeting. We have smaller study rooms for 4-5 people and two larger rooms that accommodate 10-12 people.

YABLON FINANCIAL RESOURCES LAB. Your one-stop-shop for access to Bloomberg and Capital IQ. Yablon is open to Wharton students only whenever Lippincott Library is open, and our librarians are happy to help you with these resources.

WORKSbloomberg120611_2_560HOPS.  On Wednesdays we talk about Bloomberg. Each week we offer Bloomberg training from 3:30 – 4:30 in Yablon Financial Resources Lab. It’s hands-on so be sure to come a few minutes early to create your own Bloomberg account. Register for this and other business workshops here.

 

TEXT BOOKS. We have library copies of textbooks for many Wharton courses on reserve at the Lippincott Services Desk.  Most textbooks can be checked out for three hours and used in the library. Check if we have your textbook in Franklin’s Course Reserves catalog.

cropped-datapointsheader.jpg

DATAPOINTS is Lippincott Library’s blog. Follow us for tips and tricks about library databases, new resources we’ve added to our collection, and more. And follow us on Twitter @LippincottLib for business news, library workshops, and more.

We hope to see you in Lippincott Library soon!

Need a Lyft?: The Market for Ride-Sharing Apps

So you’ve heard about Uber’s latest round of VC funding or Lyft’s expansion into a new city, (or the latest scandal Uber CEO Travis Kalanick has caused), and you want to know more about the market for ride-sharing apps and the companies running them. With 93% of millennials saying they plan to continue using Uber despite the company’s recent bad press, these companies aren’t going anywhere.

Lippincott Library subscribes to databases that offer statistics, information about VC funding, market share, and user demographics for the companies operating in this market. As you search, note that databases often use different terminology to describe this market. Try searching ride-sharingride-hailing, car-sharing, and sharing economy to find information about this market.

PrivCo offers excellent coverage of Uber, Lyft, and other ride-sharing companies. Their company profiles include a company description, company financials, sources of funding, a list of investors, competitors in that market, and news and analysis about the company. While it can be tough to find financial information on startup companies like Uber and Lyft, PrivCo offers relatively comprehensive financial information for each company it profiles. (Note: You will need to set up an account based on your Penn email to access PrivCo.)

eMarketer also provides great coverage of Uber and other ride-sharing companies, offering a variety of statistics, narrative reports, and news stories. From a report on “What Lyft’s Funding, and Uber’s Struggles, Mean for the Sharing Economy” to statistics on why consumers use ride-sharing services or which apps they use most often,  eMarketer is a good resource to use. Try searching Uber,  Lyft, ride sharing, and ride hailing to find more information.

Thomson ONE has some useful analyst reports on Lyft, Uber, and other ride-sharing apps. To find these reports, click “Screening & Analysis” and then “Research”. Search for ride-sharing or ride-hailing in “Title”, or search for sharing in “Title”  and then click the And drop down menu to  add another search row and search Lyft or Uber in “Title/Text”.

If you want to dig into each company’s market share, use Market Share Reporter. Search ride hailing to find statistical tables  including “Ride-Hailing Industry, 2014“, “Ride-Hailing Apps in China“, as well as “Business Travel Transportation, 2014-2015” which includes market share data for Uber and Lyft.

IBIS World has industry reports on “Taxi and Limousine Services in the US” and on “Limousine and Town Car Services” that mention how Uber and Lyft are affecting these industries. You can find these reports by searching Uber, Lyft, and ride-sharing. While ride-sharing companies only comprise an estimated 6% of these markets, 6% of a nearly $11 billion market is nothing to sneeze at.

Mintel Oxygen also offers great coverage of consumer markets and products, including the market for ride-sharing apps. Try searching UberLyft, and ride sharing to find reports on the way ride-sharing apps have affected insurance companies, car rental and travel companies, and driven digital trends and new business models.

Feel free to contact Lippincott’s business research librarians with questions about researching this or any other market or industry!

Hungry for More: Researching the Online Food Delivery Market

how do you order food for deliveryWhen was the last time you used Seamless, Grubhub, or another one of the many online food delivery apps and services available? If you’re anything like me, or the 13% of American consumers who usually order food through a mobile app, it was probably last weekend. If you want to learn more about how these companies are changing the food delivery market, Lippincott Library is a good place to start.

Lippincott Library subscribes to databases that offer a variety of statistics, consumer demographic information, and market research about the online food delivery market. As you search, note that databases often use slightly different terminology to describe this market. Use search terms such as online food delivery, online-to-offline food delivery, online foodservice, and consumer foodservice to find information on this market.

Statista provides a wealth of statistical and narrative information about the online food delivery market. Search online food delivery and online foodservice to find a dossier covering online food delivery services in the US, along with statistics about many aspects of online food delivery. Statistics include which online food delivery company has the biggest market share, which company is most popular with consumers, and even the most common food people order online.

Mintel Oxygen offers market research reports and info-graphics on a variety of consumer services and products, focusing their coverage on the U.S. and the U.K. A quick search will bring you a comprehensive report on The Online Foodservice Consumer.  This report covers barriers to entry, opportunities, and consumer demographics for this market. Search online food delivery to access this report and others related to this market.

Passport GMID offers global coverage of market research and statistics on many consumer services and products, including foodservice. You can use Passport GMID in two ways: 1) to find every publication and statistic about a particular industry or 2) to find any publication or statistic that mentions a specific term. For option 1), go to “Search Full Tree” and drill into “Categories and Topics”. Scroll down to “Economic and Consumer Topics”, and start drilling into the “Digital Consumer” category. For option 2), try searching online food delivery, online foodservice, and consumer foodservice remote purchase to find category briefings, industry overviews, and news stories about this industry.

Thomson ONE  focuses on companythomson one information and includes analyst reports,  several of which cover the online food delivery market. To find these reports, click “Screening & Analysis” and then “Research”. Search for publicly traded companies such as Grubhub or search for keywords, for example, online food delivery in the “Title/Text” search box. Limit your search to industry reports and find coverage of the market as a whole rather than coverage of specific companies in this market.

EMIS provides international coverage of the online food delivery market, including a mix of market research and popular news coverage of this market. Search online food delivery to find comprehensive market research reports such as a recent report on the “Online Food Delivery Market in India 2017” along with news stories like a recent article about halal certification for online food delivery services in the United Arab Emirates.

Our technology industry-focused databases Gartner and Forrester also cover some aspects of this market, like customer experience, digital payment and digital wallet products, and delivery technology such as delivery drones.

I hope this whets your appetite to learn more about this rapidly growing industry. As always, contact Lippincott’s business research librarians with questions about researching this or any other industry!

Passport GMID for Market Entry Strategies

Passport GMID is one of our premier market research databases. Learn how to utilize this tool to its fullest when working to craft a market entry strategy for consumer products. This video will illustrate some of the many ways you can use Passport GMID to inform your decisions. And, feel free to contact the Lippincott librarians for additional assistance with using this great resource.

Eyes in the Sky: Resources to Learn about Drones

Exciting research is happening at Penn’s GRASP Laboratory in the fields of robotics and drones, and the applications of drone technology are being seen in ever-expanding industries. Entrepreneurs on campus, such as Josh Phifer, Vince Kuchar and Nichin Sreekantaswamy, the founders of Barn Owl Systems,  are developing business ideas which include drones, entering business plan competitions and launching businesses. As librarians, we can begin to identify trends based on the number of questions we receive from our students, faculty and staff about specific topics. We can tell you, drones are hot!

You can search databases to which Lippincott Library subscribes to learn more about drones. As you search, note that drones are known by other names. Keywords such as unmanned aerial vehicles, UAV, unmanned aircraft systems, UAS, unmanned combat air vehicles and  UACV are all related to drones.

IBIS World Industry Reports provide broad overviews of industries in the US and China. Here you will find a report for Unmanned Aerial Vehicle (UAV) Manufacturing which outlines industry performance, operating conditions and more.

drones-by-typeIf you are looking for a global perspective on the drone industry, use BCC Research. In this database, you will find more details about the technology of drones and their markets by application, type, subsystem and region. The report, Drone Technology and Global Markets is 111 pages of market information and analysis. In BCC, you will also find reports about the sensors and batteries used in UAVs.

For even more specific market applications of drones, Marketresearch.com Academic has a report titled: Commercial and Military Drones: Technologies, Solutions, Market Outlook, and Forecasts 2016 – 2021. Details about enabling technologies and applications are covered in this 186 page report.

In EMIS, you can access company profiles, research reports and more. One of the market research report providers in EMIS is Technavio which produces country, regional and global reports. In EMIS, search for Technavio and click on Technavio Regional Market Assessment Reports, and then switch to their Global Market Assessment Reports. A search for drone will yield reports such as: Global Commercial Purpose Drone Market, Global Defense Drones Market, Global Civilian Drones Market, and more. A search for unmanned will reveal reports such as:  Global Unmanned Aerial Vehicle Market and Global Unmanned Aerial Vehicle Payload Market. Technavio reports often include a Five Forces Analysis.

Business Source Complete contains trade, academic and news articles which cover unmanned aerial vehicles. Search for words such as: drones OR uav OR unmanned aerial vehicles. From the results you can limit using the filters on the left side of the page. Here, you will find everything from an article with consumer drone ratings in Consumer Reports to video from the Associated Press of drone competitions.

bsc

Our technology focused industry research databases, Gartner, Forrester and IDC also offer some articles about drones.

Beyond the library’s subscription databases, industry associations and governmental websites in this field are also important to consult. The FAA’s Unmanned Aircraft Systems web page links to regulations and resources. The AUVSI is the Association for Unmanned Vehicle Systems International and UAVSA is a subsidiary of the Tesla Foundation Group. Both associations connect people within the industry.

In rapidly changing industries, information is being added to our databases on a regular basis. Contact the Lippincott Librarians, and we will be happy to direct you to resources to assist in your research!

What’s Your Company’s RQ™ (Research Quotient)?

Research and Development (R&D) expenditure is the amount of money a company spends on developing new products and services each year.  Academic business researchers have intensively investigated the relationship between a company’s R&D and its market value, and have searched for ways to derive a firm’s optimal R&D spending.  A recent innovation in the analysis and measurement of a firm’s R&D has been the development of the concept of Research Quotient (RQ).

A company’s Research Quotient is the percentage increase in the company’s revenue from a 1% increase in its R&D. RQ is a measure of a firm’s ability to generate revenue from its R&D expenditures.  RQ is calculated from a formula that combines a company’s measure of capital, labor and R&D. For more details concerning RQ calculation, click on Manuals and Overviews from the WRDS Research Quotient database.

RQ can be used:

  • To Link R&D spending to firm growth
  • Link R&D spending to market value
  • Derive a firm’s optimal R&D spending

The WRDS RQ database includes RQ measures for all companies in the COMPUSTAT database that report R&D expenditures. The data covers 1972 to 2010 and is updated annually.  The file allows searching by 4 digit SIC and by GV Key (COMPUSTAT’s unique company identifier).

Table 1 is an example of the output showing some of the default variables.

TableOne

  • “Raw RQ” is the “Research Quotient” that identifies the ability of a firm to generate revenue from its R&D expenditures. The higher the RQ the greater the revenue generated.
  • “RSTAR” is a calculation of optimal R&D expenditure.
  • “RD Ratio” is the ratio of R&D expenditure to Revenue.

In Table 2, for clarification, I have supplied tickers and names of companies together with a measure of “RQ” that I calculated from the “Raw RQ” supplied by WRDS. This RQ is analogous to the human IQ measure with a mean of 100 and a standard deviation of 15. An RQ with a mean of 100 is often used by academic writers as a way of making the RQ measure more intuitive.

Table 2 ranks the first 20 companies in the U.S. by their RQ in 2010.

Table2improved

There are more than 260 four digit SIC codes represented in the 2010 files, but only 10 codes have more than 35 companies. Table 3 collapses the codes into 2 digits, and ranks the average RQ of the largest 15 industry groups.

Table3Formatted

About 78% of the companies in the 2010 file were based in the U.S.  Figure 1 graphs the countries with 3 or more companies in 2010 by average R&D expenditures and average RQ.

Figure1Formatted

The principal developer of the RQ concept is Anne Marie Knott, Professor of Business at Washington University, St. Louis. In a 2012 article in Harvard Business Review, she estimateds that if the 20 largest US firms had optimized their R&D expenditure in 2010, they would increase their aggregate market capitalization by $1 trillion. (Knott, Anne Marie. “The Trillion-Dollar R&D Fix.” Harvard Business Review (90:5) 2012, pp. 76-82.) This article can be accessed using Business Source Complete.

Wharton Students and Faculty: Lippincott Library has the Business Sources You Need!!

Welcome!!  Lippincott Library provides many resources to help you with all of your business research needs. We can help you to :

  • Prepare successful business plans
  • Prep for interviews
  • Screen for investments
  • Win case competitions
  • Write a research paper
  • Much more

Continue reading

Stock Price Archeology

April often brings us a spate of income tax related questions about the price of a stock on a particular date. The questions are usually from people who want to establish the cost basis of a stock for tax purposes.  Many standard financial databases can supply daily prices (high, low, close and volume) at least for the companies on the New York Stock Exchange as far back as the early 1960’s.

Table 1.

imageONE_cropped

Here are the earliest dates available for daily prices of General Electric Company (GE) on several financial files.

Continue reading

Create Your Own Industry-Specific League Tables

The Lippincott Library has several great resources for finding league tables. However, the majority of these pre-populated league tables are typically geared towards specific geographies and companies rather than industry-specific information. What happens if you would like to look at a league table for a specific industry? You are going to have to construct your own. Fortunately, we have a resource that will enable you to do just that. Continue reading

Exploring EMIS Intelligence

EMIS Intelligence, formerly ISI Emerging Markets, has traditionally been a great resource for exploring emerging markets. Produced by Euromoney Institutional Investor, it aggregates news, reports, statistics and company information from a wide range of providers. While the focus remains primarily on emerging markets, their recent redesign allows researchers to more easily examine world or global markets, as well as giving them the ability to find information on developed markets. While one still has the option to drill into a specific country, choosing a specific country is no longer required, making it easier to search across multiple countries and regions of interest.

Login

The EMIS Intelligence Search page can be somewhat overwhelming because there are so many options to limit and refine your search. This example shows looking for material on armored vehicles, and limiting the results to research reports using the Publication Type filter.

Search1.

Once you have run the search, you can also use the Filter options on the left-hand side of the results page to further limit by country, language and more.  In the example below, two filters,  Country and Publication were used to narrow search results..

UsingFilters

 

 

 

 

 

 

 

 

ReportsTab

Alternatively, you can use the Reports tab to explore the reports that are available. When you select the Reports tab, you will note that Analysis/Research, Ratings Analysis, News Analysis, and Analytical Commentary are automatically checked under the Publication Types list in the Filter By column.

PubsSearch

Use the Publications Tab to find reports by a specific provider. For example, to find EIU (Economist Intelligence Unit) Industry Reports covering the automotive, energy, healthcare, consumer goods, financial services and telecom sectors, select EIU Industry Reports from the publications list.

These reports cover both developing and developed markets, and include tables that are exportable to Excel, as shown in this example of telecom data from Austria.

excel