Financial Insights And Business Intelligence Assignment Sample

Comprehensive Financial Insights and Business Intelligence Assignment - Expert Solutions for Students

  • 72780+ Project Delivered
  • 500+ Experts 24x7 Online Help
  • No AI Generated Content
GET 35% OFF + EXTRA 10% OFF
- +
35% Off
£ 6.69
Estimated Cost
£ 4.35
6 Pages 1593 Words

Introduction To Financial Insights And Business Intelligence

Evaluate the average rate of return

Figure 1: Average rate of return

Average rate of return

(Source: Created by learner)

The average rate of return is a process that can be used to determine the financial position of the organization. This table shows that the average rate of return for GM stock is 18.54% and also the average rate of return for Ford stock is 18.90%.

Rate of return (ROR) on the comparisons of 40% and 60% for GM stock and Ford stock

Figure 2: ROR

ROR

(Source: Created by learner)

Did you Like Our Samples from Our Delivered work?
Connect with us and make it yours in the Same Quality Order AI-FREE Content Assignment Assistance

The average return of the portfolio during the period from 2003 to 2007

The initial stage of the securities has been taken on 40% each 60% of the Ford stock
In this case, portfolio return and risk have been showcased
Year GM stock Value Ford stock Value the total value of the weighted return
2003 (-10%*0.40) -0.04 (-3%*0.60) -0.018 -5.80%
2004 (18.50%*0.40) 0.074 (21.29%*0.60) 0.128 20.17%
2005 (36.87%*0.40) 0.15 (44.25%*0.60) 0.27 41.30%
2006 (14.33%*0.40) 0.057 (3.67%*0.60) 0.02 7.93%
2007 (33% * 0.400 0.132 (28.30% *0.60) 0.17 30.18%
average rate of return of the portfolio Total of the weighted return / total number of the years 0.187572
rate of return of the portfolio 19.92%

Table 1: Average return

(Source: Created by learner)

This table describes the average rate of return of the portfolio and also the rate of return of the portfolio. This table shows that the value of the average rate of return of the portfolio is 0.18757 and also value of the rate of return of the portfolio is 19.92%.

Estimates the risk of each stock

GM stock

Calculating the risk for both of the common stocks

Figure 3: Risk for both stocks

Risk for both stocks

(Source: Created by learner)

The total Risk of a stock is computed by using the standard deviations of the stock GM
using standard deviations for identifying the GM stock value SQRT (SUM /n-1) 0.1871
Individual risk factors of the stock of GM 18.71%

Table 2: Total risk

(Source: Created by learner)

Individual risk factors for the stock of Gm are 18.71% also describes \ the total value of the square of the differentiate is 0.14.

Year Ford Common stock showcased value GM stock return - average return (18.90%) Square of the differentiate
2003 -3 -21.9 0.05
2004 21.29% 2.39% 0.00
2005 44.25% 25.35% 0.06
2006 3.67% -15.23% 0.02
2007 28.30% 9.40% 0.01
the total value of the square of the differentiate 0.14

Table 3: Value of stock return

(Source: Created by learner)

The total risk of a stock is computed by using the standard deviations of the stock FORD
Using the standard deviations of the Ford stock value SQRT / total value of the square of the differentiate/ n- 1) 0.1902629759
Individual risk factors of the Ford stock 19.03%

Table 4: Risk of stock return

(Source: Created by learner)

As well as individual risk factors of the Ford stock are 19.03% and also the total value of value of the square of the differentiate is same is 0.14.

Calculations of the Risk for the Assets Portfolio

Calculation of portfolio risk at the stage of 40% evaluations of factors
Portfolio risk SQRT (0.4*0.1871) ^2+(0.4*0.1903) ^2+2*0.4*0.4*0.9031*0.1871*0.1903
Portfolio risk 9.09%
Calculations of the portfolio risk at the stage of 60% Evaluations of factors
Portfolio risk SQRT (0.6*0.1871) ^2+(0.6*0.1903) ^2+2*0.6*0.6*0.9031*0.1871*0.1903
Portfolio risk 14.84%

Table 4: Risk of asset portfolio

(Source: Created by learner)

This table describes the portfolio risk at the stage of 40% as 9.09% and also for portfolio risk at the stage of 60% is described as 14.84%.

Evaluate the coefficient correlation between returns of common stocks (Two)

GM Ford
coming Returns 18.54% 18.90%
Standard deviations 18.71% 19.03%
GM Stock value FORD stock value RP standard deviations
Weighted value 0 1 18.9 19.03
0.1 0.9 18.8811 18.85873
0.2 0.8 18.8622 18.87776
0.3 0.7 18.8433 18.89679
0.4 0.6 18.8244 18.91582
0.5 0.5 18.8055 18.93485
0.6 0.4 18.7866 18.95388
0.7 0.3 18.7677 18.89679
0.8 0.2 18.7488 18.87776
0.9 0.1 18.7299 18.85873
1 0 18.711 18.8397

Table 5: Correlation

Flat 35% Discount on your first order!
& Extra 10% OFF on your WhatsApp order!
Place Order Now Live Chat Whatsapp Order

(Source: Created by learner)

Figure 4: Standard deviation

Standard deviation

(Source: Created by learner)

In this above evidence, this has been included that the graphical pentagons showcased the most attractive and beneficial opportunity of the investments. In this case, the opportunity built has been used by 40% and 60% shares, respectively. In this segment, the portfolio return is 19.92% Portfolio risk has been worked for 14.84%. In this consideration, this combination of the two stated stocks is presented as the value of portfolio and risk factors.

Evaluating Modern Portfolio Theory

The Modern Portfolio Theory is useful in the age of the investment and analysis of the risk engagement practice. The selected business can deliver the details about the business and projections of the business evaluations of the investment chosen. In the selected theory it has been assumed that the clones are actually risk averse (Dimmock et al. 2023). The selected theory can deliver the options to the investors to the less risky options to manage their business evaluations. In simple words, this theory is helpful due to its nature of providing low-risk investments but in practicality, it is not good that investors always take low risks, where the high risk provides high returns.

Get Extra 10% OFF on your WhatsApp order!
use my discount
scan QR code from mobile

Providing recommendations accordingly in layman's terms on the profitability

In the above considerations the recommendations under using the layman's term profitability on the measures of using the Portfolio market and evaluations the risk factors of different stocks have been clarified the stage of investing. Investors of the markets try to invest in risk-free segments of the market and use the portfolio management for investing which determines the investors can invest in risk-free agents. In this case, layman's theory discusses the diversification of their market investing which helps them to reduce the risk of the investing (Van der Niet, 2021). This theory is more effective in the market and helps investors gain profitability in their investing strategies.

References

  • Dimmock, S.G., Wang, N. and Yang, J., 2023. The endowment model and modern portfolio theory. Management Science.
  • Van der Niet, B.M., 2021. Evaluating the effect of fair value adjustments to investment property on profitability ratios (Doctoral dissertation, North-West University (South Africa)).
Seasonal Offer
scan qr code from mobile

Get Extra 10% OFF on WhatsApp Order

Get best price for your work

×
Securing Higher Grades Costing Your Pocket? Book Your Assignment At The Lowest Price Now!
X