FIN435 Class Web Page, Spring '20

Jacksonville University

Instructor: Maggie Foley

The Syllabus

Exit Exam Questions (will be posted in week 10 on blackboard)

Weekly SCHEDULE, LINKS, FILES and Questions 

Week

Coverage, HW, Supplements

-        Required

 

Videos (optional)

Week

1

Marketwatch Stock Trading Game (Pass code: havefun)

Use the information and directions below to join the game.

1.     URL for your game: 
https://www.marketwatch.com/game/jufin435-20s    

2.     Password for this private game: havefun.

3.     Click on the 'Join Now' button to get started.

4.     If you are an existing MarketWatch member, login. If you are a new user, follow the link for a Free account - it's easy!

5.     Follow the instructions and start trading!

6.   Game will be over on 4/17/2019

 

Chapter 3 Financial Statement

 

ppt

 

Using a Balance Sheet to Analyze a Company (VIDEO)

What is an Income Statement? (Video)

How Do You Read a Cash Flow Statement? | (VIDEO)

 

Finviz.com/screener for ratio analysis (https://finviz.com/screener.ashx

 

 

image001.jpg

 


Balance Sheet Template 
 

http://www.jufinance.com/10k/bs

 

Income Statement Template  

http://www.jufinance.com/10k/is

  

Cash flow template

http://www.jufinance.com/10k/cf

 

Ratio Analysis   

https://www.jufinance.com/ratio

 

FCF calculator      What is free cash flow (video)

https://www.jufinance.com/fcf

image003.jpg

Capital expenditure = increases in NFA + depreciation

Or, capital expenditure = increases in GFA

 

Note: All companies, foreign and domestic, are required to file registration statements, periodic reports, and other forms electronically through EDGAR. 

 

 

 

 

Case study of chapter 3: 

·        Excel File here  (due with the first mid term exam)   

·        Video available  on blackboard collaborate

And at https://www.jufinance.com/video/fin435_c3_case.mp4

 

 

 

***** How much does Amazon worth?”

FYI: Amazon.com Inc. (AMZN) https://www.stock-analysis-on.net/NASDAQ/Company/Amazoncom-Inc/DCF/Present-Value-of-FCFF

 

 

Present Value of Free Cash Flow to the Firm (FCFF)

In discounted cash flow (DCF) valuation techniques the value of the stock is estimated based upon present value of some measure of cash flow. Free cash flow to the firm (FCFF) is generally described as cash flows after direct costs and before any payments to capital suppliers.

 

Intrinsic Stock Value (Valuation Summary)

Amazon.com Inc., free cash flow to the firm (FCFF) forecast

 

Year

Value

FCFFt or Terminal value (TVt)

Calculation

Present value at 16.17%

01

FCFF0

(4,286)

1

FCFF1

(4,286) × (1 + 0.00%)

2

FCFF2

 × (1 + 0.00%)

3

FCFF3

 × (1 + 0.00%)

4

FCFF4

 × (1 + 0.00%)

5

FCFF5

 × (1 + 0.00%)

5

Terminal value (TV5)

 × (1 + 0.00%) ÷ (16.17% – 0.00%)

Intrinsic value of Amazon.com's capital

Less: Debt (fair value)

45,696 

Intrinsic value of Amazon.com's common stock

Intrinsic value of Amazon.com's common stock (per share)

$–

Current share price

$1,642.81

1 


Weighted Average Cost of Capital (WACC)

Amazon.com Inc., cost of capital

 

Value1

Weight

Required rate of return2

Calculation

Equity (fair value)

803,283 

0.95

16.97%

Debt (fair value)

45,696 

0.05

2.10%

2.99% × (1 – 29.84%)

1 USD $ in millions

   Equity (fair value) = No. shares of common stock outstanding × Current share price
488,968,628 × $1,642.81 = $803,282,551,764.68

   Debt (fair value). See Details »

2 Required rate of return on equity is estimated by using CAPM. See Details »

   Required rate of return on debt. See Details »

   Required rate of return on debt is after tax.

   Estimated (average) effective income tax rate
= (20.20% + 36.61% + 60.59% + 0.00% + 31.80%) ÷ 5 = 29.84%

WACC = 16.17%


FCFF Growth Rate (g)

FCFF growth rate (g) implied by PRAT model

Amazon.com Inc., PRAT model

 

Average

Dec 31, 2017

Dec 31, 2016

Dec 31, 2015

Dec 31, 2014

Dec 31, 2013

Selected Financial Data (USD $ in millions)

Interest expense

848 

484 

459 

210 

141 

Net income (loss)

3,033 

2,371 

596 

(241)

274 

Effective income tax rate (EITR)1

20.20%

36.61%

60.59%

0.00%

31.80%

Interest expense, after tax2

677 

307 

181 

210 

96 

Interest expense (after tax) and dividends

677 

307 

181 

210 

96 

EBIT(1 – EITR)3

3,710 

2,678 

777 

(31)

370 

Current portion of long-term debt

100 

1,056 

238 

1,520 

753 

Current portion of capital lease obligation

5,839 

3,997 

3,027 

2,013 

955 

Current portion of finance lease obligations

282 

144 

99 

67 

28 

Long-term debt, excluding current portion

24,743 

7,694 

8,235 

8,265 

3,191 

Long-term capital lease obligations, excluding current portion

8,438 

5,080 

4,212 

3,026 

1,435 

Long-term finance lease obligations, excluding current portion

4,745 

2,439 

1,736 

1,198 

555 

Total stockholders' equity

27,709 

19,285 

13,384 

10,741 

9,746 

Total capital

71,856 

39,695 

30,931 

26,830 

16,663 

Ratios

Retention rate (RR)4

0.82

0.89

0.77

0.74

Return on invested capital (ROIC)5

5.16%

6.75%

2.51%

-0.12%

2.22%

Averages

RR

0.80

ROIC

3.31%

Growth rate of FCFF (g)6

0.00%

1 See Details »

2017 Calculations

2 Interest expense, after tax = Interest expense × (1 – EITR)
848 × (1 – 20.20%) = 677

3 EBIT(1 – EITR) = Net income (loss) + Interest expense, after tax
3,033 + 677 = 3,710

4 RR = [EBIT(1 – EITR) – Interest expense (after tax) and dividends] ÷ EBIT(1 – EITR)
= [3,710 – 677] ÷ 3,710 = 0.82

5 ROIC = 100 × EBIT(1 – EITR) ÷ Total capital
= 100 × 3,710 ÷ 71,856 = 5.16%

6 g = RR × ROIC
0.80 × 3.31% = 0.00%


FCFF growth rate (g) forecast

Amazon.com Inc., H-model

 

Year

Value

gt

1

g1

0.00%

2

g2

0.00%

3

g3

0.00%

4

g4

0.00%

5 and thereafter

g5

0.00%

where:
g
1 is implied by PRAT model
g
5 is implied by single-stage model
g
2g3 and g4 are calculated using linear interpoltion between g1 and g5

Calculations

g2 = g1 + (g5 – g1) × (2 – 1) ÷ (5 – 1)
0.00% + (0.00% – 0.00%) × (2 – 1) ÷ (5 – 1) = 0.00%

g3 = g1 + (g5 – g1) × (3 – 1) ÷ (5 – 1)
0.00% + (0.00% – 0.00%) × (3 – 1) ÷ (5 – 1) = 0.00%

g4 = g1 + (g5 – g1) × (4 – 1) ÷ (5 – 1)
0.00% + (0.00% – 0.00%) × (4 – 1) ÷ (5 – 1) = 0.00%

 

Chapter 4 Ratio Analysis

 

Ppt

 

Reference: Ratio Formulas

 

Reference: Commonly used ratio explained

 

 

 

 

****** DuPont Identity *************

 video 

 

 

 

ROE = (net income / sales) * (sales / assets) * (assets / shareholders' equity)

This equation for ROE breaks it into three widely used and studied components:

ROE = (net profit margin) * (asset turnover) * (equity multiplie)

 

 

Chapter 4 case study (updated, due with first mid term)

 

·        PPT affiliated with this case study FYI

·        Video is available on blackboard collaborate

 

 

Ratio Analysis  template

https://www.jufinance.com/ratio

 

 

 

 

Below are Benjamin Graham’s seven time-tested criteria to identify strong value stocks.

https://cabotwealth.com/daily/value-investing/benjamin-grahams-value-stock-criteria/

Value Stock Criteria List:

VALUE CRITERIA #1:

Look for a quality rating that is average or better. You don’t need to find the best quality companiesaverage or better is fine. Benjamin Graham recommended using Standard & Poors rating system and required companies to have an S&P Earnings and Dividend Rating of B or better. The S&P rating system ranges from D to A+. Stick to stocks with ratings of B+ or better, just to be on the safe side.

VALUE CRITERIA #2:

Graham advised buying companies with Total Debt to Current Asset ratios of less than 1.10. In value investing it is important at all times to invest in companies with a low debt load. Total Debt to Current Asset ratios can be found in data supplied by Standard & Poors, Value Line, and many other services.

VALUE CRITERIA #3:

Check the Current Ratio (current assets divided by current liabilities) to find companies with ratios over 1.50. This is a common ratio provided by many investment services.

VALUE CRITERIA #4:

Criteria four is simple: Find companies with positive earnings per share growth during the past five years with no earnings deficits. Earnings need to be higher in the most recent year than five years ago. Avoiding companies with earnings deficits during the past five years will help you stay clear of high-risk companies.

 

VALUE CRITERIA #5:

Invest in companies with price to earnings per share (P/E) ratios of 9.0 or less. Look for companies that are selling at bargain prices. Finding companies with low P/Es usually eliminates high growth companies, which should be evaluated using growth investing techniques.

VALUE CRITERIA #6:

Find companies with price to book value (P/BV) ratios less than 1.20. P/E ratios, mentioned in rule 5, can sometimes be misleading. P/BV ratios are calculated by dividing the current price by the most recent book value per share for a company. Book value provides a good indication of the underlying value of a company. Investing in stocks selling near or below their book value makes sense.

VALUE CRITERIA #7:

Invest in companies that are currently paying dividends. Investing in undervalued companies requires waiting for other investors to discover the bargains you have already found. Sometimes your wait period will be long and tedious, but if the company pays a decent dividend, you can sit back and collect dividends while you wait patiently for your stock to go from undervalued to overvalued.

One last thought. We like to find out why a stock is selling at a bargain price. Is the company competing in an industry that is dying? Is the company suffering from a setback caused by an unforeseen problem? The most important question, though, is whether the companys  problem is short-term or long-term and whether management is aware of the problem and taking action to correct it. You can put your business acumen to work to determine if management has an adequate plan to solve the companys current problems.

For class discussion: Times have changed. Mr. Granhams book about value investing was published sixty years ago. Do you think the criteria in his book are still working in todays environment?

Chapter 6 Interest rate

 

ppt

 

 

Market data website:

 http://finra-markets.morningstar.com/BondCenter/Default.jsp (FINRA bond market data)

 

Market watch on Wall Street Journal has daily yield curve and interest rate information. 

http://www.marketwatch.com/tools/pftools/

http://www.youtube.com/watch?v=yph8TRldW6k

 

The yield curve (Video, Khan academy)

 

 

 

Treasury Yields

NAME

COUPON

PRICE

YIELD

1 MONTH

1 YEAR

TIME (EST)

GB3:GOV

3 Month

0.00

1.53

1.56%

+0

-87

7:02 PM

GB6:GOV

6 Month

0.00

1.53

1.56%

+1

-94

7:02 PM

GB12:GOV

12 Month

0.00

1.49

1.53%

+2

-102

7:02 PM

GT2:GOV

2 Year

1.63

100.13

1.56%

-5

-98

7:02 PM

GT5:GOV

5 Year

1.75

100.70

1.60%

-5

-93

7:02 PM

GT10:GOV

10 Year

1.75

99.69

1.79%

-4

-93

7:02 PM

GT30:GOV

30 Year

2.38

102.98

2.24%

-2

-84

7:02 PM

 

https://www.bloomberg.com/markets/rates-bonds/government-bonds/us

 

In Class Exercise:

·         Please draw the yield curve based on the above information;

·         What can be predicted from the current yield curve?

 

 

For Daily Treasury rates such as the following, please visit https://www.treasury.gov/resource-center/data-chart-center/interest-rates/pages/textview.aspx?data=yield

 

Date

1 Mo

2 Mo

3 Mo

6 Mo

1 Yr

2 Yr

3 Yr

5 Yr

7 Yr

10 Yr

20 Yr

30 Yr

01/02/20

1.53

1.55

1.54

1.57

1.56

1.58

1.59

1.67

1.79

1.88

2.19

2.33

01/03/20

1.52

1.55

1.52

1.55

1.55

1.53

1.54

1.59

1.71

1.80

2.11

2.26

01/06/20

1.54

1.54

1.56

1.56

1.54

1.54

1.56

1.61

1.72

1.81

2.13

2.28

01/07/20

1.52

1.53

1.54

1.56

1.53

1.54

1.55

1.62

1.74

1.83

2.16

2.31

01/08/20

1.50

1.53

1.54

1.56

1.55

1.58

1.61

1.67

1.78

1.87

2.21

2.35

01/09/20

1.53

1.55

1.54

1.56

1.54

1.58

1.59

1.65

1.77

1.85

2.17

2.38

01/10/20

1.52

1.55

1.54

1.55

1.53

1.56

1.59

1.63

1.74

1.83

2.14

2.28

01/13/20

1.54

1.56

1.57

1.57

1.53

1.58

1.60

1.65

1.76

1.85

2.16

2.30

01/14/20

1.53

1.56

1.57

1.57

1.53

1.58

1.59

1.63

1.74

1.82

2.12

2.27

01/15/20

1.53

1.56

1.57

1.58

1.54

1.56

1.56

1.60

1.71

1.79

2.09

2.23

Date

1 Mo

2 Mo

3 Mo

6 Mo

1 Yr

2 Yr

3 Yr

5 Yr

7 Yr

10 Yr

20 Yr

30 Yr

01/02/20

1.53

1.55

1.54

1.57

1.56

1.58

1.59

1.67

1.79

1.88

2.19

2.33

For class discussion: Why do interest rates change daily? Who determines interest rate?

 interest rates are determined by the Federal Open Market Committee (FOMC), which consists of seven governors of the Federal Reserve Board and five Federal Reserve Bank presidents. The FOMC meets eight times a year to determine the near-term direction of monetary policy and interest rates.”

 

 

Who Determines Interest Rates?

https://www.investopedia.com/ask/answers/who-determines-interest-rates/

 

By NICK K. LIOUDIS  Updated Aug 15, 2019

 

Interest rates are the cost of borrowing money. They represent what creditors earn for lending you money. These rates are constantly changing, and differ based on the lender, as well as your creditworthiness. Interest rates not only keep the economy functioning, but they also keep people borrowing, spending, and lending. But most of us don't really stop to think about how they are implemented or who determines them. This article summarizes the three main forces that control and determine interest rates.

KEY TAKEAWAYS

  • Interest rates are the cost of borrowing money and represent what creditors earn for lending money.
  • Central banks raise or lower short-term interest rates to ensure stability and liquidity in the economy.
  • Long-term interest rates are affected by demand for 10- and 30-year U.S. Treasury notes.
  • Low demand for long-term notes leads to higher rates, while higher demand leads to lower rates.
  • Retail banks also control rates based on the market, their business needs, and individual customers.

 

Short-Term Interest Rates: Central Banks

In countries using a centralized banking model, short-term interest rates are determined by central banks. A government's economic observers create a policy that helps ensure stable prices and liquidity. This policy is routinely checked so the supply of money within the economy is neither too large, which causes prices to increase, nor too small, which can lead to a drop in prices.

In the U.S., interest rates are determined by the Federal Open Market Committee (FOMC), which consists of seven governors of the Federal Reserve Board and five Federal Reserve Bank presidents. The FOMC meets eight times a year to determine the near-term direction of monetary policy and interest rates. The actions of central banks like the Fed affect short-term and variable interest rates.

If the monetary policymakers wish to decrease the money supply, they will raise the interest rate, making it more attractive to deposit funds and reduce borrowing from the central bank. Conversely, if the central bank wishes to increase the money supply, they will decrease the interest rate, which makes it more attractive to borrow and spend money.

The Fed funds rate affects the prime ratethe rate banks charge their best customers, many of whom have the highest credit rating possible. It's also the rate banks charge each other for overnight loans.

The U.S. prime rate remained at 3.25% between Dec. 16, 2008 and Dec. 17, 2015, when it was raised to 3.5%.

 

Long-Term Interest Rates: Demand for Treasury Notes

Many of these rates are independent of the Fed funds rate, and, instead, follow 10- or 30-year Treasury note yields. These yields depend on demand after the U.S. Treasury Department auctions them off on the market. Lower demand tends to result in high interest rates. But when there is a high demand for these notes, it can push rates down lower.

If you have a long-term fixed-rate mortgage, car loan, student loan, or any similar non-revolving consumer credit product, this is where it falls. Some credit card annual percentage rates are also affected by these notes.

These rates are generally lower than most revolving credit products but are higher than the prime rate.

 

Many savings account rates are also determined by long-term Treasury notes.

 

Other Rates: Retail Banks

Retail banks are also partly responsible for controlling interest rates. Loans and mortgages they offer may have rates that change based on several factors including their needs, the market, and the individual consumer.

For example, someone with a lower credit score may be at a higher risk of default, so they pay a higher interest rate. The same applies to credit cards. Banks will offer different rates to different customers, and will also increase the rate if there is a missed payment, bounced payment, or for other services like balance transfers and foreign exchange.

http://finra-markets.morningstar.com/BondCenter/Default.jsp

Understanding the yield curve (video)

Introduction to the yield curve (khan academy)

image004.jpg

image068.jpg

image064.jpg

image070.jpg

image072.jpg

Chapter six case study

www.jufinance.com/video/fin435_c6_case_p1.mp4

www.jufinance.com/video/fin435_c6_case_p2.mp4

 

What is interest rates

https://www.youtube.com/watch?v=Pod73wrvdSQ

 

 

Gerald Celente: Low Interest Rates are Building the Biggest Bubble in Modern History - 9/21/14

https://www.youtube.com/watch?v=pTpK6Te6tYI

 

 

 

How interest rates are set

https://www.youtube.com/watch?v=Oz5hNemSdWc

 

 

 

 

What happens if Fed raise interest rates

https://www.youtube.com/watch?v=4OP-3Ui6K1s

 

 

 

 

What Is the Relationship Between Inflation and Interest Rates?

By JEAN FOLGERdated Dec 6, 2019

 

Inflation and interest rates are often linked and frequently referenced in macroeconomics. Inflation refers to the rate at which prices for goods and services rise. In the United States, the interest rate, or the amount charged by a lender to a borrower, is based on the federal funds rate that is determined by the Federal Reserve (sometimes called "the Fed").

By setting the target for the federal funds rate, the Fed has at its disposal a powerful tool that it uses to influence the rate of inflation. This tool enables the Fed to expand or contract the money supply as needed to achieve target employment rates, stable prices, and stable economic growth.

KEY TAKEAWAYS

  • There is an inverse correlation between interest rates and the rate of inflation.
  • In the U.S, the Federal Reserve is responsible for implementing the country's monetary policy, including setting the federal funds rate which influences the interest rates banks charge borrowers.
  • In general, when interest rates are low, the economy grows and inflation increases.
  • Conversely, when interest rates are high, the economy slows and inflation decreases.

 

The Inverse Correlation Between Interest Rates and Inflation

Under a system of fractional reserve banking, interest rates and inflation tend to be inversely correlated. This relationship forms one of the central tenets of contemporary monetary policy: Central banks manipulate short-term interest rates to affect the rate of inflation in the economy.

The below chart demonstrates the inverse correlation between interest rates and inflation. In the chart, CPI refers to the Consumer Price Index, a measurement that tracks changes in prices. Changes in the CPI are used to identify periods of inflation and deflation.

In general, as interest rates are reduced, more people are able to borrow more money. The result is that consumers have more money to spend, causing the economy to grow and inflation to increase.

The opposite holds true for rising interest rates. As interest rates are increased, consumers tend to save as returns from savings are higher. With less disposable income being spent as a result of the increase in the interest rate, the economy slows and inflation decreases.

To better understand how the relationship between inflation and interest rates works, it's important to understand the banking system, the quantity theory of money, and the role interest rates play.

Fractional Reserve Banking

The world currently uses a fractional reserve banking system. When someone deposits $100 into the bank, they maintain a claim on that $100. The bank, however, can lend out those dollars based on the reserve ratio set by the central bank. If the reserve ratio is 10%, the bank can lend out the other 90%, which is $90 in this case. A 10% fraction of the money stays in the bank vaults.

As long as the subsequent $90 loan is outstanding, there are two claims totaling $190 in the economy. In other words, the supply of money has increased from $100 to $190. This is a simple demonstration of how banking grows the money supply.

Quantity Theory of Money

In economics, the quantity theory of money states that the supply and demand for money determines inflation. If the money supply grows, prices tend to rise, because each individual piece of paper becomes less valuable.

Hyperinflation is an economic term used to describe extreme inflation where price increases are rapid and uncontrolled. While central banks generally target an annual inflation rate of around 2% to 3% as an acceptable rate for a healthy economy, hyperinflation goes well beyond this. Countries that experience hyperinflation have an inflation rate of 50% or more per month.

Interest Rates, Savings, Loans, and Inflation

The interest rate acts as a price for holding or loaning money. Banks pay an interest rate on savings in order to attract depositors. Banks also receive an interest rate for money that is loaned from their deposits.

When interest rates are low, individuals and businesses tend to demand more loans. Each bank loan increases the money supply in a fractional reserve banking system. According to the quantity theory of money, a growing money supply increases inflation. Thus, low interest rates tend to result in more inflation. High interest rates tend to lower inflation.

This is a very simplified version of the relationship, but it highlights why interest rates and inflation tend to be inversely correlated.

The Federal Open Market Committee

The Federal Open Market Committee (FOMC) meets eight times each year to review economic and financial conditions and decide on monetary policy. Monetary policy refers to the actions taken that affect the availability and cost of money and credit. At these meetings, short-term interest rate targets are determined.

Using economic indicators such as the Consumer Price Index (CPI) and the Producer Price Indexes (PPI), the Fed will establish interest rate targets intended to keep the economy in balance. By moving interest rate targets up or down, the Fed attempts to achieve target employment rates, stable prices, and stable economic growth. The Fed will raise interest rates to reduce inflation and decrease rates to spur economic growth.

Investors and traders keep a close eye on the FOMC rate decisions. After each of the eight FOMC meetings, an announcement is made regarding the Fed's decision to increase, decrease, or maintain key interest rates. Certain markets may move in advance of the anticipated interest rate changes and in response to the actual announcements. For example, the U.S. dollar typically rallies in response to an interest rate increase, while the bond market falls in reaction to rate hikes.

Fall in inflation raises prospects of interest rate cut

The rate dropped to 1.3% last month

chartPresentational grey line

Presentational grey line

he would consider voting for a rate cut

chart

Chapter 6 Interest rate Part II: Term Structure of Interest rate

 

Calculator

 

image020.jpg

 

Question for discussion: If a% and b% are both known to investors, such as the bank rates, how much is the future interest rate, such as c%?

 

(1+a)^N = (1+b)^m *(1+c)^(N-M)

 

Either earning a% of interest rate for N years,

or b% of interest rate for M years, and then c% of interest rate for (N-M) years,

investors should be indifferent. Right?

 

Then,

 (1+a)^N = (1+b)^m *(1+c)^(N-M)è c = ((1+a)^N / (1+b)^m)^(1/(N-M))-1

 

Or approximately,

N*a = M*b +(N-M)*(c)è c = (N*a – M*b) /(N-M)

 

 

What Is Expectations Theory  (video)

Expectations theory attempts to predict what short-term interest rates will be in the future based on current long-term interest rates. The theory suggests that an investor earns the same amount of interest by investing in two consecutive one-year bond investments versus investing in one two-year bond today. The theory is also known as the "unbiased expectations theory.”

Understanding Expectations Theory

The expectations theory aims to help investors make decisions based upon a forecast of future interest rates. The theory uses long-term rates, typically from government bonds, to forecast the rate for short-term bonds. In theory, long-term rates can be used to indicate where rates of short-term bonds will trade in the future (https://www.investopedia.com/terms/e/expectationstheory.asp)

 

 

 

 

Expectations Theory

By CHRIS B. MURPHY  Updated Apr 21, 2019

 

Example of Calculating Expectations Theory

Let's say that the present bond market provides investors with a two-year bond that pays an interest rate of 20% while a one-year bond pays an interest rate of 18%. The expectations theory can be used to forecast the interest rate of a future one-year bond.

  • The first step of the calculation is to add one to the two-year bonds interest rate. The result is 1.2.
  • The next step is to square the result or (1.2 * 1.2 = 1.44).
  • Divide the result by the current one-year interest rate and add one or ((1.44 / 1.18) +1 = 1.22).
  • To calculate the forecast one-year bond interest rate for the following year, subtract one from the result or (1.22 -1 = 0.22 or 22%).

In this example, the investor is earning an equivalent return to the present interest rate of a two-year bond. If the investor chooses to invest in a one-year bond at 18% the bond yield for the following years bond would need to increase to 22% for this investment to be advantageous.

  • Expectations theory attempts to predict what short-term interest rates will be in the future based on current long-term interest rates
  • The theory suggests that an investor earns the same amount of interest by investing in two consecutive one-year bond investments versus investing in one two-year bond today
  • In theory, long-term rates can be used to indicate where rates of short-term bonds will trade in the future

 

Expectations theory aims to help investors make decisions by using long-term rates, typically from government bonds, to forecast the rate for short-term bonds.

 

Disadvantages of Expectations Theory

Investors should be aware that the expectations theory is not always a reliable tool. A common problem with using the expectations theory is that it sometimes overestimates future short-term rates, making it easy for investors to end up with an inaccurate prediction of a bond’s yield curve.

Another limitation of the theory is that many factors impact short-term and long-term bond yields. The Federal Reserve adjusts interest rates up or down, which impacts bond yields including short-term bonds. However, long-term yields might not be as impacted because many other factors impact long-term yields including inflation and economic growth expectations. As a result, the expectations theory doesn't take into account the outside forces and fundamental macroeconomic factors that drive interest rates and ultimately bond yields.

Chapter 6 In class exercise (solution on blackboard recording)

 

1 You read in The Wall Street Journal that 30-day T-bills are currently yielding 5.5%. Your brother-in-law, a broker at Safe and Sound Securities, has given you the following estimates of current interest rate premiums:

    • Inflation premium = 3.25%
    • Liquidity premium = 0.6%
    • Maturity risk premium = 1.8%
    • Default risk premium = 2.15%

On the basis of these data, what is the real risk-free rate of return?  (answer: 2.25%)

 2 The real risk-free rate is 3%. Inflation is expected to be 2% this year and 4% during the next 2 years. Assume that the maturity risk premium is zero. What is the yield on 2-year Treasury securities? What is the yield on 3-year Treasury securities?(answer: 6%, 6.33%)

 3 A Treasury bond that matures in 10 years has a yield of 6%. A 10-year corporate bond has a yield of 8%. Assume that the liquidity premium on the corporate bond is 0.5%. What is the default risk premium on the corporate bond?  (answer: 1.5%)

4 The real risk-free rate is 3%, and inflation is expected  to be 3% for the next 2 years. A 2-year Treasury security yields 6.2%. What is the maturity risk premium for the 2-year security? (answer: 0.2%)

5 One-year Treasury securities yield 5%. The market anticipates that 1 year from now, 1-year Treasury securities will yield 6%. If the pure expectations theory is correct, what is the yield today for 2-year Treasury securities? (answer: 5.5%)

 

 

 

Chapter 7

 

ppt

 

 

 Market data website:

1.   FINRA

      http://finra-markets.morningstar.com/BondCenter/Default.jsp (FINRA bond market data)

2.      WSJ

Market watch on Wall Street Journal has daily yield curve and bond yield information. 

http://www.marketwatch.com/tools/pftools/

http://www.youtube.com/watch?v=yph8TRldW6k

3.      Bond Online

http://www.bondsonline.com/Todays_Market/

 

 

Simplified Balance Sheet of WalMart

 

In Millions of USD 

As of 2019-01-31

Total Assets

219,295,000

Total Current Liabilities

77,477,000

Long Term Debt

43,520,000

Total Liabilities

139,661,000

Total Equity

72,496,000

Total Liabilities & Shareholders' Equity

219,295,000

 https://finance.yahoo.com/quote/WMT/balance-sheet/

 

For discussion:

·         What is this “long term debt”?

·         Who is the lender of this “long term debt”?

So this long term debt is called bond in the financial market. Where can you find the pricing information and other specifications of the bond issued by WMT?

image004.jpg 

 

How Bonds Work (video)

Investing Basics: Bonds(video)

 

FINRA – Bond market information

 http://finra-markets.morningstar.com/BondCenter/Default.jsp

 

WAL-MART STORES INC

http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C104227&symbol=WMT.GP

 

Coupon Rate

7.550

%

Maturity Date

02/15/2030

Symbol

WMT.GP

CUSIP

931142BF9

Next Call Date

Callable

Last Trade Price

$147.21

Last Trade Yield

2.268%

Last Trade Date

01/27/2020

US Treasury Yield

 

 

Trade History

Credit and Rating Elements

Moody's® Rating

Aa2 (5/9//2018)

Standard & Poor's Rating

AA (02/10/2000)

TRACE Grade

Investment Grade

Default

Bankruptcy

N

Insurance

Mortgage Insurer

Pre-Refunded/Escrowed

Additional Description

Senior Unsecured Note

Classification Elements

Bond Type

US Corporate Debentures

Debt Type

Senior Unsecured Note

Industry Group

Industrial

Industry Sub Group

Retail

Sub-Product Asset

CORP

Sub-Product Asset Type

Corporate Bond

State

Use of Proceeds

Security Code

Special Characteristics

Medium Term Note

N

Issue Elements

*dollar amount in thousands

Offering Date

02/09/2000

Dated Date

02/15/2000

First Coupon Date

08/15/2000

Original Offering*

$1,000,000.00

Amount Outstanding*

$1,000,000.00

Series

Issue Description

Project Name

Payment Frequency

Semi-Annual

Day Count

30/360

Form

Book Entry

Depository/Registration

Depository Trust Company

Security Level

Senior

Collateral Pledge

Capital Purpose

Bond Elements

*dollar amount in thousands

Original Maturity Size*

1,000,000.00

Amount Outstanding Size*

1,000,000.00

Yield at Offering

7.56%

Price at Offering

$99.84

Coupon Type

Fixed

Escrow Type


 

For class discussion:

Fed has hiked interest rates. So, shall you invest in short term bond or long term bond?

Study guide  

1.      Find bond sponsored by WMT

just go to www.finra.orgè Investor center è market data è bond è corporate bond

 

Corporate Bond

Issuer Name

Callable

Coupon

Maturity

Moody

S&P

Fitch

Price

Yield

WMT

No

7.55

2/15/2030

Aa2

AA

AA

138.45

3.318

WMT

yes

6.75

4/2/2043

Aa2

AA

AA

110.45

4.065

(see below for details)

 

WALMART INC

+ ADD TO WATCHLIST

Coupon Rate

4.750

%

Maturity Date

10/02/2043

Symbol

WMT4055720

CUSIP

931142DK6

Next Call Date

04/02/2043

Callable

Yes

Last Trade Price

$110.45

Last Trade Yield

4.065%

Last Trade Date

03/14/2019

US Treasury Yield

 

Trade History

Prospectus


 

For class discussion:

·                     Fed has kept interest rates low. So, shall you invest in short term bond or long term bond?

·                     Which of the three WMT bonds are the most attractive one to you? Why?

·                     Referring to the price chart of the above bond, the price was reaching peak in the middle of 2015. Why? The price was really low in the middle of 2014. Why? Interest rate is not the reason.  

http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C610043&symbol=WMT4117477

 

Case study of chapter 7     Associated PPT  (Due with first mid term)

·      Video on blackboard

·      Also at www.jufinance.com/video/fin435_c7_case.mp4

 

 

 

In class exercises

 

1.      AAA firm’ bonds will mature in eight years, and coupon is $65. YTM is 8.2%. Bond’s market value? ($903.04,  abs(pv(8.2%, 8, 65, 1000))

 

2.                  AAA firm’s bonds’ market value is $1,120, with 15 years maturity and coupon of $85. What is YTM?  (7.17%,  rate(15, 85, -1120, 1000))

 

3.         Sadik Inc.'s bonds currently sell for $1,180 and have a par value of $1,000.  They pay a $105 annual coupon and have a 15-year maturity, but they can be called in 5 years at $1,100.  What is their yield to call (YTC)? (7.74%, rate(15, 105, -1180, 1100))

 

4.         Malko Enterprises’ bonds currently sell for $1,050.  They have a 6-year maturity, an annual coupon of $75, and a par value of $1,000.  What is their current yield? (7.14%,  75/1050)

 

5.         Assume that you are considering the purchase of a 20-year, noncallable bond with an annual coupon rate of 9.5%.  The bond has a face value of $1,000, and it makes semiannual interest payments.  If you require an 8.4% nominal yield to maturity on this investment, what is the maximum price you should be willing to pay for the bond? ($1,105.69,  abs(pv(8.4%/2, 20*2, 9.%*1000/2, 1000)) )

 

 6.        Grossnickle Corporation issued 20-year, non-callable, 7.5% annual coupon bonds at their par value of $1,000 one year ago.  Today, the market interest rate on these bonds is 5.5%.  What is the current price of the bonds, given that they now have 19 years to maturity? ($1,232.15,  abs(pv(5.5%, 19, 75, 1000)))

 

 7.        McCue Inc.'s bonds currently sell for $1,250. They pay a $90 annual coupon, have a 25-year maturity, and a $1,000 par value, but they can be called in 5 years at $1,050.  Assume that no costs other than the call premium would be incurred to call and refund the bonds, and also assume that the yield curve is horizontal, with rates expected to remain at current levels on into the future.  What is the difference between this bond's YTM and its YTC?  (Subtract the YTC from the YTM; it is possible to get a negative answer.) (2.62%, YTM = rate(25, 90, -1250, 1000), YTC = rate(5, 90, -1250, 1050))

 

8.         Taussig Corp.'s bonds currently sell for $1,150.  They have a 6.35% annual coupon rate and a 20-year maturity, but they can be called in 5 years at $1,067.50.  Assume that no costs other than the call premium would be incurred to call and refund the bonds, and also assume that the yield curve is horizontal, with rates expected to remain at current levels on into the future.  Under these conditions, what rate of return should an investor expect to earn if he or she purchases these bonds? (4.2%, rate(5, 63.5, -1150, 1067.5))

 

9.         A 25-year, $1,000 par value bond has an 8.5% annual payment coupon.  The bond currently sells for $925.  If the yield to maturity remains at its current rate, what will the price be 5 years from now? ($930.11, rate(25, 85, -925, 1000), abs(pv( rate(25, 85, -925, 1000), 20, 85, 1000))

 

10. Read the attached prospects and answer the following questions: “We are offering $500,000,000 of our 1.000% notes due 2017 (symbol  WMT4117476), $1,000,000,000 of our 3.300% notes due 2024 (symbol  WMT4117477) and $1,000,000,000 of our 4.300% notes due 2044 (symbol  WMT4117478)

 1) What is the purpose for the money raised?

2) Which of the two outstanding WMT bonds are more attractive one to you? Why?

3) Who are the underwriters for the WMT bonds? 

 

 

Bond Pricing Formula (FYI)

 

image033.jpg

 

 

 

image035.jpg

 

 

 

image036.jpg

 

 

 

 

image037.jpg

 

 

 

 

image038.jpg

 

 

 

 

Bond Pricing Excel Formula

 

To calculate bond price  in EXCEL (annual coupon bond):

Price=abs(pv(yield to maturity, years left to maturity, coupon rate*1000, 1000)

 

To calculate yield to maturity (annual coupon bond)::

Yield to maturity = rate(years left to maturity, coupon rate *1000, -price, 1000)

 

To calculate bond price (semi-annual coupon bond):

Price=abs(pv(yield to maturity/2, years left to maturity*2, coupon rate*1000/2, 1000)

 

To calculate yield to maturity (semi-annual coupon bond):

Yield to maturity = rate(years left to maturity*2, coupon rate *1000/2, -price, 1000)*2

 

 

 

 

 

 

 

 

Bond Calculator

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Redemption Features (FYI)

While the maturity date indicates how long a bond will be outstanding, many bonds are structured in such a way so that an issuer or investor can substantially change that maturity date.

Call Provision

Bonds may have a redemption – or call – provision that allows or requires the issuer to redeem the bonds at a specified price and date before maturity. For example, bonds are often called when interest rates have dropped significantly from the time the bond was issued. Before you buy a bond, always ask if there is a call provision and, if there is, be sure to consider the yield to call as well as the yield to maturity . Since a call provision offers protection to the issuer, callable bonds usually offer a higher annual return than comparable non-callable bonds to compensate the investor for the risk that the investor might have to reinvest the proceeds of a called bond at a lower interest rate.

Put Provision

A bond may have a put provision, which gives an investor the option to sell the bond to an issuer at a specified price and date prior to maturity. Typically, investors exercise a put provision when they need cash or when interest rates have risen so that they may then reinvest the proceeds at a higher interest rate. Since a put provision offers protection to the investor, bonds with such features usually offer a lower annual return than comparable bonds without a put to compensate the issuer.

Conversion

Some corporate bonds, known as convertible bonds, contain an option to convert the bond into common stock instead of receiving a cash payment. Convertible bonds contain provisions on how and when the option to convert can be exercised. Convertibles offer a lower coupon rate because they have the stability of a bond while offering the potential upside of a stock.

 

Mid Term exam (chapters 3, 4, 6, 7) on 2/11 and 2/13

 

Study Guide

First Mid Term Exam – Problems Solving Study Guide
Multiple Choice:  Problems (25*2=50)

[i].              Calculate for FCF, given EBIT, depreciation, FA, NOWC, tax rate.

[ii]. Calculate for NI, given sales, costs, tax rate, interest.

3. Calculate NOWC, given balance sheet.

4. Calculate for debt, given TA, debt ratio.

5. Calculate for times-interest-earned (TIE), given sales, costs.

6. Calculate for BEP, given TA, EBIT.

7. Calculate PE ratio, given price and EPS.

8. Calculate for PM, given ROE, TA, sales.

9. Calculate for ROE, given assets, sales, NI, debt ratio.

10. Calculate for real risk free rate of return, given T-bill rate, inflation premium.

11. Calculate for T-bill rate, given real risk free rate of return, inflation premium.

12. Calculate for T-notse rate, given real risk free rate of return, inflation premium, maturity risk premium.

13.  Calculate for corporate bond rate, given real risk free rate of return, inflation premium, maturity risk premium, default premium and liquidity premium.

14.  Calculate for liquidity premium, given corporate bond rate, real risk free rate of return, inflation premium, maturity risk premium, default premium.

15. Calculate for inflation premium, given corporate bond rate, real risk free rate of return, maturity risk premium, default premium, liquidity premium,.

16.          Calculate for maturity premium, given corporate bond rate, real risk free rate of return, inflation premium, default premium, liquidity premium.

17. Expectation theory calculation question.

18. Expectation theory calculation question.

19. Calculate for bond price, given all required information.

20.          Calculate for YTM, given all required information.

20.          Calculate for YTC, given all required information.

21.          Calculate for current yield.

22.          Calculate for YTC.

23. Calculate for coupon rate, given all required information.

24. Bond pricing

25. Given Debt ratio, ROA, ROE, TE, TA calculate NI.   

 

 

 

First Mid Term Exam Conceptual Section                       
Multiple Choice (25*2=50)

 

1.        balance sheet structure question  True / false

2.        What is RE, NI? Where can find them?   True / false

3.        Balance sheet and income statement basic question. True / false

4.        What is EBIT? What is operating income? What is EBITDA? What is gross income? What is NI?  True / false

5.        What is EBIT? What is operating income? What is EBITDA? What is gross income? What is NI?  True / false

6.        balance sheet structure question  True / false

7.        balance sheet structure question  True / false

8.        What is yield curve? True / false

9.        A downward sloping yield  ---  True / false

10.     An upward-sloping yield curve   -- True / false

11.    Compare interest rates among T bonds, T bill, T notes, and corporate bonds.     True / false

12.     Break down interest rates. True / false

13.     Break down interest rates. True / false

14.     Break down interest rates. True / false

15.     Callable bond. True / false

16.    Bond sensitivity to interest rate changes. True / false

17.    The price risk of bonds with different maturities. True / false

18.    Bond basic question. True / false

19-20. What is callable bond? Difference between callable and noncallable bond?

21.          What is the capital gain yield of a bond?

22-23. What is the differences between current yield and ytm?

24-25.    What type of bond is more sensitive to interest rate change?

 

Chapter 8 Risk and Return

 

ppt

 

 

Chapter 8 case study (due with Final)

 

Videos ---  available on blackboard collaborate Ultra under Recording

 

And also available below

1.  class video excel solver part I

2.  class video excel solver part 2 (solver, for 5 extra points)

       Excel File here (with solver solution)

3. Case video

 

 

Equations

1.     Expected return and standard deviation

 

Calculator

 

Given a probability distribution of returns, the expected return can be calculated using the following equation:

http://www.zenwealth.com/businessfinanceonline/RR/images/ER.gif

where

  • E[R] = the expected return on the stock,
  • N = the number of states,
  • pi = the probability of state i, and
  • Ri = the return on the stock in state i.

http://www.zenwealth.com/businessfinanceonline/RR/ExpectedReturn.html

Given an asset's expected return, its variance can be calculated using the following equation:

http://www.zenwealth.com/businessfinanceonline/RR/images/Var.gif

where

  • N = the number of states,
  • pi = the probability of state i,
  • Ri = the return on the stock in state i, and
  • E[R] = the expected return on the stock.

The standard deviation is calculated as the positive square root of the variance.

http://www.zenwealth.com/businessfinanceonline/RR/images/SD.gif

 http://www.zenwealth.com/businessfinanceonline/RR/MeasuresOfRisk.html

 

2.     Two stock portfolio equations:

3.       

Calculator

 

image026.jpg

W1 and W2 are the percentage of each stock in the portfolio.

image028.jpg

 

image031.gif

  • r12 = the correlation coefficient between the returns on stocks 1 and 2,
  • s12 = the covariance between the returns on stocks 1 and 2,
  • s1 = the standard deviation on stock 1, and
  • s2 = the standard deviation on stock 2.

image076.jpg

image022.jpg

  • s12 = the covariance between the returns on stocks 1 and 2,
  • N = the number of states,
  • pi = the probability of state i,
  • R1i = the return on stock 1 in state i,
  • E[R1] = the expected return on stock 1,
  • R2i = the return on stock 2 in state i, and
  • E[R2] = the expected return on stock 2.

 

3.. Historical returns

Holding period return (HPR) = (Selling price – Purchasing price + dividend)/ Purchasing price

HPR calculator

 

4.    CAPM model 

·         What Is the Capital Asset Pricing Model?

The Capital Asset Pricing Model (CAPM) describes the relationship between systematic risk and expected return for assets, particularly stocks. CAPM is widely used throughout finance for pricing risky securities and generating expected returns for assets given the risk of those assets and cost of capital.

 Ri = Rf + βi  *( Rm - Rf) ------ CAPM model

Ri = Expected return of investment

Rf = Risk-free rate

βi = Beta of the investment

Rm = Expected return of market

(Rm - Rf) = Market risk premium

 

 CAPM calculator

 

·        What is Beta? Where to find Beta?

image018.gif

 

 

·        SML – Security Market Line

image043.jpg

 

 

RISK and Return General Template

 

 

In Class Exercise 

1.      An investor currently holds the following portfolio: He invested 30% of the fund in Apple with Beta equal 1.1. He also invested 40% in GE with Beta equal 1.6. The rest of his fund goes to Ford, with Beta equal 2.2. Use the above information to answer the following questions.

1)      The beta for the portfolio is? (1.63)

2)      The three month Treasury bill rate (this is risk free rate) is 2%. S&P500 index return is 10% (this is market return).  Now calculate the portfolio’s return.  15.04%

 

 

Refer to the following graph. The three month Treasury bill rate (this is risk free rate) is 2%. S&P500 index return is 10% (this is market return). 

image045.jpg

 

2.  What is the value of A?  2%

3. What is the value of B? 10%

4. How much is the slope of the above security market line? 8%

5. Your uncle bought Apple in January, year 2000 for $30. The current price of Apple is $480 per share. Assume there are no dividend ever paid. Calculate your uncle’s holding period return.  15 times

6. Your current portfolio’s BETA is about 1.2. Your total investment is worth around $200,000. You uncle just gave you $100,000 to invest for him. With this $100,000 extra funds in hand, you plan to invest the whole $100,000 in additional stocks to increase your whole portfolio’s BETA to 1.5 (Your portfolio now worth $200,000 plus $100,000). What is the average BETA of the new stocks to achieve your goal? (hint: write down the equation of the portfolio’s Beta first) 2.10

7.

                                           Years                  Market r                Stock A                 Stock B

                                               1                               3%                      16%                         5%

                                               2                             -5%                      20%                         5%

                                               3                               1%                      18%                         5%

                                               4                           -10%                      25%                         5%

                                               5                               6%                      14%                         5%

                                               

·         Calculate the average returns of the market r and stock A and stock B. (Answer: -1%, 18.6%, 5%)

·         Calculate the standard deviations of the market, stock A, & stock B (Answer: 6.44%, 4.21%;  0 )

·         Calculate the correlation of stock market r and stock a. (Answer: -0.98)

·         Assume you invest 50% in stock A and 50% in stock B. Calculate the average return and the standard deviation of the portfolio. (Answer: 11.8%; 2.11%)

Calculate beta of stock A and beta of stock B, respectively (Answer: -0.64, 0)

 

 

 

Beating the Historical Odds: Recession Risk in 2019 and Beyond

 

 

We have long highlighted the risks that have historically been associated with large overshoots of full employment. We have noted that the Fed has never engineered a soft landing from beyond full employment, that few other advanced economy central banks have either, and that countries that have achieved very long expansions often used countercyclical policy to prevent a large overshoot in the first place. In practice it hasn’t been easy to nudge up the unemployment rate just so. While we take this lesson seriously, we think it is being applied too mechanically by market participants today. The key difference with the past is that the Phillips curve is flatter and better anchored on the Fed’s target today. As a result, where labor market overshoots once led to high and accelerating inflation and consequently had to be unwound urgently with a forceful policy response, today an overshoot will more likely mean inflation persistently but only moderately above target. The Fed could probably live with this for a while, permitting it to tighten gradually and unwind the overshoot slowly. This gives the Fed a good chance of beating the historical odds. How worried should we be about recession risk today? The history of US recessions points to two classic causes of US recessions, overheating and financial imbalances. While overheating risks could emerge down the road, they look quite limited for now: core inflation is at 2%, trend unit labor cost growth is at 2%, and both household inflation expectations and market-implied inflation compensation are below average (Exhibit 9).

image028.jpg

(Please refer to https://www.goldmansachs.com/insights/pages/outlook-2019/us-outlook/report.pdf for a better quality graph)

 

 

We also see little risk from financial imbalances at the moment. At a high level, the private sector financial balance—a very good predictor of recession risk—looks quite healthy (Exhibit 10). Digging deeper, our financial excess monitor looks for elevated valuations and stretched risk appetite across major asset classes, and for financial imbalances and vulnerabilities in the household, business, banking, and government sectors. Overall, the message is mostly reassuring. On the valuations side, while commercial real estate prices look somewhat frothy, lending terms and standards have tightened in recent years. On the sectoral imbalances side, fiscal sustainability remains a long-run concern, but we see this less as a recession trigger than as something that could prolong a downturn if policymakers perceive a lack fiscal space to respond. These two classic recession risks are complementary—overheating and the associated risk of a more abrupt shift in monetary policy is more threatening when financial imbalances are elevated and less threatening when they are limited. With neither risk looking worrisome at the moment, we do not think it makes sense to characterize the economy as “late cycle” at this point.

 

image029.jpg

The most obvious recession risk beyond 2019 is a mundane and technical one. With a low potential growth rate and a possible need to operate the economy a touch below potential to gradually unwind the overshoot—we forecast 1.5% growth in 2020 and 2021—the likelihood that normal fluctuations will tip growth negative is mechanically somewhat higher. We would interpret this as simply highlighting the arbitrariness of defining recessions as negative growth, rather than as a material rise in the unemployment rate. Of course, even a less severe recession could see a large sell-off in risk assets. Accounting for these and other considerations, our recession risk model indicates that recession risk is still quite low (Exhibit 11). The expansion is therefore on course to become the longest in US history next year, and even in subsequent years recession is not our base case.

 

image030.jpg

(Please refer to https://www.goldmansachs.com/insights/pages/outlook-2019/us-outlook/report.pdf for a better quality graph)

 

 

 

 

 

 

·         What Is the Capital Asset Pricing Model?

The Capital Asset Pricing Model (CAPM) describes the relationship between systematic risk and expected return for assets, particularly stocks. CAPM is widely used throughout finance for pricing risky securities and generating expected returns for assets given the risk of those assets and cost of capital.

 Ri = Rf + βi  *( Rm - Rf) ------ CAPM model

Ri = Expected return of investment

Rf = Risk-free rate

βi = Beta of the investment

Rm = Expected return of market

(Rm - Rf) = Market risk premium

Investors expect to be compensated for risk and the time value of money. The risk-free rate in the CAPM formula accounts for the time value of money. The other components of the CAPM formula account for the investor taking on additional risk.

 The beta of a potential investment is a measure of how much risk the investment will add to a portfolio that looks like the market. If a stock is riskier than the market, it will have a beta greater than one. If a stock has a beta of less than one, the formula assumes it will reduce the risk of a portfolio.

A stock’s beta is then multiplied by the market risk premium, which is the return expected from the market above the risk-free rate. The risk-free rate is then added to the product of the stock’s beta and the market risk premium. The result should give an investor the required return or discount rate they can use to find the value of an asset.

The goal of the CAPM formula is to evaluate whether a stock is fairly valued when its risk and the time value of money are compared to its expected return.

For example, imagine an investor is contemplating a stock worth $100 per share today that pays a 3% annual dividend. The stock has a beta compared to the market of 1.3, which means it is riskier than a market portfolio. Also, assume that the risk-free rate is 3% and this investor expects the market to rise in value by 8% per year.

The expected return of the stock based on the CAPM formula is 9.5%.

The expected return of the CAPM formula is used to discount the expected dividends and capital appreciation of the stock over the expected holding period. If the discounted value of those future cash flows is equal to $100 then the CAPM formula indicates the stock is fairly valued relative to risk.

(https://www.investopedia.com/terms/c/capm.asp)

 

 

 

Finding Beta Value  (https://finance.zacks.com/stock-beta-value-8004.html)

The current beta value of a company stock is provided for free by many online financial news services, including Morningstar, Google Finance and Yahoo Finance. Online brokerage services provide more extensive tracking of a company's beta measurements, including historical trends. Beta is sometimes listed under "market data" or other similar headings, as it describes past market performance. A stock with a beta of 1.0 has the same price volatility as the market index, meaning if the market gains, the stock makes gains at the same rate. A stock with a beta of greater than 1.0 is riskier and has greater price fluctuations, while stocks with beta values of less than 1.0 are steadier and generally larger companies.

Examples of Beta

Beta is often measured against the S&P 500 index. An S&P 500 stock with a beta of 2.0 produced a 20 percent increase in returns during a period of time when the S&P 500 Index grew only 10 percent. This same measurement also means the stock would lose 20 percent when the market dropped by only 10 percent. High beta values, including those more than 1.0, are volatile and carry more risk along with greater potential returns. The measurement doesn't distinguish between upward and downward movements. Investing Daily notes that investors try to use stocks with high beta values to quickly recoup their investments after sharp market losses.

Small-Cap Stocks

Beta values are useful to evaluate stock prices of smaller companies. These small-capitalization stocks are attractive to investors because their price volatility can promise greater returns, but Market Watch recommends only buying small-cap stocks with beta values of less than 1.0. The beta value is also a component of the Capital Asset Pricing Model, which helps investors analyze the risk of an investment and the returns needed to make it profitable.

 

 

The Importance of Diversification

http://www.youtube.com/watch?v=RoqAcdTFVFY

 

 

 Understanding Diversification in Stock Trading to Avoid Losses

http://www.youtube.com/watch?v=FrmoXog9zig

 

 

 

How to Build a Portfolio | by Wall Street Survivor

http://www.youtube.com/watch?v=V48NECmT3Ns

 

 Chapter 9 Stock Return Evaluation

 

ppt

 

For class discussion:

·       What is dividend growth model? Why can we use dividend to estimate a firm’s intrinsic value?

·       Are future dividends predictable?

·       Refer to the following table for WMT’s dividend history

 

http://stock.walmart.com/investors/stock-information/dividend-history/default.aspx

 

 

Record Dates

Payable Dates

Amount

Type

March 15, 2019

April 1, 2019

$0.53

Regular Cash

May 10, 2019

June 3, 2019

$0.53

Regular Cash

Aug. 9, 2019

Sept. 3, 2019

$0.53

Regular Cash

Dec. 6, 2019

Jan. 2, 2020

$0.53

Regular Cash

Record Dates

Payable Dates

Amount

Type

March 9, 2018

April 2, 2018

$0.52

Regular Cash

May 11, 2018

June 4, 2018

$0.52

Regular Cash

Aug. 10, 2018

Sept. 4, 2018

$0.52

Regular Cash

Dec. 7, 2018

Jan. 2, 2019

$0.52

Regular Cash

 

Record Dates

Payable Dates

Amount

Type

March 10, 2017

April 3, 2017

$0.51

Regular Cash

May 12, 2017

June 5, 2017

$0.51

Regular Cash

Aug. 11, 2017

Sept. 5, 2017

$0.51

Regular Cash

Dec. 8, 2017

Jan. 2, 2018

$0.51

Regular Cash

Record Dates

Payable Dates

Amount

Type

March 11, 2016

April 4, 2016

$0.50

Regular Cash

May 13, 2016

June 6, 2016

$0.50

Regular Cash

Aug. 12, 2016

Sep. 6, 2016

$0.50

Regular Cash

Dec. 9, 2016

Jan. 3, 2017

$0.50

Regular Cash

 

Record Dates

Payable Dates

Amount

Type

March 13, 2015

April 6, 2015

$0.490

Regular Cash

May 8, 2015

June 1, 2015

$0.490

Regular Cash

Aug. 7, 2015

Sep. 8, 2015

$0.490

Regular Cash

Dec. 4, 2015

Jan. 4, 2016

$0.490

Regular Cash

 

Can you estimate the expected dividend in 2021? And in 2022? And on and on…

image044.jpg

 

Can you write down the math equation now?

WMT stock price = ?

 

Can you calculate now? It is hard right because we assume dividend payment goes to infinity. How can we simplify the calculation?

 

We can assume that dividend grows at certain rate, just as the table on the right shows.

Discount rate is r (based on Beta and CAPM learned in chapter 6)

 

 

Dividend growth model:

image086.jpg

Refer to http://www.calculatinginvestor.com/2011/05/18/gordon-growth-model/

 

·        Now let’s apply this Dividend growth model in problem solving.

 

 

Dividend Growth Model Calculator (www.jufinance.com/stock)

 

Equations

Po = D1/(r-g) = Do*(1+g)/(r-g), 

Where D1= next dividend; Do = just paid dividend; r=stock return; g= dividend growth rate; Po= current market price 

Dividend Yield = D1/Po = Do*(1+g) / Po

Capital gain yield = (P1/Po) -1 = g

Total return = dividend yield + capital gain yield = D1/Po + g

 

Non-constant dividend growth model (www.jufinance.com/dcf)

 

Equations

Pn = Dn+1/(r-g) = Dn*(1+g)/(r-g), since year n, dividends start to grow at a constant rate.

Where Dn+1= next dividend in year n+1;

Do = just paid dividend in year n;

r=stock return; g= dividend growth rate;

Pn= current market price in year n;

 

Po = npv(r, D1, D2, …, Dn+Pn)

Or,

Po = D1/(1+r) + D2/(1+r)^2 + … + (Dn+Pn)/(1+r)^n

 

 

Case Study (due with Final)

Video on blackboard and here (www.jufinance.com/video/fin435_c9_case.mp4) 

 

In class exercise (video)

 

1.      You expect AAA Corporation to generate the following free cash flows over the next five years:

 

Year

1

2

3

4

5

FCF ($ millions)

75

84

96

111

120

 

Since year 6, you estimate that AAA's free cash flows will grow at 6% per year. WACC of AAA = 15%

·         Calculate the enterprise value for DM Corporation.

·         Assume that AAA has $500 million debt and 14 million shares outstanding, calculate its stock price.

 

2.  AAA’s divided yield = 2.5%, equity cost = 10%, and its dividends will grow at a constant rate of g.  How much is g?

A) 2.5%

B) 5.0%

C) 10.0%

D) 7.5%

Answer: 

 

3. AAA pays no dividend currently. However, you expect it pay an annual dividend of $0.56/share 2 years from now with a growth rate of 4% per year thereafter. Its equity cost = 12%, then its stock price=?

A) $4.67

B) $5.00

C) $6.25

D) $7.00

Answer: 

 


 

4. AAA expects to have earnings of $2.50 per share this coming year. It will retain all of the earnings for the next year. For the following 3 years, it will retain 50% of its earnings. It will ten retain 25% of its earnings after that. Each year, retained earnings will be used in new projects with a return of 20% per year as expected. The rest of retained earnings will paid to shareholders as dividends. Its equity cost = 10%. Its stock price=?

A) $40.80

B) $44.60

C) $59.80

D) $63.50

 

Year

EPS

Retained

Earnings

Growth in Earnings (.20 × R.E.)

Dividends

1

$2.50

$2.50

 

 

2

 

 

 

 

3

 

 

 

 

4

 

 

 

 

5

 

 

 

 

 

 Hint: after year 5, the growth rate =0.2/3.99 = 5%

 

Answer:

Year

EPS

Retained

Earnings

Growth in Earnings (.20 × R.E.)

Dividends

1

$2.50

$2.50

0.5

0

2

3

1.5

0.3

1.5

3

3.3

1.65

0.33

1.65

4

3.63

1.82

0.36

1.82

5

3.99

1

0.2

3

 

after year 5, the growth rate =0.2/3.99 = 5% = growth in earnings / EPS

So price at year 4 = 3/(10%-5%) =60

So current stock price = 1.5/(1+10%)^2 + 1.65/(1+10%)^3 + 1.82/(1+10%)^4 + 60/(1+10%)^4 = 44.60

Or price = npv(10%, 0, 1.5, 1.65, 1.82+44.60)

 

 

 

 

Live session on 3/17 (on blackboard collaborate ultra recording as well)    Class notes FYI

·       In class exercise of chapter 9

 

Stock screening tools

·         Reuters stock screener to help select stocks

http://stockscreener.us.reuters.com/Stock/US/

 

·         FINVIZ.com

http://finviz.com/screener.ashx

 

·         WSJ stock screen

http://online.wsj.com/public/quotes/stock_screener.html

 

·         Simply the Web's Best Financial Charts

 Stock charts

 

 

MSN Money

You can find analyst rating from MSN money

For instance,

ANALYSTS RATINGS

Zacks average brokerage recommendation is Moderate Buy

RECOMMENDATIONS

CURRENT

1 MONTH AGO

2 MONTHS AGO

3 MONTHS AGO

Strong Buy

26

26

25

24

Moderate Buy

4

4

4

4

Hold

8

8

8

9

Moderate Sell

0

0

0

0

Strong Sell

0

0

0

0

Mean Rec.

1.51

1.51

1.53

1.58

 

 

 

Summary of stock screening rules from class discussion

PEG<1

PE<15  (? FB’s PE>100?)

Growth rate<20

ROE>10%

Analyst ranking: strong buy only

Zacks average =1 (from Ranking stocks using PEG ratio)

current price>5

 

 

   How to pick stocks

Capital Asset Pricing Model (CAPM)Explained

http://www.youtube.com/watch?v=JApBhv3VLTo

 

Ranking stocks using PEG ratio

http://www.youtube.com/watch?v=bekW_hTehNU

 

 

 

P/E Ratio Summary by industry (FYI)

(http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/pedata.html

 

Industry Name

#of firms

Current PE

Expected growth - next 5 years

PEG Ratio

Advertising

40

42.07

7.24%

2.19

Aerospace/Defense

87

45.24

11.46%

2.08

Air Transport

17

12.40

6.46%

2.00

Apparel

51

19.94

11.32%

2.33

Auto & Truck

18

15.03

18.35%

0.80

Auto Parts

62

23.32

12.64%

1.17

Bank (Money Center)

11

17.09

7.54%

1.86

Banks (Regional)

612

33.24

9.43%

1.87

Beverage (Alcoholic)

28

31.31

20.06%

0.95

Beverage (Soft)

35

28.28

10.77%

2.99

Broadcasting

27

31.34

7.59%

2.58

Brokerage & Investment Banking

42

31.77

11.70%

1.39

Building Materials

39

28.83

14.98%

1.58

Business & Consumer Services

169

59.52

12.94%

2.01

Cable TV

14

25.74

10.25%

2.51

Chemical (Basic)

38

28.39

14.14%

1.38

Chemical (Diversified)

7

281.02

18.82%

2.28

Chemical (Specialty)

99

145.32

12.34%

2.04

Coal & Related Energy

30

13.36

NA

NA

Computer Services

111

48.66

12.36%

1.37

Computers/Peripherals

58

26.11

15.79%

1.14

Construction Supplies

49

35.67

15.00%

2.21

Diversified

24

38.63

12.48%

1.96

Drugs (Biotechnology)

459

127.65

27.31%

0.65

Drugs (Pharmaceutical)

185

46.35

20.47%

1.32

Education

34

132.99

11.91%

2.35

Electrical Equipment

118

29.63

15.09%

1.75

Electronics (Consumer & Office)

24

35.28

12.77%

4.86

Electronics (General)

167

56.36

17.82%

1.42

Engineering/Construction

49

28.75

12.30%

1.92

Entertainment

90

312.73

11.54%

1.56

Environmental & Waste Services

87

73.67

12.83%

2.43

Farming/Agriculture

34

22.90

15.33%

1.42

Financial Svcs. (Non-bank & Insurance)

264

41.45

11.62%

0.88

Food Processing

87

36.08

9.46%

2.55

Food Wholesalers

15

50.79

8.70%

3.03

Furn/Home Furnishings

31

17.82

13.40%

1.43

Green & Renewable Energy

22

89.05

11.05%

2.91

Healthcare Products

251

161.11

16.55%

2.27

Healthcare Support Services

115

38.56

14.52%

1.37

Heathcare Information and Technology

112

174.42

15.21%

2.52

Homebuilding

32

883.19

17.58%

0.99

Hospitals/Healthcare Facilities

35

58.93

6.50%

2.09

Hotel/Gaming

70

34.20

13.18%

1.90

Household Products

131

46.52

11.60%

1.61

Information Services

61

60.11

14.92%

2.42

Insurance (General)

21

34.97

10.46%

2.11

Insurance (Life)

25

152.83

7.82%

1.52

Insurance (Prop/Cas.)

50

120.04

11.56%

1.64

Investments & Asset Management

165

99.35

13.11%

1.31

Machinery

126

47.35

14.03%

1.82

Metals & Mining

102

28.08

30.62%

0.92

Office Equipment & Services

24

18.92

12.25%

1.72

Oil/Gas (Integrated)

5

45.20

25.77%

1.26

Oil/Gas (Production and Exploration)

311

25.17

1.81%

7.33

Oil/Gas Distribution

16

313.75

10.00%

3.77

Oilfield Svcs/Equip.

130

87.54

40.24%

0.90

Packaging & Container

25

51.42

9.31%

2.31

Paper/Forest Products

21

40.11

9.62%

2.09

Power

61

25.25

5.41%

2.07

Precious Metals

111

29.92

24.26%

2.47

Publishing & Newspapers

41

53.87

7.90%

2.75

R.E.I.T.

244

58.88

6.81%

3.65

Real Estate (Development)

20

20.24

NA

NA

Real Estate (General/Diversified)

10

216.85

NA

NA

Real Estate (Operations & Services)

60

486.19

13.63%

1.39

Recreation

70

27.16

12.23%

1.90

Reinsurance

3

11.75

8.75%

2.27

Restaurant/Dining

81

37.50

15.04%

1.70

Retail (Automotive)

25

14.30

16.63%

0.96

Retail (Building Supply)

8

46.86

20.46%

1.21

Retail (Distributors)

92

120.38

15.04%

1.45

Retail (General)

18

96.81

7.88%

2.93

Retail (Grocery and Food)

14

28.23

7.90%

1.75

Retail (Online)

61

73.27

20.77%

3.70

Retail (Special Lines)

106

43.48

11.59%

1.52

Rubber& Tires

4

13.28

9.50%

0.85

Semiconductor

72

49.82

15.68%

1.30

Semiconductor Equip

45

37.81

16.67%

0.97

Shipbuilding & Marine

9

18.23

13.50%

1.96

Shoe

11

95.38

12.39%

2.17

Software (Entertainment)

13

67.28

14.94%

2.56

Software (Internet)

305

205.58

27.74%

1.03

Software (System & Application)

255

209.66

17.06%

1.90

Steel

37

28.91

12.22%

1.53

Telecom (Wireless)

18

64.32

10.83%

2.27

Telecom. Equipment

104

114.62

14.42%

1.36

Telecom. Services

66

61.28

5.99%

2.77

Tobacco

24

29.52

10.33%

1.30

Transportation

18

82.37

15.49%

1.74

Transportation (Railroads)

8

27.22

10.56%

2.26

Trucking

30

29.95

21.01%

1.54

Utility (General)

18

27.54

5.50%

4.30

Utility (Water)

23

141.22

8.99%

3.66

Total Market

7247

71.28

13.60%

1.58

Total Market (without financials)

6057

75.42

14.19%

1.64

 

 

 

 

Details about how to derive the model mathematically (FYI)

The Gordon growth model is a simple discounted cash flow (DCF) model which can be used to value a stock, mutual fund, or even the entire stock market.  The model is named after Myron Gordon who first published the model in 1959.

The Gordon model assumes that a financial security pays a periodic dividend (D) which grows at a constant rate (g). These growing dividend payments are assumed to continue forever. The future dividend payments are discounted at the required rate of return (r) to find the price (P) for the stock or fund.

Under these simple assumptions, the price of the security is given by this equation:

image086.jpg

In this equation, I’ve used the “0” subscript on the price (P) and the “1” subscript on the dividend (D) to indicate that the price is calculated at time zero and the dividend is the expected dividend at the end of period one. However, the equation is commonly written with these subscripts omitted.

Obviously, the assumptions built into this model are overly simplistic for many real-world valuation problems. Many companies pay no dividends, and, for those that do, we may expect changing payout ratios or growth rates as the business matures.

Despite these limitations, I believe spending some time experimenting with the Gordon model can help develop intuition about the relationship between valuation and return.

Deriving the Gordon Growth Model Equation

The Gordon growth model calculates the present value of the security by summing an infinite series of discounted dividend payments which follows the pattern shown here:

image081.jpg

Multiplying both sides of the previous equation by (1+g)/(1+r) gives:

image082.jpg

We can then subtract the second equation from the first equation to get:

image083.jpg

Rearranging and simplifying:

image084.jpg

image085.jpg

Finally, we can simplify further to get the Gordon growth model equation

 

Chapter 10 WACC

 

ppt

 

image050.jpg

 

 

 

 

One option (if beta is given)

image087.jpg

Another option (if dividend is given):

image088.jpg

 

WACC Formula

image089.jpg

WACC calculator (annual coupon bond)

(www.jufinance.com/wacc)

 

image090.jpg

WACC calculator  (semi-annual coupon bond)

 (www.jufinance.com/wacc_1)

 

 

WACC Calculator help videos FYI

 

 

Summary of Equations

 

Discount rate to figure out the value of projects is called WACC (weighted average cost of capital)

 

WACC = weight of debt * cost of debt   + weight of equity *( cost of equity)

 

·         Wd= total debt / Total capital  = total borrowed / total capital

·         We= total equity/ Total capital  

·         Cost of debt = rate(nper, coupon, -(price – flotation costs), 1000)*(1-tax rate)

·         Cost of Equity = D1/(Po – Flotation Cost)  + g  

·         D1: Next period dividend; Po: Current stock price; g: dividend growth rate

·         Note: flotation costs = flotation percentage * price

 

·         Or if beta is given, use CAPM model

1.      Cost of equity = risk free rate + beta *(market return – risk free rate)

2.      Cost of equity = risk free rate + beta * market risk premium

 

 

 

 

Discussion:

·         Cheaper to raise capital from debt market. Why? Why not 100% financing via borrowing?

·         Why tax rate cannot reduce firms’ cost of equity?

·         Please refer to the following excel worksheet to learn how to calculate WACC of Hertz (7.99%).

Excel file is here. Thanks to Chris, Brian and Hanna, the CFA competition team of 2017.

 

(FYI: Hertz Global Holdings Inc  (NYSE:HTZ) WACC %:-6.02% As of Today 

 

As of today, Hertz Global Holdings Inc's weighted average cost of capital is -6.02%. Hertz Global Holdings Inc's ROIC % is -16.07% (calculated using TTM income statement data). Hertz Global Holdings Inc generates higher returns on investment than it costs the company to raise the capital needed for that investment. It is earning excess returns. A firm that expects to continue generating positive excess returns on new investments in the future will see its value increase as growth increases.  https://www.gurufocus.com/term/wacc/HTZ/WACC/Hertz+Global+Holdings+Inc)

 

 

In Class Exercise     (Class notes 3-24-2020)

1.      IBM financed 10m via debt coupon 5%, 10 year, price is $950 and flotation is 7% of the price, tax 40%.

IBM financed 20m via equity. D1=$5. Po=50, g is 5%. Flotation cost =0. So WACC?

Wd=1/3. We=2/3.

Kd = rate(10, 5%*1000, 950-950*7%, 1000)*(1-40%)

Ke = 5/(50 – 0) + 5%

WACC = Wd*Kd +We*Ke =

 

2.      Firm AAA sold a noncallable bond now has 20 years to maturity.  9.25% annual coupon rate, paid semiannually, sells at a price = $1,075, par = $1,000.  Tax rate = 40%, calculate after tax cost of debt (5.08%)

3.        Firm AAA’s equity condition is as follows. D1 = $1.25; P0 = $27.50; g = 5.00%; and Flotation = 6.00% of price.  Calculate cost of equity (9.84%)

4.      Firm AAA raised 10m from the capital market. In it, 3m is from the debt market and the rest from the equity market. Calculate WACC.

 

WACC Case study (due with final)

 

Live session 3-19 (also on blackboard)

·       Case study of chapter 10 part I

 

Live session 3-24 (also on blackboard)

·       Case study of chapter 10 part II

·       In class exercise  Class notes

 

 

 

 

 

FYI
Walmart Inc  (NYSE:WMT) WACC %:4.81% As of Today 

 

As of today, Walmart Inc's weighted average cost of capital is 4.81%. Walmart Inc's ROIC % is 11.04% (calculated using TTM income statement data). Walmart Inc generates higher returns on investment than it costs the company to raise the capital needed for that investment. It is earning excess returns. A firm that expects to continue generating positive excess returns on new investments in the future will see its value increase as growth increases.

https://www.gurufocus.com/term/wacc/WMT/WACC/Walmart%2BInc

 

 

 

Amazon.com Inc  (NAS:AMZN) WACC %:10.06% As of Today 

 

As of today, Amazon.com Inc's weighted average cost of capital is 10.06%. Amazon.com Inc's ROIC % is 19.58% (calculated using TTM income statement data). Amazon.com Inc generates higher returns on investment than it costs the company to raise the capital needed for that investment. It is earning excess returns. A firm that expects to continue generating positive excess returns on new investments in the future will see its value increase as growth increases.

 https://www.gurufocus.com/term/wacc/AMZN/WACC-Percentage/Amazon.com%20Inc

 

 

Apple Inc  (NAS:AAPL) WACC %:7.96% As of Today 

 

As of today, Apple Inc's weighted average cost of capital is 7.64%. Apple Inc's ROIC % is 48.13% (calculated using TTM income statement data). Apple Inc generates higher returns on investment than it costs the company to raise the capital needed for that investment. It is earning excess returns. A firm that expects to continue generating positive excess returns on new investments in the future will see its value increase as growth increases.

https://www.gurufocus.com/term/wacc/AAPL/WACC/Apple%2Binc 

 

 Cost of Capital by Sector (US)

 

 Date of Analysis: Data used is as of January 2019

 

Industry Name

Number of Firms

Beta

Cost of Equity

E/(D+E)

Std Dev in Stock

Cost of Debt

Tax Rate

After-tax Cost of Debt

D/(D+E)

Cost of Capital

Advertising

48

1.22

9.93%

58.46%

66.44%

5.43%

5.69%

4.07%

41.54%

7.49%

Aerospace/Defense

85

1.24

10.07%

79.75%

40.77%

4.56%

11.40%

3.42%

20.25%

8.72%

Air Transport

18

1.02

8.77%

52.68%

34.19%

4.18%

6.48%

3.14%

47.32%

6.10%

Apparel

50

0.93

8.23%

74.07%

48.89%

4.56%

14.19%

3.42%

25.93%

6.98%

Auto & Truck

14

0.79

7.41%

33.85%

38.24%

4.18%

10.15%

3.14%

66.15%

4.58%

Auto Parts

52

1.17

9.63%

71.45%

44.28%

4.56%

11.57%

3.42%

28.55%

7.86%

Bank (Money Center)

10

0.71

6.93%

32.91%

18.29%

3.58%

26.01%

2.69%

67.09%

4.08%

Banks (Regional)

633

0.57

6.07%

56.65%

20.60%

3.58%

26.99%

2.69%

43.35%

4.60%

Beverage (Alcoholic)

31

1.3

10.42%

74.53%

33.49%

4.18%

2.55%

3.14%

25.47%

8.57%

Beverage (Soft)

37

1.18

9.70%

80.95%

50.32%

4.56%

3.87%

3.42%

19.05%

8.50%

Broadcasting

24

1.02

8.76%

40.89%

37.29%

4.18%

2.54%

3.14%

59.11%

5.44%

Brokerage & Investment Banking

38

1.21

9.87%

25.21%

32.08%

4.18%

22.47%

3.14%

74.79%

4.83%

Building Materials

42

1.1

9.21%

75.19%

33.40%

4.18%

16.11%

3.14%

24.81%

7.70%

Business & Consumer Services

168

1.22

9.94%

73.70%

44.86%

4.56%

7.60%

3.42%

26.30%

8.22%

Cable TV

14

1.13

9.43%

58.58%

26.32%

4.18%

3.61%

3.14%

41.42%

6.82%

Chemical (Basic)

39

1.55

11.92%

60.07%

54.33%

4.56%

7.33%

3.42%

39.93%

8.52%

Chemical (Diversified)

6

1.82

13.51%

73.10%

32.60%

4.18%

3.18%

3.14%

26.90%

10.72%

Chemical (Specialty)

89

1.17

9.65%

75.40%

42.33%

4.56%

10.71%

3.42%

24.60%

8.12%

Coal & Related Energy

23

1.17

9.64%

59.74%

53.58%

4.56%

1.75%

3.42%

40.26%

7.14%

Computer Services

119

1.27

10.25%

71.85%

41.69%

4.56%

8.75%

3.42%

28.15%

8.32%

Computers/Peripherals

57

1.68

12.69%

79.92%

49.87%

4.56%

6.60%

3.42%

20.08%

10.83%

Construction Supplies

48

1.45

11.34%

68.55%

32.24%

4.18%

13.21%

3.14%

31.45%

8.76%

Diversified

23

1.36

10.78%

73.82%

39.46%

4.18%

7.41%

3.14%

26.18%

8.78%

Drugs (Biotechnology)

481

1.51

11.69%

84.09%

68.96%

5.43%

0.93%

4.07%

15.91%

10.48%

Drugs (Pharmaceutical)

237

1.47

11.41%

87.44%

72.45%

5.43%

2.26%

4.07%

12.56%

10.49%

Education

35

1.28

10.29%

76.49%

37.66%

4.18%

6.14%

3.14%

23.51%

8.61%

Electrical Equipment

116

1.32

10.56%

81.87%

57.29%

4.56%

4.36%

3.42%

18.13%

9.27%

Electronics (Consumer & Office)

19

1.19

9.78%

91.10%

62.71%

4.56%

7.67%

3.42%

8.90%

9.21%

Electronics (General)

160

1.02

8.74%

83.77%

46.69%

4.56%

11.67%

3.42%

16.23%

7.87%

Engineering/Construction

52

1.01

8.68%

67.17%

40.14%

4.56%

7.62%

3.42%

32.83%

6.96%

Entertainment

120

1.33

10.61%

83.43%

54.34%

4.56%

1.93%

3.42%

16.57%

9.42%

Environmental & Waste Services

91

1.19

9.78%

74.83%

46.15%

4.56%

3.23%

3.42%

25.17%

8.18%

Farming/Agriculture

33

0.72

6.95%

60.15%

29.07%

4.18%

9.64%

3.14%

39.85%

5.43%

Financial Svcs. (Non-bank & Insurance)

259

0.7

6.87%

8.08%

27.33%

4.18%

20.38%

3.14%

91.92%

3.44%

Food Processing

83

0.81

7.51%

68.12%

27.46%

4.18%

5.17%

3.14%

31.88%

6.12%

Food Wholesalers

18

1.62

12.36%

69.03%

40.99%

4.56%

4.71%

3.42%

30.97%

9.59%

Furn/Home Furnishings

30

0.88

7.95%

66.37%

43.51%

4.56%

16.96%

3.42%

33.63%

6.43%

Green & Renewable Energy

21

1.62

12.34%

40.58%

69.48%

5.43%

0.00%

4.07%

59.42%

7.43%

Healthcare Products

248

1.12

9.37%

87.06%

56.32%

4.56%

5.46%

3.42%

12.94%

8.60%

Healthcare Support Services

111

1.15

9.56%

73.41%

48.13%

4.56%

8.33%

3.42%

26.59%

7.92%

Heathcare Information and Technology

119

1.29

10.36%

85.30%

53.01%

4.56%

5.65%

3.42%

14.70%

9.34%

Homebuilding

31

0.98

8.53%

61.64%

34.08%

4.18%

24.35%

3.14%

38.36%

6.46%

Hospitals/Healthcare Facilities

34

1.12

9.34%

41.71%

49.69%

4.56%

6.88%

3.42%

58.29%

5.89%

Hotel/Gaming

70

1.01

8.68%

61.01%

35.01%

4.18%

9.55%

3.14%

38.99%

6.52%

Household Products

141

1.13

9.42%

82.56%

54.64%

4.56%

7.14%

3.42%

17.44%

8.37%

Information Services

71

1.12

9.36%

86.91%

37.11%

4.18%

10.37%

3.14%

13.09%

8.55%

Insurance (General)

20

0.87

7.88%

67.63%

24.63%

3.58%

13.97%

2.69%

32.37%

6.20%

Insurance (Life)

23

1.11

9.29%

48.84%

27.64%

4.18%

3.47%

3.14%

51.16%

6.14%

Insurance (Prop/Cas.)

50

0.74

7.09%

79.71%

23.90%

3.58%

15.95%

2.69%

20.29%

6.20%

Investments & Asset Management

172

1.1

9.26%

59.76%

35.43%

4.18%

7.09%

3.14%

40.24%

6.79%

Machinery

127

1.17

9.66%

78.78%

34.36%

4.18%

13.62%

3.14%

21.22%

8.27%

Metals & Mining

94

1.32

10.56%

70.53%

75.46%

8.43%

3.06%

6.32%

29.47%

9.31%

Office Equipment & Services

24

1.81

13.49%

61.97%

39.46%

4.18%

13.71%

3.14%

38.03%

9.55%

Oil/Gas (Integrated)

5

1.16

9.58%

85.29%

17.62%

3.58%

8.91%

2.69%

14.71%

8.57%

Oil/Gas (Production and Exploration)

301

1.45

11.34%

64.44%

57.36%

4.56%

1.93%

3.42%

35.56%

8.52%

Oil/Gas Distribution

20

1.07

9.06%

49.68%

36.03%

4.18%

8.05%

3.14%

50.32%

6.08%

Oilfield Svcs/Equip.

134

1.33

10.59%

68.13%

49.29%

4.56%

4.22%

3.42%

31.87%

8.31%

Packaging & Container

27

1.07

9.09%

60.09%

27.47%

4.18%

13.01%

3.14%

39.91%

6.71%

Paper/Forest Products

20

1.4

11.00%

67.40%

42.72%

4.56%

8.42%

3.42%

32.60%

8.53%

Power

51

0.54

5.92%

55.74%

20.53%

3.58%

13.59%

2.69%

44.26%

4.49%

Precious Metals

91

1.19

9.78%

82.48%

74.54%

5.43%

2.08%

4.07%

17.52%

8.78%

Publishing & Newspapers

33

1.26

10.16%

58.78%

39.32%

4.18%

12.00%

3.14%

41.22%

7.26%

R.E.I.T.

238

0.68

6.72%

52.44%

21.22%

3.58%

2.42%

2.69%

47.56%

4.80%

Real Estate (Development)

18

1.19

9.80%

59.01%

40.78%

4.56%

0.00%

3.42%

40.99%

7.19%

Real Estate (General/Diversified)

11

1.36

10.81%

66.74%

21.50%

3.58%

7.10%

2.69%

33.26%

8.11%

Real Estate (Operations & Services)

59

1.35

10.70%

60.48%

42.49%

4.56%

8.46%

3.42%

39.52%

7.82%

Recreation

72

0.98

8.51%

73.36%

42.73%

4.56%

7.43%

3.42%

26.64%

7.16%

Reinsurance

2

0.97

8.46%

77.00%

16.27%

3.58%

9.80%

2.69%

23.00%

7.13%

Restaurant/Dining

78

0.8

7.44%

73.79%

38.18%

4.18%

8.96%

3.14%

26.21%

6.31%

Retail (Automotive)

24

1.15

9.56%

58.17%

33.22%

4.18%

8.89%

3.14%

41.83%

6.87%

Retail (Building Supply)

17

1.12

9.34%

81.41%

46.94%

4.56%

20.08%

3.42%

18.59%

8.24%

Retail (Distributors)

88

1.44

11.26%

60.37%

44.59%

4.56%

8.15%

3.42%

39.63%

8.15%

Retail (General)

19

0.91

8.12%

74.58%

39.63%

4.18%

10.85%

3.14%

25.42%

6.85%

Retail (Grocery and Food)

12

0.45

5.37%

54.52%

33.06%

4.18%

3.01%

3.14%

45.48%

4.35%

Retail (Online)

79

1.42

11.12%

89.29%

54.22%

4.56%

3.85%

3.42%

10.71%

10.30%

Retail (Special Lines)

91

1.07

9.06%

65.95%

49.17%

4.56%

13.81%

3.42%

34.05%

7.14%

Rubber& Tires

4

0.42

5.17%

45.53%

29.03%

4.18%

25.00%

3.14%

54.47%

4.06%

Semiconductor

72

1.34

10.64%

87.61%

42.66%

4.56%

10.19%

3.42%

12.39%

9.75%

Semiconductor Equip

41

1.39

10.96%

85.78%

48.66%

4.56%

13.77%

3.42%

14.22%

9.88%

Shipbuilding & Marine

9

1.08

9.10%

63.81%

55.89%

4.56%

0.00%

3.42%

36.19%

7.05%

Shoe

10

0.75

7.18%

93.08%

38.65%

4.18%

18.57%

3.14%

6.92%

6.90%

Software (Entertainment)

92

1.26

10.18%

97.86%

65.58%

5.43%

3.47%

4.07%

2.14%

10.04%

Software (Internet)

44

1.46

11.37%

82.20%

51.90%

4.56%

0.85%

3.42%

17.80%

9.95%

Software (System & Application)

355

1.23

10.00%

88.60%

50.68%

4.56%

4.62%

3.42%

11.40%

9.25%

Steel

37

1.62

12.33%

66.56%

44.32%

4.56%

4.18%

3.42%

33.44%

9.35%

Telecom (Wireless)

21

1.26

10.21%

46.34%

44.49%

4.56%

2.38%

3.42%

53.66%

6.57%

Telecom. Equipment

98

1.09

9.18%

84.71%

45.72%

4.56%

6.20%

3.42%

15.29%

8.30%

Telecom. Services

67

1.22

9.94%

52.85%

54.23%

4.56%

3.72%

3.42%

47.15%

6.87%

Tobacco

17

1.29

10.37%

79.85%

48.08%

4.56%

7.27%

3.42%

20.15%

8.97%

Transportation

19

1.14

9.49%

70.19%

33.82%

4.18%

5.29%

3.14%

29.81%

7.59%

Transportation (Railroads)

10

2.47

17.39%

78.78%

20.12%

3.58%

0.00%

2.69%

21.22%

14.27%

Trucking

28

1.22

9.94%

49.24%

41.51%

4.56%

1.23%

3.42%

50.76%

6.63%

Utility (General)

18

0.27

4.27%

58.36%

15.34%

3.58%

14.66%

2.69%

41.64%

3.61%

Utility (Water)

19

0.42

5.21%

69.93%

22.94%

3.58%

9.49%

2.69%

30.07%

4.45%

Total Market 

7209

1.12

9.38%

60.01%

42.67%

4.56%

8.76%

3.42%

39.99%

7.00%

Total Market (without financials)

6004

1.21

9.87%

74.34%

46.24%

4.56%

6.21%

3.42%

25.66%

8.22%

 

http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/wacc.htm

 

 

KPMG WACC Study 2017 (FYI)

 

 

Chapter 11: Capital Budgeting

 

ppt

 

calculator   Excel Template

 

Case study questions (due with final)

 

 

3-26 live session (also on blackboard)

·       Chapter 11 case study part I

 

 3-31 live session(also on blackboard)

·       Chapter 11 case study part II

 

 

 

 

1.      NPV Excel syntax

Syntax

  NPV(rate,value1,value2, ...)

  Rate     is the rate of discount over the length of one period.

  Value1, value2, ...     are 1 to 29 arguments representing the payments and income.

·         Value1, value2, ... must be equally spaced in time and occur at the end of each    period. NPV uses the order of value1, value2, ... to interpret the order of cash flows. Be sure to enter your payment and income values in the correct sequence.

 

2.      IRR Excel syntax

Syntax

   IRR(values, guess)

   Values  is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.

  Guess     is a number that you guess is close to the result of IRR.

 image040.jpg

 

image100.jpg 

 

image099.jpg

 

image047.jpg

 

Or, PI = NPV / CFo +1

Profitable index (PI) =1 + NPV / absolute value of CFo

 

3.     MIRR( valuesfinance_ratereinvest_rate )   ----- Excel

Where the function arguments are as follows:

Values

-

An array of values (or a reference to a range of cells containing values) representing the series of cash flows (investment and net income values) that occur at regular periods.

These must contain at least one negative value (representing payment) and at least one positive value (representing income).

finance_rate

-

The interest rate paid on the money used in the cash flows.

reinvest_rate

-

The interest rate paid on the reinvested cash flows.

 

image036.jpg

 

 

Modified Rate of Return: Definition & Example (video)

https://study.com/academy/lesson/modified-rate-of-return-definition-example.html 

 

 


image046.jpg

 

 

Weighted Average Cost of Capital (WACC) Calculator (FYI)

http://www.ultimatecalculators.com/weighted_average_cost_of_capital_WACC_calculator.html

 

 

Simple Rules for Running a Business (fyi)

From the 20-page cellphone contract to the five-pound employee handbook, even the simple things seem to be getting more complicated.

Companies have been complicating things for themselves, tooanalyzing hundreds of factors when making decisions, or consulting reams of data to resolve every budget dilemma. But those requirements might be wasting time and muddling priorities.

So argues Donald Sull, a lecturer at the Sloan School of Management at the Massachusetts Institute of Technology who has also worked for McKinsey & Co. and Clayton, Dubilier & Rice LLC. In the book Simple Rules: How to Thrive in a Complex World, out this week from Houghton Mifflin Harcourt HMHC -1.36%, he and Kathleen Eisenhardt of Stanford University claim that straightforward guidelines lead to better results than complex formulas.

Mr. Sull recently spoke with At Work about what companies can do to simplify, and why five basic rules can beat a 50-item checklist. Edited excerpts:

WSJ: Where, in the business context, might simple rules help more than a complicated approach?

Donald Sull: Well, a common decision that people face in organizations is capital allocation. In many organizations, there will be thick procedure books or algorithmsone company I worked with had an algorithm that had almost 100 variables for every project. These are very cumbersome approaches to making decisions and can waste time. Basically, any decision about how to focus resourceseither people or money or attentioncan benefit from simple rules.

WSJ: Can you give an example of how that simplification works in a company?

Sull: Theres a German company called Weima GmBH that makes shredders. At one point, they were getting about 10,000 requests and could only fill about a thousand because of technical capabilities, so they had this massive problem of sorting out which of these proposals to pursue.

They had a very detailed checklist with 40 or 50 items. People had to gather data and if there were gray areas the proposal would go to management. But because the data was hard to obtain and there were so many different pieces, people didnt always fill out the checklists completely. Then management had to discuss a lot of these proposals personally because there was incomplete data. So top management is spending a disproportionate amount of time discussing this low-level stuff.

Then Weima came up with guidelines that the frontline sales force and engineers could use to quickly decide whether a request fell in the yes,” “no or maybe category. They did it with five rules only, stuff like Weima had to collect at least 70% of the price before the unit leaves the factory.

After that, only the maybes were sent to management. This dramatically decreased the amount of time management spend evaluating these projectsthat time was decreased by almost a factor of 10.

Or, take Frontier Dental Laboratories in Canada. They were working with a sales force of two covering the entire North American market. Limiting their sales guidelines to a few factors that made someone likely to be receptive to Frontierstuff like dentists who have their own practice and dentists with a website”—helped focus their efforts and increase sales 42% in a declining market.

WSJ: Weima used five factorsis that the optimal number? And how do you choose which rules to follow?

Sull: You should have four to six rules. Any more than that, youll spend too much time trying to follow everything perfectly. The entire reason simple rules help is because they force you to prioritize the goals that matter. Theyre easy to remember, they dont confuse or stress you, they save time.

They should be tailored to your specific goals, so you choose the rules based on what exactly youre trying to achieve. And you should of course talk to others. Get information from different sources, and ask them for the top things that worked for them. But focus on whether what will work for you and your circumstances.

WSJ: Is there a business leader you can point to who has embraced the simple rules guideline?

Donald Sull: Lets look at when Alex Behring took over America Latina Logistica SARUMO3.BR +1.59%, the Brazilian railway and logistics company. With a budget of $15 million, how do you choose among $200 million of investment requests, all of which are valid?

The textbook business-school answer to this is that you run the NPV (net present value) test on each project and rank-order them by NPV. Alex Behring knows this. He was at the top of the class at Harvard Business School.

But insteadhe decided what the most important goals were. You cant achieve everything at once. In their case, their priorities were removing bottlenecks on growing revenues and minimizing upfront expenditure. So when allocating money, they had a bias for projects that both addressed the bottleneck problem and, for example, used existing tracks and trains.

Similarly, the global-health arm of the Gates Foundation gets many, many funding requests. But since they know that their goal is to have the most impact worldwide, they focus on projects in developing countries because thats where the money will stretch farther.

Chapter 12: Cash Flow Estimation

 

ppt

 

Chapter 12  case study (due with final. Monte Carol simulation part is not required. FYI only)

 

Structure or template:

 

 

 

Years

https://www.jufinance.com/mag/fin435_19s/index_files/image057.gif

 

https://www.jufinance.com/mag/fin435_19s/index_files/image058.gif

 

 

0

1

2

3

4

Investment Outlay

Equipment cost

 $(----------)

Installation

    (--------)

Increase in inventory

    (-------)

Increase in A/P

       -------

Initial net investment

 $(-------)

Operating Cash Flows

Units sales

-------

-------

-------

-------

Price per unit

*  $     ---

 $     ---

 $        ---

 $     ---

  Total revenues

-------

-------

-------

-------

Operating costs (w/o deprn)

-------

-------

-------

-------

Depreciation

-------

-------

-------

-------

  Total costs

-------

-------

-------

-------

Operating income

-------

-------

-------

-------

Taxes on operating income

-------

-------

-------

-------

A-T operating income

-------

-------

-------

-------

Depreciation

-------

-------

-------

-------

Operating cash flow

-------

-------

-------

-------

 

Terminal Year Cash Flows

Recovery of net working capital                                                                              -------

 

Salvage value

    -------

 

Tax on salvage value

   (-------)

 

Total termination cash flow

    -------

 

 

Project Cash Flows

 

 

 

 

 

Net cash flows

 $(-------)

 $  -------

 $  -------

 $    -------

 

 

 

Live session 4/2 (on  blackboard as well)

·        Chapter 12 case study I

 

Live session 4/7 (on  blackboard as well)

·        Chapter 12 case study II

·        For the sensitivity analysis part, there is an easy fix. Just type the new numbers directly into the cell for the units sold, the unit costs, and the salvage value, and you will get the correct NPVs. I made a mistake in the video. I used the equations to get the numbers for those columns. This is wrong. For example, just type in 700, 850, 1000, 1150, 1300, for new units sold. Do not use equations.

·         Instead of earning 10 points for this case study, you can earn a total of 15 points for this case study, if you could get the sensitivity analysis part done correctly.

 

 

Chapter 18 Derivatives

 

Chapter 18 PPT

 

Chapter 18 Case Study -  due with final

 

1st, understand what is call and put option

2nd, understand the pay off of call and put option

3rd, can draw payoff profile of call and put option

 

Call and Put Option Calculator

www.jufinance.com/option

 

Call and Put Option Diagram Illustration Excel

(Thanks to Dr. Greence at UAH)

 

4th, can calculate call option price using black-scholes model

Black-Scholes Option Calculator

http://www.tradingtoday.com/black-scholes

 

Black-Scholes Model Illustration Excel

(Thanks to Dr. Greence at UAH)

 

 

5th, can calculate option pricing using binomial model (FYI)

 

Binomial option Calculator (FYI)

http://janroman.dhis.org/calc/Binomial2.php

 

 

 

 

image012.jpg

Black-Scholes model (reference only)

 

image013.jpg

 

 

 

 

Puts and Calls - How to Make Money When Stocks are Going Up or Down

https://www.youtube.com/watch?v=D9-_Jar2UpQ

Call Options Trading for Beginners in 9 min. - Put and Call Options Explained

https://www.youtube.com/watch?v=q_z1Zx_BALo

 

 

 

Gambling on Derivatives, Hedging Risk or Courting Disaster?

 

 

Bullish option strategies example on optionhouse

 

 

 

Bearish option strategies example on optionhouse

 

 

Option Strategy graphs

 

Live session 4/9 (on  blackboard as well)

·        Chapter 18 case study I – intrinsic value of option and binomial option pricing

·        FRM: Binomial (one step) for option price (video, fyi)

 

Live session 4/14 (on  blackboard as well)

·        Chapter 18 case study II – Black Scholes Model and sensitivity analysis

·        Introduction to the Black-Scholes formula | | Khan Academy (fyi)

 

 

 

 

4/16 – No class

 

4/17 – Final exam and case studies due

·        will be posted at 8am on blackboard under course introduction

·        due at 11:59pm

·        All case studies due (videos for each case study could be found on this website and on blackboard under blackboard collaborate/recording)

·        Check list for all case studies after the midterm exam

1.     Chapter 8

2.     Chapter 9

3.     Chapter 10

4.     Chapter 12

5.     Chapter 18

 

 

 

Winner! (Congraduations!)

Hossam Alomim

NET WORTH

LAST

TRADES

TOTAL RETURNS

$2,559,372.69

0.00%

8

$1,559,372.69

NAME

NET WORTH

LAST

TRADES

TOTAL RETURNS

2

Connor Eckert

$1,509,139.77

0.00%

90

$509,139.77

3

Dwayne Mattushik

$1,117,350.51

0.00%

22

$117,350.51

4

Kacie Patterson

$999,518.20

0.01%

3

-$481.80

5

Jenny Madrid

$952,743.95

6.28%

107

-$47,256.05

 

 

 

 

 

 

Warmest congratulations on your graduation!

 

 

image065.jpg

 

 

 

 

 

 



 

1.