Yield Curve and Bond Valuation Worksheet
Action Items:
1. Go to the http:/www.federalreserve.gov/releases/h15/data.htm to
examine historical daily interest rates on U.S. Treasuries.
2. Scroll down to "Treasury constant maturities" and in the row "1month"
Financial Analysis
Lidian Barbosa
Finance - 301
David Logan
October 1, 2016
Financial Analysis
Company Name as of
Exxon
12/31/2015
Merck & Co
12/31/2015
Target
01/30/2016
Verizon
12/31/2015
Current Ratio
Total Assets
0.78x
336,758,000
1.55x
101,779,000
1.
Financial Analysis
Lidian Barbosa
Finance - 301
David Logan
October 15, 2016
Financial Analysis
The stock price performance for Target seems to be going down in comparison with the
market. As a matter of fact, the most well-known markets such as Dow jones
MEMO
Lidian Barbosa
BSAD - 220
Jacqueline Hagerott
August 28, 2016
MEMORANDUM
TO: Alex J. Brixton
CC: CEO Jonathan Mayflower
FROM: Lidian Barbosa
DATE: August 28, 2016
RE: Misconduct of the Wall Mart Employees
Facts:
Jean Taylor and Karla Hughes procedure
FINA 301: SHERWIN-WILLIAMS EXAMPLE
Supporting Information for Financial Analysis Exercise III
Part A: This first part of the exercise asks you to select one of four company stocks and apply
the constant- growth model in an attempt to value a share of that
Yield Curve and Bond Valuation Worksheet
Action Items:
1. Go to the http:/www.federalreserve.gov/releases/h15/data.htm to examine
historical daily interest rates on U.S. Treasuries.
2. Scroll down to "Treasury constant maturities" and in the row "1-month"
FINA301-Q4WW
Capital Budgeting Exercises
Capital Budgeting Exercise 1
You are considering the purchase of one of two machines used in your manufacturing plant.
Machine A has a life of two years, costs $1500 initially, and then $400 per year in maintenance
Year-to-date, Yum Brands had earned a 3.10 percent return. During the same time period, Raytheon
earned 4.28 percent and Coca-Cola earned 0.47 percent.
If you have a portfolio made up of 35 percent Yum Brands, 30 percent Raytheon, and 35 percent CocaCola,
Column1
Current Ratio
Total Asset Turnover
Times Interest Earned
Total Debt/Equity
Return on Sales
Return on Assets
Return on Equity
P/E Ratio
ASSETS
REVENUES
DEBT
EQUITY
Market price
EPS
EBIT
INTEREST
NET INCOME
AT & T (T)
0.68
0.47
4.03
1.95
6%
2.97%
7.
Financial Analysis Exercise IV
Part A: Weighted Average Cost of Capital (WACC) Worksheet
Here again is the formula for WACC. For simplicity the term for preferred stock has been
removed:
Exxon Mobile
Cost of debt, iD
2.29%
Corporate tax rate, TC
40.82%
To
Financial Analysis Exercise IV
Part B: Dividend Payout and Growth Ratios Worksheet
Sustainable growth rate = (ROE RR) / [1-(ROE RR)]
(Eq. 3-33)
If the firm uses retained earnings to support asset growth, the firms capital structure will change
over time,
FUTURE VALUE
number of periods
interest rate
present value
future value
payment
n
i
pv
fv
pmt
6
11%
-170
$317.97
0
Compounding different rates
PRESENT VALUE
1
1
10
8%
11%
12%
-690
($745.20)
($515.16)
$745.20
$827.17
$1,600.00
0
0
Rule of 72
5.5
Rule numbe
Assets
Current Assets
Fixed Assets
TOTAL
Liabilities and Equity
Current Liabilities
Long-Term Debt
Stockholder Equity
TOTAL
436,000
550,000
986,000
778,500
(200,000)
578,500
(202,475)
376,025
Cash flow from Operating Activities
Cash flow from Investing Ac