Conduct analysis of the dividends of companies

Assignment Help Other Subject
Reference no: EM132920210

Analysis of Corporate Dividends in Australia and Canada

Jupyter Notebook should be uploaded to the appropriate folder on Moodle.

For the final project you will conduct analysis of the dividends of companies from the following two countries: Australia and Canada.

Relevant financial data is available on Moodle in one excel file: dividend_au_cn.xlsx. This file is in the "Final Project Documents" folder on Moodle. You will have to download the data, upload to your Jupyter notebook and then conduct your analysis using Pandas and other Python Libraries. You will have to submit the Jupyter notebook you used to do the analysis for this project.

You will have to write up your analysis in a report of up to 2,000 words. Your report should also include tables and graphs from your analysis. These tables and graphs have to be produced using Python and you will have to submit all the relevant codes in a Jupyter notebook.

The objectives of your analysis are as follows:

• Document and discuss the distribution and trends in dividend payout ratio (dividend/net income) and the number and percentage of dividend payers (positive dividend) over time in each country:
o Use dividend to net income ratio as the measure of dividend payout ratio.
o Dividend payout ratio attempts to measure what percentage a firm's earnings is paid out in dividends.
o Dividend payout ratio is not a meaningful measure in the following two cases, so you need to deal with these cases in the data pre-processing step:
1. When a firm has negative net income, the dividend payout ratio is not a meaningful measure.
» So exclude observations (rows) with negative net income from your sample
2. When a firm has a dividend payout ratio higher than 1 (dividend is higher than net income), the dividend payout ratio is not reliable as a firm cannot pay out more dividend than net income in the long run.
» So cap the value of dividend payout ratio at 1.0 --- set any value higher than 1.0 to 1.0.

o You will conduct the analysis for Australia and Canada and you will discuss how the dividend payout ratios of the two countries compare with each other and if they show similar or different trends over time.
o You should perform similar analysis of dividend payers in the two countries. In two separate graphs, you should show the number and percentage of dividend paying firms in the two counties and how these have changed over time.

o You will document the distribution of dividend payout ratio in each country in 2007 and 2017 to see if the distribution has changed over time. You can use histograms, kernel density plots and percentile plots to show the distributions.

• Analyse the determinants of dividend payout ratio in each country. So you will have two sets of results.
o Initially, explore the relations between various firm characteristics (such as firm size, profitability, growth opportunity etc.) and dividend payout ratio using scatter plot.
o You will then conduct correlation analysis to determine if there are significant correlations between these characteristics and dividend payout ratio.
o Then use simple linear regressions to quantify the relation between leverage and these characteristics one at a time. Here you will use regressions with one independent variable (see lecture 7).
o Finally you will use multiple linear regression analysis to consider the effects of all the different firm characteristics on dividend payout ratio.
o You will compare and contrast the results you get from the above analysis for the two countries in your sample: Australia and Canada.

• Finally, you should estimate two Machine Learning models and evaluate the predictive performance of these models.
o The first model will try to predict the dividend payout ratio of a firm. You can use the Boston House Price example as a template for this analysis and do similar analysis on dividend payout ratio (instead of house price).
» As X (or independent) variables (features matrix), use the four firm characteristics we used in the group project: Firm size (Logsale), Profitability, Tangibility and Market to book ratio.
» The y variable or dependent variable (the target vector) in your model would be the dividend payout ratio.
» You should to the train-test split and evaluate the model's performance on the test dataset and interpret the results.
o The second model will try to predict whether a firm pays dividends --- that is, whether the dividend of a firm is positive.
» Create a variable in your dataframe called PAYER which should be 1 if a firm has positive dividend (and therefore positive dividend payout ratio) and 0 otherwise. This variable will be the categorical dependent variable in your supervised classification model.
» Same as in the first model, as X (or independent) variables, use the four firm characteristics we used in the group project: Firm size (Logsale), Profitability, Tangibility and Market to book ratio.
» Use the K Nearest Neighbor model or KNN model for this analysis
» You can use Iris flower example (covered in lecture 8) as a template for this analysis and do similar analysis on dividend PAYER (instead of Iris flower types).
» You should do the train-test split and evaluate the model's performance on the test dataset and interpret the results.

I have posted two papers on Moodle for you to read for this assignment. These papers analyse dividend payout ratio, but they do not use the same firm characteristics as independent variables that your dataset has --- but these papers will help you understand the general research background and how to interpret the results. As independent variables in your analysis, you should use the same firm characteristics that we used in the leverage analysis (such as firm size (Logsales), Profitability etc.).

You should also do additional research via google on the determinants of dividend payout ratio and use those sources as references in your report.

You will summarise you main finding is a report of 2000 words. The report will:

1. Summarise the relevant literature (research papers) and research question.

2. Report and discuss descriptive data analysis and data visualisation.

3. Report and discuss correlation and regression analysis

4. Report and discuss Machine Learning (ML) analysis of dividend payout ratio using the linear regression model (LinearRegression: covered in lecture 11 in the Boston House Price example). Fit an ML model to predict dividend payout ratio and evaluate the performance of the model.

5. Report and discuss Machine Learning (ML) analysis of dividend payers (if dividend payout ratio > 0 then dividend payer = 1, otherwise dividend payer = 0) using the K Nearest Neighbor model or KNN model (covered in lecture 8). Fit an ML model to predict whether a firm pays dividend and evaluate the performance of the model.

6. Draw inference and conclusion and relate the findings to existing research.

Attachment:- Data Analytics.rar

Reference no: EM132920210

Questions Cloud

What are the main components of attitudes : What are the main components of attitudes? Are these components related or unrelated?
Mission vision and values of british petroleum company : What is mission vision and values of british petroleum company. And are they following it and how?
Process of developing a strategic review : Describe the process of developing a strategic review for a strategic plan and give examples.
Explain role of business analyst : a) What does Business Analyst do in a software implementation project?
Conduct analysis of the dividends of companies : Analysis of Corporate Dividends in Australia and Canada - discuss the distribution and trends in dividend payout ratio (dividend/net income) and the number
Find how much would pay in total interest : You are going to prepare an amortization plan for her. Indicate the annual payment amount. How much would she pay in total interest?
What are valuations of two stocks using dividend-growth : you expect the market to increase at an annual rate of 8.7 percent, what are the valuations of these two stocks using the dividend-growth model?
What would be the book value after year five : Using straight line depreciation method. Calculate GWH yearly depreciation on that equipment. What would be the book value after year 5?
How much would pay in total interest : You must prepare an amortization plan for her. Indicate the annual payment amount. How much would she pay in total interest?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd