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

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

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

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

Essay on Southwood School

Flexibility. The sessions could be run at the times convenient to managers, which may have been more difficult to accommodate with an external trainer.  note PLeaSe Note: From this point forward, the Hr manager is referred to as the trainer. Designing the Training…

Words 3042 - Pages 13

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

Case Study Essay

Healing II: Modalities Instructor: David Rabinowitsch, DNP RN CHTP/I CNE INTRODUCTION Subject presented on 10/11/2014 with the complaint that she is experiencing bilateral shoulder pain at bedtime. She states pain is only present when she is lying down in bed. Describes the pain as a hybrid of soreness and achiness. Rates pain at a “6”on scale of 0-10 (0 is no pain and 10 is severe pain). No medications or interventions have been taken/pursued, and she has no evidence of what may diminish…

Words 2218 - Pages 9

Essay about Marketing Concept

(8) 2 RATIONALE 2 AIMS (9) 2 LEARNING OUTCOMES (9) 2 MODULE TEACHING (10) 3 TEACHING PLAN – indicative content (11) 4 RESOURCE LIST (12) 10 ASSESSMENT (13) 10 ASSIGNMENT DETAILS (14) 12 FEEDBACK (15)............................................................................12 INTRODUCTION This handbook has been designed to provide you with information on the module objectives and content for each session of the programme. It also includes details of the learning resources to which…

Words 2492 - Pages 10