\$20 Bonus + 25% OFF

# ACC3201 Accounting Information Systems

0 Download5 Pages / 1,218 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
• Course Code: ACC3201
• University: Edith Cowan University
• Country: Australia

## Question:

#### Poblem

You have been approached by a strategic investor who is interested in firms on the Australian Stock Exchange (ASX). The investor is aware of your data analytics skill.

It is their expectation that you can provide an appropriate advice using your data analytics skill and considering their personal values. Specifically, as a believer of climate change and good governance, they are interested in the effect of emissions on firm profitability.

Using financial and regression analysis, advise the strategic investor.

NB: You are required to use five firms for the above problem.

### Instruction

Part 1: Firms selection and request for data

1. Identify and select five firms on the Australian Stock Exchange (ASX) with available data.
2. Download the following data for the selected firms from 2010 to 2018 using Thomson Reuters Eikon DataStream:
1. Financial Data
1. Net profit margin
2. Return on Assets
3. Quick ratio
4. Current ratio
5. Long-term debt to equity ratio
6. Interest coverage ratio
7. Total assets
1. Non-financial Data
1. Emissions Score

Part 2: Data preparation and cleaning

2. Critically evaluate the data, identify and report any extreme values (outliers)
3. Clean the data and prepare the spreadsheet for analysis
4. Run basic statistical analysis (summary statistics in excel)

Part 3: Financial analysis

With the aid of appropriate graphs and charts, perform a financial analysis of each firm (NB. using the downloaded ratios). Emphasis on the following;

1. profitability
2. liquidity
3. solvency

Part 4: Regression analysis

1. Using any of the profitability ratios as the dependent variable, run a multiple regression in Excel with Emissions Score, firm size (natural log of total assets) and leverage (long-term debt to equity ratio) as independent variables.
2. Write the regression equation using the output from your regression analysis.
3. Provide an interpretation of the regression output.

NB: Provide correlation analysis as part of your regression analysis.

Part 5: Creating interactive dashboard in excel

Based on your analyses, develop an interactive dashboard in excel that highlights indicators you consider relevant for managerial decisions.

Write a report to document the outcomes of your analysis. The report should include the following:

1. An indication of any missing data and outliers together with how they were treated
2. Financial analysis of the firms.
3. An interpretation of your regression analysis.
4. Based on your regression analysis, what is your recommendation to the strategic investor? Do firm emissions enhance profitability?  Justify your recommendations to the client

### Cite This Work

"Accounting Information Systems." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/acc3201-accounting-information-systems.

My Assignment Help (2020) Accounting Information Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/acc3201-accounting-information-systems
[Accessed 26 September 2020].

My Assignment Help. 'Accounting Information Systems' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/acc3201-accounting-information-systems> accessed 26 September 2020.

My Assignment Help. Accounting Information Systems [Internet]. My Assignment Help. 2020 [cited 26 September 2020]. Available from: https://myassignmenthelp.com/free-samples/acc3201-accounting-information-systems.

### Latest Finance Samples

#### ACC510 Financial Reporting 2

Answers: Part (i) Acquisition Price  \$2,000,000.00  Goodwill  \$240,000.00  Recoverable Amount  \$465,000.00  Carrying amount   Factory  \$250,000.00  Inventories  \$150,000.00  Brand  \$50,000.00  Goodwill  \$50,000.00  Carrying amount  \$500,000.00  Impairment Loss  \$35,000.00    ...

#### 7211AFE Corporate Finance

• Course Code: 7211AFE
• University: Griffith University
• Country: Australia

Answers: a. Value of shares = 30,000,000 * \$ 42 = \$ Determination of weighted average cost of capital for CWC Cost of equity – Ke = Rf  + β (Rm – Rf) (Magni 2015) Where, Ke = cost of equity Rf  = Risk free rate = 3.5% Β = Beta = 2.639 Rm = Market return = 12.52% Therefore, Ke = 3.5 + 2.639 * (12.52 – 3.5) = 3.5 + 23.8038 = 27.3038% Therefore, Ke or cost of equity = 27.3038% Cost of bond &ndas...

#### ACC510 Financial Reporting

Answer: Fair value has different meaning depending on the usage and context. Fair value in a broader context is the price that is received or paid for transfer of any asset or the amount received after the sale of any asset. In the normal context fair value is termed as the exit price. Fair value is mainly based on market specific assumption and not entity based assumption. In the present case fair value is used in three different contexts th...

#### FINA2006 Principles Of Finance

Answer:   Description  Formuals FMG OZL                 Total assets (book value) (\$m)     \$       19,115.00  \$         2,826.00   Recommendation:    On the basis of the calculations on both the stock of FMG and OZL. It has been found that the market value to...

#### BUST08029 Introduction To Financial Markets

• Course Code: BUST08029
• University: The University Of Edinburgh
• Country: United Kingdom

Answer: a) Ratio and performance analysis of Company X: The detailed ratio as well as performance analysis of the company has been provided below: Ratios 2017 2016 2015 2014 2013 Liquidity Ratios:           Current ratio 1.07 1.00 1.06 1.06 1.05 Quick ratio 0.85 0.63 0.83 0.61 0....

Next

### Save Time & improve Grade

Just share requirement and get customized Solution.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

1692 Order Completed

98% Response Time

### Alfred Dodd

#### Wellington, New Zealand

5/5

529 Order Completed

95% Response Time

### Ivan Blank

#### Wellington, New Zealand

5/5

285 Order Completed

99% Response Time

### Eugene Baranowski

#### London, United Kingdom

5/5

2632 Order Completed

100% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

Neat and speed work, able to help me complete urgent work in 1 hour! Satisfied with this service

#### User Id: 199325 - 26 Sep 2020

Australia

Best assignment made by my assignment. i got 99.5% marks. They made assignment on time and deliver it to me early then my requested time.

#### User Id: 496434 - 26 Sep 2020

Australia

Got such good marks I’m very happy. The work was delivered on time and well researched. Excellent Job.

#### User Id: 484402 - 26 Sep 2020

Australia

I would like to thank the author for a great piece. Obviously an expert in writing essay\'s. The essay was great, very clear, no fillers, structured and well written.

Australia