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.

Read More

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.

Read More

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.

Read More

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.

Read More