mba sim fund - w. p. carey school of business · mba sim fund board presentation may 1, 2009. 2 2....
TRANSCRIPT
![Page 1: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/1.jpg)
MBA SIM Fund
Board Presentation May 1, 2009
![Page 2: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/2.jpg)
22
2008-2009 Student Managers
Colin Nelson W.P. Carey MBA Finance Class of 2009
Jay Krumme W.P. Carey MBA Finance Class of 2009
Jeremy Kelstrom W.P. Carey MBA Finance & Real Estate Class of 2009
Bill Pappa W.P. Carey MBA Real Estate Class of 2009
![Page 3: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/3.jpg)
3
Agenda
Overview•
Fund Objectives
•
Economic Outlook
Portfolio Holdings
•
Additions and Removals•
Selected Stocks
Performance•
Portfolio
•
Attribution
![Page 4: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/4.jpg)
4
Executive Summary
-45%-40%-35%-30%-25%-20%-15%-10%
-5%0%5%
10%
SIM FundS&P 500
(27.2%)(32.3%)
ReturnsSept 29 to April 17
SIM FundS&P 500
(20.9%)(21.4%)
![Page 5: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/5.jpg)
Overview
Board Presentation May 1, 2009
![Page 6: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/6.jpg)
6
Fund Objectives
Long-term investment strategy
Minimum 70% equity
Low cash reserve
No short selling
$750MM market cap
Limits on derivatives
![Page 7: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/7.jpg)
7
Selection Criteria
Screening criteria for stocks
Low beta relative to industry
High dividend yield
Industry leaders
International exposure
High balance sheet cash relative to debt
Strong capital expenditure
![Page 8: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/8.jpg)
8
Fund Characteristics
SIM Fund S&P 500Market Cap ($B) 55.83 64.48Dividend Yield 4.89 3.15Price/Earnings 12.14 14.25Forward PE 11.82 14.59ROE 26.32 19.16Price/Cash Flow 7.91 8.295 Year Beta vs S&P 500 0.72 0.96
![Page 9: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/9.jpg)
9
Economic Outlook
Based on finance capstone project
Economic model inferred from historic economic indicators
Model Drivers
InflationReal Wages
Monetary PolicyPCE GDP
![Page 10: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/10.jpg)
10
Economic Outlook
Model Predictions
GDP Recovery in Q3 2009
End of Bear Market early Q2 2009
![Page 11: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/11.jpg)
11
Economic Indicators
Was our forecast right?
Current market shows some signs of stabilization
PCE ticks up in January and February
Dow rebounds from low of 6,547 on March 9
![Page 12: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/12.jpg)
12
DJIA 11/20-4/17
Dec. 23rd – Oil hits low price per barrel of $30.28
Feb 17th – Economic
Recovery and Stimulus Act
March 9th – Dow and S&P hit lows of
6,547.05 and 676.53, respectively
Jan 20th – Senator Obama inaugurated as
President
Feb. 25th – Bank stress tests announced
March 18th – Fed announces quantitative
easing
April 2nd – Mark-to- Market rules eased by
FASB
April 17th – Bank of America, Citigroup,
and JPMorgan earnings week
Source: Google Finance
Retrospective
![Page 13: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/13.jpg)
Portfolio Holdings
Board Presentation May 1, 2009
![Page 14: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/14.jpg)
14
Additions and Removals
Source: Google Finance
December 17, 2008
Buy
– CHK $16.35 PEP
$54.18, GE $18.02,
WMT $55.58Sell
– RIMM $39.51
March 4, 2009
Buy
– MO $15.01
![Page 15: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/15.jpg)
15
Low beta stock
Additionally, low beta during last recession
International Exposure
Defensive play given discount food
Strong dividend yield
McDonald’s (MCD)
Reasons for Hold
![Page 16: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/16.jpg)
16
McDonald’s (MCD)
Source: Google Finance
Has held up well vs. S&P
![Page 17: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/17.jpg)
17
Initially there was a debt payment concern
We performed a cash flow analysis based on the following assumptions
$35 per barrel of oil
$2.50 per MMBtu
of natural gas
$15 billion in long-term debt
Chesapeake (CHK)
Reasons for Addition
![Page 18: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/18.jpg)
18
Under this worse case scenario the cash from operations to debt ratio is over 2*
Based on this analysis we determined that CHK’s
stock price was unnecessarily low
We purchased 300 more shares at $16.35
CHK is currently trading at $20.80
Chesapeake (CHK)
Reasons for Addition
*See appendix for detailed ratio analysis
![Page 19: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/19.jpg)
19
Chesapeake (CHK)
Source: Google Finance
Chesapeake has been highly volatile with the price of energy
Natural Gas is currently at $3.297 / MMBtu
Sept 29 to April 17
![Page 20: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/20.jpg)
20
Chesapeake (CHK)
Source: Google Finance
Nov 20 to April 17
![Page 21: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/21.jpg)
21
Diversified industrial giant
Global exposure
Growing operating income and ROE
Concerns with financial unit, but assurances that capital was “adequate”
(AAA credit rating)
Beta 0.65
Dividend yield near 5%, (later, near 10%)
Trading at a 10-year low of $25 at first purchase
General Electric (GE)
Reasons for Addition
![Page 22: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/22.jpg)
22
General Electric (GE)
Source: Google Finance
Oct 1st – $3B Buffet infusion,
$12B equity offering
Dec 16th – Immelt
reiterates 31¢ dividend
Dec 2nd – Moodys affirms Aaa rating
Dec 17th – S&P affirms AAA rating,
negative outlook
Feb 6th – Immelt promises “continued attractive dividends”
Jan 27th – Moodys puts on ratings
review
Jan 23rd – Earnings released, 37¢ EPS. Committed to $1.24 dividend, AAA rating
![Page 23: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/23.jpg)
23
General Electric (GE)
Source: Google Finance
Mar 23rd – Moodys cuts
from Aaa to Aa2 (stable outlook)
Mar 12th – S&P cuts from AAA to AA+ (stable outlook)
Feb 27th – Dividend cut from 31¢ to 10¢
![Page 24: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/24.jpg)
24
Research in Motion (RIMM)
Stock price fell additional 8% as market rallied from November low
Earnings warning in early December with reduced ongoing forecast
Increased competition
Fit with Fund?
Add to cash position for future investments
Reasons for Sell
![Page 25: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/25.jpg)
25
Research in Motion (RIMM)
Sold on Dec 17th
(38.55% loss overall)
Dec 18th
-
Q4 guidance above estimates
Feb 11th
-
Guidance incorrect
Source: Google Finance
![Page 26: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/26.jpg)
26
Altria (MO)
Dividends (Safe ones!) –
7.8%
Recession resistant, low beta (.31)
Brand Portfolio (#1 in major segments)
Near monopoly (50.4% of cigarette market)
Diversification (28.5% of SABMiller)
Reasons for Purchase
![Page 27: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/27.jpg)
27
Altria (MO)
Source: Google Finance
Up 16.21% overall
March 5th
-
Cigarette price change announcement
Recently beat estimates, no change to stock
![Page 28: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/28.jpg)
Portfolio Analysis
Board Presentation May 1, 2009
![Page 29: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/29.jpg)
29
Asset Allocation
ACL, 3.3% CHK, 6.2%
DD, 5.1%
DEO, 5.1%
GD, 5.0%
GE, 6.7%
JNJ, 5.7%
LMT, 5.5%
MCD, 7.0%MO, 8.5%
PEP, 7.5%
TRV, 7.6%
WMT, 7.2%
LQD, 13.8%
Cash, 6.0%
![Page 30: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/30.jpg)
30
Sector Allocation
Consumer Discretionary
10%
Consumer Staples31%
Energy6%
Financials10%
Health Care13%
Industrials24%
Materials6%
Note: Equities only
![Page 31: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/31.jpg)
31
PerformancePortfolio ValueSept 29 to April 17
$0
$100,000
$200,000
$300,000
$400,000
Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09
9/29 Portfolio Value
$353,254
11/20 Portfolio Value
$257,072 (-27.2%)
4/17 Portfolio Value
$279,579 (-20.9%)
3/9 Portfolio Value
$234,075 (-33.7%)
![Page 32: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/32.jpg)
32
Performance
-45%-40%-35%-30%-25%-20%-15%-10%
-5%0%5%
10%
SIM FundS&P 500
(27.2%)(32.3%)
ReturnsSept 29 to April 17
SIM FundS&P 500
(20.9%)(21.4%)
![Page 33: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/33.jpg)
33
PerformanceHolding Period Returns by Security
![Page 34: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/34.jpg)
34
Performance Attribution
‐2.98%
9.36%
‐5.96%
‐8.00%
‐6.00%
‐4.00%
‐2.00%
0.00%
2.00%
4.00%
6.00%
8.00%
10.00%
12.00%
Allocation Selection InteractionNote: Equities only
0.69%
![Page 35: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/35.jpg)
35
Allocation Effect
0.71
‐1.58
‐0.18
1.78
0.31
‐2.17
‐2.14
0.53
‐3 ‐2 ‐1 0 1 2
Materials
Information Technology
Industrials
Health Care
Financials
Energy
Consumer Staples
Consumer Discretionary
-2.98%Note: Equities only
![Page 36: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/36.jpg)
36
Selection Effect
‐0.02
0.46
2.5
9.63
‐1.86
‐0.85
‐1.27
0.21
‐5 0 5 10
Materials
Information Technology
Industrials
Health Care
Financials
Energy
Consumer Staples
Consumer Discretionary
9.36%Note: Equities only
![Page 37: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/37.jpg)
Takeaways
Board Presentation May 1, 2009
![Page 38: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/38.jpg)
38
Learning Points
Corporate statements are useful, but there is no substitute for doing your own in-depth research
Interpret CEO statements in light of their role
Fund strategy must be driven by an understanding of economic fundamentals
Be aware of current events, but keep a long-term view –
returns are noisy
![Page 39: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/39.jpg)
39
Thank You
Thank you to
Keith Wirtz, Justin Dammel, and Fifth Third
Chuck Michaels
Board of Directors
Herb Kaufman
![Page 40: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/40.jpg)
Questions
Board Presentation May 1, 2009
![Page 41: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/41.jpg)
412
2009-2010 Student Managers
Spencer Rands
W.P. Carey MBA
Finance & RE
Class of 2010
Eric Dalbom
W.P. Carey MBA
Finance & RE
Class of 2010
Himanshu Gupta
W.P. Carey MBA
Supply Chain Finance
Class of 2010
Andrew Harbut
W.P. Carey MBA
Finance
Class of 2010
Matt Pendleton
W.P. Carey MBA
Finance
Class of 2010
Perrin Gayle
W.P. Carey MBA
Finance & RE
Class of 2010
![Page 42: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/42.jpg)
Appendix
Board Presentation May 1, 2009
![Page 43: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/43.jpg)
43
AppendixChesapeake Ratio Analysis
Percent of Product Sold from 2007 90%Price per barrel of oil $ 35.00 Price per million cubic feet of natural gas $ 2.50 Price growth 0%DDA drop 80%Interest Rate 6%
Assumptions
2007* 2009 2010 2011Oil ($ per barrel) $ 68.64 $ 35.00 $ 35.00 $ 35.00 Amount Sold (Oil) 6,293,706 5,664,336 5,097,902 4,588,112 Oil (Sales $) $ 432.00 $ 198.25 $ 178.43 $ 160.58 Natural Gas ($ per mcf) $ 6.29 $ 2.50 $ 2.50 $ 2.50 Amount Sold (Gas) 825,437,202 742,893,482 668,604,134 601,743,720 Natural Gas (Sales $) $ 5,192.00 $ 1,857.23 $ 1,671.51 $ 1,504.36 Total Oil and Gas Sales $ 5,624 $ 2,055 $ 1,850 $ 1,665 Oil and Natural Gas Marketing (Sales $) $ 2,040 $ 746 $ 671 $ 604 Total Sales $ 7,664 $ 2,801 $ 2,521 $ 2,269 Total Operating Expenses $ 5,151 $ 1,883 $ 1,694 $ 1,525 Operating Profit $ 2,513 $ 918 $ 827 $ 744 Other expense $ 308 $ 308 $ 308 $ 308 EBIT $ 2,205 $ 610 $ 519 $ 436 Taxes $ 772 $ 214 $ 182 $ 153 EBI $ 1,433 $ 397 $ 337 $ 283
Income Statement
Source: Chesapeake 2007 10-K
![Page 44: MBA SIM Fund - W. P. Carey School of Business · MBA SIM Fund Board Presentation May 1, 2009. 2 2. 2008-2009 Student Managers. Colin Nelson W.P. Carey MBA Finance Class of 2009](https://reader033.vdocuments.us/reader033/viewer/2022052719/5f07e8807e708231d41f5c3e/html5/thumbnails/44.jpg)
44
AppendixChesapeake Ratio Analysis
Cash Flow
Ratio Calculation
2007* 2009 2010 2011EBI $ 1,433 $ 397 $ 337 $ 283 DDA $ 1,971 $ 1,577 $ 1,577 $ 1,577 Deferred Taxes $ 835 $ - $ - $ -Derivatives $ 415 $ - $ - $ -
Cash from Operations $ 4,654 $ 1,974 $ 1,914 $ 1,860
Source: Chesapeake 2007 10-K
Long-Term Debt $ 10,000 $ 15,000 $ 15,000 $ 15,000 Interest $ 406 $ 900 $ 900 $ 900 Coverage Ratio 11.46 2.19 2.13 2.07