country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ACC3201 Accounting Information Systems

tag 0 Download5 Pages / 1,218 Words tag 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

  1. Examine the downloaded data and note any missing values
  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.

Part 6: Documenting your findings

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
 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 5 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Accounting Information Systems. Retrieved from https://myassignmenthelp.com/free-samples/acc3201-accounting-information-systems.

"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.


Availing the assistance of qualified experts at MyAssignmenthelp.com is the best way to secure good grades in your assignments. Many Students fail to gather information to write a research paper. An appropriate research paper outline is essential to submit the assignment. Moreover, our experts choose unique research topics to provide compelling content. Writing a research paper is a tedious task, but our academic writers are efficient in providing 100% genuine content. They are well-versed with the formats and the resources from where data should be collected to deliver quality assignments.

Latest Finance Samples

ACC510 Financial Reporting 2

Download : 0 | Pages : 3

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    ...

Read More arrow

7211AFE Corporate Finance

Download : 0 | Pages : 7
  • 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...

Read More arrow

ACC510 Financial Reporting

Download : 0 | Pages : 4

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...

Read More arrow

FINA2006 Principles Of Finance

Download : 0 | Pages : 8

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...

Read More arrow

BUST08029 Introduction To Financial Markets

Download : 0 | Pages : 10
  • 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....

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,425,888

Orders

4.9/5

Overall Rating

5,092

Experts

Our Amazing Features

delivery

On Time Delivery

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

work

Plagiarism Free Work

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

time

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.

subject

Services For All Subjects

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

price

Best Price Guarantee

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

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1692 Order Completed

98% Response Time

Alfred Dodd

PhD in Computer and Information Science with specialization in Database

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

529 Order Completed

95% Response Time

Ivan Blank

PhD in Functional Human Biology

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

285 Order Completed

99% Response Time

Eugene Baranowski

MBA in Supply Chain

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2632 Order Completed

100% Response Time

Albert Ambrosio

MSc in Nursing

London, United Kingdom

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

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

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

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

calculator

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

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

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

flag

User Id: 199325 - 26 Sep 2020

Australia

student rating student rating student rating student rating student rating

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.

flag

User Id: 496434 - 26 Sep 2020

Australia

student rating student rating student rating student rating student rating

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

flag

User Id: 484402 - 26 Sep 2020

Australia

student rating student rating student rating student rating student rating

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.

flag

User Id: 460335 - 26 Sep 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?