Spreadsheet Calculations for Risk and Reward

Now, the earlier mentioned calculations, when done by hand are painstaking. We calculated all these parameters within the span of the framework of just the four scenarios as per example, so that the meaning of the concept is assimilated well. But this operation can be done quicker practically. Generally it so happens that we would have to collect the historic data about the rate of return, and then copies the same on to some spread sheet such as MS Excel or Open Office. With spread sheets various functionalities that are already embedded in the system can be explored, and by now we are aware of exactly which operation to pick. Practically the following might be used:

  • Average (range): used for calculation of the mean degree of income return.
  • Varp (range): used for calculation of the variance here it is population. In case if we are considering historical data in place of already known cases, we would be using the function var(range). In the latter function, we divide by N-1, not N, which is explained later.
  • Stdevp (range): used for calculation of the standard deviation, variance being population. If make use of the data from the past in place of already known cases stdev (range) would have been used.
  • covar (range1, range2): is used for calculation of covariance of population amid twofold series. Depending upon the use of Excel, this function would be called as covarp.
  • correl (range1, range2): used for calculation of the correlation in the middle of two given series.
  • Slope (range-Y, range-X): used for calculation of the value of beta. Here, range-Y contains the rate of return on an investment, while range-X contains rate of return on market.

Table 8.3 has shown values post calculation of the parameters discussed here.


In this section of our discussion we have under the presumption that historical information provides us with an unprejudiced monitor to the period yet to come, as is just the case in section 7.1E. This assumption is for computing means, variance, covariance and also betas. Although it is a simplified version, it can also hurl difficulties on our way. This assumption would be more problematic when we deal with mean than any other parameters as covariance, variances and also betas. Ironically dealings with these terms would be at the risk of your own.

Again, there is another minor statistical problem that needs to be brought to light. Statisticians frequently make use of a covariance function, which is mathematically divides by N-1, and not by N. Looking into it sternly, we see that by dividing N-1 is apt if we deal with data from past, also termed as historical database.  It is meant for analysis purpose and do not provide us with total population that has likely outcomes. Given a sample finding the de mean wouldn’t provide us with the value of the true average.

The arithmetic division operation using a lesser numerical value, N-1, gives us a larger and an unprejudiced covariance measure. It is at the same time frequently termed as the sample covariance. Against mathematically dividing the same with N is proper if we work with samples rather scenarios that we are aware of to be existent and are similarly probable. In such case, statistics is more often termed the population covariance. Now the alteration infrequently makes a difference in finance. Here one is in general given many a number of observations, apart from the example we cited- the one where we had four scenarios.
Say for example we notice that dividing N=1000 and N=1001 has no difference in the results.

Spreadsheet Calculations for Risk and Reward 43

The beta value will not be affected by any of these circumstances. Hence, there is no need for the statistical ways of computation. Hence, it might be called and referred to as the statistical deviation.

There are much more deviations that are caused by the unknown statistical evaluations. Hence there is a change in the denominator values.


Spreadsheet Calculations for Risk and Reward 44
Spreadsheet Calculations for Risk and Reward 45

Key terms

Spreadsheet Calculations for Risk and Reward 46

Solve now! Solutions

Spreadsheet Calculations for Risk and Reward 47
Spreadsheet Calculations for Risk and Reward 48
Spreadsheet Calculations for Risk and Reward 49
Spreadsheet Calculations for Risk and Reward 50
Spreadsheet Calculations for Risk and Reward 51


Spreadsheet Calculations for Risk and Reward 52
Spreadsheet Calculations for Risk and Reward 53
Spreadsheet Calculations for Risk and Reward 54
Spreadsheet Calculations for Risk and Reward 55


Links of Previous Main Topic:-

Links of Next Financial Accounting Topics:-


We’re rated Excellent

4.7 out of 5 based on 39 reviews

Order Homework Help
Click or drag files to this area to upload. You can upload up to 5 files.
We do not share numbers with 3rd party.

Join over 200,000+ happy students served our tutors

Take a look at independent reviews to see what users have to say about our homework help service.


overall rating
on LiveChat


of users
recommend service

How It Works

1. Get Price Estimate.
1. Get Price Estimate.


Send us your homework. Mention deadline & upload relevant files.

2. Pay Securely.
2. Pay Securely.


We accept all major credit cards. Partial payments also accepted.

3. Get Solutions.
3. Get Solutions.


Receive error-free, step-by-step solutions in your email.


Why use Myhomeworkhelp?

We provide you with the homework help from top experienced experts. Your satisfaction is a priority to us. Get better grades or money-back. It’s that risk-free! Furthermore, everything about you is kept confidential.

How quickly can you help me with my homework?

We take pride in our 24×7 homework help services. Which means, student can approach us anytime, to get help even on short notices. As short as few hours! And yes, we provide complementary plagiarism-free report.

How much will it cost?

We do not have a monthly fees or minimum payments. Each homework task is quoted a unique price. It is based on tutor’s estimate of the time it will take them to complete your task. There are no obligations, and you are free to discuss the price quote with the tutor.
We do accept partial payment (subject to our policy) to start working on your assignment help. You can pay the remaining amount when your task gets completed. No pressure of up-front payment. No hidden costs.

Who are your tutors?

All our experts are highly qualified professionals – holding at least Master’s degree of their respective fields of expertise. We are very selective and choose only the best qualified tutors for each academic subject. All tutor applicants must provide academic transcripts for each degree they hold, and are tested and screened carefully by our staff.

I have privacy concerns. Can I trust you?

Myhomeworkhelp has completed over 250,000 homework help tasks over the last 12 years. But do not take our word for it! See our here and on Trustpilot. Furthermore, everything about you is kept confidential. Your credit card information is not stored anywhere, and use of PayPal relies on their secure payment networks. Your identity, payment and homework help are in safe hands.

Check our video

Our Reviews