task investor ratios 9-2 and 9-13 using excel

Project Description:

p 9-2 a firm has earnings before interest and tax of $1,000,000, interest of $200,000, and
net income of $400,000 in year 1.
required
a. calculate the degree of financial leverage in base year 1.
b. if earnings before interest and tax increase by 10% in year 2, what will be the new level of earnings, assuming the same tax rate as in year 1?
c. if earnings before interest and tax decrease to $800,000 in year 2, what will be the new level of earnings, assuming the same tax rate as in year 1?




p 9-13 consecutive five-year balance sheets and income statements of donna szabo corporation are shown below and on the following page.
required
a. compute or determine the following for the years 2007–2011:
1. degree of financial leverage
2. earnings per common share
3. price/earnings ratio
4. percentage of earnings retained
5. dividend payout
6. dividend yield
7. book value per share
8. materiality of options (use stock options outstanding)
b. comment from the perspective of an investor.

donna szabo corporation
balance sheets
december 31, 2007 through december 31, 2011
(dollars in thousands) 2011 2010 2009 2008 2007
assets
current assets:
cash $ 26,000 $ 27,000 $ 29,000 $ 28,000 $ 27,000
accounts receivable, net 125,000 126,000 128,000 130,000 128,000
inventories 140,000 143,000 145,000 146,000 144,000
total current assets 291,000 296,000 302,000 304,000 299,000
property, plant, and
equipment, net 420,000 418,000 417,000 418,000 415,000
total assets $ 711,000 $ 714,000 $ 719,000 $ 722,000 $ 714,000
liabilities and stockholders’ equity
current liabilities:
accounts payable $ 120,000 $ 122,000 $ 122,500 $ 124,000 $ 125,000
income taxes 12,000 13,000 13,500 13,000 12,000
total current liabilities 132,000 135,000 136,000 137,000 137,000
long-term debt 90,000 65,000 67,000 68,000 69,000

(dollars in thousands) 2011 2010 2009 2008 2007
stockholders’ equity:
preferred stock 49,000 76,000 80,000 82,000 75,000
common stock 290,000 290,000 290,000 290,000 290,000
paid-in capital in excess of
par, common stock 70,000 70,000 70,000 70,000 70,000
retained earnings 80,000 78,000 76,000 75,000 73,000
total stockholders’ equity 489,000 514,000 516,000 517,000 508,000
total liabilities and
stockholders’ equity $711,000 $714,000 $719,000 $722,000 $714,000

donna szabo corporation
statement of earnings
years ended december 31, 2007–2011
(in thousands, except per share) 2011 2010 2009 2008 2007
net sales $ 890,000 $ 870,000 $ 850,000 $ 935,000 $ 920,000
cost of goods sold (540,000) (530,700) (522,750) (579,000) (570,000)
gross profit 350,000 339,300 327,250 356,000 350,000
selling and administrative
expense (230,000) (225,000) (220,000) (225,000) (224,000)
interest expense (9,500) (6,600) (6,800) (6,900) (7,000)
earnings from continuing
operations before income taxes 110,500 107,700 100,450 124,100 119,000
income taxes (33,000) (33,300) (32,100) (30,400) (37,400)
earnings from continuing
operations 77,500 74,400 68,350 93,700 81,600
extraordinary gains, net of taxes 20,000 — — — —
net earnings $ 97,500 $ 74,400 $ 68,350 $ 93,700 $ 81,600
earnings per share:
continuing operations $ 2.67 $ 2.57 $ 2.36 $ 3.23 $ 2.81
extraordinary gain 0.69 — — — —
net earnings per share $ 3.36 $ 2.57 $ 2.36 $ 3.23 $ 2.81
note: additional data:

1. preferred stock dividends (in thousands):
2011 $3,920
2010 $6,100
2009 $6,400
2008 $6,600
2007 $6,000

2. common shares outstanding, 29,000,000 (actual) (2007–2011)

3. stock options outstanding, 1,000,000 (actual) (2007–2011)

4. dividends per common share (actual):
2011 $3.16
2010 $2.29
2009 $2.10
2008 $2.93
2007 $2.80

5. market price per common share (actual):
2011 $24.00
2010 $22.00
2009 $21.00
2008 $37.00
2007 $29.00
Skills Required:
Project Stats:

Price Type: Negotiable

Refunded
Total Proposals: 8
1 Current viewersl
39 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.8
    405 Jobs 247 Reviews
    $0 in 0 Day
  • 4.6
    647 Jobs 468 Reviews
    $0 in 0 Day
  • 3.7
    12 Jobs 3 Reviews
    $25 in 0 Day
  • 4.9
    287 Jobs 248 Reviews
    $0 in 0 Day
  • 4.9
    59 Jobs 52 Reviews
    $0 in 0 Day
  • 4.4
    86 Jobs 65 Reviews
    $0 in 0 Day