Research Spotlight: Does Borrowing from Banks Cost More than Borrowing from the Market?

Featured

The third installment of Research Spotlight, a Datapoints series focusing on research emerging from Wharton that has made use of library resources, focuses on a paper authored by Wharton faculty member Michael Schwert. “Does Borrowing from Banks Cost More than Borrowing from the Market?” was published in The Journal of Finance 75 (2). 

As the article title implies, the study analyzes the pricing of private bank loans compared to capital market debt. Professor Schwert used S&P Capital IQ to obtain recent data on the capital structures of the sample firms used in the study. Capital IQ is a leading provider of financial information for both public and private companies with additional coverage of market and industry information, M&A transactions and more. 

For more information on Capital IQ, please contact a Lippincott librarian

At What Cost? Databases with Product Prices

image of price tag

Product prices are considered numerical gold by researchers and budding entrepreneurs. Typically proprietary, this data often comes at a high cost, an irony not lost on those who seek it. Fortunately, Lippincott Library provides access to several databases that contain product prices:

Mintel Global New Products Database (GNPD)

The Mintel Global New Products Database (GNPD) is a resource for researching the consumer packaged goods (CPG) marketplace. GNPD focuses on new products in the food, drink, beauty and personal care, home care, health and hygiene, and pet markets in 86 countries. In addition to new products, GNPD includes relaunched, reformulated, and repackaged products and new varieties or extended ranges of existing products.

To access GNPD from the Mintel platform, navigate to the Analytics menu at the top of the page and scroll over Products. From there, perform a basic keyword search or access the Advanced Search tool.

Product records provide Company & Source Details including manufacturer/distributor and name of retail store where the product was purchased, as well as Product Details including product description and positioning claims, package size, and product price at purchase location:

Mintel Global New Products Database sample cereal product record with product price outlined

Passport

This market information database covers consumer products and services on a global level. Prices are available for some products, such as Breakfast Cereals in USA:

Passport database price statistics for Breakfast Cereals in USA

Statista

Statista repackages third-party statistics from both publicly available and commercial sources, covering a variety of industries throughout the world. To locate available price statistics for a particular product, search for the product keyword followed by the word price (e.g. juice price). On the search results page, use the left side menu to filter results as desired, such as by geography.

For example, a keyword search for juice price with Countries & Territories limited to United States includes the following Beverage Digest chart depicting retail prices of juices and juice drinks in the United States from 2012 to 2019 in U.S. dollars per case:

Statista chart from Beverage Digest depicting retail price of juices and juice drinks in the United States from 2012 to 2019 (in U.S. dollars per case)

Statista’s charts and graphs include source information, making it easy to locate additional or updated price statistics from publicly available sources. For example, on the following chart depicting the average monthly retail price of orange juice in the United States from 2016 to 2020, the Sources field indicates that the U.S. Department of Agriculture is a source of this data, and the Source link is provided.

Statista graph for Average monthly retail price of orange juice in the United States from 2016 to 2020 (in U.S. dollars per 16 ounces), with U.S. Department of Agriculture Source link URL outlined

Clicking the source URL directs to a page on the USDA website featuring U.S. monthly average retail prices for fresh and processed fruits, including orange juice:

United States Department of Agriculture Economic Research Service's graph and statistics depicting U.S. monthly average retail prices for orange juice

ProcurementIQ

Designed to help purchasing and procurement managers make informed purchasing decisions, ProcurementIQ contains reports covering more than 1,000 indirect products and services in the United States. While reports target a commercial or industrial audience, some include residential focus. Search for a product by name (e.g. smoke detectors) to retrieve a report that includes a Price Environment section featuring a price summary, fundamentals, drivers, trends, forecasts, and more:

Price Environment visualization from ProcurementIQ report for smoke detectors

GlobalData Medical

GlobalData Medical focuses on the medical device, equipment, and supply industries throughout the world.

From the main menu, select Tools, then in the Medtrics Analysis Tool section, select the desired medical device product to access historical and forecasted Average Selling Prices for specific categories of medical device products across market segments and geographic areas. For example, this chart depicts Average Selling Prices for Laparoscopes in the General Surgery market across multiple countries from 2020 forecasted through 2023:

GlobalData Medical database's Market Average Selling Price for Laparoscopes in the General Surgery market in several countries for the years 2020 through 2023

CEIC

CEIC is a resource for global macroeconomic data. To access product price statistics from the CEIC landing page, open the Indicator menu and do a keyword search for price. Consumer or retail price statistics are available for a variety of products for countries throughout the world.

The CEIC chart below reflects recent retail prices of white granulated sugar in China:

CEIC chart reflecting recent retail prices of white granulated sugar in China

The data can also be viewed and downloaded as a table:

CEIC table reflecting recent retail prices of white granulated sugar in China

When your research calls for product prices, start by exploring the databases above and contact a Lippincott Librarian for additional assistance.

Mega Fans and Mega Brands: Tracking sports teams, sponsorships, and social audiences with Sports Atlas

Take me out to the ball game, take me out with the crowd!

Except that, with social distancing measures still in place, most of us probably won’t be attending any Major League Baseball games this year. But, the season is still scheduled and Opening Day is quickly approaching. If you want to follow your favorite team and maybe even learn more about your fellow fans, try using Sports Atlas.

Sports Atlas is a new database put out by the publishers of Sports Business Journal, and it collects information about professional sports leagues, their member teams, venues, and sponsorships. You can track your favorite team’s recent deals, and get an idea of its fans and their interests. In this case, let’s investigate our home team here at Penn’s campus, the Philadelphia Phillies.

An image of a user search in Sports Atlas for the phrase Philadelphia Phillies

After perusing the Team Snapshot and quick links, you can view detailed information by tab. View a list of all current sponsored brands with deals with the Phillies organization; sort by # of Deals across all sports or narrow down to those most closely-held with the MLB, or in the geographic region.

An image showing a list of brand sponsors for the current season of the Philadelphia Phillies, ranked from most deals in Major League Baseball to least.

Use the Asset Library to put yourself right in Citizens Bank Park, the Phillies’ stadium; view photos, by season, of all of the signage around the ballpark (both virtual/digital and static/print) that can be claimed for brand sponsorships.

An image showing a few of the places around the Citizens Bank Park stadium where the Phillies play where a brand can put advertising on signage

The Social Audience tab gives great insight into the fans of the team via their social media followers. Sports Atlas measures how much more likely a Phillies fan is also follow certain brands on social media than the average MLB fan; it comes as no surprise to this Phillies fan that a follower of the team is 20.59 times more likely to follow the Twitter account for Wawa than the average MLB fan.

An image showing the top brand affinities: the top brands that Philadelphia Phillies fans follow on Twitter, compared to other MLB fans

How does this compare to other teams in the region? Use the Reports tab on the left to find ways that you can explore the Philadelphia, PA market overall.

An image showing how to navigate the Sports Atlas program to find Reports on Categories and Markets

You’ll first see the top brands and teams/organizations active in the area, then you can navigate to view by brands, the demographics of fans in the area using Census data, and to compare and contrast teams by social data. Here we can see the top four teams in this market — Phillies (MLB), 76ers (NBA), Flyers (NHL), and Eagles (NFL) — and see their fans’ brand affinities as a comparison table. Looks like Wawa’s sponsorship of the 76ers is paying off even more handsomely than it is for the Phillies!

An image showing a breakout of brand support by fans of four Philadelphia-area sports teams

Sports Atlas is fun to explore, sure, but it’s also an important tool for anyone researching sports business management, brand sponsorship & major deals, or audience demographics in the fan market.

GLOBAL FINANCIAL DATA

Recently, I was trying to help someone get US Gross Domestic Product (GDP) statistics back to 1915. The problem? GDP did not exist as a construct going that far back in time. However, there was a source that came to mind: Global Financial Data (GFD). This database specializes in providing long time series on stocks, bonds, and economic indicators. In the case of GDP for the United States, they have extended it back to 1789. You can use GFD anonymously or you can create a personal account in order to access certain features such as saving workbooks.

Image of GFD login page.  Academics have the choice to log in anonymously or create a log-in

Directly from the landing page, you access search options, GFD Power Downloads, and Help.

Image of the landing page for Global Financial Data. Includes Search options, GFD Power Downloads, and Help

It is easy to download data or to create graphs to demonstrate a point. Below is a sampling of what GFD has to offer.

Continue reading

Have Questions? We Have Answers! Lippincott’s Business FAQ

Magnifying glass enlarging the words "Frequently Asked Questions"

Looking for information on the medical device industry? Wondering where to find company financial ratios? Want to find the latest issue of Forbes or The Wall Street Journal? Look no further than Lippincott Library’s Business FAQ for answers to these and many other business research questions.

Accessible from the Lippincott Library home page and the search box on the Penn Libraries home page, the Business FAQ is the perfect starting point for many business research needs. This self-help resource currently includes more than 300 (and counting) questions and answers covering various aspects of business research and more.

Simply type a concept (keyword, phrase in quotes, or combination of words) into the Business FAQ search box on the Lippincott Library home page, click the Ask button, and a list of relevant questions appears. Select the question that fits your needs.

Business FAQ keyword search for bond

Answers feature hyperlinked resources with content overviews, access instructions, and details about why the resource would be more appropriate for a specific research need.

Business FAQ answer to the question "How do I find data on total returns for stocks, bonds, and indexes?"

Business FAQ questions and answers are maintained by Lippincott Librarians based on experience responding to questions from Wharton students and faculty.

If your question is not included in the Business FAQ, the system provides an option to “Submit Your Question” for addition to the FAQ repository:

Business FAQ Submit Your Question button

Fun facts about Lippincott’s Business FAQ:

The most popular question is “How do I find analyst reports (investment bank research)?” followed by “Where can I screen for companies by IPO date, and how do I find the IPO date of a specific company?” and “Where can I find credit and bond ratings for a particular company?

The Business FAQ includes resource access questions such as “How can I access Bloomberg?” and “Why am I having difficulty using Thomson ONE?

Answers often include both subscription and publicly available resources. For example, see answers to “How do I find data on consumer demographics and buying behavior?” and “Where can I find economic, industry, and country forecasts worldwide?

There are even FAQs intended for specific audiences. For example, “How may I use the library’s resources for classes or projects that involve working with an external client?” and “As an alumnus, which online business resources am I able to access when I visit the library?

Original software for the Business FAQ was created and maintained by the Penn Libraries Information Technology and Digital Design Department. Penn shared that software with other academic libraries that were members of the Business FAQ Consortium. Over the years, software platforms changed and now each academic library maintains its own Business FAQ repository.  

Next time you have a business research question, consult Lippincott’s Business FAQ for the answer!

Unpacking Consumer Packaged Goods with Mintel’s Global New Products Database

The Mintel Global New Products Database (GNPD) is a new Lippincott Library resource for researching the consumer packaged goods (CPG) marketplace. GNPD focuses on new products in the food, drink, beauty and personal care, home care, health and hygiene, and pet markets in 86 countries. Mintel has been monitoring products since the 1990s and adds more than 30,000 product launches to GNPD each month. In addition to new products, GNPD includes relaunched, reformulated, and repackaged products and new varieties or extended ranges of existing products. Helpful tip: if a product is purchased by another company, Mintel categorizes this as a “relaunch” and creates a separate GNPD record reflecting the new company’s ownership.

Mintel users may have encountered GNPD content during general searches on the Mintel platform. GNPD data and information appears in Mintel Country and Global reports, under Content Type: Innovative Products, and when using the Product Features filter. Now, users also have the option to search within GNPD exclusively.

To access GNPD from the Mintel platform, navigate to the Analytics menu at the top of the page and scroll over Products. From there, you can perform a basic keyword search, access the Advanced Search tool, research ingredients, and explore CPG trends.

Mintel Global New Products Database landing page

Basic keyword searching provides quick access to new products. Every field in GNPD is keyword-searchable. Search suggestions allow you to drill down by product name, company name, flavor, fragrance, ingredients, and more.

Mintel GNPD search suggestions for  keyword search for "ice cream"

Use the filters on the search results page to focus results on region, product claim, ingredients, company, and more. The “Refine search” free text box allows for keyword searching within results.

Mintel Global New Products Database search results page for "ice cream"

Advanced Search allows you to limit a search by multiple filters, many at a detailed level, enabling a refined list of results:

Mintel Global New Products Database Advanced Search page

The example below reflects an Advanced Search for the key phrase “ice cream” in the product description, limiting to products containing the ingredient almond milk, and limiting geography to Latin America:

Mintel Global New Products Database Advanced Search for "ice cream" with results limited to those containing the ingredient almond milk and within the geography Latin America

Results can be sorted in several ways, including by geographic Market:

Mintel Global New Products Database search results page with option to sort results by Market outlined

Drilling into a product record yields Product Details including package size, product positioning claims, as well as Company & Source Details including manufacturer, retail store where the product was purchased, and the product price:

Mintel Global New Products Database product record reflecting information on Product Details tab
Mintel Global New Products Database product record reflecting information on Company and Source Details tab

Product records also include nutrition facts, packaging information, product variants (when available), and links to GNPD records for similar products:

Mintel Global New Products Database product record reflecting nutrition facts and packaging information
Mintel Global New Products Database product record reflecting product variants and links to Global New Products Database records for similar products

The Advanced Search function is also accessible from the basic search results page by clicking the “Edit with advanced search” link.

Product records can be downloaded into Microsoft Word, Excel/CSV, PowerPoint, or HTML. Customizable templates are available for Excel and CSV downloads. Product images can be downloaded as JPG files.

GNPD search results can be visualized, charted, and tabulated for trend analysis. Search results may also be shared through a direct link. To save GNPD searches, create a free Mintel personal profile using your Wharton or Penn email address. From a search results page, click “Save search,” name the search, and save it. You can also create email alerts for new products meeting your search criteria.

The GNPD Hopper is similar to the basket feature in Mintel reports. From a search results page, click “Add to Hopper,” then “Create new Hopper.” Name the Hopper, add records to it, and save it. You can also add Hopper comments and share Hoppers. Saved Searches and saved Hoppers are accessible from the Products page under the Analytics menu.

This is merely a brief highlight of how GNPD can streamline research in the CPG sector. To learn more about GNPD’s many tools and features, the Help & Training section accessible from the top right side of the Mintel database includes a Glossary, User Guide, and forthcoming training videos covering basic and advanced searching within GNPD.

This video from Mintel demonstrates popular GNPD features mentioned above:

For additional assistance with Mintel GNPD, please contact a Lippincott Librarian.

GNPD covers June 1996 to present. For CPG data and information prior to 1996, search GNPD’s PDF Archive, which dates back to 1973.

FT.com is now available at Penn

This is an image of the header of the FT.com site.

The Penn Libraries are pleased to announce that access to FT.com is now available to Penn students, faculty and staff. This subscription includes access to the online version of the Financial Times back to 2004, including the daily editions of the ePaper, as well as content exclusive to its online publication. To get started, use this link to set up an account with FT.com using your Penn email address. 

FT.com expands access to FT content previously unavailable through library subscriptions to include data graphics, videos, newsletters, podcasts and more. The “Today’s Newspaper (ePaper)” feature enables users to read a digitized version of the daily print publication, including its many international iterations, with options for both on- and off-line use. 

This is an image of the front page of the August 25, 2020 edition of the Financial Times.

Users can also make use of the “myFT” feature via this subscription, which provides options for curating a feed of topics of interest for quick access to relevant articles, saving articles for later use, and subscribing to newsletters from a user-friendly dashboard. 

This is an image of a dashboard in the myFT feature of FT.com that allows users to select newsletters to which they would like to subscribe.

Once you’ve registered, be sure to download the Financial Times app on your iOS or Android device. Login with your email address and password to access all of the same features for when you are on the go. 

This is an image of the mobile app for the Financial Times.

To read more about how to access the Financial Times through the Penn Libraries, please see our Business FAQ

Hidden Gem: Lippincott Library’s Document Delivery Service

Diamond

Have you found yourself in a maze of confusion while trying to track down an article or book chapter? You are not alone! Fortunately, Wharton faculty, staff, PhD, MBA, and undergraduate students can avoid this frustration by taking advantage of Lippincott Library’s Document Delivery service. If reducing research time and effort sounds appealing, read on to learn more.

Whether you need an article or a chapter from a book, Lippincott’s Document Delivery staff will track down the item and get it to you.

Here are common questions and answers about Document Delivery:

How does Document Delivery obtain the material I request?

We locate the PDF within one of our hundreds of subscription databases or make a scan from a print item in the Penn Libraries’ collections.

What if I need an article or book chapter that is not in Penn Libraries’ collections?

Open book with reading glasses on top

Not a problem! We will request the article or chapter from one of our many partner libraries around the world. You will receive a link to the PDF directly in your email inbox. 

What else should I know about the Document Delivery service?

There may be limits to the amount we can scan from a single book or journal issue based on U.S. copyright laws, including Fair Use.

How do I use Document Delivery?

Email the full citation of the article or book chapter to docdel@wharton.upenn.edu and we will get to work!  Expect to receive PDFs from our subscription databases or scans from items within Penn’s collection within 24 hours. (Note: Document Delivery is staffed Monday through Friday)