# 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, whilst 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.