Essay on Session 10

Submitted By leo1012018
Words: 410
Pages: 2
Open Document
S10: Performance Evaluation – Spreadsheet Applications

1

Using EXCEL to Evaluate Portfolio Performance
Assume that
• today is 3 January,
• investors have an investment horizon of 60 days, and
• there are two funds to evaluate, an Aussie fund and the All Ords index portfolio.
Stage 1: Collecting Data and Generating Excess Returns for the SIM
Table A: Source Data
Returns

Date
02/01
03/01
04/01
07/01
08/01
09/01
…
27/02
28/02
01/03
04/03

Aust
Aussie
60 day
Fund
Bank Bill (Unit Price)
4.84%
2.4650
4.86%
2.4775
4.87%
2.4950
4.90%
2.5175
4.93%
2.5175
4.91%
2.5325
…
…
5.07%
2.5650
5.07%
2.5775
5.05%
2.5875
4.94%
2.5800

All
Ords
2464.8
2503.8
2551.6
2545.8
2571.0
2513.4
…
2601.4
2616.5
2609.1
2644.3

Aussie
Fund
0.0051
0.0070
0.0090
0.0000
0.0059
…
0.0059
0.0049
0.0039
-0.0029

All
Ords
0.0157
0.0189
-0.0023
0.0098
-0.0227
…
0.0097
0.0058
-0.0028
0.0134

Excess Returns
Aussie
Fund
0.0049
0.0069
0.0088
-0.0001
0.0058
…
0.0057
0.0047
0.0037
-0.0030

All
Ords
0.0156
0.0188
-0.0024
0.0097
-0.0228
…
0.0096
0.0056
-0.0030
0.0133

S10: Performance Evaluation – Spreadsheet Applications

2

Stage 2: Generating Inputs for the Performance Measures
Table B: Summary Information required by the Performance Measures
Aussie
All
Fund
Ords
Average Portfolio Return
0.0011 0.0016
Standard Deviation of Portfolio Return
0.0049 0.0106
Risk-Free
Return
0.0001
alpha
0.0008
t-stat
1.0909
beta
0.0670
Residual Standard Deviation
0.0048

Both the Sharpe and Treynor indices require:
• the arithmetic average return to summarise the fund’s overall performance during the evaluation period and
• the risk-free rate at the beginning of the period.
The standard deviation of portfolio return is required by the Sharpe’s ratio.
We also regress the excess returns of the Aussie fund on the excess returns of the market index. The outputs that are of interests include
• the intercept and its t-stat - to test if the fund had a significant and positive alpha,
• the coefficient of the X-variable – to obtain the portfolio beta for computing the Treynor index, and
• the residuals – to generate the
Show More

Related Documents: Essay on Session 10

Evaluation Session Sport Ass Essay

I and my partner had 45 minutes to carry out a session teaching students in our class skills and activities to do with football. We used our own knowledge as well as doing some research on our chosen sport to decide what we would carry out and focus on during the session. I will do an evaluation of my session rating myself out of 10 and commenting on what I felt my strengths and weaknesses were. Knowledge; 8/10 Although I don’t play football I feel I know a good amount about the sport as I am a…

Words 786 - Pages 4

2014-2014 AIU Undergraduate Calendar And Graduate Calendar

Calendar When courses are offered in 5 week sessions, the courses are designated as being offered in either an A session or a B session. Two consecutive 5 week sessions compose a 10 week quarter. AIU Undergraduate Calendar operates on the A-B session sequence. 2013 Calendar Quarter 1 – 2013 Quarter 1 – 2014 Session A Begins Holiday (US) Session A Ends Session B Begins Session B Ends Break Session A Begins Holiday (UK) January 7, 2013 January 21, 2013 February 10, 2013 February 11, 2013 March 17, 2013…

Words 2340 - Pages 10

School Camp Report

Opening Ceremonies /Role Call/ Staff Introductions/Rules– be ready to start your first field session (bring cleats, ball, shin guards, water) 2:00-4:00pm Field Session (1) 4pm back to Dorm, drop off gear, head to Goudy for dinner. Goudy opens at 4:30. 4:30-5:15pm Dinner Goudy Dining Hall – All meals at Goudy – Pizza orders ready Campers, if you’d like to order a pizza for after the night session, we will take your orders at dinner. Your choices are Sausage, Pepperoni, Hawaiian and/or Cheese…

Words 915 - Pages 4

Trip Schedule Essay

! ! 9:00 am - 4:00 pm ! 1:00 pm - 10:00 pm ! 4:30 pm - 5:30 pm ! 5:30 pm - 7:00 pm ! 6:00 pm - 10:00 pm ! 6:30 pm - 8:30 pm ! 7:00 pm - 8:30 pm ! 8:30 pm - 9:30 pm ! ! ! Schedule! Wednesday, April 23, 2014! Regional Coordinators Meeting/Roundtable Discussions (includes lunch) Convention Registration! The Phi Theta Kappa Academy Facilitators Meeting! International Officer Candidate Dinner! Florida Regional Meeting! Regional Coordinators Dinner! International Officer Candidate Orientation/Certification…

Words 470 - Pages 2

A Brief Note On Instructions

TUTORIALS Session – 2 2 AGENDA RECAP OF SESSION-1 ALL *IF*S & *BUT*S NEVER ENDING *LOOPS* LET’S TALK *FUN*CTIONS Session – 2 RECAP OF SESSION-1  From coding to execution  Tools Program segments  stack, heap, data, code  Data Types  unsigned/signed – long, short, char  float, double – someone to teach us  typecast  Storage Classes  auto, register, static, extern  Keywords  const, volatile  Operator precedence  NO SHORTCUTS, someone to demo their hard work Session – 2 3 RECAP…

Words 1090 - Pages 5

Anatomy I Essay

blades forward on rib cage and hollow out my chest. This exerices is to be done 10 times per set while resting 15 seconds after each set; a total of 3 sets per session. Another upper extremity exercise is the wall shoulder press-out as I mentioned earlier. With palms flat on the wall, shoulder-width apart, and elbows straight, with shoulders pressing back and then returning. This exercise is to be done 25 times with 2 sessions per day. Once I have strenthened my arm and upper extremity it is now important…

Words 1383 - Pages 6

conference example notes Essay

November 9:45 – 10:45 Session 1: Webliteracy: Teaching Zack to Think 11:00 – 12:00 Session 2: Student as Contributor: The Digital Learning Farm - Part 1 12:00 – 1:00 LUNCH 1:00 – 2:00 Session 2: Student as Contributor: The Digital Learning Farm - Part 2 2:00 – 2:15 COFFEE 2:15 – 4:15 Session 3: Finding Meaning in the Masses: Maximizing Your Professional Learning Community ConferenCe Day Two 9:00 – 10:00 Session 4: Ethics and Safety 10:15 – 12:00 Session 5: Connective…

Words 782 - Pages 4

Venue Session Num Essay

­4.2 ­ Multi­Skills Session Plan Date Venue Session Num One Numbers Duration 1 hour Age Range Fundamentals of Movement (FoM) Session Focus Fundamental Movement Skills (FMS) Agility Running Safety Screening Notes: Risk assessment and personal details of the player are complete. Other Involved and their role: None Resources Required: Session Goals: Cones and bibs To teach them to quickly change direction both on the spot and whilst…

Words 1587 - Pages 7

Cochlear Intervention Case Study

be beneficial for the first session when the cochlear implant is really new. During the first 6 sessions, Mr. Kremer and his clinician will work intensively on information counseling for his new cochlear implant and auditory training. They will use the Ling 6 Check, which includes 6 of the phoneme frequencies that are most popular in the English language. The Ling 6 Check will help determine if the cochlear implant device is working properly. During the first 6 sessions, they will also work on phoneme…

Words 1088 - Pages 5

Description Of Chico Creek Nature Center

Chico Creek Nature Center Registration Form – Summer Camp 2013 Held at the Chico Creek Nature Center in the heart of Bidwell Park, Camp Chico Creek consists of 10 1-week sessions of environmental education camp for children 5-11 years old. The program is designed to provide outdoor recreation activities and to foster awareness of nature in a fun, safe, and caring setting. Themes covering the Park’s habitats and its natural and cultural history are presented to campers through guided nature walks…

Words 985 - Pages 4