Analyse statistical data relevant to the financial services

Assignment Help Financial Econometrics
Reference no: EM131201650

Apply economic principles to work in the financial services industry/Interpret and use financial statistical tools

Assessment Description- By completing this assessment you will gather evidence of your ability, knowledge and skills necessary to:

  • apply broad principles of financial economics that underpin a range of tasks and functions in the financial services industry
  • to access, interpret and analyse statistical data relevant to the financial services industry.

It will include:

  • applying economic principles and theories
  • evaluating economic aspects that apply to decision making
  • reviewing own work
  • maintaining personal understanding of economic policies
  • applying statistical methods to work
  • sourcing and interpret statistical data
  • analysing data using appropriate techniques and tools
  • recording statistical data analysis results and records.

Written Report- Written report consists of the following assessment methods:

- Case study

- Problem solving

Task: Written Report (Length: 2800 - 3000 words)

Instructions:

The Board of Ethical Trading Group has asked you to prepare a report on current economic trends and evaluate the impact of these on their proposed plan to move into small scale sustainable manufacturing.  In order to achieve this they need to raise around $20,000,000 in capital and they anticipate this will return them an average of $5,000,000 in additional net revenue (after tax and before financing costs).

Ethical Trading Group would like you to provide a detailed analysis of their options with regard to capital raising: should they raise capital through shareholder equity or through debt financing or a mix of both? They need to understand the various types of debt, how they work, how they are valued, how they are rated, and whether they should be considering short or long term debt. For the equity, they need to know what type of shares can be issued, what the implications are for the company in issuing different shares, and the risks associated with raising capital via equity. They also need to understand the implications to their company that capital structure decision will have.

You need to consider the current company information provided in Tables 1 - 4, Figure 1 and the current economic climate and explain to them why you would select one option over the other based on current conditions and your forecast for the economy. Your report should explain to them implications that changes to the economy may have on their decision once made. The report should also include an analysis of the mean and standard deviations of costs of debt and equity based on an analysis of the company information, and debt and equity market history.

You must demonstrate that you have followed the report writing guidelines issues by the Ethical Trading Group.

Please access these here - Ethical Trading Group Employee Guidance Materials. This file is also available in the Ethical Trading Group folder in the Additional Resources for this course.

When you are preparing your written report, make sure that you have dealt with the following points:

1. Researched current economic theories and their impact on the financial services industry. Describe the economic and political climate relating to the financial services industry, in particular the debt and equity markets as they relate to your analysis of the funding decision, such as economic growth outlook, interest rate outlook, unemployment outlook and inflationary outlook using the theories of Keynesian Economics. Learners are to identify at least two Australian-based sources.

2. Outlined key features of common economic theories that relate to the decisions being made in your report.

3. Outlined key features of microeconomic principles and how they relate to debt and equity markets and organisational practices for companies.

4. Explained and applied two key mathematical principles and two statistical methods.

5. Described a range of statistical ratios and analysis tools relevant to the financial services industry and indicated what they are.

6. Outlined two sources of relevant financial services information and their relevance to your report.

7. Explained the principles of statistical standards and sampling techniques that you used to gather valid data.

8. Applied relevant financial modelling techniques to economic data to inform your decision regarding the funding method. Modelling techniques should include the Payback Period before financing, yield curves, rate of return. Explain the types of graphs, charts, diagrams and tables used in your statistical modelling and reporting and why you used them.

9. Showed evidence that you have analysed documentation from a variety of sources, and consolidated that information to assist in justifying your recommendations.

10. Applied asset and debt pricing models and explained the theories behind the models to show how they have influenced your decision. You should include valuing debt, valuing equity and leverage ratio. You should also calculate WACC before and after your recommendation, and the leverage ratio before and after. To calculate the WACC, use the value of interest bearing finance as the debt level, and assume that the finance expenses are the interest being paid on these loans, dividends paid are the cost of equity. Lastly you can assume that the value of shareholder equity is the value of contributed equity for ordinary shareholders. For the leverage ratio, you can use the book value of total liabilities less cash as a proxy for market value of debt.

11. Demonstrated that you have used realistic rates of return for debt and equity based on an analysis of the company data provided, for example the current cost of debt and equity, and a prediction of the future costs of both based on the increased risk after the financing decision is made and the type of debt used if any, the share price movements over time and a comparison with current ASX market returns as evidenced by data collected over a period of time (for example RBA, ABS and ASX data for debt and equity returns).

12. The company have also asked you to assess the likelihood that the new initiative will generate them the $5,000,000 in income that they have estimated based on a significance level of 0.05. They have acquired data for the last 5 years from the existing manufacturing business that shows on average the net revenue has been $4,950,000 with a standard deviation of 15%.  You should use hypothesis testing with a one tailed test and an appropriate t test value.  Determine if the hypothesis is correct or not and explain your findings in line with the company requirements in your report.

13. Determine if there is any correlation between the company share price and the ASX All Ordinaries (using the Product Moment Correlation Co-Efficient, and x" as Ethical Trading Group share prices and "y" as the ASX All Ordinaries values) and provide your opinion as to whether there is any strong correlation that could be used to help predict movements in the value of the company. Show your calculations and check and validate them. As part of the validation, \explain why you have only used a sample of the ASX rather than the entire population, and explain why you believe the sample is or is not a valid representation of the population.  Validation should also include an explanation of the method you used to check for accuracy in entering data for both Ethical Trading Group and the ASX, and the ways that you checked that your formulae are correct.

14. Calculate the Dividend yield each year based on an annual average share price and the dividends paid, and then prepare a graph that enables the company to identify any trend in the dividend yield over the last 5 years.  Cleary explain and interpret the trend shown in the graph for the company and include this in your conclusions and recommendations in your report.

15. Legislation, statutory requirements and industry codes of practice will each have an impact on your report. Describe two key features of each of these.

16. To conclude your written report, write a short reflection, of no more than 300 words, describing how the knowledge and skills gained from compiling this report would enhance your ability to undertake similar tasks for the Ethical Trading Group Board.

Words:- 3000

Reference:- 3 other

Attachment:- Assignment.rar

Verified Expert

The paper is in relation to raising capital by way of either debt, equity or hybrid financing. A company shall choose its option of financing capital after detailed analysis of all the aspects relating to it. This helps the company to come out with maximum benefit with minimum cost.

Reference no: EM131201650

Questions Cloud

Total amount of compound interest earned : a. What is the value of this account now in 2010? b. What is the total amount of compound interest earned?
What is the output of the sensor in volts per new ton : G is a material constant equal to 0.055 V-m/N for quartz in compressive stress and 0.22 V-m/N for polyvinyl lidene fluoride in axial stress.
Would the speed of rollers be adjusted based on measurement : Briefly, the speed is adjusted unless the probability that the mean thickness lies within ±2% of the sample mean exceeds 0.99. A typical set of measurements (in mm) is as follows:
Present value of lottery winnings : Assuming a discount rate of 7.50%, what is the present value of your lottery winnings? Use a calculator to determine your answer.
Analyse statistical data relevant to the financial services : FNSINC601 Apply economic principles to work in the financial services industry/FNSINC602 Interpret and use financial statistical tools. This assessment you will gather evidence of your ability, knowledge and skills necessary to: to access, interpret..
Do you think it is acceptable to use social media to comment : In recent years, the National Labor Relations Board has found the social media policies of several companies to be overly broad. Do you think it is acceptable to use social media to comment about your job?
Firm weighted average cost of capital : The U.S. Treasury bill is yielding 2.8 percent and the return on the market is 11.2 percent. The corporate tax rate is 38 percent. What is the firm's weighted average cost of capital?
Analyze whether or not continuous process improvements : Select one (1) tool, other than MS Project, that you could use in order to manage project costs and scheduling. Next, speculate on the overall different project management strategy that you would apply based on the tool that you have selected. Pro..
What is the present value : What is the present value of $14,350 to be received 4 years from today if the discount rate is 5.25 percent?

Reviews

inf1201650

6/22/2017 6:18:57 AM

At long last I got a legit and trusted tutor for my assignments: Getting through my graduation was a top need for me, however because of weaker financials, I have been working also. I have to travel out for my work, because of which I missed numerous fixed due dates of assignments. Expertsmind, a debt of gratitude is in order for understanding my issues that I was confronting and you were outrageously useful with my assignments. I finished without a hitch, because of the entire group! Love yo guys! you rock ! "

Write a Review

Financial Econometrics Questions & Answers

  Find what are the effective interest rates on the loans

The entertainment system vendor has offered to finance the $2,000 purchase over one year in 12 installments, with a total of $200 in interest to be paid on the loan.

  How much external equity must gardial seek now to expand

Gardial plans to maintain its current 30% debt-to-total-assets ratio for its capital structure and to maintain its dividend policy in which at the end of each year it distributes 55% of the year's net income.

  Determine what proceeds did sheffield company receive

On September 4, Sheffield Company discounted at Sunshine Bank a $9,000 (maturity value), 120-day note dated June 4. Sunshine's discount rate was 7.50%.

  Determine what is the after-tax cost of preferred stock

A firm's preferred stock pays an annual dividend of $4, and the stock sells for $80. Flotation costs for new issuances of preferred stock are 5% of the stock value.

  Explain how to prepare a schedule of cash payments

Sedgwick Company at December 31 has cash $20,000, noncash assets $100,000 liabilities $55,000, and the following capital balances: Floyd $45,000 and DeWitt $20,000.

  What is the most that an investor should be willing to pay

suppose that the risk-free rate is currently 9% per annum(quoted as an APR). You read of a strange security that offers a risk-free payoff of 10$ per month for the next 5 years

  Estimate the intercept on the regression

You are told that Land's End, a catalog retailer, earned an excess return (Jensen's alpha), in annualized terms -  estimate the intercept on the regression.

  Which of the following securities has lowest interest rate

Which of the following securities has the lowest interest rate? A bond with default risk will always have a --- risk premium and an increase in its default risk will --- the risk premium

  Calculate the projects payback and mirr

The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it would be recovered at the end of the project's 5-year life.

  How much of anwars rental loss can he deduct currently

During the year he has a net loss of $17,300 from renting the home. His other sources of income during the year were a salary of $120,000 and $12,700 of long-term capital gains.

  How much will have available to put down on that home

Kate and Richard just won $35,000 in the Pennsylvania state lottery. They decide to spend $9,000 now and put the remaining $26,000 in an investment earning 7 percent compounded annually.

  How to compute the required rate of return

Russo's Gas Distributor, Inc. wants to determine the required return on a stock with a beta coefficient of 0.5. Assuming the risk free rate of 6 percent and the market return of 12 percent.

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