# Calculate Altman Z Score Automatically in Excel in Under 5 Minutes with 3 Simple Steps

The Altman Z Score calculation is based on five financial ratios and can take some time to produce manually, to save time (and frustration) you can use this handy Excel hack!

In this short process, we’ll show you how to pull the Altman Z Score for US publicly traded companies without doing manual calculations, which is possible through the Intrinio Excel Add-In.

# Calculate NOPAT Automatically in Excel in Under 5 Minutes with 3 Simple Steps

Stop spending precious time manually calculating Net Operating Profit After Tax (NOPAT) and start saving time by automatically calculating this in Excel in under two minutes.

In this short process, we’ll show you how to pull NOPAT for US publicly traded companies without doing manual calculations, which is possible through the Intrinio Excel Add-In.

# Calculate PE Ratio Automatically in Excel in Under 5 Minutes with 3 Simple Steps

If you’re sick of doing Price to Earnings Ratio (PE Ratio) calculations by hand and spending tons of time manually entering data, then check out this Excel hack.

In this short process, we’ll show you how to pull the P/E Ratio for US publicly traded companies without doing manual calculations, which is possible through the Intrinio Excel Add-In.

# Stock Valuation – Valuing Stocks With Intrinio’s Free Tools

## Stock Valuation - The Art and the Science

Warren Buffett is one of the most famous investors of our time and is a stock valuation pro. He learned most of what he knows from Benjamin Graham - the KING of Value Investing.

"Long ago, Ben Graham taught me that price is what you pay, and value is what you get. Whether we're talking about socks or stocks, I like buying quality merchandise when it is marked down." - Warren Buffett

Stock valuation involves analyzing a company from many different angles to determine an intrinsic value. This intrinsic value will either be above or below the current stock price. If the value you arrive at is above the stock price - buy it! It's cheap. If the value is below the stock price- sell it! It's expensive.

Not everyone is a fan of value investing; it's more of a long term approach. Hundreds of thousands of traders around the world pay little attention to the value of a stock, instead raking in big bucks betting on fluctuations in the price of the stock. Day trading, however, is incredibly risky and very few make money at it in the long run. To make an informed investment decision it's wise to analyze the value of the stock before buying.

Stock valuation is as much an art as it is a science. Running a discounted cash flow is somewhat of a science. Deciding which assumptions to put into that model - that is an art. Looking back over historical earnings and performance is a science. Modeling future sales based on industry knowledge and macroeconomic forecasts - that is an art.

There are lots of tools publicly available to assist you in performing stock valuation. We've developed two free tools that take care of the science for you, allowing you to focus fully on the art.

# Financial Data API: Affordable, Easy Access for Analysts and Developers

Financial analysts and fintech developers everywhere are realizing they have choices when it comes to sourcing financial data. Intrinio's financial data API strives to increase those choices by offering a wide variety of data types that are affordable, easy to access, and high quality.

Traditional data providers have enjoyed monopolies on this data for decades, making financial data APIs expensive or limiting access. This article shows how Intrinio is changing things.  Keep reading for examples of the data types Intrinio offers, how they can be accessed, and how much they cost.

This article shows how to get started if you are not familiar with Intrinio. You can create a free account and start accessing data feeds right away such as: US Fundamentals and Stock Prices and US Global & Economic data feeds.