This Excel template is designed to help you analyze the dividend payout of a company and to calculate its dividend coverage ratio. This template can be used as a quick analysis tool for investment decision-making. With this template, you can quickly see the current and past dividend payouts of a company, compare dividend payouts across different companies, and determine whether a company is paying out too much or too little in dividends.
The template is divided into two parts: the dividend coverage part and the dividend payout part. For the dividend coverage part, you can enter the company's revenue and its dividend payout over the past year. The template will then calculate the dividend coverage ratio, which is the total dividend payout divided by the revenue. A higher dividend coverage ratio means the company is paying out more in dividends than it is earning in revenue, which is generally a bad sign for investors.
For the dividend payout part, you can enter the company's total dividends paid out over the past year and its total number of shares outstanding. The template will then calculate the dividend payout ratio, which is the total dividends paid out divided by the total number of shares outstanding. A higher dividend payout ratio means the company is paying out more in dividends than it is earning in revenue, which could be a good sign for investors.
The Dividend Coverage and Payout Excel Template is an easy to use tool for analyzing the dividend payout of a company. It is a great tool for quickly comparing the dividend payouts of different companies and making investment decisions based on the dividend coverage and payout ratios.