StudentShare solutions
Triangle menu

Groupbased assignment for Financial data analysis - Essay Example

Extract of sample
Groupbased assignment for Financial data analysis

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

Summary

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…
Author : percivalgleichn
Groupbased assignment for Financial data analysis essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Groupbased assignment for Financial data analysis"
with a personal 20% discount.
Grab the best paper

Related Essays

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
Secondary Data Analysis Assignment
CANI provides marketing research and consumer classification data. In the following I will present some data analysis based on 2001 census data and then some information from ACRON. This practice will help
6 pages (1500 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
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation