Courtney Kiely

While there are a variety of ways to keep track of your dividend stock, we’ll focus on Excel. We’ll take you through 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, and dividend payout ratio.

Debt to EBITDA is a measure of a company’s ability to pay off its incurred debt. 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.

The Altman Z Score calculation is based on five financial ratios and can take some time to produce manually. In this short process, we’ll show you how to pull the Altman Z Score for US publicly traded companies without doing manual calculations through the Intrinio Excel Add-In.

Stop spending 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 through the Intrinio Excel Add-In.

If you’re sick of doing Price to Earnings Ratio (P/E Ratio) calculations by hand, 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.