We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Groupbased assignment for Financial data analysis - Essay Example

Comments (0) Cite this document
Summary to essay on topic "Groupbased assignment for Financial data analysis"
Decision Making is the utmost component in the life of a business and manager. Being a Finance manager is again another great problem where both the owners and the shareholders have to be satisfied. This is a dilemma facing each financial manager. The owner wants to retain as much as possible but the shareholders demand to fully disperse the profits…
Download full paper
Polish This Essay
Groupbased assignment for Financial data analysis
Read TextPreview

Extract of essay "Groupbased assignment for Financial data analysis"

Download file "Groupbased assignment for Financial data analysis" to see previous pages... The report analyses the risk and return of these two companies. Then the cost structure of these companies is compared. The first part of the report focuses on calculating the means and the variances of the two companies. 'Mean' provides a measure of average return to investors while the 'variance' and hence the 'standard deviation' indicate risk.
Let us write or edit the essay on your topic "Groupbased assignment for Financial data analysis" with a personal 20% discount.. Try it now
The second part of this report focuses on calculating the cost of capital for DGSE COMPANIES INC to aid the appraisal of a project under scrutiny.
The cost of capital is the "opportunity cost of an investment; that is, the rate of return that a company would otherwise be able to earn at the same risk level as the investment that has been selected". CAPM will be used as the model. The equity cost of capital is found by accumulating the data relating to the company's and market returns at different points in time.
The calculations yield a mean value of 0.026557 for DGSE COMPANIES INC and 0.014395 for PUBLIC SERVICE ENTRP GRP INC. These figures can be interpreted as for an investor investing $1 in DGSE COMPANIES INC and $1 in PUBLIC SERVICE ENTRP GRP INC, after a month he will get an average holding period return of 2.6 cents and 1.4 cents on his investments respectively.
The Variance and the closely related Standard Deviation are measures of dispersions, which indicate how the possible values are spread around the mean and are an indicator of risk. For the purpose of calculations, the following formula is used for variance:


As per the calculations, the monthly variance for DGSE COMPANIES INC is 0.0401 (4.01 %) and for PUBLIC SERVICE ENTRP GRP INC is 0.0050 (0.5%). The square roots of these figures give the monthly standard deviation which equals 0.200 (20%) and 0.0707 (7%), respectively. The Variance is indicative of volatility, hence the risk. It indicates how risky the investment is. A Comparison of risk and return of the two companies will give a clear idea.
Table 1. RISK - RETURN RELATIONSHIP
S.No
Company Name
Risk (%) Variance
Return (%) - Mean
1
DGSE COMPANIES INC
4.01
2.6
2
PUBLIC SERVICE ENTRP GRP INC
0.5
1.4

The famous phrase "Higher the risk, higher the return" holds well in our case.
Chart 1

Source: Primary
Table 2. YEAR WISE RETURN COMPARISON
YEAR
DGSE
PUBLIC
1997
0.0932
0.0212
1998
0.0418
0.0270
1999
0.0895
-0.0058
2000
0.0449
0.0401
2001
-0.0188
0.0034
2002
-0.0849
-0.0142
2003
0.0806
0.0318
2004
0.0199
0.0202
2005
-0.0269
0.0229
2006
0.0261
0.0063

Chart 2

Source: Primary
CALCULATION OF MINIMUM VARIANCE PORTFOLIO
S.No
Company Name
Risk (%) Variance
Return (%) - Mean
1
DGSE COMPANIES INC
4.01
2.6
2
PUBLIC SERVICE ENTRP GRP INC
0.5
1.4

The total portfolio return considering equal proportion of each companies share is
(0.5)*2.6 + (0.5)*1.4 = 2%
By Trial and error method, the minimum variance portfolio is arrived at respective ...Download file "Groupbased assignment for Financial data analysis" to see next pagesRead More
Cite this document "Groupbased assignment for Financial data analysis"
  • APA
  • MLA
  • CHICAGO
(“Groupbased assignment for Financial data analysis Essay”, n.d.)
Groupbased assignment for Financial data analysis Essay. Retrieved from https://studentshare.org/miscellaneous/1515461-groupbased-assignment-for-financial-data-analysis
(Groupbased Assignment for Financial Data Analysis Essay)
Groupbased Assignment for Financial Data Analysis Essay. https://studentshare.org/miscellaneous/1515461-groupbased-assignment-for-financial-data-analysis.
“Groupbased Assignment for Financial Data Analysis Essay”, n.d. https://studentshare.org/miscellaneous/1515461-groupbased-assignment-for-financial-data-analysis.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC "Groupbased assignment for Financial data analysis"
Secondary Data Analysis Assignment
Economic Deprivation 3.1. Economic Deprivation in Percentage 3.1.1. table 3 Economic Deprivation Claimants in Percentage 3.1.2. figure 2 Economic Deprivation Claimants in Percentage 4. Finding Patterns 4.1. Deprived total compared No-qualification Level 4.1.1.
6 Pages(1500 words)Essay
Financial data analysis
The first step in examining the relationship between the two variables is use of a scatter plot. The aim of this step is to form a general pattern and establish whether there is any deviation from this general pattern. Figure 1 below shows how WHEATSF correlated with WHEATHD.
4 Pages(1000 words)Essay
Assessed assignment 2 - Data Analysis Exercise
An analysis of the transcript of the following role-playing conversation will help to identify where the speakers with L1 Chinese diversify from the grammatical and lexical patterns used by native speakers. Spare times – the word “time”
3 Pages(750 words)Essay
Financial statement analysis and Valuation: assignment
The use of its products and services ranges from home to businesses and on the road. BP product lines include bio fuels, gas and fuel cards, industrial lubricants, marine fuels, Liquefied Petroleum Gas (or LPG), and solar
10 Pages(2500 words)Essay
Financial data analysis
Countries as well as companies, use the same tool to predict different things. Some companies like to predict their earnings in total, while some of them like to initiate certain things from the total (Borodovsky, M & Gogarten, P, 2010). Among a number of forecasting
4 Pages(1000 words)Essay
Financial data analysis
Using Excel function, a correlation analysis was conducted on the available data in order to find out how the two prices of wheat are correlated. In addition, the data analysis also identifies
4 Pages(1000 words)Essay
Data analysis
The AKT and phosphor-AKT measurements in kDa ranges from 46.5 to 165 kDa, while in HA, the range is between 28 kDa to 105 kDa. The experiment consistently use 293 cells with the three different antibodies,
2 Pages(500 words)Essay
Data Analysis
However over the past few years the term has greatly expanded and has even moved towards the field of financeInvalid source specified.. A great deal of works has been conducted regarding
8 Pages(2000 words)Essay
THE FINANCIAL RATIO ANALYSIS ASSIGNMENT
These show that the less than 50% of the company assets are financed by debts. On the other hand the leverage ratios are slightly above 50% for the years 2012 and 2013. This means that borrowing has certainly increased and over 50% of the company is based on debts.
4 Pages(1000 words)Essay
Goldman Sachs Financial Data Analysis Assignment
wide range of financial services substantially to an assorted customer base that includes administrations, commercial institutions, high net-worth personalities, and corporations. As a US based company, Goldman Sachs has its operations spread out in various parts of the world,
7 Pages(1750 words)Assignment
Let us find you another Essay on topic Groupbased assignment for Financial data analysis for FREE!
Contact us:
+16312120006
Contact Us Now
FREE Mobile Apps:
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us