# How to Create a Dividend Stock Portfolio in Excel in Under 10 Minutes

A dividend stock is a great option if you’re looking to diversify your overall investment portfolio and reduce risk while making your money work for you. Most stocks will pay out their dividends quarterly, with some raising the payout amount over time.

While there are a variety of ways to keep track of your dividend stock, in this post, we’ll focus on Excel. Specifically, we’re going to focus on utilizing Intrinio’s free Excel Add-In, which allows you to pull in a variety of dividend records such as the amount of latest dividend, the dividend yield, dividend payout ratio, and more.

# Calculate Debt to EBITDA Automatically in Excel in Under 5 Minutes with 3 Simple Steps

Debt to EBITDA is a measure of a company’s ability to pay off its incurred debt. It is calculated by pulling the total debt for a company and then dividing that number by the company’s EBITDA. In order to determine a company’s EBITDA, you will need to complete a few calculations…if you’re pulling the ratio by hand that is, but, using our hack and Excel Add-In, you can pull the ratio in a matter of seconds!

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

# 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 P/E Ratio Automatically in Excel in Under 5 Minutes with 3 Simple Steps

If you’re sick of doing Price to Earnings Ratio (P/E 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 with a free trial or subscription.