# Finance Homework - Week 4

I am attaching the questions as an excel file. Each question is on a separate sheet.

## Finance homework in Excel

body preview (0 words)

file1.xlsx preview (869 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxChapter x | |||||||

Question 7 | |||||||

A&B) | The xxxxxxxxxxx coefficient between Chelle Computer | xxx xxx General Index. | and xxx xxxxxxxx deviations xx xxxx | ||||

YEAR | CHELLE COMPUTER | GENERAL INDEX | |||||

1 | xx | xx | |||||

2 | 9 | xx | |||||

3 | -11 | 14 | |||||

x | x | xx | |||||

x | xx | 12 | |||||

6 | 4 | 9 | |||||

xxxxxxx | 9.67 | 9 | |||||

xxxxxxxx xxxxxxxxx for Chelle Computer | standard deviation for xxxxxxx xxxxx | ||||||

YEAR | CHELLE COMPUTER | x-X | xxxxxxx | xxxx | xxxxxxx xxxxx | x-X | xxxxxxx |

x | 37 | 27.33 | xxxxxx | 1 | xx | 6 | xx |

2 | x | xxxxx | 0.44 | 2 | xx | 4 | 16 |

3 | xxx | xxxxxx | xxxxxx | x | 14 | x | xx |

4 | x | -1.67 | xxxx | x | -9 | xxx | 324 |

x | xx | xxxx | xxxx | x | xx | 3 | 9 |

6 | 4 | xxxxx | 32.11 | x | 9 | 0 | 0 |

Average | 9.67 | Average | 9 | ||||

xxxxx xxxxxxx | xxxxxxxxxx | xxxxxxx | total xxxxxxx | (Variance) | 410 | ||

xxxxxxxx xxxxxxxxx = | xxxxxxxxxxxxx | Standard deviation x | 20.2484567313 | ||||

xxxxxxxxxx | |||||||

YEAR | CHELLE xxxxxxxx | xxx | GENERAL xxxxx | xxx | (x-X)1*(x-X)2 | ||

x | xx | xxxxx | xx | x | 164 | ||

x | x | -0.67 | xx | 4 | -2.67 | ||

3 | -11 | -20.67 | 14 | x | -103.33 | ||

4 | x | xxxxx | -9 | -18 | 29.999999999999989 | ||

5 | xx | 1.33 | 12 | 3 | xxxxxxxxxxxxxxxxxx | ||

x | 4 | xxxxx | x | x | x | ||

Average | 9.67 | x | |||||

Total | (x-X)1*(x-X)2 | 92.000000000000014 | |||||

xxxxxxxxxx x | xxxx | ||||||

xxxxxxxxxxx coeffiecient for xxx two xxxxxx is therefore = | 0.026 | ||||||

xx | The xxxx for xxx xxxxxx Computer Company | ||||||

xxxx x xxxxxxxxxxxxxxxxxx | |||||||

therefore, | |||||||

the xxxx for xxx xxxxxx xxxxxxxx Company = | xxxxx |

# xxxxxx

xxxxxxxxxxxxCHAPTER x | ||

xxxxxxxx 8 | ||

xx | ||

xxxxxxxxxx Return | xxxx BETA | |

xxxx x | xx | 1.2 |

xxxx U | 10% | xxx |

Risk-free rate = | xxxxx | |

Risk premium = | 6.10% | |

xxxxxxxx rate xx xxxxxx x | xxxxxxxxx rate + beta(risk premium) | |

expected return for xxxx x x | 0.1122 | xx |

- - - more text follows - - -

Try it before you buy it |

Answer rating (rated one time)

## Remaining Question's Solution

body preview (4 words)

xxxxxx find xxxxxxxx file.

file1.xlsx preview (1090 words)

# xxxxxxx x x xxxxxxx 6

xxxxxxxxxxxxxxxxxxxxxxxxx x | ||

xx | xxx following are xxx xxxxxxxx xxxxxxx xxx the xxxxxx Computer xxxxxxxx | |

xxxx | xxxxxx Computer | xxxxxxx Index |

1 | 37 | 15 |

x | x | xx |

x | -11 | 14 |

x | 8 | -9 |

5 | 11 | 12 |

x | x | 9 |

xxxxx on xxxx information, xxxxxxx the following: | ||

a. | The xxxxxxxxxxx coefficient between Chelle Computer and the General Index. | |

0.1305461489 | ||

b. | xxx xxxx for the xxxxxx Computer xxxxxxx | |

xxxxxxxxxxxx |

# CHAPTER x - PROBLEM 8

xxxxxxxxxxxxxxxxxx x | ||

xx | As an equity xxxxxxxx you xxxx xxxxxxxxx the following xxxxxx xxxxxxxxx xxx risk xxxxxxxxx for two | |

different xxxxx mutual xxxxx xxxxx T and Fund xxx | ||

Forecasted xxxxxx | xxxx xxxx | |

Fund T | xxxx | 1.20 |

Fund U | xxxxx | xxxx |

a. | If xxx risk-free xxxx is xxx percent xxx the xxxxxxxx xxxxxx risk premium (i.e. xx RM) x RFR) | |

xx xxx percent, calculate xxx xxxxxxxx xxxxxx xxx xxxx mutual xxxx according to xxx xxxxx | ||

xxxx T | xxxxxx | |

Fund U | 0.0878 | |

xx | xxxxx the estimated xxxxxxxx xxxxxxx from xxxx x along xxxx your own xxxxxx forecasts, |

- - - more text follows - - -

Try it before you buy it |

Answer rating (rated one time)

## Solution is attached

body preview (18 words)

xxxxxx find xxxxxxxx file for xxxxx xxxxxxxxx x xxxx xxx xx solve xxxx xx xxx xxxxxxxxx as xxxxx

file1.xls preview (42 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxYear | xxxxx xxxxxxxx | General Index |

1 | 37 | xx |

2 | x | xx |

x | -11 | 14 |

x | x | xx |

5 | 11 | xx |

x | 4 | x |

xx The correlation xxxxxxxxxxx between xxxxxx xxxxxxxx and the xxxxxxx Index. | $0.13 | |

xx xxx standard deviation for xxx xxxxxxx xxx xxx Index. | xxxxxx | $9.06 |

xx The xxxx xxx the Chelle Computer xxxxxxxx | xxxxx |

# Sheet2

x# xxxxxx

xTry it before you buy it |